Skip to main content

OrmLiteReadApiAsyncLegacy

Assembly: ServiceStack.OrmLite.dll​
View Source​
Declaration
public static class OrmLiteReadApiAsyncLegacy : object

Methods​

SelectFmtAsync<T>(IDbConnection, CancellationToken, 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 Task<List<T>> SelectFmtAsync<T>(this IDbConnection dbConn, CancellationToken token, string sqlFormat, params object[] filterParams)
Returns​

Task<List<<T>>>

Parameters​
TypeName
IDbConnectiondbConn
CancellationTokentoken
System.StringsqlFormat
System.Object[]filterParams
Type Parameters​
  • T

SelectFmtAsync<T>(IDbConnection, String, Object[])​

View Source​
Declaration
public static Task<List<T>> SelectFmtAsync<T>(this IDbConnection dbConn, string sqlFormat, params object[] filterParams)
Returns​

Task<List<<T>>>

Parameters​
TypeName
IDbConnectiondbConn
System.StringsqlFormat
System.Object[]filterParams
Type Parameters​
  • T

SelectFmtAsync<TModel>(IDbConnection, CancellationToken, 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 Task<List<TModel>> SelectFmtAsync<TModel>(this IDbConnection dbConn, CancellationToken token, Type fromTableType, string sqlFormat, params object[] filterParams)
Returns​

Task<List<<TModel>>>

Parameters​
TypeName
IDbConnectiondbConn
CancellationTokentoken
TypefromTableType
System.StringsqlFormat
System.Object[]filterParams
Type Parameters​
  • TModel

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

View Source​
Declaration
public static Task<List<TModel>> SelectFmtAsync<TModel>(this IDbConnection dbConn, Type fromTableType, string sqlFormat, params object[] filterParams)
Returns​

Task<List<<TModel>>>

Parameters​
TypeName
IDbConnectiondbConn
TypefromTableType
System.StringsqlFormat
System.Object[]filterParams
Type Parameters​
  • TModel

ScalarFmtAsync<T>(IDbConnection, CancellationToken, 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 Task<T> ScalarFmtAsync<T>(this IDbConnection dbConn, CancellationToken token, string sqlFormat, params object[] sqlParams)
Returns​

Task<<T>>

Parameters​
TypeName
IDbConnectiondbConn
CancellationTokentoken
System.StringsqlFormat
System.Object[]sqlParams
Type Parameters​
  • T

ScalarFmtAsync<T>(IDbConnection, String, Object[])​

View Source​
Declaration
public static Task<T> ScalarFmtAsync<T>(this IDbConnection dbConn, string sqlFormat, params object[] sqlParams)
Returns​

Task<<T>>

Parameters​
TypeName
IDbConnectiondbConn
System.StringsqlFormat
System.Object[]sqlParams
Type Parameters​
  • T

ColumnFmtAsync<T>(IDbConnection, CancellationToken, 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 Task<List<T>> ColumnFmtAsync<T>(this IDbConnection dbConn, CancellationToken token, string sqlFormat, params object[] sqlParams)
Returns​

Task<List<<T>>>

Parameters​
TypeName
IDbConnectiondbConn
CancellationTokentoken
System.StringsqlFormat
System.Object[]sqlParams
Type Parameters​
  • T

ColumnFmtAsync<T>(IDbConnection, String, Object[])​

View Source​
Declaration
public static Task<List<T>> ColumnFmtAsync<T>(this IDbConnection dbConn, string sqlFormat, params object[] sqlParams)
Returns​

Task<List<<T>>>

Parameters​
TypeName
IDbConnectiondbConn
System.StringsqlFormat
System.Object[]sqlParams
Type Parameters​
  • T

ColumnDistinctFmtAsync<T>(IDbConnection, CancellationToken, 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 Task<HashSet<T>> ColumnDistinctFmtAsync<T>(this IDbConnection dbConn, CancellationToken token, string sqlFormat, params object[] sqlParams)
Returns​

Task<HashSet<<T>>>

Parameters​
TypeName
IDbConnectiondbConn
CancellationTokentoken
System.StringsqlFormat
System.Object[]sqlParams
Type Parameters​
  • T

ColumnDistinctFmtAsync<T>(IDbConnection, String, Object[])​

View Source​
Declaration
public static Task<HashSet<T>> ColumnDistinctFmtAsync<T>(this IDbConnection dbConn, string sqlFormat, params object[] sqlParams)
Returns​

Task<HashSet<<T>>>

Parameters​
TypeName
IDbConnectiondbConn
System.StringsqlFormat
System.Object[]sqlParams
Type Parameters​
  • T

LookupFmtAsync<K, V>(IDbConnection, CancellationToken, 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 Task<Dictionary<K, List<V>>> LookupFmtAsync<K, V>(this IDbConnection dbConn, CancellationToken token, string sqlFormat, params object[] sqlParams)
Returns​

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

Parameters​
TypeName
IDbConnectiondbConn
CancellationTokentoken
System.StringsqlFormat
System.Object[]sqlParams
Type Parameters​
  • K
  • V

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

View Source​
Declaration
public static Task<Dictionary<K, List<V>>> LookupFmtAsync<K, V>(this IDbConnection dbConn, string sqlFormat, params object[] sqlParams)
Returns​

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

Parameters​
TypeName
IDbConnectiondbConn
System.StringsqlFormat
System.Object[]sqlParams
Type Parameters​
  • K
  • V

DictionaryFmtAsync<K, V>(IDbConnection, CancellationToken, 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 Task<Dictionary<K, V>> DictionaryFmtAsync<K, V>(this IDbConnection dbConn, CancellationToken token, string sqlFormat, params object[] sqlParams)
Returns​

Task<Dictionary<<K>,<V>>>

Parameters​
TypeName
IDbConnectiondbConn
CancellationTokentoken
System.StringsqlFormat
System.Object[]sqlParams
Type Parameters​
  • K
  • V

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

View Source​
Declaration
public static Task<Dictionary<K, V>> DictionaryFmtAsync<K, V>(this IDbConnection dbConn, string sqlFormat, params object[] sqlParams)
Returns​

Task<Dictionary<<K>,<V>>>

Parameters​
TypeName
IDbConnectiondbConn
System.StringsqlFormat
System.Object[]sqlParams
Type Parameters​
  • K
  • V

ExistsFmtAsync<T>(IDbConnection, CancellationToken, 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 Task<bool> ExistsFmtAsync<T>(this IDbConnection dbConn, CancellationToken token, string sqlFormat, params object[] filterParams)
Returns​

Task<System.Boolean>

Parameters​
TypeName
IDbConnectiondbConn
CancellationTokentoken
System.StringsqlFormat
System.Object[]filterParams
Type Parameters​
  • T

ExistsFmtAsync<T>(IDbConnection, String, Object[])​

View Source​
Declaration
public static Task<bool> ExistsFmtAsync<T>(this IDbConnection dbConn, string sqlFormat, params object[] filterParams)
Returns​

Task<System.Boolean>

Parameters​
TypeName
IDbConnectiondbConn
System.StringsqlFormat
System.Object[]filterParams
Type Parameters​
  • T

ExistsAsync<T>(IDbConnection, Func<SqlExpression<T>, SqlExpression<T>>, CancellationToken)​

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 Task<bool> ExistsAsync<T>(this IDbConnection dbConn, Func<SqlExpression<T>, SqlExpression<T>> expression, CancellationToken token = null)
Returns​

Task<System.Boolean>

Parameters​
TypeName
IDbConnectiondbConn
Func<ServiceStack.OrmLite.SqlExpression<<T>>,ServiceStack.OrmLite.SqlExpression<<T>>>expression
CancellationTokentoken
Type Parameters​
  • T

SqlProcedureFmtAsync<TOutputModel>(IDbConnection, CancellationToken, Object, String, Object[])​

Returns results from a Stored Procedure using an SqlFormat query. E.g: <p></p>

View Source​
Declaration
public static Task<List<TOutputModel>> SqlProcedureFmtAsync<TOutputModel>(this IDbConnection dbConn, CancellationToken token, object anonType, string sqlFilter, params object[] filterParams)
    where TOutputModel : new()
Returns​

Task<List<<TOutputModel>>>

Parameters​
TypeName
IDbConnectiondbConn
CancellationTokentoken
System.ObjectanonType
System.StringsqlFilter
System.Object[]filterParams
Type Parameters​
  • TOutputModel