public async Task Run()
{
await SqlConnection.DropTable(null, "RowVersionTracker");
var tracker = new RowVersionTracker();
await tracker.CreateTable(SqlConnection);
var initial = await tracker.Get(SqlConnection);
Assert.Equal(1, initial);
await tracker.Save(SqlConnection, 4);
var after = await tracker.Get(SqlConnection);
Assert.Equal(4, after);
}
async Task ReadLoop()
{
#region ProcessingLoop
var rowVersionTracker = new RowVersionTracker();
var startingRow = await rowVersionTracker.Get(sqlConnection);
static async Task Main()
{
Console.Title = "Samples.SqlServer.Native.ErrorProcessor";
Console.WriteLine("Press any key to exit");
await CreateErrorQueue().ConfigureAwait(false);
#region MessageProcessingLoop
long startingRow;
var rowVersionTracker = new RowVersionTracker();
using (var connection = await ConnectionHelpers.OpenConnection(SqlHelper.ConnectionString)
.ConfigureAwait(false))
{
await rowVersionTracker.CreateTable(connection).ConfigureAwait(false);
startingRow = await rowVersionTracker.Get(connection).ConfigureAwait(false);
}
Task Callback(SqlTransaction sqlTransaction, IncomingBytesMessage message, CancellationToken cancellation)
{
var bodyText = Encoding.UTF8.GetString(message.Body);
Console.WriteLine($"Message received in error queue:\r\n{bodyText}");
return(Task.CompletedTask);
}
void ErrorCallback(Exception exception)
{
Environment.FailFast("Message processing loop failed", exception);
}
Task PersistRowVersion(SqlTransaction transaction, long rowVersion, CancellationToken cancellation)
{
return(rowVersionTracker.Save(transaction, rowVersion, cancellation));
}
Task <SqlTransaction> TransactionBuilder(CancellationToken cancellation)
{
return(ConnectionHelpers.BeginTransaction(SqlHelper.ConnectionString, cancellation));
}
var processingLoop = new MessageProcessingLoop(
table: "error",
delay: TimeSpan.FromSeconds(1),
transactionBuilder: TransactionBuilder,
callback: Callback,
errorCallback: ErrorCallback,
startingRow: startingRow,
persistRowVersion: PersistRowVersion);
processingLoop.Start();
Console.ReadKey();
await processingLoop.Stop()
.ConfigureAwait(false);
#endregion
}
async Task ReadLoop()
{
#region ProcessingLoop
var rowVersionTracker = new RowVersionTracker();
var startingRow = await rowVersionTracker.Get(sqlConnection)
.ConfigureAwait(false);
async Task Callback(SqlTransaction transaction, IncomingMessage message, CancellationToken cancellation)
{
using (var reader = new StreamReader(message.Body))
{
var bodyText = await reader.ReadToEndAsync()
.ConfigureAwait(false);
Console.WriteLine($"Message received in error message:\r\n{bodyText}");
}
}
void ErrorCallback(Exception exception)
{
Environment.FailFast("Message processing loop failed", exception);
}
Task <SqlTransaction> TransactionBuilder(CancellationToken cancellation)
{
return(ConnectionHelpers.BeginTransaction(connectionString, cancellation));
}
Task PersistRowVersion(SqlTransaction transaction, long rowVersion, CancellationToken token)
{
return(rowVersionTracker.Save(sqlConnection, rowVersion, token));
}
var processingLoop = new MessageProcessingLoop(
table: "error",
delay: TimeSpan.FromSeconds(1),
transactionBuilder: TransactionBuilder,
callback: Callback,
errorCallback: ErrorCallback,
startingRow: startingRow,
persistRowVersion: PersistRowVersion);
processingLoop.Start();
Console.ReadKey();
await processingLoop.Stop()
.ConfigureAwait(false);
#endregion
}
async Task RowTracking()
{
long newRowVersion = 0;
#region RowVersionTracker
var versionTracker = new RowVersionTracker();
// create table
await versionTracker.CreateTable(sqlConnection);
// save row version
await versionTracker.Save(sqlConnection, newRowVersion);
// get row version
var startingRow = await versionTracker.Get(sqlConnection);
#endregion
}