C# (CSharp) DotNetWorkQueue.Transport.SqlServer.Basic.CommandHandler SendMessage.BuildStatusCommand示例

BuildStatusCommand() private method

private BuildStatusCommand ( SqlCommand command, TableNameHelper tableNameHelper, IHeaders headers, IAdditionalMessageData data, IMessage message, long id, SqlServerMessageQueueTransportOptions options ) : void
command	System.Data.SqlClient.SqlCommand
tableNameHelper	TableNameHelper
headers	IHeaders
data	IAdditionalMessageData
message	IMessage
id	long
options	SqlServerMessageQueueTransportOptions
return	void

示例#1

文件： SendMessageCommandHandler.cs 项目： abraham-yusuf/DotNetWorkQueue

 /// <summary>
 /// Creates the status record.
 /// </summary>
 /// <param name="connection">The connection.</param>
 /// <param name="id">The identifier.</param>
 /// <param name="message">The message.</param>
 /// <param name="data">The data.</param>
 /// <param name="trans">The transaction.</param>
 private void CreateStatusRecord(SqlConnection connection, long id, IMessage message,
                                 IAdditionalMessageData data, SqlTransaction trans)
 {
     using (var command = connection.CreateCommand())
     {
         SendMessage.BuildStatusCommand(command, _tableNameHelper, _headers, data, message, id, _options.Value);
         command.Transaction = trans;
         command.ExecuteNonQuery();
     }
 }

示例#2

 /// <summary>
 /// Creates the status record.
 /// </summary>
 /// <param name="connection">The connection.</param>
 /// <param name="id">The identifier.</param>
 /// <param name="message">The message.</param>
 /// <param name="data">The data.</param>
 /// <param name="trans">The transaction.</param>
 /// <returns></returns>
 private async Task CreateStatusRecordAsync(SqlConnection connection, long id, IMessage message,
                                            IAdditionalMessageData data, SqlTransaction trans)
 {
     using (var command = connection.CreateCommand())
     {
         SendMessage.BuildStatusCommand(command, _tableNameHelper, _headers, data, message, id, _options.Value);
         command.Transaction = trans;
         await command.ExecuteNonQueryAsync().ConfigureAwait(false);
     }
 }