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.Bindings,
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.QueryTimeout,
commandType
));
}
public static SqlMapper.GridReader GetMultiple <T>(
this QueryFactory db,
Query[] queries,
IDbTransaction transaction = null,
CommandType?commandType = null
)
{
var compiled = queries
.Select(q => db.compile(q))
.Aggregate((a, b) => a + b);
return(db.Connection.QueryMultiple(
compiled.Sql,
compiled.Bindings,
transaction,
db.QueryTimeout,
commandType
));
}
public static T FirstOrDefault <T>(this QueryFactory db, Query query)
{
var compiled = db.compile(query.Limit(1));
return(db.Connection.QueryFirstOrDefault <T>(compiled.Sql, compiled.Bindings));
}
public static IEnumerable <IDictionary <string, object> > GetDictionary(this QueryFactory db, Query query)
{
var compiled = db.compile(query);
return(db.Connection.Query(compiled.Sql, compiled.Bindings) as IEnumerable <IDictionary <string, object> >);
}
public static IEnumerable <T> Get <T>(this QueryFactory db, Query query)
{
var compiled = db.compile(query);
return(db.Connection.Query <T>(compiled.Sql, compiled.Bindings));
}
