OrmLiteReadApiLegacy

Assembly: ServiceStack.OrmLite.dll

View Source

Declaration

public static class OrmLiteReadApiLegacy : object

Methods

SelectFmt<T>(IDbConnection, String, Object[])

Returns results from using an SqlFormat query. E.g: <p>db.SelectFmt<Person>("Age > {0}", 40)</p> <p>db.SelectFmt<Person>("SELECT * FROM Person WHERE Age > {0}", 40)</p>

View Source

Declaration

public static List<T> SelectFmt<T>(this IDbConnection dbConn, string sqlFormat, params object[] filterParams)

Returns

List<<T>>

Parameters

Type	Name
IDbConnection	dbConn
System.String	sqlFormat
System.Object[]	filterParams

Type Parameters

• T

SelectFmt<TModel>(IDbConnection, Type, String, Object[])

Returns a partial subset of results from the specified tableType using a SqlFormat query. E.g: <p>db.SelectFmt<EntityWithId>(typeof(Person), "Age > {0}", 40)</p>

View Source

Declaration

public static List<TModel> SelectFmt<TModel>(this IDbConnection dbConn, Type fromTableType, string sqlFormat, params object[] filterParams)

Returns

List<<TModel>>

Parameters

Type	Name
IDbConnection	dbConn
Type	fromTableType
System.String	sqlFormat
System.Object[]	filterParams

Type Parameters

• TModel

SelectLazyFmt<T>(IDbConnection, String, Object[])

Returns a lazily loaded stream of results using an SqlFilter query. E.g: <p>db.SelectLazyFmt<Person>("Age > {0}", 40)</p>

View Source

Declaration

public static IEnumerable<T> SelectLazyFmt<T>(this IDbConnection dbConn, string sqlFormat, params object[] filterParams)

Returns

IEnumerable<<T>>

Parameters

Type	Name
IDbConnection	dbConn
System.String	sqlFormat
System.Object[]	filterParams

Type Parameters

• T

SingleFmt<T>(IDbConnection, 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 T SingleFmt<T>(this IDbConnection dbConn, string sqlFormat, params object[] filterParams)

Returns

<T>

Parameters

Type	Name
IDbConnection	dbConn
System.String	sqlFormat
System.Object[]	filterParams

Type Parameters

• T

ScalarFmt<T>(IDbConnection, String, Object[])

Returns a single scalar value using an SqlFormat query. E.g: <p>db.ScalarFmt<int>("SELECT COUNT(*) FROM Person WHERE Age > {0}", 40)</p>

View Source

Declaration

public static T ScalarFmt<T>(this IDbConnection dbConn, string sqlFormat, params object[] sqlParams)

Returns

<T>

Parameters

Type	Name
IDbConnection	dbConn
System.String	sqlFormat
System.Object[]	sqlParams

Type Parameters

• T

ColumnFmt<T>(IDbConnection, String, Object[])

Returns the first column in a List using a SqlFormat query. E.g: <p>db.ColumnFmt<string>("SELECT LastName FROM Person WHERE Age = {0}", 27)</p>

View Source

Declaration

public static List<T> ColumnFmt<T>(this IDbConnection dbConn, string sqlFormat, params object[] sqlParams)

Returns

List<<T>>

Parameters

Type	Name
IDbConnection	dbConn
System.String	sqlFormat
System.Object[]	sqlParams

Type Parameters

• T

ColumnDistinctFmt<T>(IDbConnection, String, Object[])

Returns the distinct first column values in a HashSet using an SqlFormat query. E.g: <p>db.ColumnDistinctFmt<int>("SELECT Age FROM Person WHERE Age < {0}", 50)</p>

View Source

Declaration

public static HashSet<T> ColumnDistinctFmt<T>(this IDbConnection dbConn, string sqlFormat, params object[] sqlParams)

Returns

HashSet<<T>>

Parameters

Type	Name
IDbConnection	dbConn
System.String	sqlFormat
System.Object[]	sqlParams

Type Parameters

• T

LookupFmt<K, V>(IDbConnection, String, Object[])

Returns an Dictionary<K, List<V>> grouping made from the first two columns using an SqlFormat query. E.g: <p>db.LookupFmt<int, string>("SELECT Age, LastName FROM Person WHERE Age < {0}", 50)</p>

View Source

Declaration

public static Dictionary<K, List<V>> LookupFmt<K, V>(this IDbConnection dbConn, string sqlFormat, params object[] sqlParams)

Returns

Dictionary<<K>,List<<V>>>

Parameters

Type	Name
IDbConnection	dbConn
System.String	sqlFormat
System.Object[]	sqlParams

Type Parameters

• K
• V

DictionaryFmt<K, V>(IDbConnection, String, Object[])

Returns a Dictionary from the first 2 columns: Column 1 (Keys), Column 2 (Values) using an SqlFormat query. E.g: <p>db.DictionaryFmt<int, string>("SELECT Id, LastName FROM Person WHERE Age < {0}", 50)</p>

View Source

Declaration

public static Dictionary<K, V> DictionaryFmt<K, V>(this IDbConnection dbConn, string sqlFormat, params object[] sqlParams)

Returns

Dictionary<<K>,<V>>

Parameters

Type	Name
IDbConnection	dbConn
System.String	sqlFormat
System.Object[]	sqlParams

Type Parameters

• K
• V

ExistsFmt<T>(IDbConnection, String, Object[])

Returns true if the Query returns any records, using an SqlFormat query. E.g: <p>db.ExistsFmt<Person>("Age = {0}", 42)</p> <p>db.ExistsFmt<Person>("SELECT * FROM Person WHERE Age = {0}", 50)</p>

View Source

Declaration

public static bool ExistsFmt<T>(this IDbConnection dbConn, string sqlFormat, params object[] filterParams)

Returns

System.Boolean

Parameters

Type	Name
IDbConnection	dbConn
System.String	sqlFormat
System.Object[]	filterParams

Type Parameters

• T

Exists<T>(IDbConnection, Func<SqlExpression<T>, SqlExpression<T>>)

Returns true if the Query returns any records that match the SqlExpression lambda, E.g: <p>db.Exists<Person>(q => q.Where(x => x.Age < 50))</p>

View Source

Declaration

public static bool Exists<T>(this IDbConnection dbConn, Func<SqlExpression<T>, SqlExpression<T>> expression)

Returns

System.Boolean

Parameters

Type	Name
IDbConnection	dbConn
Func<ServiceStack.OrmLite.SqlExpression<<T>>,ServiceStack.OrmLite.SqlExpression<<T>>>	expression

Type Parameters

• T