public override async Task <SqlNonQueryResult> ExecuteNonQueryAsync(SqlNonQueryRequest request, CancellationToken cancellationToken)
{
int rowCountAffected;
if (request.Parameters == null)
{
rowCountAffected = await _dbContext.Database.ExecuteSqlRawAsync(request.Sql, cancellationToken);
}
else
{
SqlParameter[] parameters = ToSqlParameters(request.Parameters);
rowCountAffected = await _dbContext.Database.ExecuteSqlRawAsync(request.Sql, parameters, cancellationToken);
}
return(new SqlNonQueryResult(rowCountAffected));
}
public override SqlNonQueryResult ExecuteNonQuery(SqlNonQueryRequest request)
{
int rowCountAffected;
if (request.Parameters == null)
{
rowCountAffected = _dbContext.Database.ExecuteSqlRaw(request.Sql);
}
else
{
SqlParameter[] parameters = ToSqlParameters(request.Parameters);
rowCountAffected = _dbContext.Database.ExecuteSqlRaw(request.Sql, parameters);
}
return(new SqlNonQueryResult(rowCountAffected));
}
public override async Task <SqlNonQueryResult> ExecuteNonQueryAsync(SqlNonQueryRequest request, CancellationToken cancellationToken)
{
return(await new SqlServerSqlNonQueryCommand(ConnectionProvider).ExecuteAsync(request, cancellationToken));
}
public override SqlNonQueryResult ExecuteNonQuery(SqlNonQueryRequest request)
{
return(new SqlServerSqlNonQueryCommand(ConnectionProvider).Execute(request));
}
/// <summary> /// Executes a SQL statement which is either an Insert, Update or Delete /// </summary> /// <param name="request">The data needed to execute the non-query command</param> /// <param name="cancellationToken">The CancellationToken from the caller</param> /// <returns>The result of the command</returns> public abstract Task <SqlNonQueryResult> ExecuteNonQueryAsync(SqlNonQueryRequest request, CancellationToken cancellationToken);
/// <summary> /// Executes a SQL statement which is either an Insert, Update or Delete /// </summary> /// <param name="request">The data needed to execute the non-query command</param> /// <returns>The result of the command</returns> public abstract SqlNonQueryResult ExecuteNonQuery(SqlNonQueryRequest request);
