protected virtual void OnChangesApplied(object sender, DbChangesAppliedEventArgs ev)
{
if (ChangesApplied != null)
{
ChangesApplied(sender, ev);
}
}
public void ChangesApplied(object sender, DbChangesAppliedEventArgs args)
{
if (null != _progressForm)
{
_progressForm.ChangesApplied(args);
}
}
public static void RemoteProvider_ChangesApplied(object sender, DbChangesAppliedEventArgs e)
{
transactionCount += 1;
int totalBytes = transactionCount * Convert.ToInt32(BatchSize);
Console.WriteLine("Changes Applied event fired: Transaction " + totalBytes + " bytes.");
}
public void ChangesApplied(object sender, DbChangesAppliedEventArgs args)
{
if (null != _progressForm)
{
_progressForm.ChangesApplied(args);
}
}
protected void Proveedor_ChangesApplied(object sender, DbChangesAppliedEventArgs e)
{
String mensaje =
string.Format(
"{0}:{1}\n\r{2}:{3}\n\r{4}:{5}\n\r{6}:{7}\n\r",
"\tSource Database :", e.Connection.Database,
"\tContexto :", e.Context,
"\tSession Id :", e.Session.SessionId,
"\tTransaccion :", e.Transaction.ToString()
);
Loguear("proveedor_ChangesApplied", mensaje);
}
public void ChangesApplied(DbChangesAppliedEventArgs args)
{
DbSyncScopeProgress progress = args.Context.ScopeProgress;
string message = "";
listSyncProgress.Items.Add(message);
foreach (DbSyncTableProgress tableProgress in args.Context.ScopeProgress.TablesProgress)
{
message = "Applied changes for table: " + tableProgress.TableName;
message += "[Applied:" + tableProgress.ChangesApplied.ToString() + "/Failed:" + tableProgress.ChangesFailed.ToString() + "/Pending:" + tableProgress.ChangesPending.ToString() + "/Total:" + tableProgress.TotalChanges.ToString() + "]";
listSyncProgress.Items.Add(message);
}
message = "Total Changes Applied: " + progress.TotalChanges.ToString() + " Inserts :" + progress.TotalInserts.ToString();
message += " Updates :" + progress.TotalUpdates.ToString() + " Deletes :" + progress.TotalDeletes.ToString();
listSyncProgress.Items.Add(message);
Application.DoEvents();
}
public void ChangesApplied(DbChangesAppliedEventArgs args)
{
DbSyncScopeProgress progress = args.Context.ScopeProgress;
string message = "";
listSyncProgress.Items.Add(message);
foreach (DbSyncTableProgress tableProgress in args.Context.ScopeProgress.TablesProgress)
{
message = "Applied changes for table: " + tableProgress.TableName;
message += "[Applied:" + tableProgress.ChangesApplied.ToString() + "/Failed:" + tableProgress.ChangesFailed.ToString() + "/Pending:" + tableProgress.ChangesPending.ToString() + "/Total:" + tableProgress.TotalChanges.ToString() + "]";
listSyncProgress.Items.Add(message);
}
message = "Total Changes Applied: " + progress.TotalChanges.ToString() + " Inserts :" + progress.TotalInserts.ToString();
message += " Updates :" + progress.TotalUpdates.ToString() + " Deletes :" + progress.TotalDeletes.ToString();
listSyncProgress.Items.Add(message);
Application.DoEvents();
}
private void to_ChangesApplied(object sender, DbChangesAppliedEventArgs e)
{
// запоминаем добавленные строки для желаемых таблиц
foreach (var table in TablesTrackAdding)
{
if (e.Context.DataSet.Tables.Contains(table))
{
var dataTable = e.Context.DataSet.Tables[table];
AddedIdsPerTable.Add(
dataTable.TableName,
dataTable.Rows
.Cast <DataRow>()
.Where(x => x.RowState == DataRowState.Added)
.Select(x => x["Id"])
.ToList());
}
}
// запоминаем удаляемые строки для желаемых таблиц
foreach (var table in TablesTrackDeleting)
{
if (e.Context.DataSet.Tables.Contains(table))
{
var dataTable = e.Context.DataSet.Tables[table];
DeletedIdsPerTable.Add(
dataTable.TableName,
dataTable.Rows
.Cast <DataRow>()
.Where(x => x.RowState == DataRowState.Deleted)
.Select(x => x["Id"])
.ToList());
}
}
}
protected abstract void SyncProviderOnChangesApplied(object sender, DbChangesAppliedEventArgs dbChangesAppliedEventArgs);
protected void proveedor_ChangesApplied(object sender, DbChangesAppliedEventArgs e)
{
String mensaje =
string.Format(
"{0}:{1}\n\r{2}:{3}\n\r{4}:{5}\n\r{6}:{7}\n\r",
"\tSource Database :", e.Connection.Database,
"\tContexto :", e.Context,
"\tSession Id :", e.Session.SessionId,
"\tTransaccion :", e.Transaction.ToString()
);
this.loguear("proveedor_ChangesApplied",mensaje);
}
/// <summary>
/// On the client (remote)
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private static void Program_ChangesApplied(object sender, DbChangesAppliedEventArgs e)
{
}
private static void RemoteProvider_ChangesApplied(object sender, DbChangesAppliedEventArgs e)
{
Console.WriteLine("Changes Applied");
}
private static void Program_ChangesApplied(object sender, DbChangesAppliedEventArgs e)
{
// display conflict type
Console.WriteLine(e.Context.DataSet.DataSetName);
}
protected override void SyncProviderOnChangesApplied(object sender, DbChangesAppliedEventArgs dbChangesAppliedEventArgs)
{
ShowMessage("Local");
}
public void SynchronizeServer_ChangesApplied(object sender, DbChangesAppliedEventArgs args)
{
LogChanges(args.Context.ScopeProgress.TablesProgress, "Server Changes Applied");
}
/// <summary>
/// Handler for the ChangesApplied event of the SqlSyncProvider class. This event is raised after the changes are
/// applied but before the SqlTransaction is committed. We use this event to read the server timestamp (@@DBTS/get_new_rowversion())
/// and use this to generate positive exceptions in the knowledge that is sent back in the response.
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void SqlSyncProviderChangesApplied(object sender, DbChangesAppliedEventArgs e)
{
Debug.Assert(e.Connection is SqlConnection, "Connection is not of type SqlConnection");
Debug.Assert(null != e.Transaction, "Transaction is null");
Debug.Assert(e.Transaction is SqlTransaction, "Transaction is not of type SqlTransaction");
if (0 != _conflicts.Count)
{
_serverTickCountAfterResolvingAllConflicts =
Microsoft.Synchronization.Services.SqlProvider.SqlEditionHelper.GetServerTickCountFromDatabase(e.Connection as SqlConnection, e.Transaction as SqlTransaction);
}
}
/// <summary>
/// List of changes successfully applied to the client (taken from the server)
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private static void Program_ChangesApplied(object sender, DbChangesAppliedEventArgs e)
{
var added = e.Context.DataSet.GetChanges(DataRowState.Added);
var deleted = e.Context.DataSet.GetChanges(DataRowState.Deleted);
var modified = e.Context.DataSet.GetChanges(DataRowState.Modified);
}
