1. Downloading
2. In this case I deleted 80k records -- that's all that should change, but it appears to be trying to pull all data down.
3. Client Provider from Designer:
//------------------------------------------------------------------------------
// <auto-generated>
// This code was generated by a tool.
// Runtime Version:2.0.50727.4927
//
// Changes to this file may cause incorrect behavior and will be lost if
// the code is regenerated.
// </auto-generated>
//------------------------------------------------------------------------------
namespace eFSR.Client {
public partial class PowerEFSRLookupClientSyncProvider : Microsoft.Synchronization.Data.SqlServerCe.SqlCeClientSyncProvider {
public PowerEFSRLookupClientSyncProvider() {
this.ConnectionString = global::eFSR.Client.Properties.Settings.Default.ClienteFSRLookup_v6ConnectionString;
this.ApplyChangeFailed += new System.EventHandler<Microsoft.Synchronization.Data.ApplyChangeFailedEventArgs>(PowerEFSRLookupClientSyncProvider_ApplyChangeFailed);
this.ChangesApplied += new System.EventHandler<Microsoft.Synchronization.Data.ChangesAppliedEventArgs>(PowerEFSRLookupClientSyncProvider_ChangesApplied);
}
void PowerEFSRLookupClientSyncProvider_ApplyChangeFailed(object sender, Microsoft.Synchronization.Data.ApplyChangeFailedEventArgs e)
{
e.Action = Microsoft.Synchronization.Data.ApplyAction.RetryApplyingRow;
}
public PowerEFSRLookupClientSyncProvider(string connectionString) {
this.ConnectionString = connectionString;
}
}
public partial class PowerEFSRLookupSyncAgent : Microsoft.Synchronization.SyncAgent {
private CommonInventorySyncTable _commonInventorySyncTable;
private TipSyncTable _tipSyncTable;
private PartsSyncTable _partsSyncTable;
private UnitSyncTable _unitSyncTable;
private InventoryItemSyncTable _inventoryItemSyncTable;
partial void OnInitialized();
public PowerEFSRLookupSyncAgent() {
this.InitializeSyncProviders();
this.InitializeSyncTables();
this.OnInitialized();
}
public PowerEFSRLookupSyncAgent(object remoteSyncProviderProxy) {
this.InitializeSyncProviders();
this.InitializeSyncTables();
this.RemoteProvider = new Microsoft.Synchronization.Data.ServerSyncProviderProxy(remoteSyncProviderProxy);
this.OnInitialized();
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public CommonInventorySyncTable CommonInventory {
get {
return this._commonInventorySyncTable;
}
set {
this.Configuration.SyncTables.Remove(this._commonInventorySyncTable);
this._commonInventorySyncTable = value;
this.Configuration.SyncTables.Add(this._commonInventorySyncTable);
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public TipSyncTable Tip {
get {
return this._tipSyncTable;
}
set {
this.Configuration.SyncTables.Remove(this._tipSyncTable);
this._tipSyncTable = value;
this.Configuration.SyncTables.Add(this._tipSyncTable);
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public PartsSyncTable Parts {
get {
return this._partsSyncTable;
}
set {
this.Configuration.SyncTables.Remove(this._partsSyncTable);
this._partsSyncTable = value;
this.Configuration.SyncTables.Add(this._partsSyncTable);
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public UnitSyncTable Unit {
get {
return this._unitSyncTable;
}
set {
this.Configuration.SyncTables.Remove(this._unitSyncTable);
this._unitSyncTable = value;
this.Configuration.SyncTables.Add(this._unitSyncTable);
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public InventoryItemSyncTable InventoryItem {
get {
return this._inventoryItemSyncTable;
}
set {
this.Configuration.SyncTables.Remove(this._inventoryItemSyncTable);
this._inventoryItemSyncTable = value;
this.Configuration.SyncTables.Add(this._inventoryItemSyncTable);
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
private void InitializeSyncProviders() {
// Create SyncProviders.
this.LocalProvider = new PowerEFSRLookupClientSyncProvider();
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
private void InitializeSyncTables() {
// Create SyncTables.
this._commonInventorySyncTable = new CommonInventorySyncTable();
this._commonInventorySyncTable.SyncGroup = new Microsoft.Synchronization.Data.SyncGroup("CommonInventorySyncTableSyncGroup");
this.Configuration.SyncTables.Add(this._commonInventorySyncTable);
this._tipSyncTable = new TipSyncTable();
this._tipSyncTable.SyncGroup = new Microsoft.Synchronization.Data.SyncGroup("TipSyncTableSyncGroup");
this.Configuration.SyncTables.Add(this._tipSyncTable);
this._partsSyncTable = new PartsSyncTable();
this._partsSyncTable.SyncGroup = new Microsoft.Synchronization.Data.SyncGroup("PartsSyncTableSyncGroup");
this.Configuration.SyncTables.Add(this._partsSyncTable);
this._unitSyncTable = new UnitSyncTable();
this._unitSyncTable.SyncGroup = new Microsoft.Synchronization.Data.SyncGroup("UnitSyncTableSyncGroup");
this.Configuration.SyncTables.Add(this._unitSyncTable);
this._inventoryItemSyncTable = new InventoryItemSyncTable();
this._inventoryItemSyncTable.SyncGroup = new Microsoft.Synchronization.Data.SyncGroup("InventoryItemSyncTableSyncGroup");
this.Configuration.SyncTables.Add(this._inventoryItemSyncTable);
}
public partial class CommonInventorySyncTable : Microsoft.Synchronization.Data.SyncTable {
partial void OnInitialized();
public CommonInventorySyncTable() {
this.InitializeTableOptions();
this.OnInitialized();
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
private void InitializeTableOptions() {
this.TableName = "CommonInventory";
this.CreationOption = Microsoft.Synchronization.Data.TableCreationOption.DropExistingOrCreateNewTable;
}
}
public partial class TipSyncTable : Microsoft.Synchronization.Data.SyncTable {
partial void OnInitialized();
public TipSyncTable() {
this.InitializeTableOptions();
this.OnInitialized();
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
private void InitializeTableOptions() {
this.TableName = "Tip";
this.CreationOption = Microsoft.Synchronization.Data.TableCreationOption.DropExistingOrCreateNewTable;
}
}
public partial class PartsSyncTable : Microsoft.Synchronization.Data.SyncTable {
partial void OnInitialized();
public PartsSyncTable() {
this.InitializeTableOptions();
this.OnInitialized();
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
private void InitializeTableOptions() {
this.TableName = "Parts";
this.CreationOption = Microsoft.Synchronization.Data.TableCreationOption.DropExistingOrCreateNewTable;
}
}
public partial class UnitSyncTable : Microsoft.Synchronization.Data.SyncTable {
partial void OnInitialized();
public UnitSyncTable() {
this.InitializeTableOptions();
this.OnInitialized();
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
private void InitializeTableOptions() {
this.TableName = "Unit";
this.CreationOption = Microsoft.Synchronization.Data.TableCreationOption.DropExistingOrCreateNewTable;
}
}
public partial class InventoryItemSyncTable : Microsoft.Synchronization.Data.SyncTable {
partial void OnInitialized();
public InventoryItemSyncTable() {
this.InitializeTableOptions();
this.OnInitialized();
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
private void InitializeTableOptions() {
this.TableName = "InventoryItem";
this.CreationOption = Microsoft.Synchronization.Data.TableCreationOption.DropExistingOrCreateNewTable;
}
}
}
}
4. Zero conflicts -- this inventory database should be downloaded ONLY.
5. No conflict resolution -- but I did just add when a change failed occurs to retry -- this resolved the memory useage issue, I assume because it clears out the conflict, but it still doesn't explain WHY that much data is pulled down. In this case -- inserts are trying to occur when the data has already been pushed to the inventory database and that is what's causing the conflicts.
I am still testing this morning -- I'll report back whatever I find.
Travich
