public static int BatchUpdate <T>(this IQueryable <T> query, Expression <Func <T, T> > updateExpression) where T : class
{
var context = BatchUtil.GetDbContext(query);
var(sql, sqlParameters) = BatchUtil.GetSqlUpdate(query, context, updateExpression);
return(BatchUtil.ExecuteSql(context, sql, sqlParameters));
}
public static int BatchDelete <T>(this IQueryable <T> query) where T : class
{
DbContext context = BatchUtil.GetDbContext(query);
(string sql, var sqlParameters) = BatchUtil.GetSqlDelete(query, context);
return(BatchUtil.ExecuteSql(context, sql, sqlParameters));
}
public static int BatchUpdate <T>(this IQueryable <T> query, T updateValues, List <string> updateColumns = null) where T : class, new()
{
DbContext context = BatchUtil.GetDbContext(query);
var(sql, sqlParameters) = BatchUtil.GetSqlUpdate(query, context, updateValues, updateColumns);
return(BatchUtil.ExecuteSql(context, sql, sqlParameters));
}
public static int BatchUpdate <T>(this IQueryable <T> query, Expression <Func <T, T> > updateExpression, Dictionary <string, object> parametersDict = null) where T : class
{
var context = BatchUtil.GetDbContext(query);
var(sql, sqlParameters) = BatchUtil.GetSqlUpdate(query, context, updateExpression, parametersDict);
return(BatchUtil.ExecuteSql(context, sql, sqlParameters));
}
