private void truncateSyncTable() { if (Synchronization != null) { using (var sync = Synchronization.CreateConnection()) { using (var truncate = sync.CreateCommand()) { truncate.CommandText = String.Format("TRUNCATE TABLE [{0}].[{1}].[SyncItem];", syncDBCatalog, ConnectionsAccess.Profile.LoginName.nullToEmpty()); int rowsAffected; try { sync.Open(); rowsAffected = truncate.ExecuteNonQuery(); } finally { sync.Close(); } _Log.InfoFormat("Sync table truncated. {0} rows affected", rowsAffected); } } } else { _Log.Error("Cannot truncate sync table. Sync Serializer is null."); } }
public bool truncateSyncTable() { if (stateHasFlag(State, ConnectionState.ConnectedToSynchronization) && Synchronization != null) { using (var sync = Synchronization.CreateConnection()) { using (var truncate = sync.CreateCommand()) { truncate.CommandText = String.Format("TRUNCATE TABLE [{0}].[{1}].[SyncItem];", SYNCDB_CATALOG, _userName); int rowsAffected; try { sync.Open(); rowsAffected = truncate.ExecuteNonQuery(); } catch (Exception ex) { _Log.ErrorFormat("Exception truncating Sync Table: [{0}]", ex); return(false); } finally { sync.Close(); } _Log.InfoFormat("Sync table truncated. {0} rows affected", rowsAffected); return(true); } } } else { _Log.Info("Cannot Truncate SyncTable, No Connection"); } return(false); }