public static async Task <T> FirstOrDefaultAsync <T>(this QueryFactory db, Query query) { var compiled = db.Compile(query.Limit(1)); return(await db.Connection.QueryFirstOrDefaultAsync <T>( compiled.Sql, compiled.NamedBindings, commandTimeout : db.QueryTimeout )); }
public static async Task <IEnumerable <T> > GetAsync <T>(this QueryFactory db, Query query) { var compiled = db.Compile(query); return(await db.Connection.QueryAsync <T>( compiled.Sql, compiled.NamedBindings, commandTimeout : db.QueryTimeout )); }
public static IEnumerable <T> Get <T>(this QueryFactory db, Query query) { var compiled = db.Compile(query); return(db.Connection.Query <T>( compiled.Sql, compiled.NamedBindings, commandTimeout: db.QueryTimeout )); }
public static async Task <IEnumerable <IDictionary <string, object> > > GetDictionaryAsync(this QueryFactory db, Query query) { var compiled = db.Compile(query); var result = await db.Connection.QueryAsync( compiled.Sql, compiled.NamedBindings, commandTimeout : db.QueryTimeout ); return(result as IEnumerable <IDictionary <string, object> >); }
public static T ExecuteScalar <T>(this QueryFactory db, Query query, IDbTransaction transaction = null, CommandType?commandType = null) { var compiled = db.Compile(query.Limit(1)); return(db.Connection.ExecuteScalar <T>( compiled.Sql, compiled.NamedBindings, transaction, db.QueryTimeout, commandType )); }
public static async Task <IEnumerable <T> > GetAsync <T>(this QueryFactory db, Query query) { var compiled = db.Compile(query); var result = (await db.Connection.QueryAsync <T>( compiled.Sql, compiled.NamedBindings, commandTimeout: db.QueryTimeout )).ToList(); result = (await handleIncludesAsync(query, result)).ToList(); return(result); }
public static IEnumerable <T> Get <T>(this QueryFactory db, Query query) { var compiled = db.Compile(query); var result = db.Connection.Query <T>( compiled.Sql, compiled.NamedBindings, commandTimeout: db.QueryTimeout ).ToList(); result = handleIncludes <T>(query, result).ToList(); return(result); }
public static async Task <int> ExecuteAsync( this QueryFactory db, Query query, IDbTransaction transaction = null, CommandType?commandType = null ) { var compiled = db.Compile(query); return(await db.Connection.ExecuteAsync( compiled.Sql, compiled.NamedBindings, transaction, db.QueryTimeout, commandType )); }
public static int Execute( this QueryFactory db, Query query, IDbTransaction transaction = null, CommandType?commandType = null ) { var compiled = db.Compile(query); return(db.Connection.Execute( compiled.Sql, compiled.NamedBindings, transaction ?? db.Transaction, db.QueryTimeout, commandType )); }
public static IEnumerable <IDictionary <string, object> > GetDictionary(this QueryFactory db, Query query) { var compiled = db.Compile(query); return(db.Connection.Query(compiled.Sql, compiled.NamedBindings, commandTimeout: db.QueryTimeout) as IEnumerable <IDictionary <string, object> >); }
public static T First <T>(this QueryFactory db, Query query) { var compiled = db.Compile(query.Limit(1)); return(db.Connection.QueryFirst <T>(compiled.Sql, compiled.NamedBindings, commandTimeout: db.QueryTimeout)); }