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