/// <example>
/// context.Items.Where(a => a.ItemId > 500).BatchDeleteAsync();
/// </example>
public static async Task <int> BatchDeleteAsync(this IQueryable query, CancellationToken cancellationToken = default)
{
var context = query.GetDbContext();
(string sql, var parameters) = BatchUtil.GetSqlDelete(query, context);
return(await context.Database.ExecuteSqlRawAsync(sql, parameters, cancellationToken).ConfigureAwait(false));
}
/// <example>
/// context.Items.Where(a => a.ItemId > 500).BatchDelete();
/// </example>
public static int BatchDelete(this IQueryable query)
{
var context = query.GetDbContext();
(string sql, var parameters) = BatchUtil.GetSqlDelete(query, context);
return(context.Database.ExecuteSqlRaw(sql, parameters));
}