/// <summary>
/// 通过存储过程查询创建 SqlCommand 对象
/// </summary>
/// <param name="query"></param>
/// <returns></returns>
protected SqlCommand CreateCommand(StoredProcedureQuery query)
{
var command = new SqlCommand(query.Name);
command.CommandType = CommandType.StoredProcedure;
query.Parameters.ForAll(pair => command.Parameters.AddWithValue(pair.Key, pair.Value));
return(command);
}
Task <IAsyncDbExecuteContext> IAsyncDbExecutor <StoredProcedureQuery> .ExecuteAsync(StoredProcedureQuery query, CancellationToken token)
{
return(ExecuteAsync(CreateCommand(query), token, TryCreateTracing(this, query)));
}
IDbExecuteContext IDbExecutor <StoredProcedureQuery> .Execute(StoredProcedureQuery query)
{
return(Execute(CreateCommand(query), TryCreateTracing(this, query)));
}
IDbExecuteContext IDbExecutor <StoredProcedureQuery> .Execute(StoredProcedureQuery query)
{
return(Execute(CreateCommand(query)));
}
