public static T Aggregate <T>(this Query query, string aggregateOperation, params string[] columns) { var factory = QueryHelper.CreateQueryFactory(query); return(factory.ExecuteScalar <T>(query.AsAggregate(aggregateOperation, columns))); }
public static async Task <T> FirstAsync <T>(this Query query) { return(await QueryHelper.CreateQueryFactory(query).FirstAsync <T>(query)); }
public static void Chunk <T>(this Query query, int chunkSize, Action <IEnumerable <T>, int> action) { var db = QueryHelper.CreateQueryFactory(query); db.Chunk(query, chunkSize, action); }
public static async Task <int> UpdateAsync(this Query query, IReadOnlyDictionary <string, object> values) { return(await QueryHelper.CreateQueryFactory(query) .ExecuteAsync(query.AsUpdate(values))); }
public static async Task <T> CountAsync <T>(this Query query, params string[] columns) { var db = QueryHelper.CreateQueryFactory(query); return(await db.ExecuteScalarAsync <T>(query.AsCount(columns))); }
public static PaginationResult <T> Paginate <T>(this Query query, int page, int perPage = 25) { var db = QueryHelper.CreateQueryFactory(query); return(db.Paginate <T>(query, page, perPage)); }
public static PaginationResult <T> Paginate <T>(this Query query, int page, int perPage = 25, IDbTransaction transaction = null) { var db = QueryHelper.CreateQueryFactory(query, transaction); return(db.Paginate <T>(query, page, perPage)); }
public static async Task ChunkAsync <T>(this Query query, int chunkSize, Action <IEnumerable <T>, int> action) { await QueryHelper.CreateQueryFactory(query).ChunkAsync <T>(query, chunkSize, action); }
public static int Delete(this Query query, IDbTransaction transaction = null) { return(QueryHelper.CreateQueryFactory(query, transaction).Execute(query.AsDelete())); }
public static T First <T>(this Query query, IDbTransaction transaction = null) { return(QueryHelper.CreateQueryFactory(query, transaction).First <T>(query)); }
public static int Update(this Query query, object data, IDbTransaction transaction = null) { return(QueryHelper.CreateQueryFactory(query, transaction).Execute(query.AsUpdate(data))); }
public static int Delete(this Query query) { return(QueryHelper.CreateQueryFactory(query).Execute(query.AsDelete())); }
public static int Update(this Query query, IReadOnlyDictionary <string, object> values) { return(QueryHelper.CreateQueryFactory(query).Execute(query.AsUpdate(values))); }
public static async Task <PaginationResult <T> > PaginateAsync <T>(this Query query, int page, int perPage = 25) { QueryFactory db = QueryHelper.CreateQueryFactory(query); return(await db.PaginateAsync <T>(query, page, perPage)); }
public static void Chunk <T>(this Query query, int chunkSize, Func <IEnumerable <T>, int, bool> func, IDbTransaction transaction = null) { var db = QueryHelper.CreateQueryFactory(query, transaction); db.Chunk <T>(query, chunkSize, func); }
public static async Task ChunkAsync <T>(this Query query, int chunkSize, Func <IEnumerable <T>, int, bool> func) { await QueryHelper.CreateQueryFactory(query).ChunkAsync <T>(query, chunkSize, func); }
public static IEnumerable <T> Get <T>(this Query query, IDbTransaction transaction = null) { return(QueryHelper.CreateQueryFactory(query, transaction).Get <T>(query)); }
public static async Task <IEnumerable <T> > GetAsync <T>(this Query query) { return(await QueryHelper.CreateQueryFactory(query).GetAsync <T>(query)); }
public static int Insert(this Query query, IReadOnlyDictionary <string, object> values, IDbTransaction transaction = null) { return(QueryHelper.CreateQueryFactory(query, transaction).Execute(query.AsInsert(values))); }
public static T First <T>(this Query query) { return(QueryHelper.CreateQueryFactory(query).First <T>(query)); }
public static int Insert(this Query query, IEnumerable <string> columns, Query fromQuery, IDbTransaction transaction = null) { return(QueryHelper.CreateQueryFactory(query, transaction).Execute(query.AsInsert(columns, fromQuery))); }
public static void Chunk <T>(this Query query, int chunkSize, Func <IEnumerable <T>, int, bool> func) { var db = QueryHelper.CreateQueryFactory(query); db.Chunk <T>(query, chunkSize, func); }
public static int Insert(this Query query, object data) { return(QueryHelper.CreateQueryFactory(query).Execute(query.AsInsert(data))); }
public static IEnumerable <T> Get <T>(this Query query) { return(QueryHelper.CreateQueryFactory(query).Get <T>(query)); }
public static async Task <int> DeleteAsync(this Query query) { return(await QueryHelper.CreateQueryFactory(query) .ExecuteAsync(query.AsDelete())); }
public static async Task <int> UpdateAsync(this Query query, object data) { return(await QueryHelper.CreateQueryFactory(query) .ExecuteAsync(query.AsUpdate(data))); }
public static T Count <T>(this Query query, params string[] columns) { var factory = QueryHelper.CreateQueryFactory(query); return(factory.ExecuteScalar <T>(query.AsCount(columns))); }