OrmLiteReadExpressionsApiAsyncLegacy
Assembly: ServiceStack.OrmLite.dll
View Source
Declaration
public static class OrmLiteReadExpressionsApiAsyncLegacy : object
Methods
SelectAsync<T>(IDbConnection, Func<SqlExpression<T>, SqlExpression<T>>, CancellationToken)
Returns results from using an SqlExpression lambda. E.g: <p>db.Select<Person>(q => q.Where(x => x.Age > 40))</p>
View Source
Declaration
public static Task<List<T>> SelectAsync<T>(this IDbConnection dbConn, Func<SqlExpression<T>, SqlExpression<T>> expression, CancellationToken token = null)
Returns
Task<List<<T>>>
Parameters
| Type | Name |
|---|---|
IDbConnection | dbConn |
Func<ServiceStack.OrmLite.SqlExpression<<T>>,ServiceStack.OrmLite.SqlExpression<<T>>> | expression |
CancellationToken | token |
Type Parameters
T
SelectAsync<Into, From>(IDbConnection, Func<SqlExpression<From>, SqlExpression<From>>, CancellationToken)
Project results from a number of joined tables into a different model
View Source
Declaration
public static Task<List<Into>> SelectAsync<Into, From>(this IDbConnection dbConn, Func<SqlExpression<From>, SqlExpression<From>> expression, CancellationToken token = null)
Returns
Task<List<<Into>>>
Parameters
| Type | Name |
|---|---|
IDbConnection | dbConn |
Func<ServiceStack.OrmLite.SqlExpression<<From>>,ServiceStack.OrmLite.SqlExpression<<From>>> | expression |
CancellationToken | token |
Type Parameters
IntoFrom
SingleAsync<T>(IDbConnection, Func<SqlExpression<T>, SqlExpression<T>>, CancellationToken)
Returns a single result from using an SqlExpression lambda. E.g: <p>db.Single<Person>(q => q.Where(x => x.Age == 42))</p>
View Source
Declaration
public static Task<T> SingleAsync<T>(this IDbConnection dbConn, Func<SqlExpression<T>, SqlExpression<T>> expression, CancellationToken token = null)
Returns
Task<<T>>
Parameters
| Type | Name |
|---|---|
IDbConnection | dbConn |
Func<ServiceStack.OrmLite.SqlExpression<<T>>,ServiceStack.OrmLite.SqlExpression<<T>>> | expression |
CancellationToken | token |
Type Parameters
T
SingleFmtAsync<T>(IDbConnection, CancellationToken, String, Object[])
Returns the first result using a SqlFormat query. E.g: <p>db.SingleFmt<Person>("Age = {0}", 42)</p>
View Source
Declaration
public static Task<T> SingleFmtAsync<T>(this IDbConnection dbConn, CancellationToken token, string sqlFormat, params object[] filterParams)
Returns
Task<<T>>
Parameters
| Type | Name |
|---|---|
IDbConnection | dbConn |
CancellationToken | token |
System.String | sqlFormat |
System.Object[] | filterParams |
Type Parameters
T
SingleFmtAsync<T>(IDbConnection, String, Object[])
View Source
Declaration
public static Task<T> SingleFmtAsync<T>(this IDbConnection dbConn, string sqlFormat, params object[] filterParams)
Returns
Task<<T>>
Parameters
| Type | Name |
|---|---|
IDbConnection | dbConn |
System.String | sqlFormat |
System.Object[] | filterParams |
Type Parameters
T
CountAsync<T>(IDbConnection, Func<SqlExpression<T>, SqlExpression<T>>, CancellationToken)
Returns the count of rows that match the SqlExpression lambda, E.g: <p>db.Count<Person>(q => q.Where(x => x.Age < 50))</p>
View Source
Declaration
public static Task<long> CountAsync<T>(this IDbConnection dbConn, Func<SqlExpression<T>, SqlExpression<T>> expression, CancellationToken token = null)
Returns
Task<System.Int64>
Parameters
| Type | Name |
|---|---|
IDbConnection | dbConn |
Func<ServiceStack.OrmLite.SqlExpression<<T>>,ServiceStack.OrmLite.SqlExpression<<T>>> | expression |
CancellationToken | token |
Type Parameters
T
LoadSelectAsync<T>(IDbConnection, Func<SqlExpression<T>, SqlExpression<T>>, String[], CancellationToken)
Returns results with references from using an SqlExpression lambda. E.g: <p>db.LoadSelectAsync<Person>(q => q.Where(x => x.Age > 40))</p>
View Source
Declaration
public static Task<List<T>> LoadSelectAsync<T>(this IDbConnection dbConn, Func<SqlExpression<T>, SqlExpression<T>> expression, string[] include = null, CancellationToken token = null)
Returns
Task<List<<T>>>
Parameters
| Type | Name |
|---|---|
IDbConnection | dbConn |
Func<ServiceStack.OrmLite.SqlExpression<<T>>,ServiceStack.OrmLite.SqlExpression<<T>>> | expression |
System.String[] | include |
CancellationToken | token |
Type Parameters
T