/
OrmLiteReadExpressionsApiAsyncLegacy.cs
82 lines (74 loc) · 3.86 KB
/
OrmLiteReadExpressionsApiAsyncLegacy.cs
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
#if ASYNC
// Copyright (c) ServiceStack, Inc. All Rights Reserved.
// License: https://raw.github.com/ServiceStack/ServiceStack/master/license.txt
using System;
using System.Collections.Generic;
using System.Data;
using System.Threading;
using System.Threading.Tasks;
namespace ServiceStack.OrmLite.Legacy
{
[Obsolete(Messages.LegacyApi)]
public static class OrmLiteReadExpressionsApiAsyncLegacy
{
/// <summary>
/// Returns results from using an SqlExpression lambda. E.g:
/// <para>db.Select<Person>(q => q.Where(x => x.Age > 40))</para>
/// </summary>
[Obsolete("Use db.SelectAsync(db.From<T>())")]
public static Task<List<T>> SelectAsync<T>(this IDbConnection dbConn, Func<SqlExpression<T>, SqlExpression<T>> expression, CancellationToken token = default)
{
return dbConn.Exec(dbCmd => dbCmd.SelectAsync(expression, token));
}
/// <summary>
/// Project results from a number of joined tables into a different model
/// </summary>
[Obsolete("Use db.SelectAsync<Into, From>(db.From<T>())")]
public static Task<List<Into>> SelectAsync<Into, From>(this IDbConnection dbConn, Func<SqlExpression<From>, SqlExpression<From>> expression, CancellationToken token = default)
{
return dbConn.Exec(dbCmd => dbCmd.SelectAsync<Into, From>(expression, token));
}
/// <summary>
/// Returns a single result from using an SqlExpression lambda. E.g:
/// <para>db.Single<Person>(q => q.Where(x => x.Age == 42))</para>
/// </summary>
[Obsolete("Use db.SingleAsync(db.From<T>())")]
public static Task<T> SingleAsync<T>(this IDbConnection dbConn, Func<SqlExpression<T>, SqlExpression<T>> expression, CancellationToken token = default)
{
return dbConn.Exec(dbCmd => dbCmd.SingleAsync(expression, token));
}
/// <summary>
/// Returns the first result using a SqlFormat query. E.g:
/// <para>db.SingleFmt<Person>("Age = {0}", 42)</para>
/// </summary>
[Obsolete("Use db.SingleAsync(\"Age = @age\", new { age = 42 })")]
public static Task<T> SingleFmtAsync<T>(this IDbConnection dbConn, CancellationToken token, string sqlFormat, params object[] filterParams)
{
return dbConn.Exec(dbCmd => dbCmd.SingleFmtAsync<T>(token, sqlFormat, filterParams));
}
[Obsolete("Use db.SingleAsync(\"Age = @age\", new { age = 42 })")]
public static Task<T> SingleFmtAsync<T>(this IDbConnection dbConn, string sqlFormat, params object[] filterParams)
{
return dbConn.Exec(dbCmd => dbCmd.SingleFmtAsync<T>(default(CancellationToken), sqlFormat, filterParams));
}
/// <summary>
/// Returns the count of rows that match the SqlExpression lambda, E.g:
/// <para>db.Count<Person>(q => q.Where(x => x.Age < 50))</para>
/// </summary>
[Obsolete("Use db.CountAsync(db.From<T>())")]
public static Task<long> CountAsync<T>(this IDbConnection dbConn, Func<SqlExpression<T>, SqlExpression<T>> expression, CancellationToken token = default)
{
return dbConn.Exec(dbCmd => dbCmd.CountAsync(expression, token));
}
/// <summary>
/// Returns results with references from using an SqlExpression lambda. E.g:
/// <para>db.LoadSelectAsync<Person>(q => q.Where(x => x.Age > 40))</para>
/// </summary>
[Obsolete("Use db.LoadSelectAsync(db.From<T>())")]
public static Task<List<T>> LoadSelectAsync<T>(this IDbConnection dbConn, Func<SqlExpression<T>, SqlExpression<T>> expression, string[] include = null, CancellationToken token = default)
{
return dbConn.Exec(dbCmd => dbCmd.LoadSelectAsync(expression, include, token));
}
}
}
#endif