private void CreateUpdateTrackingTables(Table t, string eventName)
{
var commandStr = "If exists (select name from sysobjects where name = '{0}') drop table {0} CREATE TABLE {0}{1}";
commandStr = string.Format(commandStr, eventName + "_" + t.TableName, CreateTableColumns(t.OrderedColumnSchema));
SDQ.ExecuteNonQuery(commandStr);
}
private void UpdateEntitySyncLog(string entityId, string showCode, int sysEventId)
{
var commandStr = "exec InsertUpdateEntityState '{0}', '{1}', {2}";
commandStr = string.Format(commandStr, entityId, showCode, sysEventId);
SDQ.ExecuteNonQuery(commandStr);
}