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