SqlExpression<T>
Assembly: ServiceStack.OrmLite.dll
View Source
public abstract class SqlExpression<T> : object, ISqlExpression, IHasUntypedSqlExpression, IHasDialectProvider
Properties
OnlyFields
View Source
public HashSet<string> OnlyFields { get; protected set; }
UpdateFields
View Source
public List<string> UpdateFields { get; set; }
InsertFields
View Source
public List<string> InsertFields { get; set; }
TableAlias
View Source
public string TableAlias { get; set; }
DialectProvider
View Source
public IOrmLiteDialectProvider DialectProvider { get; set; }
Params
View Source
public List<IDbDataParameter> Params { get; set; }
SqlFilter
View Source
public Func<string, string> SqlFilter { get; set; }
SelectFilter
View Source
public static Action<SqlExpression<T>> SelectFilter { get; set; }
Rows
View Source
public int? Rows { get; set; }
Offset
View Source
public int? Offset { get; set; }
PrefixFieldWithTableName
View Source
public bool PrefixFieldWithTableName { get; set; }
UseSelectPropertiesAsAliases
View Source
public bool UseSelectPropertiesAsAliases { get; set; }
WhereStatementWithoutWhereString
View Source
public bool WhereStatementWithoutWhereString { get; set; }
Tags
View Source
public ISet<string> Tags { get; }
CustomSelect
View Source
protected bool CustomSelect { get; set; }
Sep
View Source
protected string Sep { get; }
SelectExpression
View Source
public string SelectExpression { get; set; }
FromExpression
View Source
public string FromExpression { get; set; }
BodyExpression
View Source
public string BodyExpression { get; }
WhereExpression
View Source
public string WhereExpression { get; set; }
GroupByExpression
View Source
public string GroupByExpression { get; set; }
HavingExpression
View Source
public string HavingExpression { get; set; }
OrderByExpression
View Source
public string OrderByExpression { get; set; }
ModelDef
View Source
public ModelDefinition ModelDef { get; protected set; }
UseFieldName
View Source
protected bool UseFieldName { get; set; }
Fields
TrueLiteral
View Source
public const string TrueLiteral = null
FalseLiteral
View Source
public const string FalseLiteral = null
modelDef
View Source
protected ModelDefinition modelDef
useFieldName
View Source
protected bool useFieldName
selectDistinct
View Source
protected bool selectDistinct
visitedExpressionIsTableColumn
View Source
protected bool visitedExpressionIsTableColumn
skipParameterizationForThisExpression
View Source
protected bool skipParameterizationForThisExpression
isSelectExpression
View Source
protected bool isSelectExpression
tableDefs
View Source
protected List<ModelDefinition> tableDefs
Methods
Clone()
View Source
public SqlExpression<T> Clone()
Returns
ServiceStack.OrmLite.SqlExpression<T>
AddTag(String)
View Source
public virtual void AddTag(string tag)
Parameters
Type | Name |
---|---|
System.String | tag |
CopyTo(SqlExpression<T>)
View Source
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
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
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
public virtual SqlExpression<T> Select()
Returns
ServiceStack.OrmLite.SqlExpression<T>
Select(String)
set the specified selectExpression.
View Source
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
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
public virtual SqlExpression<T> UnsafeSelect(string rawSelect)
Returns
ServiceStack.OrmLite.SqlExpression<T>
Parameters
Type | Name |
---|---|
System.String | rawSelect |
UnsafeSelect(String, Boolean)
View Source
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
public virtual SqlExpression<T> SelectDistinct()
Returns
ServiceStack.OrmLite.SqlExpression<T>
From(String)
View Source
public virtual SqlExpression<T> From(string tables)
Returns
ServiceStack.OrmLite.SqlExpression<T>
Parameters
Type | Name |
---|---|
System.String | tables |
IncludeTablePrefix()
View Source
public virtual SqlExpression<T> IncludeTablePrefix()
Returns
ServiceStack.OrmLite.SqlExpression<T>
SetTableAlias(String)
View Source
public virtual SqlExpression<T> SetTableAlias(string tableAlias)
Returns
ServiceStack.OrmLite.SqlExpression<T>
Parameters
Type | Name |
---|---|
System.String | tableAlias |
UnsafeFrom(String)
View Source
public virtual SqlExpression<T> UnsafeFrom(string rawFrom)
Returns
ServiceStack.OrmLite.SqlExpression<T>
Parameters
Type | Name |
---|---|
System.String | rawFrom |
Where()
View Source
public virtual SqlExpression<T> Where()
Returns
ServiceStack.OrmLite.SqlExpression<T>
UnsafeWhere(String, Object[])
View Source
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
public virtual SqlExpression<T> GroupBy()
Returns
ServiceStack.OrmLite.SqlExpression<T>
GroupBy(String)
View Source
public virtual SqlExpression<T> GroupBy(string groupBy)
Returns
ServiceStack.OrmLite.SqlExpression<T>
Parameters
Type | Name |
---|---|
System.String | groupBy |
UnsafeGroupBy(String)
View Source
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
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
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
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
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
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
public virtual SqlExpression<T> Having()
Returns
ServiceStack.OrmLite.SqlExpression<T>
Having(String, Object[])
View Source
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
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
protected SqlExpression<T> AppendHaving(Expression predicate)
Returns
ServiceStack.OrmLite.SqlExpression<T>
Parameters
Type | Name |
---|---|
Expression | predicate |
Having(Expression<Func<T, Boolean>>)
View Source
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
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
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
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
public virtual SqlExpression<T> OrderBy()
Returns
ServiceStack.OrmLite.SqlExpression<T>
OrderBy(String)
View Source
public virtual SqlExpression<T> OrderBy(string orderBy)
Returns
ServiceStack.OrmLite.SqlExpression<T>
Parameters
Type | Name |
---|---|
System.String | orderBy |
OrderBy(Int64)
View Source
public virtual SqlExpression<T> OrderBy(long columnIndex)
Returns
ServiceStack.OrmLite.SqlExpression<T>
Parameters
Type | Name |
---|---|
System.Int64 | columnIndex |
UnsafeOrderBy(String)
View Source
public virtual SqlExpression<T> UnsafeOrderBy(string orderBy)
Returns
ServiceStack.OrmLite.SqlExpression<T>
Parameters
Type | Name |
---|---|
System.String | orderBy |
OrderByRandom()
View Source
public virtual SqlExpression<T> OrderByRandom()
Returns
ServiceStack.OrmLite.SqlExpression<T>
GetModelDefinition(FieldDefinition)
View Source
public ModelDefinition GetModelDefinition(FieldDefinition fieldDef)
Returns
ServiceStack.OrmLite.ModelDefinition
Parameters
Type | Name |
---|---|
ServiceStack.OrmLite.FieldDefinition | fieldDef |
OrderByFields(FieldDefinition[])
View Source
public virtual SqlExpression<T> OrderByFields(params FieldDefinition[] fields)
Returns
ServiceStack.OrmLite.SqlExpression<T>
Parameters
Type | Name |
---|---|
ServiceStack.OrmLite.FieldDefinition[] | fields |
OrderByFieldsDescending(FieldDefinition[])
View Source
public virtual SqlExpression<T> OrderByFieldsDescending(params FieldDefinition[] fields)
Returns
ServiceStack.OrmLite.SqlExpression<T>
Parameters
Type | Name |
---|---|
ServiceStack.OrmLite.FieldDefinition[] | fields |
OrderByFields(String[])
View Source
public virtual SqlExpression<T> OrderByFields(params string[] fieldNames)
Returns
ServiceStack.OrmLite.SqlExpression<T>
Parameters
Type | Name |
---|---|
System.String[] | fieldNames |
OrderByFieldsDescending(String[])
View Source
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
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
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
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
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
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
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
public static bool IsSqlClass(object obj)
Returns
System.Boolean
Parameters
Type | Name |
---|---|
System.Object | obj |
ThenBy(String)
View Source
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
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
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
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
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
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
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
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
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
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
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
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
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
public virtual SqlExpression<T> OrderByDescending(string orderBy)
Returns
ServiceStack.OrmLite.SqlExpression<T>
Parameters
Type | Name |
---|---|
System.String | orderBy |
OrderByDescending(Int64)
View Source
public virtual SqlExpression<T> OrderByDescending(long columnIndex)
Returns
ServiceStack.OrmLite.SqlExpression<T>
Parameters
Type | Name |
---|---|
System.Int64 | columnIndex |
ThenByDescending(String)
View Source
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
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
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
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
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
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
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
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
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
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
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
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
public virtual SqlExpression<T> Limit()
Returns
ServiceStack.OrmLite.SqlExpression<T>
ClearLimits()
Clear Offset and Limit clauses. Alias for Limit()
View Source
public virtual SqlExpression<T> ClearLimits()
Returns
ServiceStack.OrmLite.SqlExpression<T>
Update(List<String>)
Fields to be updated.
View Source
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
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
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
public virtual SqlExpression<T> Update()
Returns
ServiceStack.OrmLite.SqlExpression<T>
Insert<TKey>(Expression<Func<T, TKey>>)
Fields to be inserted.
View Source
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
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
public virtual SqlExpression<T> Insert()
Returns
ServiceStack.OrmLite.SqlExpression<T>
WithSqlFilter(Func<String, String>)
View Source
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
public string SqlTable(ModelDefinition modelDef)
Returns
System.String
Parameters
Type | Name |
---|---|
ServiceStack.OrmLite.ModelDefinition | modelDef |
SqlColumn(String)
View Source
public string SqlColumn(string columnName)
Returns
System.String
Parameters
Type | Name |
---|---|
System.String | columnName |
AddParam(Object)
View Source
public virtual IDbDataParameter AddParam(object value)
Returns
IDbDataParameter
Parameters
Type | Name |
---|---|
System.Object | value |
ConvertToParam(Object)
View Source
public string ConvertToParam(object value)
Returns
System.String
Parameters
Type | Name |
---|---|
System.Object | value |
CopyParamsTo(IDbCommand)
View Source
public virtual void CopyParamsTo(IDbCommand dbCmd)
Parameters
Type | Name |
---|---|
IDbCommand | dbCmd |
ToDeleteRowStatement()
View Source
public virtual string ToDeleteRowStatement()
Returns
System.String
PrepareUpdateStatement(IDbCommand, T, Boolean)
View Source
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
public virtual void PrepareUpdateStatement(IDbCommand dbCmd, Dictionary<string, object> updateFields)
Parameters
Type | Name |
---|---|
IDbCommand | dbCmd |
Dictionary<System.String,System.Object> | updateFields |
ToSelectStatement()
View Source
public virtual string ToSelectStatement()
Returns
System.String
ToSelectStatement(QueryType)
View Source
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
public virtual string ToMergedParamsSelectStatement()
Returns
System.String
ToCountStatement()
View Source
public virtual string ToCountStatement()
Returns
System.String
Visit(Expression)
View Source
public virtual object Visit(Expression exp)
Returns
System.Object
Parameters
Type | Name |
---|---|
Expression | exp |
VisitJoin(Expression)
View Source
protected virtual object VisitJoin(Expression exp)
Returns
System.Object
Parameters
Type | Name |
---|---|
Expression | exp |
VisitLambda(LambdaExpression)
View Source
protected virtual object VisitLambda(LambdaExpression lambda)
Returns
System.Object
Parameters
Type | Name |
---|---|
LambdaExpression | lambda |
GetValue(Object, Type)
View Source
public virtual object GetValue(object value, Type type)
Returns
System.Object
Parameters
Type | Name |
---|---|
System.Object | value |
Type | type |
VisitBinary(BinaryExpression)
View Source
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
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
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
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
protected virtual bool IsConstantExpression(Expression e)
Returns
System.Boolean
Parameters
Type | Name |
---|---|
Expression | e |
CheckExpressionForTypes(Expression, ExpressionType[])
View Source
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
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
protected virtual void ConvertToPlaceholderAndParameter(ref object right)
Parameters
Type | Name |
---|---|
System.Object | right |
VisitMemberAccess(MemberExpression)
View Source
protected virtual object VisitMemberAccess(MemberExpression m)
Returns
System.Object
Parameters
Type | Name |
---|---|
MemberExpression | m |
GetMemberExpression(MemberExpression)
View Source
protected virtual object GetMemberExpression(MemberExpression m)
Returns
System.Object
Parameters
Type | Name |
---|---|
MemberExpression | m |
GetTableAlias(MemberExpression)
View Source
protected virtual string GetTableAlias(MemberExpression m)
Returns
System.String
Parameters
Type | Name |
---|---|
MemberExpression | m |
OnVisitMemberType(Type)
View Source
protected virtual void OnVisitMemberType(Type modelType)
Parameters
Type | Name |
---|---|
Type | modelType |
VisitMemberInit(MemberInitExpression)
View Source
protected virtual object VisitMemberInit(MemberInitExpression exp)
Returns
System.Object
Parameters
Type | Name |
---|---|
MemberInitExpression | exp |
VisitNew(NewExpression)
View Source
protected virtual object VisitNew(NewExpression nex)
Returns
System.Object
Parameters
Type | Name |
---|---|
NewExpression | nex |
VisitParameter(ParameterExpression)
View Source
protected virtual object VisitParameter(ParameterExpression p)
Returns
System.Object
Parameters
Type | Name |
---|---|
ParameterExpression | p |
VisitConstant(ConstantExpression)
View Source
protected virtual object VisitConstant(ConstantExpression c)
Returns
System.Object
Parameters
Type | Name |
---|---|
ConstantExpression | c |
VisitUnary(UnaryExpression)
View Source
protected virtual object VisitUnary(UnaryExpression u)
Returns
System.Object
Parameters
Type | Name |
---|---|
UnaryExpression | u |
VisitIndexExpression(IndexExpression)
View Source
protected virtual object VisitIndexExpression(IndexExpression e)
Returns
System.Object
Parameters
Type | Name |
---|---|
IndexExpression | e |
VisitConditional(ConditionalExpression)
View Source
protected virtual object VisitConditional(ConditionalExpression e)
Returns
System.Object
Parameters
Type | Name |
---|---|
ConditionalExpression | e |
IsColumnAccess(MethodCallExpression)
View Source
protected virtual bool IsColumnAccess(MethodCallExpression m)
Returns
System.Boolean
Parameters
Type | Name |
---|---|
MethodCallExpression | m |
VisitMethodCall(MethodCallExpression)
View Source
protected virtual object VisitMethodCall(MethodCallExpression m)
Returns
System.Object
Parameters
Type | Name |
---|---|
MethodCallExpression | m |
VisitExpressionList(ReadOnlyCollection<Expression>)
View Source
protected virtual List<object> VisitExpressionList(ReadOnlyCollection<Expression> original)
Returns
List<System.Object>
Parameters
Type | Name |
---|---|
ReadOnlyCollection<Expression> | original |
VisitInSqlExpressionList(ReadOnlyCollection<Expression>)
View Source
protected virtual List<object> VisitInSqlExpressionList(ReadOnlyCollection<Expression> original)
Returns
List<System.Object>
Parameters
Type | Name |
---|---|
ReadOnlyCollection<Expression> | original |
VisitNewArray(NewArrayExpression)
View Source
protected virtual object VisitNewArray(NewArrayExpression na)
Returns
System.Object
Parameters
Type | Name |
---|---|
NewArrayExpression | na |
VisitNewArrayFromExpressionList(NewArrayExpression)
View Source
protected virtual List<object> VisitNewArrayFromExpressionList(NewArrayExpression na)
Returns
List<System.Object>
Parameters
Type | Name |
---|---|
NewArrayExpression | na |
BindOperant(ExpressionType)
View Source
protected virtual string BindOperant(ExpressionType e)
Returns
System.String
Parameters
Type | Name |
---|---|
ExpressionType | e |
GetQuotedColumnName(ModelDefinition, String)
View Source
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
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
protected string RemoveQuoteFromAlias(string exp)
Returns
System.String
Parameters
Type | Name |
---|---|
System.String | exp |
IsFieldName(Object)
View Source
protected virtual bool IsFieldName(object quotedExp)
Returns
System.Boolean
Parameters
Type | Name |
---|---|
System.Object | quotedExp |
GetColumnName(String)
View Source
protected string GetColumnName(string fieldName)
Returns
System.String
Parameters
Type | Name |
---|---|
System.String | fieldName |
GetTrueExpression()
View Source
protected object GetTrueExpression()
Returns
System.Object
GetFalseExpression()
View Source
protected object GetFalseExpression()
Returns
System.Object
GetQuotedTrueValue()
View Source
protected object GetQuotedTrueValue()
Returns
System.Object
GetQuotedFalseValue()
View Source
protected object GetQuotedFalseValue()
Returns
System.Object
GetAllFields()
View Source
public IList<string> GetAllFields()
Returns
IList<System.String>
IsStaticArrayMethod(MethodCallExpression)
View Source
protected virtual bool IsStaticArrayMethod(MethodCallExpression m)
Returns
System.Boolean
Parameters
Type | Name |
---|---|
MethodCallExpression | m |
VisitStaticArrayMethodCall(MethodCallExpression)
View Source
protected virtual object VisitStaticArrayMethodCall(MethodCallExpression m)
Returns
System.Object
Parameters
Type | Name |
---|---|
MethodCallExpression | m |
VisitEnumerableMethodCall(MethodCallExpression)
View Source
protected virtual object VisitEnumerableMethodCall(MethodCallExpression m)
Returns
System.Object
Parameters
Type | Name |
---|---|
MethodCallExpression | m |
IsStaticStringMethod(MethodCallExpression)
View Source
protected virtual bool IsStaticStringMethod(MethodCallExpression m)
Returns
System.Boolean
Parameters
Type | Name |
---|---|
MethodCallExpression | m |
VisitStaticStringMethodCall(MethodCallExpression)
View Source
protected virtual object VisitStaticStringMethodCall(MethodCallExpression m)
Returns
System.Object
Parameters
Type | Name |
---|---|
MethodCallExpression | m |
ToLengthPartialString(Object)
View Source
protected virtual PartialSqlString ToLengthPartialString(object arg)
Returns
ServiceStack.OrmLite.PartialSqlString
Parameters
Type | Name |
---|---|
System.Object | arg |
ToConcatPartialString(List<Object>)
View Source
protected PartialSqlString ToConcatPartialString(List<object> args)
Returns
ServiceStack.OrmLite.PartialSqlString
Parameters
Type | Name |
---|---|
List<System.Object> | args |
ToComparePartialString(List<Object>)
View Source
protected virtual PartialSqlString ToComparePartialString(List<object> args)
Returns
ServiceStack.OrmLite.PartialSqlString
Parameters
Type | Name |
---|---|
List<System.Object> | args |
VisitSqlMethodCall(MethodCallExpression)
View Source
protected virtual object VisitSqlMethodCall(MethodCallExpression m)
Returns
System.Object
Parameters
Type | Name |
---|---|
MethodCallExpression | m |
ConvertInExpressionToSql(MethodCallExpression, Object)
View Source
protected string ConvertInExpressionToSql(MethodCallExpression m, object quotedColName)
Returns
System.String
Parameters
Type | Name |
---|---|
MethodCallExpression | m |
System.Object | quotedColName |
CreateInSubQuerySql(Object, String)
View Source
protected virtual string CreateInSubQuerySql(object quotedColName, string subSelect)
Returns
System.String
Parameters
Type | Name |
---|---|
System.Object | quotedColName |
System.String | subSelect |
VisitColumnAccessMethod(MethodCallExpression)
View Source
protected virtual object VisitColumnAccessMethod(MethodCallExpression m)
Returns
System.Object
Parameters
Type | Name |
---|---|
MethodCallExpression | m |
ToCast(String)
View Source
protected virtual string ToCast(string quotedColName)
Returns
System.String
Parameters
Type | Name |
---|---|
System.String | quotedColName |
GetSubstringSql(Object, Int32, Nullable<Int32>)
View Source
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
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
public IUntypedSqlExpression GetUntyped()
Returns
ServiceStack.OrmLite.IUntypedSqlExpression
GetAllTables()
View Source
public List<ModelDefinition> GetAllTables()
Returns
List<ServiceStack.OrmLite.ModelDefinition>
AddReferenceTableIfNotExists<Target>()
View Source
public SqlExpression<T> AddReferenceTableIfNotExists<Target>()
Returns
ServiceStack.OrmLite.SqlExpression<T>
Type Parameters
Target
CustomJoin<Target>(String)
View Source
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
public bool IsJoinedTable(Type type)
Returns
System.Boolean
Parameters
Type | Name |
---|---|
Type | type |
Join<Target>(Expression<Func<T, Target, Boolean>>)
View Source
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
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
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
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
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