SqlExpression<T>

Assembly: ServiceStack.OrmLite.dll

View Source

Declaration
public abstract class SqlExpression<T> : object, ISqlExpression, IHasUntypedSqlExpression, IHasDialectProvider

Properties

OnlyFields

View Source

Declaration
public HashSet<string> OnlyFields { get; protected set; }

UpdateFields

View Source

Declaration
public List<string> UpdateFields { get; set; }

InsertFields

View Source

Declaration
public List<string> InsertFields { get; set; }

TableAlias

View Source

Declaration
public string TableAlias { get; set; }

DialectProvider

View Source

Declaration
public IOrmLiteDialectProvider DialectProvider { get; set; }

Params

View Source

Declaration
public List<IDbDataParameter> Params { get; set; }

SqlFilter

View Source

Declaration
public Func<string, string> SqlFilter { get; set; }

SelectFilter

View Source

Declaration
public static Action<SqlExpression<T>> SelectFilter { get; set; }

Rows

View Source

Declaration
public int? Rows { get; set; }

Offset

View Source

Declaration
public int? Offset { get; set; }

PrefixFieldWithTableName

View Source

Declaration
public bool PrefixFieldWithTableName { get; set; }

UseSelectPropertiesAsAliases

View Source

Declaration
public bool UseSelectPropertiesAsAliases { get; set; }

WhereStatementWithoutWhereString

View Source

Declaration
public bool WhereStatementWithoutWhereString { get; set; }

CustomSelect

View Source

Declaration
protected bool CustomSelect { get; set; }

Sep

View Source

Declaration
protected string Sep { get; }

SelectExpression

View Source

Declaration
public string SelectExpression { get; set; }

FromExpression

View Source

Declaration
public string FromExpression { get; set; }

BodyExpression

View Source

Declaration
public string BodyExpression { get; }

WhereExpression

View Source

Declaration
public string WhereExpression { get; set; }

GroupByExpression

View Source

Declaration
public string GroupByExpression { get; set; }

HavingExpression

View Source

Declaration
public string HavingExpression { get; set; }

OrderByExpression

View Source

Declaration
public string OrderByExpression { get; set; }

ModelDef

View Source

Declaration
public ModelDefinition ModelDef { get; protected set; }

UseFieldName

View Source

Declaration
protected bool UseFieldName { get; set; }

Fields

TrueLiteral

View Source

Declaration
public const string TrueLiteral = null

FalseLiteral

View Source

Declaration
public const string FalseLiteral = null

modelDef

View Source

Declaration

protected ModelDefinition modelDef

useFieldName

View Source

Declaration
protected bool useFieldName

selectDistinct

View Source

Declaration
protected bool selectDistinct

visitedExpressionIsTableColumn

View Source

Declaration
protected bool visitedExpressionIsTableColumn

skipParameterizationForThisExpression

View Source

Declaration
protected bool skipParameterizationForThisExpression

isSelectExpression

View Source

Declaration
protected bool isSelectExpression

tableDefs

View Source

Declaration
protected List<ModelDefinition> tableDefs

Methods

Clone()

View Source

Declaration
public SqlExpression<T> Clone()

Returns

ServiceStack.OrmLite.SqlExpression<T>

AddTag(String)

View Source

Declaration
public virtual void AddTag(string tag)

Parameters

Type	Name
`System.String`	tag

CopyTo(SqlExpression<T>)

View Source

Declaration
protected virtual SqlExpression<T> CopyTo(SqlExpression<T> to)

Returns

ServiceStack.OrmLite.SqlExpression<T>

Parameters

Type	Name
ServiceStack.OrmLite.SqlExpression<T>	to

ComputeHash(Boolean)

Generate a unique SHA1 hash of expression with param values for caching

View Source

Declaration
public string ComputeHash(bool includeParams = true)

Returns

System.String

Parameters

Type	Name
`System.Boolean`	includeParams

Dump(Boolean)

Dump internal state of this SqlExpression into a string

View Source

Declaration
public string Dump(bool includeParams)

Returns

System.String

Parameters

Type	Name
`System.Boolean`	includeParams

Select()

Clear select expression. All properties will be selected.

View Source

Declaration
public virtual SqlExpression<T> Select()

Returns

ServiceStack.OrmLite.SqlExpression<T>

Select(String)

set the specified selectExpression.

View Source

Declaration
public virtual SqlExpression<T> Select(string selectExpression)

Returns

ServiceStack.OrmLite.SqlExpression<T>

Parameters

Type	Name	Description
`System.String`	selectExpression

raw Select expression: "SomeField1, SomeField2 from SomeTable"

SelectDistinct(String)

set the specified DISTINCT selectExpression.

View Source

Declaration
public virtual SqlExpression<T> SelectDistinct(string selectExpression)

Returns

ServiceStack.OrmLite.SqlExpression<T>

Parameters

Type	Name	Description
`System.String`	selectExpression

raw Select expression: "SomeField1, SomeField2 from SomeTable"

UnsafeSelect(String)

View Source

Declaration
public virtual SqlExpression<T> UnsafeSelect(string rawSelect)

Returns

ServiceStack.OrmLite.SqlExpression<T>

Parameters

Type	Name
`System.String`	rawSelect

UnsafeSelect(String, Boolean)

View Source

Declaration
public virtual SqlExpression<T> UnsafeSelect(string rawSelect, bool distinct)

Returns

ServiceStack.OrmLite.SqlExpression<T>

Parameters

Type	Name
`System.String`	rawSelect
`System.Boolean`	distinct

Select(String[])

Set the specified selectExpression using matching fields.

View Source

Declaration
public virtual SqlExpression<T> Select(string[] fields)

Returns

ServiceStack.OrmLite.SqlExpression<T>

Parameters

Type	Name	Description
`System.String[]`	fields

Matching Fields: "SomeField1, SomeField2"

SelectDistinct(String[])

Set the specified DISTINCT selectExpression using matching fields.

View Source

Declaration
public virtual SqlExpression<T> SelectDistinct(string[] fields)

Returns

ServiceStack.OrmLite.SqlExpression<T>

Parameters

Type	Name	Description
`System.String[]`	fields

Matching Fields: "SomeField1, SomeField2"

Select(Expression<Func<T, Object>>)

Fields to be selected.

View Source

Declaration
public virtual SqlExpression<T> Select(Expression<Func<T, object>> fields)

Returns

ServiceStack.OrmLite.SqlExpression<T>

Parameters

Type	Name	Description
`Expression<Func<<T>,System.Object>>`	fields

x=> x.SomeProperty1 or x=> new{ x.SomeProperty1, x.SomeProperty2}

Select<Table1>(Expression<Func<Table1, Object>>)

View Source

Declaration
public virtual SqlExpression<T> Select<Table1>(Expression<Func<Table1, object>> fields)

Returns

ServiceStack.OrmLite.SqlExpression<T>

Parameters

Type	Name
`Expression<Func<<Table1>,System.Object>>`	fields

Type Parameters

Table1

Select<Table1, Table2>(Expression<Func<Table1, Table2, Object>>)

View Source

Declaration
public virtual SqlExpression<T> Select<Table1, Table2>(Expression<Func<Table1, Table2, object>> fields)

Returns

ServiceStack.OrmLite.SqlExpression<T>

Parameters

Type	Name
`Expression<Func<<Table1>,<Table2>,System.Object>>`	fields

Type Parameters

Table1
Table2

Select<Table1, Table2, Table3>(Expression<Func<Table1, Table2, Table3, Object>>)

View Source

Declaration
public virtual SqlExpression<T> Select<Table1, Table2, Table3>(Expression<Func<Table1, Table2, Table3, object>> fields)

Returns

ServiceStack.OrmLite.SqlExpression<T>

Parameters

Type	Name
`Expression<Func<<Table1>,<Table2>,<Table3>,System.Object>>`	fields

Type Parameters

Table1
Table2
Table3

Select<Table1, Table2, Table3, Table4>(Expression<Func<Table1, Table2, Table3, Table4, Object>>)

View Source

Declaration
public virtual SqlExpression<T> Select<Table1, Table2, Table3, Table4>(Expression<Func<Table1, Table2, Table3, Table4, object>> fields)

Returns

ServiceStack.OrmLite.SqlExpression<T>

Parameters

Type	Name
`Expression<Func<<Table1>,<Table2>,<Table3>,<Table4>,System.Object>>`	fields

Type Parameters

Table1
Table2
Table3
Table4

Select<Table1, Table2, Table3, Table4, Table5>(Expression<Func<Table1, Table2, Table3, Table4, Table5, Object>>)

View Source

Declaration
public virtual SqlExpression<T> Select<Table1, Table2, Table3, Table4, Table5>(Expression<Func<Table1, Table2, Table3, Table4, Table5, object>> fields)

Returns

ServiceStack.OrmLite.SqlExpression<T>

Parameters

Type	Name
`Expression<Func<<Table1>,<Table2>,<Table3>,<Table4>,<Table5>,System.Object>>`	fields

Type Parameters

Table1
Table2
Table3
Table4
Table5

Select<Table1, Table2, Table3, Table4, Table5, Table6>(Expression<Func<Table1, Table2, Table3, Table4, Table5, Table6, Object>>)

View Source

Declaration
public virtual SqlExpression<T> Select<Table1, Table2, Table3, Table4, Table5, Table6>(Expression<Func<Table1, Table2, Table3, Table4, Table5, Table6, object>> fields)

Returns

ServiceStack.OrmLite.SqlExpression<T>

Parameters

Type	Name
`Expression<Func<<Table1>,<Table2>,<Table3>,<Table4>,<Table5>,<Table6>,System.Object>>`	fields

Type Parameters

Table1
Table2
Table3
Table4
Table5
Table6

Select<Table1, Table2, Table3, Table4, Table5, Table6, Table7>(Expression<Func<Table1, Table2, Table3, Table4, Table5, Table6, Table7, Object>>)

View Source

Declaration
public virtual SqlExpression<T> Select<Table1, Table2, Table3, Table4, Table5, Table6, Table7>(Expression<Func<Table1, Table2, Table3, Table4, Table5, Table6, Table7, object>> fields)

Returns

ServiceStack.OrmLite.SqlExpression<T>

Parameters

Type	Name
`Expression<Func<<Table1>,<Table2>,<Table3>,<Table4>,<Table5>,<Table6>,<Table7>,System.Object>>`	fields

Type Parameters

Table1
Table2
Table3
Table4
Table5
Table6
Table7

Select<Table1, Table2, Table3, Table4, Table5, Table6, Table7, Table8>(Expression<Func<Table1, Table2, Table3, Table4, Table5, Table6, Table7, Table8, Object>>)

View Source

Declaration
public virtual SqlExpression<T> Select<Table1, Table2, Table3, Table4, Table5, Table6, Table7, Table8>(Expression<Func<Table1, Table2, Table3, Table4, Table5, Table6, Table7, Table8, object>> fields)

Returns

ServiceStack.OrmLite.SqlExpression<T>

Parameters

Type	Name
`Expression<Func<<Table1>,<Table2>,<Table3>,<Table4>,<Table5>,<Table6>,<Table7>,<Table8>,System.Object>>`	fields

Type Parameters

Table1
Table2
Table3
Table4
Table5
Table6
Table7
Table8

Select<Table1, Table2, Table3, Table4, Table5, Table6, Table7, Table8, Table9>(Expression<Func<Table1, Table2, Table3, Table4, Table5, Table6, Table7, Table8, Table9, Object>>)

View Source

Declaration
public virtual SqlExpression<T> Select<Table1, Table2, Table3, Table4, Table5, Table6, Table7, Table8, Table9>(Expression<Func<Table1, Table2, Table3, Table4, Table5, Table6, Table7, Table8, Table9, object>> fields)

Returns

ServiceStack.OrmLite.SqlExpression<T>

Parameters

Type	Name
`Expression<Func<<Table1>,<Table2>,<Table3>,<Table4>,<Table5>,<Table6>,<Table7>,<Table8>,<Table9>,System.Object>>`	fields

Type Parameters

Table1
Table2
Table3
Table4
Table5
Table6
Table7
Table8
Table9

Select<Table1, Table2, Table3, Table4, Table5, Table6, Table7, Table8, Table9, Table10>(Expression<Func<Table1, Table2, Table3, Table4, Table5, Table6, Table7, Table8, Table9, Table10, Object>>)

View Source

Declaration
public virtual SqlExpression<T> Select<Table1, Table2, Table3, Table4, Table5, Table6, Table7, Table8, Table9, Table10>(Expression<Func<Table1, Table2, Table3, Table4, Table5, Table6, Table7, Table8, Table9, Table10, object>> fields)

Returns

ServiceStack.OrmLite.SqlExpression<T>

Parameters

Type	Name
`Expression<Func<<Table1>,<Table2>,<Table3>,<Table4>,<Table5>,<Table6>,<Table7>,<Table8>,<Table9>,<Table10>,System.Object>>`	fields

Type Parameters

Table1
Table2
Table3
Table4
Table5
Table6
Table7
Table8
Table9
Table10

Select<Table1, Table2, Table3, Table4, Table5, Table6, Table7, Table8, Table9, Table10, Table11>(Expression<Func<Table1, Table2, Table3, Table4, Table5, Table6, Table7, Table8, Table9, Table10, Table11, Object>>)

View Source

Declaration
public virtual SqlExpression<T> Select<Table1, Table2, Table3, Table4, Table5, Table6, Table7, Table8, Table9, Table10, Table11>(Expression<Func<Table1, Table2, Table3, Table4, Table5, Table6, Table7, Table8, Table9, Table10, Table11, object>> fields)

Returns

ServiceStack.OrmLite.SqlExpression<T>

Parameters

Type	Name
`Expression<Func<<Table1>,<Table2>,<Table3>,<Table4>,<Table5>,<Table6>,<Table7>,<Table8>,<Table9>,<Table10>,<Table11>,System.Object>>`	fields

Type Parameters

Table1
Table2
Table3
Table4
Table5
Table6
Table7
Table8
Table9
Table10
Table11

Select<Table1, Table2, Table3, Table4, Table5, Table6, Table7, Table8, Table9, Table10, Table11, Table12>(Expression<Func<Table1, Table2, Table3, Table4, Table5, Table6, Table7, Table8, Table9, Table10, Table11, Table12, Object>>)

View Source

Declaration
public virtual SqlExpression<T> Select<Table1, Table2, Table3, Table4, Table5, Table6, Table7, Table8, Table9, Table10, Table11, Table12>(Expression<Func<Table1, Table2, Table3, Table4, Table5, Table6, Table7, Table8, Table9, Table10, Table11, Table12, object>> fields)

Returns

ServiceStack.OrmLite.SqlExpression<T>

Parameters

Type	Name
`Expression<Func<<Table1>,<Table2>,<Table3>,<Table4>,<Table5>,<Table6>,<Table7>,<Table8>,<Table9>,<Table10>,<Table11>,<Table12>,System.Object>>`	fields

Type Parameters

Table1
Table2
Table3
Table4
Table5
Table6
Table7
Table8
Table9
Table10
Table11
Table12

SelectDistinct(Expression<Func<T, Object>>)

View Source

Declaration
public virtual SqlExpression<T> SelectDistinct(Expression<Func<T, object>> fields)

Returns

ServiceStack.OrmLite.SqlExpression<T>

Parameters

Type	Name
`Expression<Func<<T>,System.Object>>`	fields

SelectDistinct<Table1>(Expression<Func<Table1, Object>>)

View Source

Declaration
public virtual SqlExpression<T> SelectDistinct<Table1>(Expression<Func<Table1, object>> fields)

Returns

ServiceStack.OrmLite.SqlExpression<T>

Parameters

Type	Name
`Expression<Func<<Table1>,System.Object>>`	fields

Type Parameters

Table1

SelectDistinct<Table1, Table2>(Expression<Func<Table1, Table2, Object>>)

View Source

Declaration
public virtual SqlExpression<T> SelectDistinct<Table1, Table2>(Expression<Func<Table1, Table2, object>> fields)

Returns

ServiceStack.OrmLite.SqlExpression<T>

Parameters

Type	Name
`Expression<Func<<Table1>,<Table2>,System.Object>>`	fields

Type Parameters

Table1
Table2

SelectDistinct<Table1, Table2, Table3>(Expression<Func<Table1, Table2, Table3, Object>>)

View Source

Declaration
public virtual SqlExpression<T> SelectDistinct<Table1, Table2, Table3>(Expression<Func<Table1, Table2, Table3, object>> fields)

Returns

ServiceStack.OrmLite.SqlExpression<T>

Parameters

Type	Name
`Expression<Func<<Table1>,<Table2>,<Table3>,System.Object>>`	fields

Type Parameters

Table1
Table2
Table3

SelectDistinct<Table1, Table2, Table3, Table4>(Expression<Func<Table1, Table2, Table3, Table4, Object>>)

View Source

Declaration
public virtual SqlExpression<T> SelectDistinct<Table1, Table2, Table3, Table4>(Expression<Func<Table1, Table2, Table3, Table4, object>> fields)

Returns

ServiceStack.OrmLite.SqlExpression<T>

Parameters

Type	Name
`Expression<Func<<Table1>,<Table2>,<Table3>,<Table4>,System.Object>>`	fields

Type Parameters

Table1
Table2
Table3
Table4

SelectDistinct<Table1, Table2, Table3, Table4, Table5>(Expression<Func<Table1, Table2, Table3, Table4, Table5, Object>>)

View Source

Declaration
public virtual SqlExpression<T> SelectDistinct<Table1, Table2, Table3, Table4, Table5>(Expression<Func<Table1, Table2, Table3, Table4, Table5, object>> fields)

Returns

ServiceStack.OrmLite.SqlExpression<T>

Parameters

Type	Name
`Expression<Func<<Table1>,<Table2>,<Table3>,<Table4>,<Table5>,System.Object>>`	fields

Type Parameters

Table1
Table2
Table3
Table4
Table5

SelectDistinct<Table1, Table2, Table3, Table4, Table5, Table6>(Expression<Func<Table1, Table2, Table3, Table4, Table5, Table6, Object>>)

View Source

Declaration
public virtual SqlExpression<T> SelectDistinct<Table1, Table2, Table3, Table4, Table5, Table6>(Expression<Func<Table1, Table2, Table3, Table4, Table5, Table6, object>> fields)

Returns

ServiceStack.OrmLite.SqlExpression<T>

Parameters

Type	Name
`Expression<Func<<Table1>,<Table2>,<Table3>,<Table4>,<Table5>,<Table6>,System.Object>>`	fields

Type Parameters

Table1
Table2
Table3
Table4
Table5
Table6

SelectDistinct<Table1, Table2, Table3, Table4, Table5, Table6, Table7>(Expression<Func<Table1, Table2, Table3, Table4, Table5, Table6, Table7, Object>>)

View Source

Declaration
public virtual SqlExpression<T> SelectDistinct<Table1, Table2, Table3, Table4, Table5, Table6, Table7>(Expression<Func<Table1, Table2, Table3, Table4, Table5, Table6, Table7, object>> fields)

Returns

ServiceStack.OrmLite.SqlExpression<T>

Parameters

Type	Name
`Expression<Func<<Table1>,<Table2>,<Table3>,<Table4>,<Table5>,<Table6>,<Table7>,System.Object>>`	fields

Type Parameters

Table1
Table2
Table3
Table4
Table5
Table6
Table7

SelectDistinct<Table1, Table2, Table3, Table4, Table5, Table6, Table7, Table8>(Expression<Func<Table1, Table2, Table3, Table4, Table5, Table6, Table7, Table8, Object>>)

View Source

Declaration
public virtual SqlExpression<T> SelectDistinct<Table1, Table2, Table3, Table4, Table5, Table6, Table7, Table8>(Expression<Func<Table1, Table2, Table3, Table4, Table5, Table6, Table7, Table8, object>> fields)

Returns

ServiceStack.OrmLite.SqlExpression<T>

Parameters

Type	Name
`Expression<Func<<Table1>,<Table2>,<Table3>,<Table4>,<Table5>,<Table6>,<Table7>,<Table8>,System.Object>>`	fields

Type Parameters

Table1
Table2
Table3
Table4
Table5
Table6
Table7
Table8

SelectDistinct<Table1, Table2, Table3, Table4, Table5, Table6, Table7, Table8, Table9>(Expression<Func<Table1, Table2, Table3, Table4, Table5, Table6, Table7, Table8, Table9, Object>>)

View Source

Declaration
public virtual SqlExpression<T> SelectDistinct<Table1, Table2, Table3, Table4, Table5, Table6, Table7, Table8, Table9>(Expression<Func<Table1, Table2, Table3, Table4, Table5, Table6, Table7, Table8, Table9, object>> fields)

Returns

ServiceStack.OrmLite.SqlExpression<T>

Parameters

Type	Name
`Expression<Func<<Table1>,<Table2>,<Table3>,<Table4>,<Table5>,<Table6>,<Table7>,<Table8>,<Table9>,System.Object>>`	fields

Type Parameters

Table1
Table2
Table3
Table4
Table5
Table6
Table7
Table8
Table9

SelectDistinct<Table1, Table2, Table3, Table4, Table5, Table6, Table7, Table8, Table9, Table10>(Expression<Func<Table1, Table2, Table3, Table4, Table5, Table6, Table7, Table8, Table9, Table10, Object>>)

View Source

Declaration
public virtual SqlExpression<T> SelectDistinct<Table1, Table2, Table3, Table4, Table5, Table6, Table7, Table8, Table9, Table10>(Expression<Func<Table1, Table2, Table3, Table4, Table5, Table6, Table7, Table8, Table9, Table10, object>> fields)

Returns

ServiceStack.OrmLite.SqlExpression<T>

Parameters

Type	Name
`Expression<Func<<Table1>,<Table2>,<Table3>,<Table4>,<Table5>,<Table6>,<Table7>,<Table8>,<Table9>,<Table10>,System.Object>>`	fields

Type Parameters

Table1
Table2
Table3
Table4
Table5
Table6
Table7
Table8
Table9
Table10

SelectDistinct<Table1, Table2, Table3, Table4, Table5, Table6, Table7, Table8, Table9, Table10, Table11>(Expression<Func<Table1, Table2, Table3, Table4, Table5, Table6, Table7, Table8, Table9, Table10, Table11, Object>>)

View Source

Declaration
public virtual SqlExpression<T> SelectDistinct<Table1, Table2, Table3, Table4, Table5, Table6, Table7, Table8, Table9, Table10, Table11>(Expression<Func<Table1, Table2, Table3, Table4, Table5, Table6, Table7, Table8, Table9, Table10, Table11, object>> fields)

Returns

ServiceStack.OrmLite.SqlExpression<T>

Parameters

Type	Name
`Expression<Func<<Table1>,<Table2>,<Table3>,<Table4>,<Table5>,<Table6>,<Table7>,<Table8>,<Table9>,<Table10>,<Table11>,System.Object>>`	fields

Type Parameters

Table1
Table2
Table3
Table4
Table5
Table6
Table7
Table8
Table9
Table10
Table11

SelectDistinct<Table1, Table2, Table3, Table4, Table5, Table6, Table7, Table8, Table9, Table10, Table11, Table12>(Expression<Func<Table1, Table2, Table3, Table4, Table5, Table6, Table7, Table8, Table9, Table10, Table11, Table12, Object>>)

View Source

Declaration
public virtual SqlExpression<T> SelectDistinct<Table1, Table2, Table3, Table4, Table5, Table6, Table7, Table8, Table9, Table10, Table11, Table12>(Expression<Func<Table1, Table2, Table3, Table4, Table5, Table6, Table7, Table8, Table9, Table10, Table11, Table12, object>> fields)

Returns

ServiceStack.OrmLite.SqlExpression<T>

Parameters

Type	Name
`Expression<Func<<Table1>,<Table2>,<Table3>,<Table4>,<Table5>,<Table6>,<Table7>,<Table8>,<Table9>,<Table10>,<Table11>,<Table12>,System.Object>>`	fields

Type Parameters

Table1
Table2
Table3
Table4
Table5
Table6
Table7
Table8
Table9
Table10
Table11
Table12

SelectDistinct()

View Source

Declaration
public virtual SqlExpression<T> SelectDistinct()

Returns

ServiceStack.OrmLite.SqlExpression<T>

From(String)

View Source

Declaration
public virtual SqlExpression<T> From(string tables)

Returns

ServiceStack.OrmLite.SqlExpression<T>

Parameters

Type	Name
`System.String`	tables

IncludeTablePrefix()

View Source

Declaration
public virtual SqlExpression<T> IncludeTablePrefix()

Returns

ServiceStack.OrmLite.SqlExpression<T>

SetTableAlias(String)

View Source

Declaration
public virtual SqlExpression<T> SetTableAlias(string tableAlias)

Returns

ServiceStack.OrmLite.SqlExpression<T>

Parameters

Type	Name
`System.String`	tableAlias

UnsafeFrom(String)

View Source

Declaration
public virtual SqlExpression<T> UnsafeFrom(string rawFrom)

Returns

ServiceStack.OrmLite.SqlExpression<T>

Parameters

Type	Name
`System.String`	rawFrom

Where()

View Source

Declaration
public virtual SqlExpression<T> Where()

Returns

ServiceStack.OrmLite.SqlExpression<T>

UnsafeWhere(String, Object[])

View Source

Declaration
public virtual SqlExpression<T> UnsafeWhere(string rawSql, params object[] filterParams)

Returns

ServiceStack.OrmLite.SqlExpression<T>

Parameters

Type	Name
`System.String`	rawSql
`System.Object[]`	filterParams

Where(String, Object[])

View Source

Declaration
public virtual SqlExpression<T> Where(string sqlFilter, params object[] filterParams)

Returns

ServiceStack.OrmLite.SqlExpression<T>

Parameters

Type	Name
`System.String`	sqlFilter
`System.Object[]`	filterParams

UnsafeAnd(String, Object[])

View Source

Declaration
public virtual SqlExpression<T> UnsafeAnd(string rawSql, params object[] filterParams)

Returns

ServiceStack.OrmLite.SqlExpression<T>

Parameters

Type	Name
`System.String`	rawSql
`System.Object[]`	filterParams

And(String, Object[])

View Source

Declaration
public virtual SqlExpression<T> And(string sqlFilter, params object[] filterParams)

Returns

ServiceStack.OrmLite.SqlExpression<T>

Parameters

Type	Name
`System.String`	sqlFilter
`System.Object[]`	filterParams

UnsafeOr(String, Object[])

View Source

Declaration
public virtual SqlExpression<T> UnsafeOr(string rawSql, params object[] filterParams)

Returns

ServiceStack.OrmLite.SqlExpression<T>

Parameters

Type	Name
`System.String`	rawSql
`System.Object[]`	filterParams

Or(String, Object[])

View Source

Declaration
public virtual SqlExpression<T> Or(string sqlFilter, params object[] filterParams)

Returns

ServiceStack.OrmLite.SqlExpression<T>

Parameters

Type	Name
`System.String`	sqlFilter
`System.Object[]`	filterParams

AddCondition(String, String, Object[])

View Source

Declaration
public virtual SqlExpression<T> AddCondition(string condition, string sqlFilter, params object[] filterParams)

Returns

ServiceStack.OrmLite.SqlExpression<T>

Parameters

Type	Name
`System.String`	condition
`System.String`	sqlFilter
`System.Object[]`	filterParams

Where(Expression<Func<T, Boolean>>)

View Source

Declaration
public virtual SqlExpression<T> Where(Expression<Func<T, bool>> predicate)

Returns

ServiceStack.OrmLite.SqlExpression<T>

Parameters

Type	Name
`Expression<Func<<T>,System.Boolean>>`	predicate

Where(Expression<Func<T, Boolean>>, Object[])

View Source

Declaration
public virtual SqlExpression<T> Where(Expression<Func<T, bool>> predicate, params object[] filterParams)

Returns

ServiceStack.OrmLite.SqlExpression<T>

Parameters

Type	Name
`Expression<Func<<T>,System.Boolean>>`	predicate
`System.Object[]`	filterParams

And(Expression<Func<T, Boolean>>)

View Source

Declaration
public virtual SqlExpression<T> And(Expression<Func<T, bool>> predicate)

Returns

ServiceStack.OrmLite.SqlExpression<T>

Parameters

Type	Name
`Expression<Func<<T>,System.Boolean>>`	predicate

And(Expression<Func<T, Boolean>>, Object[])

View Source

Declaration
public virtual SqlExpression<T> And(Expression<Func<T, bool>> predicate, params object[] filterParams)

Returns

ServiceStack.OrmLite.SqlExpression<T>

Parameters

Type	Name
`Expression<Func<<T>,System.Boolean>>`	predicate
`System.Object[]`	filterParams

Or(Expression<Func<T, Boolean>>)

View Source

Declaration
public virtual SqlExpression<T> Or(Expression<Func<T, bool>> predicate)

Returns

ServiceStack.OrmLite.SqlExpression<T>

Parameters

Type	Name
`Expression<Func<<T>,System.Boolean>>`	predicate

Or(Expression<Func<T, Boolean>>, Object[])

View Source

Declaration
public virtual SqlExpression<T> Or(Expression<Func<T, bool>> predicate, params object[] filterParams)

Returns

ServiceStack.OrmLite.SqlExpression<T>

Parameters

Type	Name
`Expression<Func<<T>,System.Boolean>>`	predicate
`System.Object[]`	filterParams

AppendToWhere(String, Expression, Object[])

View Source

Declaration
protected SqlExpression<T> AppendToWhere(string condition, Expression predicate, object[] filterParams)

Returns

ServiceStack.OrmLite.SqlExpression<T>

Parameters

Type	Name
`System.String`	condition
`Expression`	predicate
`System.Object[]`	filterParams

AppendToWhere(String, Expression)

View Source

Declaration
protected SqlExpression<T> AppendToWhere(string condition, Expression predicate)

Returns

ServiceStack.OrmLite.SqlExpression<T>

Parameters

Type	Name
`System.String`	condition
`Expression`	predicate

AppendToWhere(String, String)

View Source

Declaration
protected SqlExpression<T> AppendToWhere(string condition, string sqlExpression)

Returns

ServiceStack.OrmLite.SqlExpression<T>

Parameters

Type	Name
`System.String`	condition
`System.String`	sqlExpression

Ensure(Expression<Func<T, Boolean>>)

View Source

Declaration
public virtual SqlExpression<T> Ensure(Expression<Func<T, bool>> predicate)

Returns

ServiceStack.OrmLite.SqlExpression<T>

Parameters

Type	Name
`Expression<Func<<T>,System.Boolean>>`	predicate

Ensure<Target>(Expression<Func<Target, Boolean>>)

View Source

Declaration
public virtual SqlExpression<T> Ensure<Target>(Expression<Func<Target, bool>> predicate)

Returns

ServiceStack.OrmLite.SqlExpression<T>

Parameters

Type	Name
`Expression<Func<<Target>,System.Boolean>>`	predicate

Type Parameters

Target

Ensure<Source, Target>(Expression<Func<Source, Target, Boolean>>)

View Source

Declaration
public virtual SqlExpression<T> Ensure<Source, Target>(Expression<Func<Source, Target, bool>> predicate)

Returns

ServiceStack.OrmLite.SqlExpression<T>

Parameters

Type	Name
`Expression<Func<<Source>,<Target>,System.Boolean>>`	predicate

Type Parameters

Source
Target

Ensure<T1, T2, T3>(Expression<Func<T1, T2, T3, Boolean>>)

View Source

Declaration
public virtual SqlExpression<T> Ensure<T1, T2, T3>(Expression<Func<T1, T2, T3, bool>> predicate)

Returns

ServiceStack.OrmLite.SqlExpression<T>

Parameters

Type	Name
`Expression<Func<<T1>,<T2>,<T3>,System.Boolean>>`	predicate

Type Parameters

T1
T2
T3

Ensure<T1, T2, T3, T4>(Expression<Func<T1, T2, T3, T4, Boolean>>)

View Source

Declaration
public virtual SqlExpression<T> Ensure<T1, T2, T3, T4>(Expression<Func<T1, T2, T3, T4, bool>> predicate)

Returns

ServiceStack.OrmLite.SqlExpression<T>

Parameters

Type	Name
`Expression<Func<<T1>,<T2>,<T3>,<T4>,System.Boolean>>`	predicate

Type Parameters

T1
T2
T3
T4

Ensure<T1, T2, T3, T4, T5>(Expression<Func<T1, T2, T3, T4, T5, Boolean>>)

View Source

Declaration
public virtual SqlExpression<T> Ensure<T1, T2, T3, T4, T5>(Expression<Func<T1, T2, T3, T4, T5, bool>> predicate)

Returns

ServiceStack.OrmLite.SqlExpression<T>

Parameters

Type	Name
`Expression<Func<<T1>,<T2>,<T3>,<T4>,<T5>,System.Boolean>>`	predicate

Type Parameters

T1
T2
T3
T4
T5

AppendToEnsure(Expression)

View Source

Declaration
protected SqlExpression<T> AppendToEnsure(Expression predicate)

Returns

ServiceStack.OrmLite.SqlExpression<T>

Parameters

Type	Name
`Expression`	predicate

Ensure(String, Object[])

Add a WHERE Condition to always be applied, irrespective of other WHERE conditions

View Source

Declaration
public SqlExpression<T> Ensure(string sqlFilter, params object[] filterParams)

Returns

ServiceStack.OrmLite.SqlExpression<T>

Parameters

Type	Name
`System.String`	sqlFilter
`System.Object[]`	filterParams

GroupBy()

View Source

Declaration
public virtual SqlExpression<T> GroupBy()

Returns

ServiceStack.OrmLite.SqlExpression<T>

GroupBy(String)

View Source

Declaration
public virtual SqlExpression<T> GroupBy(string groupBy)

Returns

ServiceStack.OrmLite.SqlExpression<T>

Parameters

Type	Name
`System.String`	groupBy

UnsafeGroupBy(String)

View Source

Declaration
public virtual SqlExpression<T> UnsafeGroupBy(string groupBy)

Returns

ServiceStack.OrmLite.SqlExpression<T>

Parameters

Type	Name
`System.String`	groupBy

GroupBy<Table>(Expression<Func<Table, Object>>)

View Source

Declaration
public virtual SqlExpression<T> GroupBy<Table>(Expression<Func<Table, object>> keySelector)

Returns

ServiceStack.OrmLite.SqlExpression<T>

Parameters

Type	Name
`Expression<Func<<Table>,System.Object>>`	keySelector

Type Parameters

Table

GroupBy<Table1, Table2>(Expression<Func<Table1, Table2, Object>>)

View Source

Declaration
public virtual SqlExpression<T> GroupBy<Table1, Table2>(Expression<Func<Table1, Table2, object>> keySelector)

Returns

ServiceStack.OrmLite.SqlExpression<T>

Parameters

Type	Name
`Expression<Func<<Table1>,<Table2>,System.Object>>`	keySelector

Type Parameters

Table1
Table2

GroupBy<Table1, Table2, Table3>(Expression<Func<Table1, Table2, Table3, Object>>)

View Source

Declaration
public virtual SqlExpression<T> GroupBy<Table1, Table2, Table3>(Expression<Func<Table1, Table2, Table3, object>> keySelector)

Returns

ServiceStack.OrmLite.SqlExpression<T>

Parameters

Type	Name
`Expression<Func<<Table1>,<Table2>,<Table3>,System.Object>>`	keySelector

Type Parameters

Table1
Table2
Table3

GroupBy<Table1, Table2, Table3, Table4>(Expression<Func<Table1, Table2, Table3, Table4, Object>>)

View Source

Declaration
public virtual SqlExpression<T> GroupBy<Table1, Table2, Table3, Table4>(Expression<Func<Table1, Table2, Table3, Table4, object>> keySelector)

Returns

ServiceStack.OrmLite.SqlExpression<T>

Parameters

Type	Name
`Expression<Func<<Table1>,<Table2>,<Table3>,<Table4>,System.Object>>`	keySelector

Type Parameters

Table1
Table2
Table3
Table4

GroupBy(Expression<Func<T, Object>>)

View Source

Declaration
public virtual SqlExpression<T> GroupBy(Expression<Func<T, object>> keySelector)

Returns

ServiceStack.OrmLite.SqlExpression<T>

Parameters

Type	Name
`Expression<Func<<T>,System.Object>>`	keySelector

Having()

View Source

Declaration
public virtual SqlExpression<T> Having()

Returns

ServiceStack.OrmLite.SqlExpression<T>

Having(String, Object[])

View Source

Declaration
public virtual SqlExpression<T> Having(string sqlFilter, params object[] filterParams)

Returns

ServiceStack.OrmLite.SqlExpression<T>

Parameters

Type	Name
`System.String`	sqlFilter
`System.Object[]`	filterParams

UnsafeHaving(String, Object[])

View Source

Declaration
public virtual SqlExpression<T> UnsafeHaving(string sqlFilter, params object[] filterParams)

Returns

ServiceStack.OrmLite.SqlExpression<T>

Parameters

Type	Name
`System.String`	sqlFilter
`System.Object[]`	filterParams

AppendHaving(Expression)

View Source

Declaration
protected SqlExpression<T> AppendHaving(Expression predicate)

Returns

ServiceStack.OrmLite.SqlExpression<T>

Parameters

Type	Name
`Expression`	predicate

Having(Expression<Func<T, Boolean>>)

View Source

Declaration
public virtual SqlExpression<T> Having(Expression<Func<T, bool>> predicate)

Returns

ServiceStack.OrmLite.SqlExpression<T>

Parameters

Type	Name
`Expression<Func<<T>,System.Boolean>>`	predicate

Having<Table>(Expression<Func<Table, Boolean>>)

View Source

Declaration
public virtual SqlExpression<T> Having<Table>(Expression<Func<Table, bool>> predicate)

Returns

ServiceStack.OrmLite.SqlExpression<T>

Parameters

Type	Name
`Expression<Func<<Table>,System.Boolean>>`	predicate

Type Parameters

Table

Having<Table1, Table2>(Expression<Func<Table1, Table2, Boolean>>)

View Source

Declaration
public virtual SqlExpression<T> Having<Table1, Table2>(Expression<Func<Table1, Table2, bool>> predicate)

Returns

ServiceStack.OrmLite.SqlExpression<T>

Parameters

Type	Name
`Expression<Func<<Table1>,<Table2>,System.Boolean>>`	predicate

Type Parameters

Table1
Table2

Having<Table1, Table2, Table3>(Expression<Func<Table1, Table2, Table3, Boolean>>)

View Source

Declaration
public virtual SqlExpression<T> Having<Table1, Table2, Table3>(Expression<Func<Table1, Table2, Table3, bool>> predicate)

Returns

ServiceStack.OrmLite.SqlExpression<T>

Parameters

Type	Name
`Expression<Func<<Table1>,<Table2>,<Table3>,System.Boolean>>`	predicate

Type Parameters

Table1
Table2
Table3

OrderBy()

View Source

Declaration
public virtual SqlExpression<T> OrderBy()

Returns

ServiceStack.OrmLite.SqlExpression<T>

OrderBy(String)

View Source

Declaration
public virtual SqlExpression<T> OrderBy(string orderBy)

Returns

ServiceStack.OrmLite.SqlExpression<T>

Parameters

Type	Name
`System.String`	orderBy

OrderBy(Int64)

View Source

Declaration
public virtual SqlExpression<T> OrderBy(long columnIndex)

Returns

ServiceStack.OrmLite.SqlExpression<T>

Parameters

Type	Name
`System.Int64`	columnIndex

UnsafeOrderBy(String)

View Source

Declaration
public virtual SqlExpression<T> UnsafeOrderBy(string orderBy)

Returns

ServiceStack.OrmLite.SqlExpression<T>

Parameters

Type	Name
`System.String`	orderBy

OrderByRandom()

View Source

Declaration
public virtual SqlExpression<T> OrderByRandom()

Returns

ServiceStack.OrmLite.SqlExpression<T>

GetModelDefinition(FieldDefinition)

View Source

Declaration
public ModelDefinition GetModelDefinition(FieldDefinition fieldDef)

Returns

ServiceStack.OrmLite.ModelDefinition

Parameters

Type	Name
ServiceStack.OrmLite.FieldDefinition	fieldDef

OrderByFields(FieldDefinition[])

View Source

Declaration
public virtual SqlExpression<T> OrderByFields(params FieldDefinition[] fields)

Returns

ServiceStack.OrmLite.SqlExpression<T>

Parameters

Type	Name
`ServiceStack.OrmLite.FieldDefinition[]`	fields

OrderByFieldsDescending(FieldDefinition[])

View Source

Declaration
public virtual SqlExpression<T> OrderByFieldsDescending(params FieldDefinition[] fields)

Returns

ServiceStack.OrmLite.SqlExpression<T>

Parameters

Type	Name
`ServiceStack.OrmLite.FieldDefinition[]`	fields

OrderByFields(String[])

View Source

Declaration
public virtual SqlExpression<T> OrderByFields(params string[] fieldNames)

Returns

ServiceStack.OrmLite.SqlExpression<T>

Parameters

Type	Name
`System.String[]`	fieldNames

OrderByFieldsDescending(String[])

View Source

Declaration
public virtual SqlExpression<T> OrderByFieldsDescending(params string[] fieldNames)

Returns

ServiceStack.OrmLite.SqlExpression<T>

Parameters

Type	Name
`System.String[]`	fieldNames

OrderBy(Expression<Func<T, Object>>)

View Source

Declaration
public virtual SqlExpression<T> OrderBy(Expression<Func<T, object>> keySelector)

Returns

ServiceStack.OrmLite.SqlExpression<T>

Parameters

Type	Name
`Expression<Func<<T>,System.Object>>`	keySelector

OrderBy<Table>(Expression<Func<Table, Object>>)

View Source

Declaration
public virtual SqlExpression<T> OrderBy<Table>(Expression<Func<Table, object>> fields)

Returns

ServiceStack.OrmLite.SqlExpression<T>

Parameters

Type	Name
`Expression<Func<<Table>,System.Object>>`	fields

Type Parameters

Table

OrderBy<Table1, Table2>(Expression<Func<Table1, Table2, Object>>)

View Source

Declaration
public virtual SqlExpression<T> OrderBy<Table1, Table2>(Expression<Func<Table1, Table2, object>> fields)

Returns

ServiceStack.OrmLite.SqlExpression<T>

Parameters

Type	Name
`Expression<Func<<Table1>,<Table2>,System.Object>>`	fields

Type Parameters

Table1
Table2

OrderBy<Table1, Table2, Table3>(Expression<Func<Table1, Table2, Table3, Object>>)

View Source

Declaration
public virtual SqlExpression<T> OrderBy<Table1, Table2, Table3>(Expression<Func<Table1, Table2, Table3, object>> fields)

Returns

ServiceStack.OrmLite.SqlExpression<T>

Parameters

Type	Name
`Expression<Func<<Table1>,<Table2>,<Table3>,System.Object>>`	fields

Type Parameters

Table1
Table2
Table3

OrderBy<Table1, Table2, Table3, Table4>(Expression<Func<Table1, Table2, Table3, Table4, Object>>)

View Source

Declaration
public virtual SqlExpression<T> OrderBy<Table1, Table2, Table3, Table4>(Expression<Func<Table1, Table2, Table3, Table4, object>> fields)

Returns

ServiceStack.OrmLite.SqlExpression<T>

Parameters

Type	Name
`Expression<Func<<Table1>,<Table2>,<Table3>,<Table4>,System.Object>>`	fields

Type Parameters

Table1
Table2
Table3
Table4

OrderBy<Table1, Table2, Table3, Table4, Table5>(Expression<Func<Table1, Table2, Table3, Table4, Table5, Object>>)

View Source

Declaration
public virtual SqlExpression<T> OrderBy<Table1, Table2, Table3, Table4, Table5>(Expression<Func<Table1, Table2, Table3, Table4, Table5, object>> fields)

Returns

ServiceStack.OrmLite.SqlExpression<T>

Parameters

Type	Name
`Expression<Func<<Table1>,<Table2>,<Table3>,<Table4>,<Table5>,System.Object>>`	fields

Type Parameters

Table1
Table2
Table3
Table4
Table5

IsSqlClass(Object)

View Source

Declaration
public static bool IsSqlClass(object obj)

Returns

System.Boolean

Parameters

Type	Name
`System.Object`	obj

ThenBy(String)

View Source

Declaration
public virtual SqlExpression<T> ThenBy(string orderBy)

Returns

ServiceStack.OrmLite.SqlExpression<T>

Parameters

Type	Name
`System.String`	orderBy

ThenBy(Expression<Func<T, Object>>)

View Source

Declaration
public virtual SqlExpression<T> ThenBy(Expression<Func<T, object>> keySelector)

Returns

ServiceStack.OrmLite.SqlExpression<T>

Parameters

Type	Name
`Expression<Func<<T>,System.Object>>`	keySelector

ThenBy<Table>(Expression<Func<Table, Object>>)

View Source

Declaration
public virtual SqlExpression<T> ThenBy<Table>(Expression<Func<Table, object>> fields)

Returns

ServiceStack.OrmLite.SqlExpression<T>

Parameters

Type	Name
`Expression<Func<<Table>,System.Object>>`	fields

Type Parameters

Table

ThenBy<Table1, Table2>(Expression<Func<Table1, Table2, Object>>)

View Source

Declaration
public virtual SqlExpression<T> ThenBy<Table1, Table2>(Expression<Func<Table1, Table2, object>> fields)

Returns

ServiceStack.OrmLite.SqlExpression<T>

Parameters

Type	Name
`Expression<Func<<Table1>,<Table2>,System.Object>>`	fields

Type Parameters

Table1
Table2

ThenBy<Table1, Table2, Table3>(Expression<Func<Table1, Table2, Table3, Object>>)

View Source

Declaration
public virtual SqlExpression<T> ThenBy<Table1, Table2, Table3>(Expression<Func<Table1, Table2, Table3, object>> fields)

Returns

ServiceStack.OrmLite.SqlExpression<T>

Parameters

Type	Name
`Expression<Func<<Table1>,<Table2>,<Table3>,System.Object>>`	fields

Type Parameters

Table1
Table2
Table3

ThenBy<Table1, Table2, Table3, Table4>(Expression<Func<Table1, Table2, Table3, Table4, Object>>)

View Source

Declaration
public virtual SqlExpression<T> ThenBy<Table1, Table2, Table3, Table4>(Expression<Func<Table1, Table2, Table3, Table4, object>> fields)

Returns

ServiceStack.OrmLite.SqlExpression<T>

Parameters

Type	Name
`Expression<Func<<Table1>,<Table2>,<Table3>,<Table4>,System.Object>>`	fields

Type Parameters

Table1
Table2
Table3
Table4

ThenBy<Table1, Table2, Table3, Table4, Table5>(Expression<Func<Table1, Table2, Table3, Table4, Table5, Object>>)

View Source

Declaration
public virtual SqlExpression<T> ThenBy<Table1, Table2, Table3, Table4, Table5>(Expression<Func<Table1, Table2, Table3, Table4, Table5, object>> fields)

Returns

ServiceStack.OrmLite.SqlExpression<T>

Parameters

Type	Name
`Expression<Func<<Table1>,<Table2>,<Table3>,<Table4>,<Table5>,System.Object>>`	fields

Type Parameters

Table1
Table2
Table3
Table4
Table5

OrderByDescending(Expression<Func<T, Object>>)

View Source

Declaration
public virtual SqlExpression<T> OrderByDescending(Expression<Func<T, object>> keySelector)

Returns

ServiceStack.OrmLite.SqlExpression<T>

Parameters

Type	Name
`Expression<Func<<T>,System.Object>>`	keySelector

OrderByDescending<Table>(Expression<Func<Table, Object>>)

View Source

Declaration
public virtual SqlExpression<T> OrderByDescending<Table>(Expression<Func<Table, object>> keySelector)

Returns

ServiceStack.OrmLite.SqlExpression<T>

Parameters

Type	Name
`Expression<Func<<Table>,System.Object>>`	keySelector

Type Parameters

Table

OrderByDescending<Table1, Table2>(Expression<Func<Table1, Table2, Object>>)

View Source

Declaration
public virtual SqlExpression<T> OrderByDescending<Table1, Table2>(Expression<Func<Table1, Table2, object>> fields)

Returns

ServiceStack.OrmLite.SqlExpression<T>

Parameters

Type	Name
`Expression<Func<<Table1>,<Table2>,System.Object>>`	fields

Type Parameters

Table1
Table2

OrderByDescending<Table1, Table2, Table3>(Expression<Func<Table1, Table2, Table3, Object>>)

View Source

Declaration
public virtual SqlExpression<T> OrderByDescending<Table1, Table2, Table3>(Expression<Func<Table1, Table2, Table3, object>> fields)

Returns

ServiceStack.OrmLite.SqlExpression<T>

Parameters

Type	Name
`Expression<Func<<Table1>,<Table2>,<Table3>,System.Object>>`	fields

Type Parameters

Table1
Table2
Table3

OrderByDescending<Table1, Table2, Table3, Table4>(Expression<Func<Table1, Table2, Table3, Table4, Object>>)

View Source

Declaration
public virtual SqlExpression<T> OrderByDescending<Table1, Table2, Table3, Table4>(Expression<Func<Table1, Table2, Table3, Table4, object>> fields)

Returns

ServiceStack.OrmLite.SqlExpression<T>

Parameters

Type	Name
`Expression<Func<<Table1>,<Table2>,<Table3>,<Table4>,System.Object>>`	fields

Type Parameters

Table1
Table2
Table3
Table4

OrderByDescending<Table1, Table2, Table3, Table4, Table5>(Expression<Func<Table1, Table2, Table3, Table4, Table5, Object>>)

View Source

Declaration
public virtual SqlExpression<T> OrderByDescending<Table1, Table2, Table3, Table4, Table5>(Expression<Func<Table1, Table2, Table3, Table4, Table5, object>> fields)

Returns

ServiceStack.OrmLite.SqlExpression<T>

Parameters

Type	Name
`Expression<Func<<Table1>,<Table2>,<Table3>,<Table4>,<Table5>,System.Object>>`	fields

Type Parameters

Table1
Table2
Table3
Table4
Table5

OrderByDescending(String)

View Source

Declaration
public virtual SqlExpression<T> OrderByDescending(string orderBy)

Returns

ServiceStack.OrmLite.SqlExpression<T>

Parameters

Type	Name
`System.String`	orderBy

OrderByDescending(Int64)

View Source

Declaration
public virtual SqlExpression<T> OrderByDescending(long columnIndex)

Returns

ServiceStack.OrmLite.SqlExpression<T>

Parameters

Type	Name
`System.Int64`	columnIndex

ThenByDescending(String)

View Source

Declaration
public virtual SqlExpression<T> ThenByDescending(string orderBy)

Returns

ServiceStack.OrmLite.SqlExpression<T>

Parameters

Type	Name
`System.String`	orderBy

ThenByDescending(Expression<Func<T, Object>>)

View Source

Declaration
public virtual SqlExpression<T> ThenByDescending(Expression<Func<T, object>> keySelector)

Returns

ServiceStack.OrmLite.SqlExpression<T>

Parameters

Type	Name
`Expression<Func<<T>,System.Object>>`	keySelector

ThenByDescending<Table>(Expression<Func<Table, Object>>)

View Source

Declaration
public virtual SqlExpression<T> ThenByDescending<Table>(Expression<Func<Table, object>> fields)

Returns

ServiceStack.OrmLite.SqlExpression<T>

Parameters

Type	Name
`Expression<Func<<Table>,System.Object>>`	fields

Type Parameters

Table

ThenByDescending<Table1, Table2>(Expression<Func<Table1, Table2, Object>>)

View Source

Declaration
public virtual SqlExpression<T> ThenByDescending<Table1, Table2>(Expression<Func<Table1, Table2, object>> fields)

Returns

ServiceStack.OrmLite.SqlExpression<T>

Parameters

Type	Name
`Expression<Func<<Table1>,<Table2>,System.Object>>`	fields

Type Parameters

Table1
Table2

ThenByDescending<Table1, Table2, Table3>(Expression<Func<Table1, Table2, Table3, Object>>)

View Source

Declaration
public virtual SqlExpression<T> ThenByDescending<Table1, Table2, Table3>(Expression<Func<Table1, Table2, Table3, object>> fields)

Returns

ServiceStack.OrmLite.SqlExpression<T>

Parameters

Type	Name
`Expression<Func<<Table1>,<Table2>,<Table3>,System.Object>>`	fields

Type Parameters

Table1
Table2
Table3

ThenByDescending<Table1, Table2, Table3, Table4>(Expression<Func<Table1, Table2, Table3, Table4, Object>>)

View Source

Declaration
public virtual SqlExpression<T> ThenByDescending<Table1, Table2, Table3, Table4>(Expression<Func<Table1, Table2, Table3, Table4, object>> fields)

Returns

ServiceStack.OrmLite.SqlExpression<T>

Parameters

Type	Name
`Expression<Func<<Table1>,<Table2>,<Table3>,<Table4>,System.Object>>`	fields

Type Parameters

Table1
Table2
Table3
Table4

ThenByDescending<Table1, Table2, Table3, Table4, Table5>(Expression<Func<Table1, Table2, Table3, Table4, Table5, Object>>)

View Source

Declaration
public virtual SqlExpression<T> ThenByDescending<Table1, Table2, Table3, Table4, Table5>(Expression<Func<Table1, Table2, Table3, Table4, Table5, object>> fields)

Returns

ServiceStack.OrmLite.SqlExpression<T>

Parameters

Type	Name
`Expression<Func<<Table1>,<Table2>,<Table3>,<Table4>,<Table5>,System.Object>>`	fields

Type Parameters

Table1
Table2
Table3
Table4
Table5

Skip(Nullable<Int32>)

Offset of the first row to return. The offset of the initial row is 0

View Source

Declaration
public virtual SqlExpression<T> Skip(int? skip = null)

Returns

ServiceStack.OrmLite.SqlExpression<T>

Parameters

Type	Name
`System.Nullable<System.Int32>`	skip

Take(Nullable<Int32>)

Number of rows returned by a SELECT statement

View Source

Declaration
public virtual SqlExpression<T> Take(int? take = null)

Returns

ServiceStack.OrmLite.SqlExpression<T>

Parameters

Type	Name
`System.Nullable<System.Int32>`	take

Limit(Int32, Int32)

Set the specified offset and rows for SQL Limit clause.

View Source

Declaration
public virtual SqlExpression<T> Limit(int skip, int rows)

Returns

ServiceStack.OrmLite.SqlExpression<T>

Parameters

Type	Name	Description
`System.Int32`	skip

Offset of the first row to return. The offset of the initial row is 0

| | System.Int32 | rows | Number of rows returned by a SELECT statement

Limit(Nullable<Int32>, Nullable<Int32>)

Set the specified offset and rows for SQL Limit clause where they exist.

View Source

Declaration
public virtual SqlExpression<T> Limit(int? skip, int? rows)

Returns

ServiceStack.OrmLite.SqlExpression<T>

Parameters

Type	Name	Description
`System.Nullable<System.Int32>`	skip

Offset of the first row to return. The offset of the initial row is 0

| | System.Nullable<System.Int32> | rows | Number of rows returned by a SELECT statement

Limit(Int32)

Set the specified rows for Sql Limit clause.

View Source

Declaration
public virtual SqlExpression<T> Limit(int rows)

Returns

ServiceStack.OrmLite.SqlExpression<T>

Parameters

Type	Name	Description
`System.Int32`	rows

Number of rows returned by a SELECT statement

Limit()

Clear Sql Limit clause

View Source

Declaration
public virtual SqlExpression<T> Limit()

Returns

ServiceStack.OrmLite.SqlExpression<T>

ClearLimits()

Clear Offset and Limit clauses. Alias for Limit()

View Source

Declaration
public virtual SqlExpression<T> ClearLimits()

Returns

ServiceStack.OrmLite.SqlExpression<T>

Update(List<String>)

Fields to be updated.

View Source

Declaration
public virtual SqlExpression<T> Update(List<string> updateFields)

Returns

ServiceStack.OrmLite.SqlExpression<T>

Parameters

Type	Name	Description
`List<System.String>`	updateFields

List<string> containing Names of properties to be updated

Update(IEnumerable<String>)

Fields to be updated.

View Source

Declaration
public virtual SqlExpression<T> Update(IEnumerable<string> updateFields)

Returns

ServiceStack.OrmLite.SqlExpression<T>

Parameters

Type	Name	Description
`IEnumerable<System.String>`	updateFields

IEnumerable<string> containing Names of properties to be updated

Update(Expression<Func<T, Object>>)

Fields to be updated.

View Source

Declaration
public virtual SqlExpression<T> Update(Expression<Func<T, object>> fields)

Returns

ServiceStack.OrmLite.SqlExpression<T>

Parameters

Type	Name	Description
`Expression<Func<<T>,System.Object>>`	fields

x=> x.SomeProperty1 or x=> new { x.SomeProperty1, x.SomeProperty2 }

Update()

Clear UpdateFields list ( all fields will be updated)

View Source

Declaration
public virtual SqlExpression<T> Update()

Returns

ServiceStack.OrmLite.SqlExpression<T>

Insert<TKey>(Expression<Func<T, TKey>>)

Fields to be inserted.

View Source

Declaration
public virtual SqlExpression<T> Insert<TKey>(Expression<Func<T, TKey>> fields)

Returns

ServiceStack.OrmLite.SqlExpression<T>

Parameters

Type	Name	Description
`Expression<Func<<T>,<TKey>>>`	fields

x=> x.SomeProperty1 or x=> new{ x.SomeProperty1, x.SomeProperty2}

Type Parameters

Name	Description
`TKey`

objectWithProperties |

Insert(List<String>)

fields to be inserted.

View Source

Declaration
public virtual SqlExpression<T> Insert(List<string> insertFields)

Returns

ServiceStack.OrmLite.SqlExpression<T>

Parameters

Type	Name	Description
`List<System.String>`	insertFields

IList<string> containing Names of properties to be inserted

Insert()

Clear InsertFields list ( all fields will be inserted)

View Source

Declaration
public virtual SqlExpression<T> Insert()

Returns

ServiceStack.OrmLite.SqlExpression<T>

WithSqlFilter(Func<String, String>)

View Source

Declaration
public virtual SqlExpression<T> WithSqlFilter(Func<string, string> sqlFilter)

Returns

ServiceStack.OrmLite.SqlExpression<T>

Parameters

Type	Name
`Func<System.String,System.String>`	sqlFilter

SqlTable(ModelDefinition)

View Source

Declaration
public string SqlTable(ModelDefinition modelDef)

Returns

System.String

Parameters

Type	Name
ServiceStack.OrmLite.ModelDefinition	modelDef

SqlColumn(String)

View Source

Declaration
public string SqlColumn(string columnName)

Returns

System.String

Parameters

Type	Name
`System.String`	columnName

AddParam(Object)

View Source

Declaration
public virtual IDbDataParameter AddParam(object value)

Returns

IDbDataParameter

Parameters

Type	Name
`System.Object`	value

ConvertToParam(Object)

View Source

Declaration
public string ConvertToParam(object value)

Returns

System.String

Parameters

Type	Name
`System.Object`	value

CopyParamsTo(IDbCommand)

View Source

Declaration
public virtual void CopyParamsTo(IDbCommand dbCmd)

Parameters

Type	Name
`IDbCommand`	dbCmd

ToDeleteRowStatement()

View Source

Declaration
public virtual string ToDeleteRowStatement()

Returns

System.String

PrepareUpdateStatement(IDbCommand, T, Boolean)

View Source

Declaration
public virtual void PrepareUpdateStatement(IDbCommand dbCmd, T item, bool excludeDefaults = false)

Parameters

Type	Name
`IDbCommand`	dbCmd
`<T>`	item
`System.Boolean`	excludeDefaults

PrepareUpdateStatement(IDbCommand, Dictionary<String, Object>)

View Source

Declaration
public virtual void PrepareUpdateStatement(IDbCommand dbCmd, Dictionary<string, object> updateFields)

Parameters

Type	Name
`IDbCommand`	dbCmd
`Dictionary<System.String,System.Object>`	updateFields

ToSelectStatement()

View Source

Declaration
public virtual string ToSelectStatement()

Returns

System.String

ToSelectStatement(QueryType)

View Source

Declaration
public virtual string ToSelectStatement(QueryType forType)

Returns

System.String

Parameters

Type	Name
ServiceStack.OrmLite.QueryType	forType

ToMergedParamsSelectStatement()

Merge params into an encapsulated SQL Statement with embedded param values

View Source

Declaration
public virtual string ToMergedParamsSelectStatement()

Returns

System.String

ToCountStatement()

View Source

Declaration
public virtual string ToCountStatement()

Returns

System.String

Visit(Expression)

View Source

Declaration
public virtual object Visit(Expression exp)

Returns

System.Object

Parameters

Type	Name
`Expression`	exp

VisitJoin(Expression)

View Source

Declaration
protected virtual object VisitJoin(Expression exp)

Returns

System.Object

Parameters

Type	Name
`Expression`	exp

VisitLambda(LambdaExpression)

View Source

Declaration
protected virtual object VisitLambda(LambdaExpression lambda)

Returns

System.Object

Parameters

Type	Name
`LambdaExpression`	lambda

GetValue(Object, Type)

View Source

Declaration
public virtual object GetValue(object value, Type type)

Returns

System.Object

Parameters

Type	Name
`System.Object`	value
`Type`	type

VisitBinary(BinaryExpression)

View Source

Declaration
protected virtual object VisitBinary(BinaryExpression b)

Returns

System.Object

Parameters

Type	Name
`BinaryExpression`	b

IsBooleanComparison(Expression)

Determines whether the expression is the parameter inside MemberExpression which should be compared with TrueExpression.

View Source

Declaration
protected virtual bool IsBooleanComparison(Expression e)

Returns

System.Boolean: Returns true if the specified expression is the parameter inside MemberExpression which should be compared with TrueExpression; otherwise, false.

Parameters

Type	Name
`Expression`	e

IsParameterAccess(Expression)

Determines whether the expression is the parameter.

View Source

Declaration
protected virtual bool IsParameterAccess(Expression e)

Returns

System.Boolean: Returns true if the specified expression is parameter; otherwise, false.

Parameters

Type	Name
`Expression`	e

IsParameterOrConvertAccess(Expression)

Determines whether the expression is a Parameter or Convert Expression.

View Source

Declaration
protected virtual bool IsParameterOrConvertAccess(Expression e)

Returns

System.Boolean: Returns true if the specified expression is parameter or convert; otherwise, false.

Parameters

Type	Name
`Expression`	e

IsConstantExpression(Expression)

Check whether the expression is a constant expression to determine whether we should use the expression value instead of Column Name

View Source

Declaration
protected virtual bool IsConstantExpression(Expression e)

Returns

System.Boolean

Parameters

Type	Name
`Expression`	e

CheckExpressionForTypes(Expression, ExpressionType[])

View Source

Declaration
protected bool CheckExpressionForTypes(Expression e, ExpressionType[] types)

Returns

System.Boolean

Parameters

Type	Name
`Expression`	e
`ExpressionType[]`	types

VisitFilter(String, Object, Object, ref Object, ref Object)

View Source

Declaration
protected virtual void VisitFilter(string operand, object originalLeft, object originalRight, ref object left, ref object right)

Parameters

Type	Name
`System.String`	operand
`System.Object`	originalLeft
`System.Object`	originalRight
`System.Object`	left
`System.Object`	right

ConvertToPlaceholderAndParameter(ref Object)

View Source

Declaration
protected virtual void ConvertToPlaceholderAndParameter(ref object right)

Parameters

Type	Name
`System.Object`	right

VisitMemberAccess(MemberExpression)

View Source

Declaration
protected virtual object VisitMemberAccess(MemberExpression m)

Returns

System.Object

Parameters

Type	Name
`MemberExpression`	m

GetMemberExpression(MemberExpression)

View Source

Declaration
protected virtual object GetMemberExpression(MemberExpression m)

Returns

System.Object

Parameters

Type	Name
`MemberExpression`	m

GetTableAlias(MemberExpression)

View Source

Declaration
protected virtual string GetTableAlias(MemberExpression m)

Returns

System.String

Parameters

Type	Name
`MemberExpression`	m

OnVisitMemberType(Type)

View Source

Declaration
protected virtual void OnVisitMemberType(Type modelType)

Parameters

Type	Name
`Type`	modelType

VisitMemberInit(MemberInitExpression)

View Source

Declaration
protected virtual object VisitMemberInit(MemberInitExpression exp)

Returns

System.Object

Parameters

Type	Name
`MemberInitExpression`	exp

VisitNew(NewExpression)

View Source

Declaration
protected virtual object VisitNew(NewExpression nex)

Returns

System.Object

Parameters

Type	Name
`NewExpression`	nex

VisitParameter(ParameterExpression)

View Source

Declaration
protected virtual object VisitParameter(ParameterExpression p)

Returns

System.Object

Parameters

Type	Name
`ParameterExpression`	p

VisitConstant(ConstantExpression)

View Source

Declaration
protected virtual object VisitConstant(ConstantExpression c)

Returns

System.Object

Parameters

Type	Name
`ConstantExpression`	c

VisitUnary(UnaryExpression)

View Source

Declaration
protected virtual object VisitUnary(UnaryExpression u)

Returns

System.Object

Parameters

Type	Name
`UnaryExpression`	u

VisitIndexExpression(IndexExpression)

View Source

Declaration
protected virtual object VisitIndexExpression(IndexExpression e)

Returns

System.Object

Parameters

Type	Name
`IndexExpression`	e

VisitConditional(ConditionalExpression)

View Source

Declaration
protected virtual object VisitConditional(ConditionalExpression e)

Returns

System.Object

Parameters

Type	Name
`ConditionalExpression`	e

IsColumnAccess(MethodCallExpression)

View Source

Declaration
protected virtual bool IsColumnAccess(MethodCallExpression m)

Returns

System.Boolean

Parameters

Type	Name
`MethodCallExpression`	m

VisitMethodCall(MethodCallExpression)

View Source

Declaration
protected virtual object VisitMethodCall(MethodCallExpression m)

Returns

System.Object

Parameters

Type	Name
`MethodCallExpression`	m

VisitExpressionList(ReadOnlyCollection<Expression>)

View Source

Declaration
protected virtual List<object> VisitExpressionList(ReadOnlyCollection<Expression> original)

Returns

List<System.Object>

Parameters

Type	Name
`ReadOnlyCollection<Expression>`	original

VisitInSqlExpressionList(ReadOnlyCollection<Expression>)

View Source

Declaration
protected virtual List<object> VisitInSqlExpressionList(ReadOnlyCollection<Expression> original)

Returns

List<System.Object>

Parameters

Type	Name
`ReadOnlyCollection<Expression>`	original

VisitNewArray(NewArrayExpression)

View Source

Declaration
protected virtual object VisitNewArray(NewArrayExpression na)

Returns

System.Object

Parameters

Type	Name
`NewArrayExpression`	na

VisitNewArrayFromExpressionList(NewArrayExpression)

View Source

Declaration
protected virtual List<object> VisitNewArrayFromExpressionList(NewArrayExpression na)

Returns

List<System.Object>

Parameters

Type	Name
`NewArrayExpression`	na

BindOperant(ExpressionType)

View Source

Declaration
protected virtual string BindOperant(ExpressionType e)

Returns

System.String

Parameters

Type	Name
`ExpressionType`	e

GetQuotedColumnName(ModelDefinition, String)

View Source

Declaration
protected virtual string GetQuotedColumnName(ModelDefinition tableDef, string memberName)

Returns

System.String

Parameters

Type	Name
ServiceStack.OrmLite.ModelDefinition	tableDef
`System.String`	memberName

GetQuotedColumnName(ModelDefinition, String, String)

View Source

Declaration
protected virtual string GetQuotedColumnName(ModelDefinition tableDef, string tableAlias, string memberName)

Returns

System.String

Parameters

Type	Name
ServiceStack.OrmLite.ModelDefinition	tableDef
`System.String`	tableAlias
`System.String`	memberName

RemoveQuoteFromAlias(String)

View Source

Declaration
protected string RemoveQuoteFromAlias(string exp)

Returns

System.String

Parameters

Type	Name
`System.String`	exp

IsFieldName(Object)

View Source

Declaration
protected virtual bool IsFieldName(object quotedExp)

Returns

System.Boolean

Parameters

Type	Name
`System.Object`	quotedExp

GetColumnName(String)

View Source

Declaration
protected string GetColumnName(string fieldName)

Returns

System.String

Parameters

Type	Name
`System.String`	fieldName

GetTrueExpression()

View Source

Declaration
protected object GetTrueExpression()

Returns

System.Object

GetFalseExpression()

View Source

Declaration
protected object GetFalseExpression()

Returns

System.Object

GetQuotedTrueValue()

View Source

Declaration
protected object GetQuotedTrueValue()

Returns

System.Object

GetQuotedFalseValue()

View Source

Declaration
protected object GetQuotedFalseValue()

Returns

System.Object

GetAllFields()

View Source

Declaration
public IList<string> GetAllFields()

Returns

IList<System.String>

IsStaticArrayMethod(MethodCallExpression)

View Source

Declaration
protected virtual bool IsStaticArrayMethod(MethodCallExpression m)

Returns

System.Boolean

Parameters

Type	Name
`MethodCallExpression`	m

VisitStaticArrayMethodCall(MethodCallExpression)

View Source

Declaration
protected virtual object VisitStaticArrayMethodCall(MethodCallExpression m)

Returns

System.Object

Parameters

Type	Name
`MethodCallExpression`	m

VisitEnumerableMethodCall(MethodCallExpression)

View Source

Declaration
protected virtual object VisitEnumerableMethodCall(MethodCallExpression m)

Returns

System.Object

Parameters

Type	Name
`MethodCallExpression`	m

IsStaticStringMethod(MethodCallExpression)

View Source

Declaration
protected virtual bool IsStaticStringMethod(MethodCallExpression m)

Returns

System.Boolean

Parameters

Type	Name
`MethodCallExpression`	m

VisitStaticStringMethodCall(MethodCallExpression)

View Source

Declaration
protected virtual object VisitStaticStringMethodCall(MethodCallExpression m)

Returns

System.Object

Parameters

Type	Name
`MethodCallExpression`	m

ToLengthPartialString(Object)

View Source

Declaration
protected virtual PartialSqlString ToLengthPartialString(object arg)

Returns

ServiceStack.OrmLite.PartialSqlString

Parameters

Type	Name
`System.Object`	arg

ToConcatPartialString(List<Object>)

View Source

Declaration
protected PartialSqlString ToConcatPartialString(List<object> args)

Returns

ServiceStack.OrmLite.PartialSqlString

Parameters

Type	Name
`List<System.Object>`	args

ToComparePartialString(List<Object>)

View Source

Declaration
protected virtual PartialSqlString ToComparePartialString(List<object> args)

Returns

ServiceStack.OrmLite.PartialSqlString

Parameters

Type	Name
`List<System.Object>`	args

VisitSqlMethodCall(MethodCallExpression)

View Source

Declaration
protected virtual object VisitSqlMethodCall(MethodCallExpression m)

Returns

System.Object

Parameters

Type	Name
`MethodCallExpression`	m

ConvertInExpressionToSql(MethodCallExpression, Object)

View Source

Declaration
protected string ConvertInExpressionToSql(MethodCallExpression m, object quotedColName)

Returns

System.String

Parameters

Type	Name
`MethodCallExpression`	m
`System.Object`	quotedColName

CreateInSubQuerySql(Object, String)

View Source

Declaration
protected virtual string CreateInSubQuerySql(object quotedColName, string subSelect)

Returns

System.String

Parameters

Type	Name
`System.Object`	quotedColName
`System.String`	subSelect

VisitColumnAccessMethod(MethodCallExpression)

View Source

Declaration
protected virtual object VisitColumnAccessMethod(MethodCallExpression m)

Returns

System.Object

Parameters

Type	Name
`MethodCallExpression`	m

ToCast(String)

View Source

Declaration
protected virtual string ToCast(string quotedColName)

Returns

System.String

Parameters

Type	Name
`System.String`	quotedColName

GetSubstringSql(Object, Int32, Nullable<Int32>)

View Source

Declaration
public virtual string GetSubstringSql(object quotedColumn, int startIndex, int? length = null)

Returns

System.String

Parameters

Type	Name
`System.Object`	quotedColumn
`System.Int32`	startIndex
`System.Nullable<System.Int32>`	length

CreateParam(String, Object, ParameterDirection, Nullable<DbType>, DataRowVersion)

View Source

Declaration
public IDbDataParameter CreateParam(string name, object value = null, ParameterDirection direction = null, DbType? dbType = null, DataRowVersion sourceVersion = null)

Returns

IDbDataParameter

Parameters

Type	Name
`System.String`	name
`System.Object`	value
`ParameterDirection`	direction
`System.Nullable<DbType>`	dbType
`DataRowVersion`	sourceVersion

GetUntyped()

View Source

Declaration
public IUntypedSqlExpression GetUntyped()

Returns

ServiceStack.OrmLite.IUntypedSqlExpression

GetAllTables()

View Source

Declaration
public List<ModelDefinition> GetAllTables()

Returns

List<ServiceStack.OrmLite.ModelDefinition>

AddReferenceTableIfNotExists<Target>()

View Source

Declaration
public SqlExpression<T> AddReferenceTableIfNotExists<Target>()

Returns

ServiceStack.OrmLite.SqlExpression<T>

Type Parameters

Target

CustomJoin<Target>(String)

View Source

Declaration
public SqlExpression<T> CustomJoin<Target>(string joinString)

Returns

ServiceStack.OrmLite.SqlExpression<T>

Parameters

Type	Name
`System.String`	joinString

Type Parameters

Target

IsJoinedTable(Type)

View Source

Declaration
public bool IsJoinedTable(Type type)

Returns

System.Boolean

Parameters

Type	Name
`Type`	type

Join<Target>(Expression<Func<T, Target, Boolean>>)

View Source

Declaration
public SqlExpression<T> Join<Target>(Expression<Func<T, Target, bool>> joinExpr = null)

Returns

ServiceStack.OrmLite.SqlExpression<T>

Parameters

Type	Name
`Expression<Func<<T>,<Target>,System.Boolean>>`	joinExpr

Type Parameters

Target

Join<Target>(Expression<Func<T, Target, Boolean>>, TableOptions)

View Source

Declaration
public SqlExpression<T> Join<Target>(Expression<Func<T, Target, bool>> joinExpr, TableOptions options)

Returns

ServiceStack.OrmLite.SqlExpression<T>

Parameters

Type	Name
`Expression<Func<<T>,<Target>,System.Boolean>>`	joinExpr
ServiceStack.OrmLite.TableOptions	options

Type Parameters

Target

Join<Target>(Expression<Func<T, Target, Boolean>>, JoinFormatDelegate)

View Source

Declaration
public SqlExpression<T> Join<Target>(Expression<Func<T, Target, bool>> joinExpr, JoinFormatDelegate joinFormat)

Returns

ServiceStack.OrmLite.SqlExpression<T>

Parameters

Type	Name
`Expression<Func<<T>,<Target>,System.Boolean>>`	joinExpr
ServiceStack.OrmLite.JoinFormatDelegate	joinFormat

Type Parameters

Target

Join<Source, Target>(Expression<Func<Source, Target, Boolean>>)

View Source

Declaration
public SqlExpression<T> Join<Source, Target>(Expression<Func<Source, Target, bool>> joinExpr = null)

Returns

ServiceStack.OrmLite.SqlExpression<T>

Parameters

Type	Name
`Expression<Func<<Source>,<Target>,System.Boolean>>`	joinExpr

Type Parameters

Source
Target

Join<Source, Target>(Expression<Func<Source, Target, Boolean>>, JoinFormatDelegate)

View Source

Declaration
public SqlExpression<T> Join<Source, Target>(Expression<Func<Source, Target, bool>> joinExpr, JoinFormatDelegate joinFormat)

Returns

ServiceStack.OrmLite.SqlExpression<T>

Parameters

Type	Name
`Expression<Func<<Source>,<Target>,System.Boolean>>`	joinExpr
ServiceStack.OrmLite.JoinFormatDelegate	joinFormat

Type Parameters

Source
Target

Join<Source, Target>(Expression<Func<Source, Target, Boolean>>, TableOptions)

View Source

Declaration
public SqlExpression<T> Join<Source, Target>(Expression<Func<Source, Target, bool>> joinExpr, TableOptions options)

Returns

ServiceStack.OrmLite.SqlExpression<T>

Parameters

Type	Name
`Expression<Func<<Source>,<Target>,System.Boolean>>`	joinExpr
ServiceStack.OrmLite.TableOptions	options

Type Parameters

Source
Target

Join(Type, Type, Expression)

View Source

Declaration
public SqlExpression<T> Join(Type sourceType, Type targetType, Expression joinExpr = null)

Returns

ServiceStack.OrmLite.SqlExpression<T>

Parameters

Type	Name
`Type`	sourceType
`Type`	targetType
`Expression`	joinExpr

LeftJoin<Target>(Expression<Func<T, Target, Boolean>>)

View Source

Declaration
public SqlExpression<T> LeftJoin<Target>(Expression<Func<T, Target, bool>> joinExpr = null)

Returns

ServiceStack.OrmLite.SqlExpression<T>

Parameters

Type	Name
`Expression<Func<<T>,<Target>,System.Boolean>>`	joinExpr

Type Parameters

Target

LeftJoin<Target>(Expression<Func<T, Target, Boolean>>, JoinFormatDelegate)

View Source

Declaration
public SqlExpression<T> LeftJoin<Target>(Expression<Func<T, Target, bool>> joinExpr, JoinFormatDelegate joinFormat)

Returns

ServiceStack.OrmLite.SqlExpression<T>

Parameters

Type	Name
`Expression<Func<<T>,<Target>,System.Boolean>>`	joinExpr
ServiceStack.OrmLite.JoinFormatDelegate	joinFormat

Type Parameters

Target

LeftJoin<Target>(Expression<Func<T, Target, Boolean>>, TableOptions)

View Source

Declaration
public SqlExpression<T> LeftJoin<Target>(Expression<Func<T, Target, bool>> joinExpr, TableOptions options)

Returns

ServiceStack.OrmLite.SqlExpression<T>

Parameters

Type	Name
`Expression<Func<<T>,<Target>,System.Boolean>>`	joinExpr
ServiceStack.OrmLite.TableOptions	options

Type Parameters

Target

LeftJoin<Source, Target>(Expression<Func<Source, Target, Boolean>>)

View Source

Declaration
public SqlExpression<T> LeftJoin<Source, Target>(Expression<Func<Source, Target, bool>> joinExpr = null)

Returns

ServiceStack.OrmLite.SqlExpression<T>

Parameters

Type	Name
`Expression<Func<<Source>,<Target>,System.Boolean>>`	joinExpr

Type Parameters

Source
Target

LeftJoin<Source, Target>(Expression<Func<Source, Target, Boolean>>, JoinFormatDelegate)

View Source

Declaration
public SqlExpression<T> LeftJoin<Source, Target>(Expression<Func<Source, Target, bool>> joinExpr, JoinFormatDelegate joinFormat)

Returns

ServiceStack.OrmLite.SqlExpression<T>

Parameters

Type	Name
`Expression<Func<<Source>,<Target>,System.Boolean>>`	joinExpr
ServiceStack.OrmLite.JoinFormatDelegate	joinFormat

Type Parameters

Source
Target

LeftJoin<Source, Target>(Expression<Func<Source, Target, Boolean>>, TableOptions)

View Source

Declaration
public SqlExpression<T> LeftJoin<Source, Target>(Expression<Func<Source, Target, bool>> joinExpr, TableOptions options)

Returns

ServiceStack.OrmLite.SqlExpression<T>

Parameters

Type	Name
`Expression<Func<<Source>,<Target>,System.Boolean>>`	joinExpr
ServiceStack.OrmLite.TableOptions	options

Type Parameters

Source
Target

LeftJoin(Type, Type, Expression)

View Source

Declaration
public SqlExpression<T> LeftJoin(Type sourceType, Type targetType, Expression joinExpr = null)

Returns

ServiceStack.OrmLite.SqlExpression<T>

Parameters

Type	Name
`Type`	sourceType
`Type`	targetType
`Expression`	joinExpr

RightJoin<Target>(Expression<Func<T, Target, Boolean>>)

View Source

Declaration
public SqlExpression<T> RightJoin<Target>(Expression<Func<T, Target, bool>> joinExpr = null)

Returns

ServiceStack.OrmLite.SqlExpression<T>

Parameters

Type	Name
`Expression<Func<<T>,<Target>,System.Boolean>>`	joinExpr

Type Parameters

Target

RightJoin<Target>(Expression<Func<T, Target, Boolean>>, JoinFormatDelegate)

View Source

Declaration
public SqlExpression<T> RightJoin<Target>(Expression<Func<T, Target, bool>> joinExpr, JoinFormatDelegate joinFormat)

Returns

ServiceStack.OrmLite.SqlExpression<T>

Parameters

Type	Name
`Expression<Func<<T>,<Target>,System.Boolean>>`	joinExpr
ServiceStack.OrmLite.JoinFormatDelegate	joinFormat

Type Parameters

Target

RightJoin<Target>(Expression<Func<T, Target, Boolean>>, TableOptions)

View Source

Declaration
public SqlExpression<T> RightJoin<Target>(Expression<Func<T, Target, bool>> joinExpr, TableOptions options)

Returns

ServiceStack.OrmLite.SqlExpression<T>

Parameters

Type	Name
`Expression<Func<<T>,<Target>,System.Boolean>>`	joinExpr
ServiceStack.OrmLite.TableOptions	options

Type Parameters

Target

RightJoin<Source, Target>(Expression<Func<Source, Target, Boolean>>)

View Source

Declaration
public SqlExpression<T> RightJoin<Source, Target>(Expression<Func<Source, Target, bool>> joinExpr = null)

Returns

ServiceStack.OrmLite.SqlExpression<T>

Parameters

Type	Name
`Expression<Func<<Source>,<Target>,System.Boolean>>`	joinExpr

Type Parameters

Source
Target

RightJoin<Source, Target>(Expression<Func<Source, Target, Boolean>>, JoinFormatDelegate)

View Source

Declaration
public SqlExpression<T> RightJoin<Source, Target>(Expression<Func<Source, Target, bool>> joinExpr, JoinFormatDelegate joinFormat)

Returns

ServiceStack.OrmLite.SqlExpression<T>

Parameters

Type	Name
`Expression<Func<<Source>,<Target>,System.Boolean>>`	joinExpr
ServiceStack.OrmLite.JoinFormatDelegate	joinFormat

Type Parameters

Source
Target

RightJoin<Source, Target>(Expression<Func<Source, Target, Boolean>>, TableOptions)

View Source

Declaration
public SqlExpression<T> RightJoin<Source, Target>(Expression<Func<Source, Target, bool>> joinExpr, TableOptions options)

Returns

ServiceStack.OrmLite.SqlExpression<T>

Parameters

Type	Name
`Expression<Func<<Source>,<Target>,System.Boolean>>`	joinExpr
ServiceStack.OrmLite.TableOptions	options

Type Parameters

Source
Target

FullJoin<Target>(Expression<Func<T, Target, Boolean>>)

View Source

Declaration
public SqlExpression<T> FullJoin<Target>(Expression<Func<T, Target, bool>> joinExpr = null)

Returns

ServiceStack.OrmLite.SqlExpression<T>

Parameters

Type	Name
`Expression<Func<<T>,<Target>,System.Boolean>>`	joinExpr

Type Parameters

Target

FullJoin<Source, Target>(Expression<Func<Source, Target, Boolean>>)

View Source

Declaration
public SqlExpression<T> FullJoin<Source, Target>(Expression<Func<Source, Target, bool>> joinExpr = null)

Returns

ServiceStack.OrmLite.SqlExpression<T>

Parameters

Type	Name
`Expression<Func<<Source>,<Target>,System.Boolean>>`	joinExpr

Type Parameters

Source
Target

CrossJoin<Target>(Expression<Func<T, Target, Boolean>>)

View Source

Declaration
public SqlExpression<T> CrossJoin<Target>(Expression<Func<T, Target, bool>> joinExpr = null)

Returns

ServiceStack.OrmLite.SqlExpression<T>

Parameters

Type	Name
`Expression<Func<<T>,<Target>,System.Boolean>>`	joinExpr

Type Parameters

Target

CrossJoin<Source, Target>(Expression<Func<Source, Target, Boolean>>)

View Source

Declaration
public SqlExpression<T> CrossJoin<Source, Target>(Expression<Func<Source, Target, bool>> joinExpr = null)

Returns

ServiceStack.OrmLite.SqlExpression<T>

Parameters

Type	Name
`Expression<Func<<Source>,<Target>,System.Boolean>>`	joinExpr

Type Parameters

Source
Target

InternalJoin<Source, Target>(String, Expression<Func<Source, Target, Boolean>>, JoinFormatDelegate)

View Source

Declaration
protected SqlExpression<T> InternalJoin<Source, Target>(string joinType, Expression<Func<Source, Target, bool>> joinExpr, JoinFormatDelegate joinFormat)

Returns

ServiceStack.OrmLite.SqlExpression<T>

Parameters

Type	Name
`System.String`	joinType
`Expression<Func<<Source>,<Target>,System.Boolean>>`	joinExpr
ServiceStack.OrmLite.JoinFormatDelegate	joinFormat

Type Parameters

Source
Target

InternalJoin<Source, Target>(String, Expression<Func<Source, Target, Boolean>>, TableOptions)

View Source

Declaration
protected SqlExpression<T> InternalJoin<Source, Target>(string joinType, Expression<Func<Source, Target, bool>> joinExpr, TableOptions options = null)

Returns

ServiceStack.OrmLite.SqlExpression<T>

Parameters

Type	Name
`System.String`	joinType
`Expression<Func<<Source>,<Target>,System.Boolean>>`	joinExpr
ServiceStack.OrmLite.TableOptions	options

Type Parameters

Source
Target

InternalJoin<Source, Target>(String, Expression)

View Source

Declaration
protected SqlExpression<T> InternalJoin<Source, Target>(string joinType, Expression joinExpr)

Returns

ServiceStack.OrmLite.SqlExpression<T>

Parameters

Type	Name
`System.String`	joinType
`Expression`	joinExpr

Type Parameters

Source
Target

Join<Source, Target, T3>(Expression<Func<Source, Target, T3, Boolean>>)

View Source

Declaration
public SqlExpression<T> Join<Source, Target, T3>(Expression<Func<Source, Target, T3, bool>> joinExpr)

Returns

ServiceStack.OrmLite.SqlExpression<T>

Parameters

Type	Name
`Expression<Func<<Source>,<Target>,<T3>,System.Boolean>>`	joinExpr

Type Parameters

Source
Target
T3

LeftJoin<Source, Target, T3>(Expression<Func<Source, Target, T3, Boolean>>)

View Source

Declaration
public SqlExpression<T> LeftJoin<Source, Target, T3>(Expression<Func<Source, Target, T3, bool>> joinExpr)

Returns

ServiceStack.OrmLite.SqlExpression<T>

Parameters

Type	Name
`Expression<Func<<Source>,<Target>,<T3>,System.Boolean>>`	joinExpr

Type Parameters

Source
Target
T3

RightJoin<Source, Target, T3>(Expression<Func<Source, Target, T3, Boolean>>)

View Source

Declaration
public SqlExpression<T> RightJoin<Source, Target, T3>(Expression<Func<Source, Target, T3, bool>> joinExpr)

Returns

ServiceStack.OrmLite.SqlExpression<T>

Parameters

Type	Name
`Expression<Func<<Source>,<Target>,<T3>,System.Boolean>>`	joinExpr

Type Parameters

Source
Target
T3

FullJoin<Source, Target, T3>(Expression<Func<Source, Target, T3, Boolean>>)

View Source

Declaration
public SqlExpression<T> FullJoin<Source, Target, T3>(Expression<Func<Source, Target, T3, bool>> joinExpr)

Returns

ServiceStack.OrmLite.SqlExpression<T>

Parameters

Type	Name
`Expression<Func<<Source>,<Target>,<T3>,System.Boolean>>`	joinExpr

Type Parameters

Source
Target
T3

Join<Source, Target, T3, T4>(Expression<Func<Source, Target, T3, T4, Boolean>>)

View Source

Declaration
public SqlExpression<T> Join<Source, Target, T3, T4>(Expression<Func<Source, Target, T3, T4, bool>> joinExpr)

Returns

ServiceStack.OrmLite.SqlExpression<T>

Parameters

Type	Name
`Expression<Func<<Source>,<Target>,<T3>,<T4>,System.Boolean>>`	joinExpr

Type Parameters

Source
Target
T3
T4

LeftJoin<Source, Target, T3, T4>(Expression<Func<Source, Target, T3, T4, Boolean>>)

View Source

Declaration
public SqlExpression<T> LeftJoin<Source, Target, T3, T4>(Expression<Func<Source, Target, T3, T4, bool>> joinExpr)

Returns

ServiceStack.OrmLite.SqlExpression<T>

Parameters

Type	Name
`Expression<Func<<Source>,<Target>,<T3>,<T4>,System.Boolean>>`	joinExpr

Type Parameters

Source
Target
T3
T4

RightJoin<Source, Target, T3, T4>(Expression<Func<Source, Target, T3, T4, Boolean>>)

View Source

Declaration
public SqlExpression<T> RightJoin<Source, Target, T3, T4>(Expression<Func<Source, Target, T3, T4, bool>> joinExpr)

Returns

ServiceStack.OrmLite.SqlExpression<T>

Parameters

Type	Name
`Expression<Func<<Source>,<Target>,<T3>,<T4>,System.Boolean>>`	joinExpr

Type Parameters

Source
Target
T3
T4

FullJoin<Source, Target, T3, T4>(Expression<Func<Source, Target, T3, T4, Boolean>>)

View Source

Declaration
public SqlExpression<T> FullJoin<Source, Target, T3, T4>(Expression<Func<Source, Target, T3, T4, bool>> joinExpr)

Returns

ServiceStack.OrmLite.SqlExpression<T>

Parameters

Type	Name
`Expression<Func<<Source>,<Target>,<T3>,<T4>,System.Boolean>>`	joinExpr

Type Parameters

Source
Target
T3
T4

CustomJoin(String)

View Source

Declaration
public SqlExpression<T> CustomJoin(string joinString)

Returns

ServiceStack.OrmLite.SqlExpression<T>

Parameters

Type	Name
`System.String`	joinString

InternalJoin(String, Expression, ModelDefinition, ModelDefinition, TableOptions)

View Source

Declaration
protected virtual SqlExpression<T> InternalJoin(string joinType, Expression joinExpr, ModelDefinition sourceDef, ModelDefinition targetDef, TableOptions options = null)

Returns

ServiceStack.OrmLite.SqlExpression<T>

Parameters

Type	Name
`System.String`	joinType
`Expression`	joinExpr
ServiceStack.OrmLite.ModelDefinition	sourceDef
ServiceStack.OrmLite.ModelDefinition	targetDef
ServiceStack.OrmLite.TableOptions	options

SelectInto<TModel>()

View Source

Declaration
public string SelectInto<TModel>()

Returns

System.String

Type Parameters

TModel

SelectInto<TModel>(QueryType)

View Source

Declaration
public string SelectInto<TModel>(QueryType queryType)

Returns

System.String

Parameters

Type	Name
ServiceStack.OrmLite.QueryType	queryType

Type Parameters

TModel

Where<Target>(Expression<Func<Target, Boolean>>)

View Source

Declaration
public virtual SqlExpression<T> Where<Target>(Expression<Func<Target, bool>> predicate)

Returns

ServiceStack.OrmLite.SqlExpression<T>

Parameters

Type	Name
`Expression<Func<<Target>,System.Boolean>>`	predicate

Type Parameters

Target

Where<Source, Target>(Expression<Func<Source, Target, Boolean>>)

View Source

Declaration
public virtual SqlExpression<T> Where<Source, Target>(Expression<Func<Source, Target, bool>> predicate)

Returns

ServiceStack.OrmLite.SqlExpression<T>

Parameters

Type	Name
`Expression<Func<<Source>,<Target>,System.Boolean>>`	predicate

Type Parameters

Source
Target

Where<T1, T2, T3>(Expression<Func<T1, T2, T3, Boolean>>)

View Source

Declaration
public virtual SqlExpression<T> Where<T1, T2, T3>(Expression<Func<T1, T2, T3, bool>> predicate)

Returns

ServiceStack.OrmLite.SqlExpression<T>

Parameters

Type	Name
`Expression<Func<<T1>,<T2>,<T3>,System.Boolean>>`	predicate

Type Parameters

T1
T2
T3

Where<T1, T2, T3, T4>(Expression<Func<T1, T2, T3, T4, Boolean>>)

View Source

Declaration
public virtual SqlExpression<T> Where<T1, T2, T3, T4>(Expression<Func<T1, T2, T3, T4, bool>> predicate)

Returns

ServiceStack.OrmLite.SqlExpression<T>

Parameters

Type	Name
`Expression<Func<<T1>,<T2>,<T3>,<T4>,System.Boolean>>`	predicate

Type Parameters

T1
T2
T3
T4

Where<T1, T2, T3, T4, T5>(Expression<Func<T1, T2, T3, T4, T5, Boolean>>)

View Source

Declaration
public virtual SqlExpression<T> Where<T1, T2, T3, T4, T5>(Expression<Func<T1, T2, T3, T4, T5, bool>> predicate)

Returns

ServiceStack.OrmLite.SqlExpression<T>

Parameters

Type	Name
`Expression<Func<<T1>,<T2>,<T3>,<T4>,<T5>,System.Boolean>>`	predicate

Type Parameters

T1
T2
T3
T4
T5

Where<T1, T2, T3, T4, T5, T6>(Expression<Func<T1, T2, T3, T4, T5, T6, Boolean>>)

View Source

Declaration
public virtual SqlExpression<T> Where<T1, T2, T3, T4, T5, T6>(Expression<Func<T1, T2, T3, T4, T5, T6, bool>> predicate)

Returns

ServiceStack.OrmLite.SqlExpression<T>

Parameters

Type	Name
`Expression<Func<<T1>,<T2>,<T3>,<T4>,<T5>,<T6>,System.Boolean>>`	predicate

Type Parameters

T1
T2
T3
T4
T5
T6

Where<T1, T2, T3, T4, T5, T6, T7>(Expression<Func<T1, T2, T3, T4, T5, T6, T7, Boolean>>)

View Source

Declaration
public virtual SqlExpression<T> Where<T1, T2, T3, T4, T5, T6, T7>(Expression<Func<T1, T2, T3, T4, T5, T6, T7, bool>> predicate)

Returns

ServiceStack.OrmLite.SqlExpression<T>

Parameters

Type	Name
`Expression<Func<<T1>,<T2>,<T3>,<T4>,<T5>,<T6>,<T7>,System.Boolean>>`	predicate

Type Parameters

T1
T2
T3
T4
T5
T6
T7

Where<T1, T2, T3, T4, T5, T6, T7, T8>(Expression<Func<T1, T2, T3, T4, T5, T6, T7, T8, Boolean>>)

View Source

Declaration
public virtual SqlExpression<T> Where<T1, T2, T3, T4, T5, T6, T7, T8>(Expression<Func<T1, T2, T3, T4, T5, T6, T7, T8, bool>> predicate)

Returns

ServiceStack.OrmLite.SqlExpression<T>

Parameters

Type	Name
`Expression<Func<<T1>,<T2>,<T3>,<T4>,<T5>,<T6>,<T7>,<T8>,System.Boolean>>`	predicate

Type Parameters

T1
T2
T3
T4
T5
T6
T7
T8

Where<T1, T2, T3, T4, T5, T6, T7, T8, T9>(Expression<Func<T1, T2, T3, T4, T5, T6, T7, T8, T9, Boolean>>)

View Source

Declaration
public virtual SqlExpression<T> Where<T1, T2, T3, T4, T5, T6, T7, T8, T9>(Expression<Func<T1, T2, T3, T4, T5, T6, T7, T8, T9, bool>> predicate)

Returns

ServiceStack.OrmLite.SqlExpression<T>

Parameters

Type	Name
`Expression<Func<<T1>,<T2>,<T3>,<T4>,<T5>,<T6>,<T7>,<T8>,<T9>,System.Boolean>>`	predicate

Type Parameters

T1
T2
T3
T4
T5
T6
T7
T8
T9

Where<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10>(Expression<Func<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, Boolean>>)

View Source

Declaration
public virtual SqlExpression<T> Where<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10>(Expression<Func<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, bool>> predicate)

Returns

ServiceStack.OrmLite.SqlExpression<T>

Parameters

Type	Name
`Expression<Func<<T1>,<T2>,<T3>,<T4>,<T5>,<T6>,<T7>,<T8>,<T9>,<T10>,System.Boolean>>`	predicate

Type Parameters

T1
T2
T3
T4
T5
T6
T7
T8
T9
T10

Where<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11>(Expression<Func<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, Boolean>>)

View Source

Declaration
public virtual SqlExpression<T> Where<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11>(Expression<Func<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, bool>> predicate)

Returns

ServiceStack.OrmLite.SqlExpression<T>

Parameters

Type	Name
`Expression<Func<<T1>,<T2>,<T3>,<T4>,<T5>,<T6>,<T7>,<T8>,<T9>,<T10>,<T11>,System.Boolean>>`	predicate

Type Parameters

T1
T2
T3
T4
T5
T6
T7
T8
T9
T10
T11

Where<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12>(Expression<Func<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, Boolean>>)

View Source

Declaration
public virtual SqlExpression<T> Where<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12>(Expression<Func<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, bool>> predicate)

Returns

ServiceStack.OrmLite.SqlExpression<T>

Parameters

Type	Name
`Expression<Func<<T1>,<T2>,<T3>,<T4>,<T5>,<T6>,<T7>,<T8>,<T9>,<T10>,<T11>,<T12>,System.Boolean>>`	predicate

Type Parameters

T1
T2
T3
T4
T5
T6
T7
T8
T9
T10
T11
T12

Where<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13>(Expression<Func<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, Boolean>>)

View Source

Declaration
public virtual SqlExpression<T> Where<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13>(Expression<Func<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, bool>> predicate)

Returns

ServiceStack.OrmLite.SqlExpression<T>

Parameters

Type	Name
`Expression<Func<<T1>,<T2>,<T3>,<T4>,<T5>,<T6>,<T7>,<T8>,<T9>,<T10>,<T11>,<T12>,<T13>,System.Boolean>>`	predicate

Type Parameters

T1
T2
T3
T4
T5
T6
T7
T8
T9
T10
T11
T12
T13

Where<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14>(Expression<Func<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, Boolean>>)

View Source

Declaration
public virtual SqlExpression<T> Where<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14>(Expression<Func<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, bool>> predicate)

Returns

ServiceStack.OrmLite.SqlExpression<T>

Parameters

Type	Name
`Expression<Func<<T1>,<T2>,<T3>,<T4>,<T5>,<T6>,<T7>,<T8>,<T9>,<T10>,<T11>,<T12>,<T13>,<T14>,System.Boolean>>`	predicate

Type Parameters

T1
T2
T3
T4
T5
T6
T7
T8
T9
T10
T11
T12
T13
T14

Where<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15>(Expression<Func<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, Boolean>>)

View Source

Declaration
public virtual SqlExpression<T> Where<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15>(Expression<Func<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, bool>> predicate)

Returns

ServiceStack.OrmLite.SqlExpression<T>

Parameters

Type	Name
`Expression<Func<<T1>,<T2>,<T3>,<T4>,<T5>,<T6>,<T7>,<T8>,<T9>,<T10>,<T11>,<T12>,<T13>,<T14>,<T15>,System.Boolean>>`	predicate

Type Parameters

T1
T2
T3
T4
T5
T6
T7
T8
T9
T10
T11
T12
T13
T14
T15

And<Target>(Expression<Func<Target, Boolean>>)

View Source

Declaration
public virtual SqlExpression<T> And<Target>(Expression<Func<Target, bool>> predicate)

Returns

ServiceStack.OrmLite.SqlExpression<T>

Parameters

Type	Name
`Expression<Func<<Target>,System.Boolean>>`	predicate

Type Parameters

Target

And<Source, Target>(Expression<Func<Source, Target, Boolean>>)

View Source

Declaration
public virtual SqlExpression<T> And<Source, Target>(Expression<Func<Source, Target, bool>> predicate)

Returns

ServiceStack.OrmLite.SqlExpression<T>

Parameters

Type	Name
`Expression<Func<<Source>,<Target>,System.Boolean>>`	predicate

Type Parameters

Source
Target

And<T1, T2, T3>(Expression<Func<T1, T2, T3, Boolean>>)

View Source

Declaration
public virtual SqlExpression<T> And<T1, T2, T3>(Expression<Func<T1, T2, T3, bool>> predicate)

Returns

ServiceStack.OrmLite.SqlExpression<T>

Parameters

Type	Name
`Expression<Func<<T1>,<T2>,<T3>,System.Boolean>>`	predicate

Type Parameters

T1
T2
T3

And<T1, T2, T3, T4>(Expression<Func<T1, T2, T3, T4, Boolean>>)

View Source

Declaration
public virtual SqlExpression<T> And<T1, T2, T3, T4>(Expression<Func<T1, T2, T3, T4, bool>> predicate)

Returns

ServiceStack.OrmLite.SqlExpression<T>

Parameters

Type	Name
`Expression<Func<<T1>,<T2>,<T3>,<T4>,System.Boolean>>`	predicate

Type Parameters

T1
T2
T3
T4

And<T1, T2, T3, T4, T5>(Expression<Func<T1, T2, T3, T4, T5, Boolean>>)

View Source

Declaration
public virtual SqlExpression<T> And<T1, T2, T3, T4, T5>(Expression<Func<T1, T2, T3, T4, T5, bool>> predicate)

Returns

ServiceStack.OrmLite.SqlExpression<T>

Parameters

Type	Name
`Expression<Func<<T1>,<T2>,<T3>,<T4>,<T5>,System.Boolean>>`	predicate

Type Parameters

T1
T2
T3
T4
T5

And<T1, T2, T3, T4, T5, T6>(Expression<Func<T1, T2, T3, T4, T5, T6, Boolean>>)

View Source

Declaration
public virtual SqlExpression<T> And<T1, T2, T3, T4, T5, T6>(Expression<Func<T1, T2, T3, T4, T5, T6, bool>> predicate)

Returns

ServiceStack.OrmLite.SqlExpression<T>

Parameters

Type	Name
`Expression<Func<<T1>,<T2>,<T3>,<T4>,<T5>,<T6>,System.Boolean>>`	predicate

Type Parameters

T1
T2
T3
T4
T5
T6

And<T1, T2, T3, T4, T5, T6, T7>(Expression<Func<T1, T2, T3, T4, T5, T6, T7, Boolean>>)

View Source

Declaration
public virtual SqlExpression<T> And<T1, T2, T3, T4, T5, T6, T7>(Expression<Func<T1, T2, T3, T4, T5, T6, T7, bool>> predicate)

Returns

ServiceStack.OrmLite.SqlExpression<T>

Parameters

Type	Name
`Expression<Func<<T1>,<T2>,<T3>,<T4>,<T5>,<T6>,<T7>,System.Boolean>>`	predicate

Type Parameters

T1
T2
T3
T4
T5
T6
T7

And<T1, T2, T3, T4, T5, T6, T7, T8>(Expression<Func<T1, T2, T3, T4, T5, T6, T7, T8, Boolean>>)

View Source

Declaration
public virtual SqlExpression<T> And<T1, T2, T3, T4, T5, T6, T7, T8>(Expression<Func<T1, T2, T3, T4, T5, T6, T7, T8, bool>> predicate)

Returns

ServiceStack.OrmLite.SqlExpression<T>

Parameters

Type	Name
`Expression<Func<<T1>,<T2>,<T3>,<T4>,<T5>,<T6>,<T7>,<T8>,System.Boolean>>`	predicate

Type Parameters

T1
T2
T3
T4
T5
T6
T7
T8

And<T1, T2, T3, T4, T5, T6, T7, T8, T9>(Expression<Func<T1, T2, T3, T4, T5, T6, T7, T8, T9, Boolean>>)

View Source

Declaration
public virtual SqlExpression<T> And<T1, T2, T3, T4, T5, T6, T7, T8, T9>(Expression<Func<T1, T2, T3, T4, T5, T6, T7, T8, T9, bool>> predicate)

Returns

ServiceStack.OrmLite.SqlExpression<T>

Parameters

Type	Name
`Expression<Func<<T1>,<T2>,<T3>,<T4>,<T5>,<T6>,<T7>,<T8>,<T9>,System.Boolean>>`	predicate

Type Parameters

T1
T2
T3
T4
T5
T6
T7
T8
T9

And<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10>(Expression<Func<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, Boolean>>)

View Source

Declaration
public virtual SqlExpression<T> And<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10>(Expression<Func<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, bool>> predicate)

Returns

ServiceStack.OrmLite.SqlExpression<T>

Parameters

Type	Name
`Expression<Func<<T1>,<T2>,<T3>,<T4>,<T5>,<T6>,<T7>,<T8>,<T9>,<T10>,System.Boolean>>`	predicate

Type Parameters

T1
T2
T3
T4
T5
T6
T7
T8
T9
T10

And<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11>(Expression<Func<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, Boolean>>)

View Source

Declaration
public virtual SqlExpression<T> And<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11>(Expression<Func<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, bool>> predicate)

Returns

ServiceStack.OrmLite.SqlExpression<T>

Parameters

Type	Name
`Expression<Func<<T1>,<T2>,<T3>,<T4>,<T5>,<T6>,<T7>,<T8>,<T9>,<T10>,<T11>,System.Boolean>>`	predicate

Type Parameters

T1
T2
T3
T4
T5
T6
T7
T8
T9
T10
T11

And<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12>(Expression<Func<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, Boolean>>)

View Source

Declaration
public virtual SqlExpression<T> And<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12>(Expression<Func<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, bool>> predicate)

Returns

ServiceStack.OrmLite.SqlExpression<T>

Parameters

Type	Name
`Expression<Func<<T1>,<T2>,<T3>,<T4>,<T5>,<T6>,<T7>,<T8>,<T9>,<T10>,<T11>,<T12>,System.Boolean>>`	predicate

Type Parameters

T1
T2
T3
T4
T5
T6
T7
T8
T9
T10
T11
T12

And<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13>(Expression<Func<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, Boolean>>)

View Source

Declaration
public virtual SqlExpression<T> And<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13>(Expression<Func<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, bool>> predicate)

Returns

ServiceStack.OrmLite.SqlExpression<T>

Parameters

Type	Name
`Expression<Func<<T1>,<T2>,<T3>,<T4>,<T5>,<T6>,<T7>,<T8>,<T9>,<T10>,<T11>,<T12>,<T13>,System.Boolean>>`	predicate

Type Parameters

T1
T2
T3
T4
T5
T6
T7
T8
T9
T10
T11
T12
T13

And<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14>(Expression<Func<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, Boolean>>)

View Source

Declaration
public virtual SqlExpression<T> And<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14>(Expression<Func<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, bool>> predicate)

Returns

ServiceStack.OrmLite.SqlExpression<T>

Parameters

Type	Name
`Expression<Func<<T1>,<T2>,<T3>,<T4>,<T5>,<T6>,<T7>,<T8>,<T9>,<T10>,<T11>,<T12>,<T13>,<T14>,System.Boolean>>`	predicate

Type Parameters

T1
T2
T3
T4
T5
T6
T7
T8
T9
T10
T11
T12
T13
T14

And<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15>(Expression<Func<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, Boolean>>)

View Source

Declaration
public virtual SqlExpression<T> And<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15>(Expression<Func<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, bool>> predicate)

Returns

ServiceStack.OrmLite.SqlExpression<T>

Parameters

Type	Name
`Expression<Func<<T1>,<T2>,<T3>,<T4>,<T5>,<T6>,<T7>,<T8>,<T9>,<T10>,<T11>,<T12>,<T13>,<T14>,<T15>,System.Boolean>>`	predicate

Type Parameters

T1
T2
T3
T4
T5
T6
T7
T8
T9
T10
T11
T12
T13
T14
T15

Or<Target>(Expression<Func<Target, Boolean>>)

View Source

Declaration
public virtual SqlExpression<T> Or<Target>(Expression<Func<Target, bool>> predicate)

Returns

ServiceStack.OrmLite.SqlExpression<T>

Parameters

Type	Name
`Expression<Func<<Target>,System.Boolean>>`	predicate

Type Parameters

Target

Or<Source, Target>(Expression<Func<Source, Target, Boolean>>)

View Source

Declaration
public virtual SqlExpression<T> Or<Source, Target>(Expression<Func<Source, Target, bool>> predicate)

Returns

ServiceStack.OrmLite.SqlExpression<T>

Parameters

Type	Name
`Expression<Func<<Source>,<Target>,System.Boolean>>`	predicate

Type Parameters

Source
Target

Or<T1, T2, T3>(Expression<Func<T1, T2, T3, Boolean>>)

View Source

Declaration
public virtual SqlExpression<T> Or<T1, T2, T3>(Expression<Func<T1, T2, T3, bool>> predicate)

Returns

ServiceStack.OrmLite.SqlExpression<T>

Parameters

Type	Name
`Expression<Func<<T1>,<T2>,<T3>,System.Boolean>>`	predicate

Type Parameters

T1
T2
T3

Or<T1, T2, T3, T4>(Expression<Func<T1, T2, T3, T4, Boolean>>)

View Source

Declaration
public virtual SqlExpression<T> Or<T1, T2, T3, T4>(Expression<Func<T1, T2, T3, T4, bool>> predicate)

Returns

ServiceStack.OrmLite.SqlExpression<T>

Parameters

Type	Name
`Expression<Func<<T1>,<T2>,<T3>,<T4>,System.Boolean>>`	predicate

Type Parameters

T1
T2
T3
T4

Or<T1, T2, T3, T4, T5>(Expression<Func<T1, T2, T3, T4, T5, Boolean>>)

View Source

Declaration
public virtual SqlExpression<T> Or<T1, T2, T3, T4, T5>(Expression<Func<T1, T2, T3, T4, T5, bool>> predicate)

Returns

ServiceStack.OrmLite.SqlExpression<T>

Parameters

Type	Name
`Expression<Func<<T1>,<T2>,<T3>,<T4>,<T5>,System.Boolean>>`	predicate

Type Parameters

T1
T2
T3
T4
T5

Or<T1, T2, T3, T4, T5, T6>(Expression<Func<T1, T2, T3, T4, T5, T6, Boolean>>)

View Source

Declaration
public virtual SqlExpression<T> Or<T1, T2, T3, T4, T5, T6>(Expression<Func<T1, T2, T3, T4, T5, T6, bool>> predicate)

Returns

ServiceStack.OrmLite.SqlExpression<T>

Parameters

Type	Name
`Expression<Func<<T1>,<T2>,<T3>,<T4>,<T5>,<T6>,System.Boolean>>`	predicate

Type Parameters

T1
T2
T3
T4
T5
T6

Or<T1, T2, T3, T4, T5, T6, T7>(Expression<Func<T1, T2, T3, T4, T5, T6, T7, Boolean>>)

View Source

Declaration
public virtual SqlExpression<T> Or<T1, T2, T3, T4, T5, T6, T7>(Expression<Func<T1, T2, T3, T4, T5, T6, T7, bool>> predicate)

Returns

ServiceStack.OrmLite.SqlExpression<T>

Parameters

Type	Name
`Expression<Func<<T1>,<T2>,<T3>,<T4>,<T5>,<T6>,<T7>,System.Boolean>>`	predicate

Type Parameters

T1
T2
T3
T4
T5
T6
T7

Or<T1, T2, T3, T4, T5, T6, T7, T8>(Expression<Func<T1, T2, T3, T4, T5, T6, T7, T8, Boolean>>)

View Source

Declaration
public virtual SqlExpression<T> Or<T1, T2, T3, T4, T5, T6, T7, T8>(Expression<Func<T1, T2, T3, T4, T5, T6, T7, T8, bool>> predicate)

Returns

ServiceStack.OrmLite.SqlExpression<T>

Parameters

Type	Name
`Expression<Func<<T1>,<T2>,<T3>,<T4>,<T5>,<T6>,<T7>,<T8>,System.Boolean>>`	predicate

Type Parameters

T1
T2
T3
T4
T5
T6
T7
T8

Or<T1, T2, T3, T4, T5, T6, T7, T8, T9>(Expression<Func<T1, T2, T3, T4, T5, T6, T7, T8, T9, Boolean>>)

View Source

Declaration
public virtual SqlExpression<T> Or<T1, T2, T3, T4, T5, T6, T7, T8, T9>(Expression<Func<T1, T2, T3, T4, T5, T6, T7, T8, T9, bool>> predicate)

Returns

ServiceStack.OrmLite.SqlExpression<T>

Parameters

Type	Name
`Expression<Func<<T1>,<T2>,<T3>,<T4>,<T5>,<T6>,<T7>,<T8>,<T9>,System.Boolean>>`	predicate

Type Parameters

T1
T2
T3
T4
T5
T6
T7
T8
T9

Or<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10>(Expression<Func<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, Boolean>>)

View Source

Declaration
public virtual SqlExpression<T> Or<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10>(Expression<Func<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, bool>> predicate)

Returns

ServiceStack.OrmLite.SqlExpression<T>

Parameters

Type	Name
`Expression<Func<<T1>,<T2>,<T3>,<T4>,<T5>,<T6>,<T7>,<T8>,<T9>,<T10>,System.Boolean>>`	predicate

Type Parameters

T1
T2
T3
T4
T5
T6
T7
T8
T9
T10

Or<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11>(Expression<Func<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, Boolean>>)

View Source

Declaration
public virtual SqlExpression<T> Or<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11>(Expression<Func<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, bool>> predicate)

Returns

ServiceStack.OrmLite.SqlExpression<T>

Parameters

Type	Name
`Expression<Func<<T1>,<T2>,<T3>,<T4>,<T5>,<T6>,<T7>,<T8>,<T9>,<T10>,<T11>,System.Boolean>>`	predicate

Type Parameters

T1
T2
T3
T4
T5
T6
T7
T8
T9
T10
T11

Or<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12>(Expression<Func<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, Boolean>>)

View Source

Declaration
public virtual SqlExpression<T> Or<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12>(Expression<Func<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, bool>> predicate)

Returns

ServiceStack.OrmLite.SqlExpression<T>

Parameters

Type	Name
`Expression<Func<<T1>,<T2>,<T3>,<T4>,<T5>,<T6>,<T7>,<T8>,<T9>,<T10>,<T11>,<T12>,System.Boolean>>`	predicate

Type Parameters

T1
T2
T3
T4
T5
T6
T7
T8
T9
T10
T11
T12

Or<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13>(Expression<Func<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, Boolean>>)

View Source

Declaration
public virtual SqlExpression<T> Or<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13>(Expression<Func<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, bool>> predicate)

Returns

ServiceStack.OrmLite.SqlExpression<T>

Parameters

Type	Name
`Expression<Func<<T1>,<T2>,<T3>,<T4>,<T5>,<T6>,<T7>,<T8>,<T9>,<T10>,<T11>,<T12>,<T13>,System.Boolean>>`	predicate

Type Parameters

T1
T2
T3
T4
T5
T6
T7
T8
T9
T10
T11
T12
T13

Or<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14>(Expression<Func<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, Boolean>>)

View Source

Declaration
public virtual SqlExpression<T> Or<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14>(Expression<Func<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, bool>> predicate)

Returns

ServiceStack.OrmLite.SqlExpression<T>

Parameters

Type	Name
`Expression<Func<<T1>,<T2>,<T3>,<T4>,<T5>,<T6>,<T7>,<T8>,<T9>,<T10>,<T11>,<T12>,<T13>,<T14>,System.Boolean>>`	predicate

Type Parameters

T1
T2
T3
T4
T5
T6
T7
T8
T9
T10
T11
T12
T13
T14

Or<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15>(Expression<Func<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, Boolean>>)

View Source

Declaration
public virtual SqlExpression<T> Or<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15>(Expression<Func<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, bool>> predicate)

Returns

ServiceStack.OrmLite.SqlExpression<T>

Parameters

Type	Name
`Expression<Func<<T1>,<T2>,<T3>,<T4>,<T5>,<T6>,<T7>,<T8>,<T9>,<T10>,<T11>,<T12>,<T13>,<T14>,<T15>,System.Boolean>>`	predicate

Type Parameters

T1
T2
T3
T4
T5
T6
T7
T8
T9
T10
T11
T12
T13
T14
T15

FirstMatchingField(String)

View Source

Declaration
public Tuple<ModelDefinition, FieldDefinition> FirstMatchingField(string fieldName)

Returns

Tuple<ServiceStack.OrmLite.ModelDefinition,ServiceStack.OrmLite.FieldDefinition>

Parameters

Type	Name
`System.String`	fieldName

Implements

Properties
Fields
Methods
Implements

SqlExpression<T>

Assembly: ServiceStack.OrmLite.dll​

Properties​

OnlyFields​

UpdateFields​

InsertFields​

TableAlias​

DialectProvider​

Params​

SqlFilter​

SelectFilter​

Rows​

Offset​

PrefixFieldWithTableName​

UseSelectPropertiesAsAliases​

WhereStatementWithoutWhereString​

Tags​

CustomSelect​

Sep​

SelectExpression​

FromExpression​

BodyExpression​

WhereExpression​

GroupByExpression​

HavingExpression​

OrderByExpression​

ModelDef​

UseFieldName​

Fields​

TrueLiteral​

FalseLiteral​

modelDef​

useFieldName​

selectDistinct​

visitedExpressionIsTableColumn​

skipParameterizationForThisExpression​

isSelectExpression​

tableDefs​

Methods​

Clone()​

Returns​

AddTag(String)​

Parameters​

CopyTo(SqlExpression<T>)​

Returns​

Parameters​

ComputeHash(Boolean)​

Returns​

Parameters​

Dump(Boolean)​

Returns​

Parameters​

Select()​

Returns​

Select(String)​

Returns​

Parameters​

SelectDistinct(String)​

Returns​

Parameters​

UnsafeSelect(String)​

Returns​

Parameters​

UnsafeSelect(String, Boolean)​

Returns​

Parameters​

Select(String[])​

Returns​

Parameters​

SelectDistinct(String[])​

Returns​

Parameters​

Select(Expression<Func<T, Object>>)​

Returns​

Parameters​

Select<Table1>(Expression<Func<Table1, Object>>)​

Returns​

Parameters​

Type Parameters​

Select<Table1, Table2>(Expression<Func<Table1, Table2, Object>>)​

Assembly: ServiceStack.OrmLite.dll

Properties

OnlyFields

UpdateFields

InsertFields

TableAlias

DialectProvider

Params

SqlFilter

SelectFilter

Rows

Offset

PrefixFieldWithTableName

UseSelectPropertiesAsAliases

WhereStatementWithoutWhereString

Tags

CustomSelect

Sep

SelectExpression

FromExpression

BodyExpression

WhereExpression

GroupByExpression

HavingExpression

OrderByExpression

ModelDef

UseFieldName

Fields

TrueLiteral

FalseLiteral

modelDef

useFieldName

selectDistinct

visitedExpressionIsTableColumn

skipParameterizationForThisExpression

isSelectExpression

tableDefs

Methods

Clone()

Returns

AddTag(String)

Parameters

CopyTo(SqlExpression<T>)

Returns

Parameters

ComputeHash(Boolean)

Returns

Parameters

Dump(Boolean)

Returns

Parameters

Select()

Returns

Select(String)

Returns

Parameters

SelectDistinct(String)

Returns

Parameters

UnsafeSelect(String)

Returns

Parameters

UnsafeSelect(String, Boolean)

Returns

Parameters

Select(String[])

Returns

Parameters

SelectDistinct(String[])

Returns

Parameters

Select(Expression<Func<T, Object>>)

Returns

Parameters

Select<Table1>(Expression<Func<Table1, Object>>)

Returns

Parameters

Type Parameters

Select<Table1, Table2>(Expression<Func<Table1, Table2, Object>>)

Returns