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