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