OrmLiteReadExpressionsApiLegacy
Assembly: ServiceStack.OrmLite.dll
View Source
public static class OrmLiteReadExpressionsApiLegacy : object
Methods
SqlExpression<T>(IDbConnection)
Create a new SqlExpression builder allowing typed LINQ-like queries.
View Source
public static SqlExpression<T> SqlExpression<T>(this IDbConnection dbConn)
Returns
ServiceStack.OrmLite.SqlExpression<T>
Parameters
Type | Name |
---|---|
IDbConnection | dbConn |
Type Parameters
T
Select<T>(IDbConnection, Func<SqlExpression<T>, SqlExpression<T>>)
Returns results from using an SqlExpression lambda. E.g: <p>db.Select<Person>(q => q.Where(x => x.Age > 40))</p>
View Source
public static List<T> Select<T>(this IDbConnection dbConn, Func<SqlExpression<T>, SqlExpression<T>> expression)
Returns
List<<T>>
Parameters
Type | Name |
---|---|
IDbConnection | dbConn |
Func<ServiceStack.OrmLite.SqlExpression<<T>>,ServiceStack.OrmLite.SqlExpression<<T>>> | expression |
Type Parameters
T
Select<Into, From>(IDbConnection, SqlExpression<From>)
Project results from a number of joined tables into a different model
View Source
public static List<Into> Select<Into, From>(this IDbConnection dbConn, SqlExpression<From> expression)
Returns
List<<Into>>
Parameters
Type | Name |
---|---|
IDbConnection | dbConn |
ServiceStack.OrmLite.SqlExpression<T> | expression |
Type Parameters
Into
From
Select<Into, From>(IDbConnection, Func<SqlExpression<From>, SqlExpression<From>>)
Project results from a number of joined tables into a different model
View Source
public static List<Into> Select<Into, From>(this IDbConnection dbConn, Func<SqlExpression<From>, SqlExpression<From>> expression)
Returns
List<<Into>>
Parameters
Type | Name |
---|---|
IDbConnection | dbConn |
Func<ServiceStack.OrmLite.SqlExpression<<From>>,ServiceStack.OrmLite.SqlExpression<<From>>> | expression |
Type Parameters
Into
From
Single<T>(IDbConnection, Func<SqlExpression<T>, SqlExpression<T>>)
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
public static T Single<T>(this IDbConnection dbConn, Func<SqlExpression<T>, SqlExpression<T>> expression)
Returns
<T>
Parameters
Type | Name |
---|---|
IDbConnection | dbConn |
Func<ServiceStack.OrmLite.SqlExpression<<T>>,ServiceStack.OrmLite.SqlExpression<<T>>> | expression |
Type Parameters
T
Count<T>(IDbConnection, Func<SqlExpression<T>, SqlExpression<T>>)
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
public static long Count<T>(this IDbConnection dbConn, Func<SqlExpression<T>, SqlExpression<T>> expression)
Returns
System.Int64
Parameters
Type | Name |
---|---|
IDbConnection | dbConn |
Func<ServiceStack.OrmLite.SqlExpression<<T>>,ServiceStack.OrmLite.SqlExpression<<T>>> | expression |
Type Parameters
T
LoadSelect<T>(IDbConnection, Func<SqlExpression<T>, SqlExpression<T>>, IEnumerable<String>)
Returns results with references from using an SqlExpression lambda. E.g: <p>db.LoadSelect<Person>(q => q.Where(x => x.Age > 40))</p>
View Source
public static List<T> LoadSelect<T>(this IDbConnection dbConn, Func<SqlExpression<T>, SqlExpression<T>> expression, IEnumerable<string> include = null)
Returns
List<<T>>
Parameters
Type | Name |
---|---|
IDbConnection | dbConn |
Func<ServiceStack.OrmLite.SqlExpression<<T>>,ServiceStack.OrmLite.SqlExpression<<T>>> | expression |
IEnumerable<System.String> | include |
Type Parameters
T
LoadSelect<T>(IDbConnection, Func<SqlExpression<T>, SqlExpression<T>>, Func<T, Object>)
Returns results with references from using an SqlExpression lambda. E.g: <p>db.LoadSelect<Person>(q => q.Where(x => x.Age > 40), include: x => new { x.PrimaryAddress })</p>
View Source
public static List<T> LoadSelect<T>(this IDbConnection dbConn, Func<SqlExpression<T>, SqlExpression<T>> expression, Func<T, object> include)
Returns
List<<T>>
Parameters
Type | Name |
---|---|
IDbConnection | dbConn |
Func<ServiceStack.OrmLite.SqlExpression<<T>>,ServiceStack.OrmLite.SqlExpression<<T>>> | expression |
Func<<T>,System.Object> | include |
Type Parameters
T