internal static Task <List <T> > WhereAsync <T>(this IDbCommand dbCmd, object anonType, CancellationToken token)
{
dbCmd.SetFilters <T>(anonType);
return(OrmLiteReadExtensions.IsScalar <T>()
? dbCmd.ColumnAsync <T>(null, token)
: dbCmd.ConvertToListAsync <T>(null, token));
}
internal static Task <List <T> > ColumnAsync <T>(this IDbCommand dbCmd, string sql, object anonType, CancellationToken token)
{
if (anonType != null)
{
dbCmd.SetParameters <T>(anonType, excludeDefaults: false);
}
return(dbCmd.ColumnAsync <T>(dbCmd.GetDialectProvider().ToSelectStatement(typeof(T), sql), token));
}
internal static Task <List <T> > SqlColumnAsync <T>(this IDbCommand dbCmd, string sql, Dictionary <string, object> dict, CancellationToken token)
{
if (dict != null)
{
dbCmd.SetParameters(dict, false);
}
dbCmd.CommandText = sql;
return(OrmLiteReadExtensions.IsScalar <T>()
? dbCmd.ColumnAsync <T>(null, token)
: dbCmd.ConvertToListAsync <T>(null, token));
}
internal static Task <List <T> > SqlColumnAsync <T>(this IDbCommand dbCmd, string sql, object anonType, CancellationToken token)
{
if (anonType != null)
{
dbCmd.SetParameters <T>(anonType, excludeDefaults: false);
}
dbCmd.CommandText = sql;
return(OrmLiteReadExtensions.IsScalar <T>()
? dbCmd.ColumnAsync <T>(null, token)
: dbCmd.ConvertToListAsync <T>(null, token));
}
internal static Task <List <T> > SelectAsync <T>(this IDbCommand dbCmd, string sql, object anonType, CancellationToken token)
{
if (anonType != null)
{
dbCmd.SetParameters <T>(anonType, excludeDefaults: false);
}
dbCmd.CommandText = OrmLiteConfig.DialectProvider.ToSelectStatement(typeof(T), null, sql);
return(OrmLiteReadExtensions.IsScalar <T>()
? dbCmd.ColumnAsync <T>(null, token)
: dbCmd.ConvertToListAsync <T>(null, token));
}
internal static Task <List <T> > SelectAsync <T>(this IDbCommand dbCmd, string sql, Dictionary <string, object> dict, CancellationToken token)
{
if (dict != null)
{
dbCmd.SetParameters((IDictionary <string, object>)dict, (bool)false);
}
dbCmd.CommandText = OrmLiteConfig.DialectProvider.ToSelectStatement(typeof(T), null, sql);
return(OrmLiteReadExtensions.IsScalar <T>()
? dbCmd.ColumnAsync <T>(null, token)
: dbCmd.ConvertToListAsync <T>(null, token));
}
internal static async Task <long> GetCountAsync(this IDbCommand dbCmd, string sql, IEnumerable <IDbDataParameter> sqlParams, CancellationToken token)
{
var ret = await dbCmd.ColumnAsync <long>(sql, sqlParams, token);
return(ret.Sum());
}
internal static Task <List <T> > ColumnFmtAsync <T>(this IDbCommand dbCmd, CancellationToken token, string sql, params object[] sqlParams)
{
return(dbCmd.ColumnAsync <T>(sql.SqlFmt(sqlParams), token));
}
internal static Task <long> GetCountAsync(this IDbCommand dbCmd, string sql, IEnumerable <IDbDataParameter> sqlParams, CancellationToken token)
{
return(dbCmd.ColumnAsync <long>(sql, sqlParams, token).Then(x => x.Sum()));
}
internal static Task <long> GetCountAsync(this IDbCommand dbCmd, string sql, CancellationToken token)
{
return(dbCmd.ColumnAsync <long>(sql, token).Then(x => x.Sum()));
}
