internal static Task<T> SingleWhereAsync<T>(this IDbCommand dbCmd, string name, object value, CancellationToken token) { if (!dbCmd.CanReuseParam<T>(name)) dbCmd.SetFilter<T>(name, value); ((IDbDataParameter)dbCmd.Parameters[0]).Value = value; return dbCmd.ConvertToAsync<T>(null, token); }
internal static Task<T> SingleByIdAsync<T>(this IDbCommand dbCmd, object value, CancellationToken token) { if (!dbCmd.CanReuseParam<T>(ModelDefinition<T>.PrimaryKeyName)) dbCmd.SetFilter<T>(ModelDefinition<T>.PrimaryKeyName, value); ((IDbDataParameter)dbCmd.Parameters[0]).Value = value; return dbCmd.ConvertToAsync<T>(null, token); }
internal static Task <T> SingleAsync <T>(this IDbCommand dbCmd, string sql, object anonType, CancellationToken token) { if (OrmLiteReadExtensions.IsScalar <T>()) { return(dbCmd.ScalarAsync <T>(sql, anonType, token)); } dbCmd.SetParameters <T>(anonType, excludeDefaults: false); return(dbCmd.ConvertToAsync <T>(OrmLiteConfig.DialectProvider.ToSelectStatement(typeof(T), null, sql), token)); }
internal static Task <T> SingleFmtAsync <T>(this IDbCommand dbCmd, CancellationToken token, string filter, params object[] filterParams) { return(dbCmd.ConvertToAsync <T>(OrmLiteConfig.DialectProvider.ToSelectStatement(typeof(T), null, filter, filterParams), token)); }
internal static Task <T> SingleAsync <T>(this IDbCommand dbCmd, object anonType, CancellationToken token) { dbCmd.SetFilters <T>(anonType, excludeDefaults: false); return(dbCmd.ConvertToAsync <T>(null, token)); }
public static Task <T> ConvertToAsync <T>(this IDbCommand dbCmd) { return(dbCmd.ConvertToAsync <T>(null, default(CancellationToken))); }
internal static Task <T> SingleWhereAsync <T>(this IDbCommand dbCmd, string name, object value, CancellationToken token) { dbCmd.SetFilter <T>(name, value); return(dbCmd.ConvertToAsync <T>(null, token)); }
internal static Task <T> SingleByIdAsync <T>(this IDbCommand dbCmd, object value, CancellationToken token) { dbCmd.SetFilter <T>(ModelDefinition <T> .PrimaryKeyName, value); return(dbCmd.ConvertToAsync <T>(null, token)); }
internal static Task <T> SingleAsync <T>(this IDbCommand dbCmd, SqlExpression <T> expression, CancellationToken token) { string sql = expression.Limit(1).SelectInto <T>(); return(dbCmd.ConvertToAsync <T>(sql, token)); }