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); }