public Task Handle(OrderSubmitted message, IMessageHandlerContext context)
{
log.Info($"Order {message.OrderId} worth {message.Value} persisted by Dapper");
#region StoreDataDapper
var session = context.SynchronizedStorageSession.SqlPersistenceSession();
var order = new SubmittedOrder
{
Id = $"Dapper-{message.OrderId}",
Value = message.Value,
};
var sql = @"insert into receiver.SubmittedOrder
(Id, Value)
values (@Id, @Value)";
return(SqlMapper.ExecuteAsync(
cnn: session.Connection,
sql: sql,
param: order,
transaction: session.Transaction));
#endregion
}
public static async Task <int> ExecuteAsync(this AnyDbConnection cnn, InsertSelect query, IDbTransaction transaction = null, int?commandTimeout = default(int?))
{
string insertSelectSql = GetInsertSelectSql(cnn, query);
if (!commandTimeout.HasValue)
{
commandTimeout = cnn.DefaultCommandTimeout;
}
DynamicParameters parameters = GetParameters(query.Query.CommandParams);
return(await SqlMapper.ExecuteAsync((IDbConnection)cnn, insertSelectSql, (object)parameters, transaction, commandTimeout, (CommandType?)CommandType.Text));
}
public static async Task <long> ExecuteAsync(this AnyDbConnection cnn, Insert query, IDbTransaction transaction = null, int?commandTimeout = default(int?))
{
string sql = GetInsertSql(cnn, query);
if (!commandTimeout.HasValue)
{
commandTimeout = cnn.DefaultCommandTimeout;
}
DynamicParameters parameters = GetParameters(query.Query.CommandParams);
if (string.IsNullOrEmpty(query.Query.IdentityField))
{
return(Convert.ToInt64(await SqlMapper.ExecuteAsync((IDbConnection)cnn, sql, (object)parameters, transaction, commandTimeout, (CommandType?)CommandType.Text)));
}
return(Convert.ToInt64(await SqlMapper.ExecuteScalarAsync((IDbConnection)cnn, sql, (object)parameters, transaction, commandTimeout, (CommandType?)CommandType.Text)));
}
public static Task <int> ExecuteAsync(this IDbConnection cnn, string sql, object param = null, IDbTransaction transaction = null, int?commandTimeout = null, CommandType?commandType = null)
{
TRACE(sql);
return(SqlMapper.ExecuteAsync(cnn, sql, param, transaction, commandTimeout, commandType));
}
