Skip to main content

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; }

Tags

View Source
Declaration
public ISet<string> Tags { get; }

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
TypeName
System.Stringtag

CopyTo(SqlExpression<T>)

View Source
Declaration
protected virtual SqlExpression<T> CopyTo(SqlExpression<T> to)
Returns

ServiceStack.OrmLite.SqlExpression<T>

Parameters
TypeName
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
TypeName
System.BooleanincludeParams

Dump(Boolean)

Dump internal state of this SqlExpression into a string

View Source
Declaration
public string Dump(bool includeParams)
Returns

System.String

Parameters
TypeName
System.BooleanincludeParams

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
TypeNameDescription
System.StringselectExpression

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
TypeNameDescription
System.StringselectExpression

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
TypeName
System.StringrawSelect

UnsafeSelect(String, Boolean)

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

ServiceStack.OrmLite.SqlExpression<T>

Parameters
TypeName
System.StringrawSelect
System.Booleandistinct

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
TypeNameDescription
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
TypeNameDescription
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
TypeNameDescription
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
TypeName
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
TypeName
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
TypeName
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
TypeName
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
TypeName
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
TypeName
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
TypeName
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
TypeName
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
TypeName
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
TypeName
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
TypeName
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
TypeName
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
TypeName
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
TypeName
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
TypeName
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
TypeName
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
TypeName
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
TypeName
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
TypeName
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
TypeName
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
TypeName
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
TypeName
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
TypeName
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
TypeName
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
TypeName
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
TypeName
System.Stringtables

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
TypeName
System.StringtableAlias

UnsafeFrom(String)

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

ServiceStack.OrmLite.SqlExpression<T>

Parameters
TypeName
System.StringrawFrom

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
TypeName
System.StringrawSql
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
TypeName
System.StringsqlFilter
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
TypeName
System.StringrawSql
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
TypeName
System.StringsqlFilter
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
TypeName
System.StringrawSql
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
TypeName
System.StringsqlFilter
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
TypeName
System.Stringcondition
System.StringsqlFilter
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
TypeName
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
TypeName
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
TypeName
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
TypeName
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
TypeName
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
TypeName
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
TypeName
System.Stringcondition
Expressionpredicate
System.Object[]filterParams

AppendToWhere(String, Expression)

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

ServiceStack.OrmLite.SqlExpression<T>

Parameters
TypeName
System.Stringcondition
Expressionpredicate

AppendToWhere(String, String)

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

ServiceStack.OrmLite.SqlExpression<T>

Parameters
TypeName
System.Stringcondition
System.StringsqlExpression

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

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

ServiceStack.OrmLite.SqlExpression<T>

Parameters
TypeName
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
TypeName
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
TypeName
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
TypeName
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
TypeName
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
TypeName
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
TypeName
Expressionpredicate

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
TypeName
System.StringsqlFilter
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
TypeName
System.StringgroupBy

UnsafeGroupBy(String)

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

ServiceStack.OrmLite.SqlExpression<T>

Parameters
TypeName
System.StringgroupBy

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
TypeName
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
TypeName
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
TypeName
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
TypeName
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
TypeName
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
TypeName
System.StringsqlFilter
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
TypeName
System.StringsqlFilter
System.Object[]filterParams

AppendHaving(Expression)

View Source
Declaration
protected SqlExpression<T> AppendHaving(Expression predicate)
Returns

ServiceStack.OrmLite.SqlExpression<T>

Parameters
TypeName
Expressionpredicate

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

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

ServiceStack.OrmLite.SqlExpression<T>

Parameters
TypeName
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
TypeName
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
TypeName
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
TypeName
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
TypeName
System.StringorderBy

OrderBy(Int64)

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

ServiceStack.OrmLite.SqlExpression<T>

Parameters
TypeName
System.Int64columnIndex

UnsafeOrderBy(String)

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

ServiceStack.OrmLite.SqlExpression<T>

Parameters
TypeName
System.StringorderBy

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
TypeName
ServiceStack.OrmLite.FieldDefinitionfieldDef

OrderByFields(FieldDefinition[])

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

ServiceStack.OrmLite.SqlExpression<T>

Parameters
TypeName
ServiceStack.OrmLite.FieldDefinition[]fields

OrderByFieldsDescending(FieldDefinition[])

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

ServiceStack.OrmLite.SqlExpression<T>

Parameters
TypeName
ServiceStack.OrmLite.FieldDefinition[]fields

OrderByFields(String[])

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

ServiceStack.OrmLite.SqlExpression<T>

Parameters
TypeName
System.String[]fieldNames

OrderByFieldsDescending(String[])

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

ServiceStack.OrmLite.SqlExpression<T>

Parameters
TypeName
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
TypeName
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
TypeName
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
TypeName
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
TypeName
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
TypeName
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
TypeName
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
TypeName
System.Objectobj

ThenBy(String)

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

ServiceStack.OrmLite.SqlExpression<T>

Parameters
TypeName
System.StringorderBy

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

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

ServiceStack.OrmLite.SqlExpression<T>

Parameters
TypeName
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
TypeName
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
TypeName
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
TypeName
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
TypeName
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
TypeName
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
TypeName
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
TypeName
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
TypeName
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
TypeName
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
TypeName
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
TypeName
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
TypeName
System.StringorderBy

OrderByDescending(Int64)

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

ServiceStack.OrmLite.SqlExpression<T>

Parameters
TypeName
System.Int64columnIndex

ThenByDescending(String)

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

ServiceStack.OrmLite.SqlExpression<T>

Parameters
TypeName
System.StringorderBy

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

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

ServiceStack.OrmLite.SqlExpression<T>

Parameters
TypeName
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
TypeName
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
TypeName
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
TypeName
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
TypeName
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
TypeName
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
TypeName
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
TypeName
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
TypeNameDescription
System.Int32skip

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
TypeNameDescription
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
TypeNameDescription
System.Int32rows

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
TypeNameDescription
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
TypeNameDescription
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
TypeNameDescription
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
TypeNameDescription
Expression<Func<<T>,<TKey>>>fields

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

|

Type Parameters
NameDescription
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
TypeNameDescription
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
TypeName
Func<System.String,System.String>sqlFilter

SqlTable(ModelDefinition)

View Source
Declaration
public string SqlTable(ModelDefinition modelDef)
Returns

System.String

Parameters
TypeName
ServiceStack.OrmLite.ModelDefinitionmodelDef

SqlColumn(String)

View Source
Declaration
public string SqlColumn(string columnName)
Returns

System.String

Parameters
TypeName
System.StringcolumnName

AddParam(Object)

View Source
Declaration
public virtual IDbDataParameter AddParam(object value)
Returns

IDbDataParameter

Parameters
TypeName
System.Objectvalue

ConvertToParam(Object)

View Source
Declaration
public string ConvertToParam(object value)
Returns

System.String

Parameters
TypeName
System.Objectvalue

CopyParamsTo(IDbCommand)

View Source
Declaration
public virtual void CopyParamsTo(IDbCommand dbCmd)
Parameters
TypeName
IDbCommanddbCmd

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
TypeName
IDbCommanddbCmd
<T>item
System.BooleanexcludeDefaults

PrepareUpdateStatement(IDbCommand, Dictionary<String, Object>)

View Source
Declaration
public virtual void PrepareUpdateStatement(IDbCommand dbCmd, Dictionary<string, object> updateFields)
Parameters
TypeName
IDbCommanddbCmd
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
TypeName
ServiceStack.OrmLite.QueryTypeforType

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
TypeName
Expressionexp

VisitJoin(Expression)

View Source
Declaration
protected virtual object VisitJoin(Expression exp)
Returns

System.Object

Parameters
TypeName
Expressionexp

VisitLambda(LambdaExpression)

View Source
Declaration
protected virtual object VisitLambda(LambdaExpression lambda)
Returns

System.Object

Parameters
TypeName
LambdaExpressionlambda

GetValue(Object, Type)

View Source
Declaration
public virtual object GetValue(object value, Type type)
Returns

System.Object

Parameters
TypeName
System.Objectvalue
Typetype

VisitBinary(BinaryExpression)

View Source
Declaration
protected virtual object VisitBinary(BinaryExpression b)
Returns

System.Object

Parameters
TypeName
BinaryExpressionb

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
TypeName
Expressione

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
TypeName
Expressione

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
TypeName
Expressione

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
TypeName
Expressione

CheckExpressionForTypes(Expression, ExpressionType[])

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

System.Boolean

Parameters
TypeName
Expressione
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
TypeName
System.Stringoperand
System.ObjectoriginalLeft
System.ObjectoriginalRight
System.Objectleft
System.Objectright

ConvertToPlaceholderAndParameter(ref Object)

View Source
Declaration
protected virtual void ConvertToPlaceholderAndParameter(ref object right)
Parameters
TypeName
System.Objectright

VisitMemberAccess(MemberExpression)

View Source
Declaration
protected virtual object VisitMemberAccess(MemberExpression m)
Returns

System.Object

Parameters
TypeName
MemberExpressionm

GetMemberExpression(MemberExpression)

View Source
Declaration
protected virtual object GetMemberExpression(MemberExpression m)
Returns

System.Object

Parameters
TypeName
MemberExpressionm

GetTableAlias(MemberExpression)

View Source
Declaration
protected virtual string GetTableAlias(MemberExpression m)
Returns

System.String

Parameters
TypeName
MemberExpressionm

OnVisitMemberType(Type)

View Source
Declaration
protected virtual void OnVisitMemberType(Type modelType)
Parameters
TypeName
TypemodelType

VisitMemberInit(MemberInitExpression)

View Source
Declaration
protected virtual object VisitMemberInit(MemberInitExpression exp)
Returns

System.Object

Parameters
TypeName
MemberInitExpressionexp

VisitNew(NewExpression)

View Source
Declaration
protected virtual object VisitNew(NewExpression nex)
Returns

System.Object

Parameters
TypeName
NewExpressionnex

VisitParameter(ParameterExpression)

View Source
Declaration
protected virtual object VisitParameter(ParameterExpression p)
Returns

System.Object

Parameters
TypeName
ParameterExpressionp

VisitConstant(ConstantExpression)

View Source
Declaration
protected virtual object VisitConstant(ConstantExpression c)
Returns

System.Object

Parameters
TypeName
ConstantExpressionc

VisitUnary(UnaryExpression)

View Source
Declaration
protected virtual object VisitUnary(UnaryExpression u)
Returns

System.Object

Parameters
TypeName
UnaryExpressionu

VisitIndexExpression(IndexExpression)

View Source
Declaration
protected virtual object VisitIndexExpression(IndexExpression e)
Returns

System.Object

Parameters
TypeName
IndexExpressione

VisitConditional(ConditionalExpression)

View Source
Declaration
protected virtual object VisitConditional(ConditionalExpression e)
Returns

System.Object

Parameters
TypeName
ConditionalExpressione

IsColumnAccess(MethodCallExpression)

View Source
Declaration
protected virtual bool IsColumnAccess(MethodCallExpression m)
Returns

System.Boolean

Parameters
TypeName
MethodCallExpressionm

VisitMethodCall(MethodCallExpression)

View Source
Declaration
protected virtual object VisitMethodCall(MethodCallExpression m)
Returns

System.Object

Parameters
TypeName
MethodCallExpressionm

VisitExpressionList(ReadOnlyCollection<Expression>)

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

List<System.Object>

Parameters
TypeName
ReadOnlyCollection<Expression>original

VisitInSqlExpressionList(ReadOnlyCollection<Expression>)

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

List<System.Object>

Parameters
TypeName
ReadOnlyCollection<Expression>original

VisitNewArray(NewArrayExpression)

View Source
Declaration
protected virtual object VisitNewArray(NewArrayExpression na)
Returns

System.Object

Parameters
TypeName
NewArrayExpressionna

VisitNewArrayFromExpressionList(NewArrayExpression)

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

List<System.Object>

Parameters
TypeName
NewArrayExpressionna

BindOperant(ExpressionType)

View Source
Declaration
protected virtual string BindOperant(ExpressionType e)
Returns

System.String

Parameters
TypeName
ExpressionTypee

GetQuotedColumnName(ModelDefinition, String)

View Source
Declaration
protected virtual string GetQuotedColumnName(ModelDefinition tableDef, string memberName)
Returns

System.String

Parameters
TypeName
ServiceStack.OrmLite.ModelDefinitiontableDef
System.StringmemberName

GetQuotedColumnName(ModelDefinition, String, String)

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

System.String

Parameters
TypeName
ServiceStack.OrmLite.ModelDefinitiontableDef
System.StringtableAlias
System.StringmemberName

RemoveQuoteFromAlias(String)

View Source
Declaration
protected string RemoveQuoteFromAlias(string exp)
Returns

System.String

Parameters
TypeName
System.Stringexp

IsFieldName(Object)

View Source
Declaration
protected virtual bool IsFieldName(object quotedExp)
Returns

System.Boolean

Parameters
TypeName
System.ObjectquotedExp

GetColumnName(String)

View Source
Declaration
protected string GetColumnName(string fieldName)
Returns

System.String

Parameters
TypeName
System.StringfieldName

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
TypeName
MethodCallExpressionm

VisitStaticArrayMethodCall(MethodCallExpression)

View Source
Declaration
protected virtual object VisitStaticArrayMethodCall(MethodCallExpression m)
Returns

System.Object

Parameters
TypeName
MethodCallExpressionm

VisitEnumerableMethodCall(MethodCallExpression)

View Source
Declaration
protected virtual object VisitEnumerableMethodCall(MethodCallExpression m)
Returns

System.Object

Parameters
TypeName
MethodCallExpressionm

IsStaticStringMethod(MethodCallExpression)

View Source
Declaration
protected virtual bool IsStaticStringMethod(MethodCallExpression m)
Returns

System.Boolean

Parameters
TypeName
MethodCallExpressionm

VisitStaticStringMethodCall(MethodCallExpression)

View Source
Declaration
protected virtual object VisitStaticStringMethodCall(MethodCallExpression m)
Returns

System.Object

Parameters
TypeName
MethodCallExpressionm

ToLengthPartialString(Object)

View Source
Declaration
protected virtual PartialSqlString ToLengthPartialString(object arg)
Returns

ServiceStack.OrmLite.PartialSqlString

Parameters
TypeName
System.Objectarg

ToConcatPartialString(List<Object>)

View Source
Declaration
protected PartialSqlString ToConcatPartialString(List<object> args)
Returns

ServiceStack.OrmLite.PartialSqlString

Parameters
TypeName
List<System.Object>args

ToComparePartialString(List<Object>)

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

ServiceStack.OrmLite.PartialSqlString

Parameters
TypeName
List<System.Object>args

VisitSqlMethodCall(MethodCallExpression)

View Source
Declaration
protected virtual object VisitSqlMethodCall(MethodCallExpression m)
Returns

System.Object

Parameters
TypeName
MethodCallExpressionm

ConvertInExpressionToSql(MethodCallExpression, Object)

View Source
Declaration
protected string ConvertInExpressionToSql(MethodCallExpression m, object quotedColName)
Returns

System.String

Parameters
TypeName
MethodCallExpressionm
System.ObjectquotedColName

CreateInSubQuerySql(Object, String)

View Source
Declaration
protected virtual string CreateInSubQuerySql(object quotedColName, string subSelect)
Returns

System.String

Parameters
TypeName
System.ObjectquotedColName
System.StringsubSelect

VisitColumnAccessMethod(MethodCallExpression)

View Source
Declaration
protected virtual object VisitColumnAccessMethod(MethodCallExpression m)
Returns

System.Object

Parameters
TypeName
MethodCallExpressionm

ToCast(String)

View Source
Declaration
protected virtual string ToCast(string quotedColName)
Returns

System.String

Parameters
TypeName
System.StringquotedColName

GetSubstringSql(Object, Int32, Nullable<Int32>)

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

System.String

Parameters
TypeName
System.ObjectquotedColumn
System.Int32startIndex
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
TypeName
System.Stringname
System.Objectvalue
ParameterDirectiondirection
System.Nullable<DbType>dbType
DataRowVersionsourceVersion

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
TypeName
System.StringjoinString
Type Parameters
  • Target

IsJoinedTable(Type)

View Source
Declaration
public bool IsJoinedTable(Type type)
Returns

System.Boolean

Parameters
TypeName
Typetype

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
TypeName
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
TypeName
Expression<Func<<T>,<Target>,System.Boolean>>joinExpr
ServiceStack.OrmLite.TableOptionsoptions
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
TypeName
Expression<Func<<T>,<Target>,System.Boolean>>joinExpr
ServiceStack.OrmLite.JoinFormatDelegatejoinFormat
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
TypeName
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
TypeName
Expression<Func<<Source>,<Target>,System.Boolean>>joinExpr
ServiceStack.OrmLite.JoinFormatDelegatejoinFormat
Type Parameters
  • Source
  • Target

Join<Source, Target>(Expressio