本文整理汇总了C#中System.Data.Common.DbCommand.ExecuteNonQueryAsync方法的典型用法代码示例。如果您正苦于以下问题:C# DbCommand.ExecuteNonQueryAsync方法的具体用法?C# DbCommand.ExecuteNonQueryAsync怎么用?C# DbCommand.ExecuteNonQueryAsync使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类System.Data.Common.DbCommand
的用法示例。
在下文中一共展示了DbCommand.ExecuteNonQueryAsync方法的5个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: NonQueryAsync
public virtual async Task NonQueryAsync(MapperDb db, DbCommand command)
{
var connection = db.GetConnection();
if (connection == null)
{
throw new MapperException("Could not create database connection.");
}
await db.OpenSharedConnectionAsync().ConfigureAwait(false);
command.Connection = connection;
command.Transaction = db.GetTransaction();
await command.ExecuteNonQueryAsync().ConfigureAwait(false);
}
示例2: InsertInTransactionAsync
private async Task InsertInTransactionAsync(DbCommand sqlCommand, IEnumerable<JournalEntry> journalEntires)
{
using (var tx = _dbConnection.BeginTransaction())
{
sqlCommand.Transaction = tx;
try
{
foreach (var entry in journalEntires)
{
CopyParamsToCommand(sqlCommand, entry);
var commandResult = await sqlCommand.ExecuteNonQueryAsync();
if (commandResult != 1)
{
//TODO: something went wrong, ExecuteNonQuery() should return 1 (number of rows added)
}
}
tx.Commit();
}
catch (Exception)
{
tx.Rollback();
throw;
}
}
}
示例3: ExecuteCommandAsync
/// <summary>
/// Will execute the given command on the database asynchronously
/// </summary>
/// <param name="command">The command to execute</param>
protected async void ExecuteCommandAsync(DbCommand command)
{
bool doClose = await InitializeConnectionAsync();
initializeCommand(ref command);
await command.ExecuteNonQueryAsync();
if (doClose)
Connection.Close();
}
示例4: InsertInTransactionAsync
private async Task InsertInTransactionAsync(DbCommand sqlCommand, IEnumerable<JournalEntry> journalEntries)
{
using (var tx = sqlCommand.Connection.BeginTransaction())
{
sqlCommand.Transaction = tx;
try
{
foreach (var entry in journalEntries)
{
CopyParamsToCommand(sqlCommand, entry);
var result = await sqlCommand.ExecuteNonQueryAsync();
if (result != 1)
{
Log.Error("Persisted event operation was expected to return 1, but returned [{0}]", result);
}
}
tx.Commit();
}
catch (Exception)
{
tx.Rollback();
throw;
}
}
}
示例5: DoExecuteNonQueryAsync
private async Task<int> DoExecuteNonQueryAsync(DbCommand command)
{
using (DbContext context = await DbContext.GetContextAsync(this.name))
{
command.Connection = context.Connection;
DoDbEvent(command, DbEventType.BeforeExecution);
int rowsAffected = await command.ExecuteNonQueryAsync();
DoDbEvent(command, DbEventType.AfterExecution);
return rowsAffected;
}
}