protected int GetNumberDeleted(DbContext context)
{
var resultParameter = SqlClientHelper.CreateParameter(context.Database.GetDbConnection());
resultParameter.ParameterName = "@result";
resultParameter.DbType = DbType.Int32;
resultParameter.Direction = ParameterDirection.Output;
string sqlQueryCount = SqlQueryBuilder.SelectCountIsDeleteFromOutputTable(this);
context.Database.ExecuteSqlRaw($"SET @result = ({sqlQueryCount});", resultParameter);
return((int)resultParameter.Value);
}
protected async Task <int> GetNumberDeletedAsync(DbContext context, CancellationToken cancellationToken)
{
var resultParameters = new List <IDbDataParameter>();
var p = SqlClientHelper.CreateParameter(context.Database.GetDbConnection());
p.ParameterName = "@result";
p.DbType = DbType.Int32;
p.Direction = ParameterDirection.Output;
resultParameters.Add(p);
string sqlQueryCount = SqlQueryBuilder.SelectCountIsDeleteFromOutputTable(this);
await context.Database.ExecuteSqlRawAsync($"SET @result = ({sqlQueryCount});", resultParameters, cancellationToken).ConfigureAwait(false); // TODO cancellationToken if Not
return((int)resultParameters.FirstOrDefault().Value);
}
