Skip to main content

IUntypedSqlExpression

Assembly: ServiceStack.OrmLite.dll​
View Source​
Declaration
public interface IUntypedSqlExpression : ISqlExpression

Properties​

TableAlias​

View Source​
Declaration
string TableAlias { get; set; }

PrefixFieldWithTableName​

View Source​
Declaration
bool PrefixFieldWithTableName { get; set; }

WhereStatementWithoutWhereString​

View Source​
Declaration
bool WhereStatementWithoutWhereString { get; set; }

DialectProvider​

View Source​
Declaration
IOrmLiteDialectProvider DialectProvider { get; set; }

SelectExpression​

View Source​
Declaration
string SelectExpression { get; set; }

FromExpression​

View Source​
Declaration
string FromExpression { get; set; }

BodyExpression​

View Source​
Declaration
string BodyExpression { get; }

WhereExpression​

View Source​
Declaration
string WhereExpression { get; set; }

GroupByExpression​

View Source​
Declaration
string GroupByExpression { get; set; }

HavingExpression​

View Source​
Declaration
string HavingExpression { get; set; }

OrderByExpression​

View Source​
Declaration
string OrderByExpression { get; set; }

Rows​

View Source​
Declaration
int? Rows { get; set; }

Offset​

View Source​
Declaration
int? Offset { get; set; }

UpdateFields​

View Source​
Declaration
List<string> UpdateFields { get; set; }

InsertFields​

View Source​
Declaration
List<string> InsertFields { get; set; }

ModelDef​

View Source​
Declaration
ModelDefinition ModelDef { get; }

Methods​

Clone()​

View Source​
Declaration
IUntypedSqlExpression Clone()
Returns​

ServiceStack.OrmLite.IUntypedSqlExpression

Select()​

View Source​
Declaration
IUntypedSqlExpression Select()
Returns​

ServiceStack.OrmLite.IUntypedSqlExpression

Select(String)​

View Source​
Declaration
IUntypedSqlExpression Select(string selectExpression)
Returns​

ServiceStack.OrmLite.IUntypedSqlExpression

Parameters​
TypeName
System.StringselectExpression

UnsafeSelect(String)​

View Source​
Declaration
IUntypedSqlExpression UnsafeSelect(string rawSelect)
Returns​

ServiceStack.OrmLite.IUntypedSqlExpression

Parameters​
TypeName
System.StringrawSelect

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

View Source​
Declaration
IUntypedSqlExpression Select<Table1, Table2>(Expression<Func<Table1, Table2, object>> fields)
Returns​

ServiceStack.OrmLite.IUntypedSqlExpression

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
IUntypedSqlExpression Select<Table1, Table2, Table3>(Expression<Func<Table1, Table2, Table3, object>> fields)
Returns​

ServiceStack.OrmLite.IUntypedSqlExpression

Parameters​
TypeName
Expression<Func<<Table1>,<Table2>,<Table3>,System.Object>>fields
Type Parameters​
  • Table1
  • Table2
  • Table3

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

View Source​
Declaration
IUntypedSqlExpression SelectDistinct<Table1, Table2>(Expression<Func<Table1, Table2, object>> fields)
Returns​

ServiceStack.OrmLite.IUntypedSqlExpression

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
IUntypedSqlExpression SelectDistinct<Table1, Table2, Table3>(Expression<Func<Table1, Table2, Table3, object>> fields)
Returns​

ServiceStack.OrmLite.IUntypedSqlExpression

Parameters​
TypeName
Expression<Func<<Table1>,<Table2>,<Table3>,System.Object>>fields
Type Parameters​
  • Table1
  • Table2
  • Table3

SelectDistinct()​

View Source​
Declaration
IUntypedSqlExpression SelectDistinct()
Returns​

ServiceStack.OrmLite.IUntypedSqlExpression

From(String)​

View Source​
Declaration
IUntypedSqlExpression From(string tables)
Returns​

ServiceStack.OrmLite.IUntypedSqlExpression

Parameters​
TypeName
System.Stringtables

UnsafeFrom(String)​

View Source​
Declaration
IUntypedSqlExpression UnsafeFrom(string rawFrom)
Returns​

ServiceStack.OrmLite.IUntypedSqlExpression

Parameters​
TypeName
System.StringrawFrom

Where()​

View Source​
Declaration
IUntypedSqlExpression Where()
Returns​

ServiceStack.OrmLite.IUntypedSqlExpression

UnsafeWhere(String, Object[])​

View Source​
Declaration
IUntypedSqlExpression UnsafeWhere(string rawSql, params object[] filterParams)
Returns​

ServiceStack.OrmLite.IUntypedSqlExpression

Parameters​
TypeName
System.StringrawSql
System.Object[]filterParams

Ensure(String, Object[])​

View Source​
Declaration
IUntypedSqlExpression Ensure(string sqlFilter, params object[] filterParams)
Returns​

ServiceStack.OrmLite.IUntypedSqlExpression

Parameters​
TypeName
System.StringsqlFilter
System.Object[]filterParams

Where(String, Object[])​

View Source​
Declaration
IUntypedSqlExpression Where(string sqlFilter, params object[] filterParams)
Returns​

ServiceStack.OrmLite.IUntypedSqlExpression

Parameters​
TypeName
System.StringsqlFilter
System.Object[]filterParams

UnsafeAnd(String, Object[])​

View Source​
Declaration
IUntypedSqlExpression UnsafeAnd(string rawSql, params object[] filterParams)
Returns​

ServiceStack.OrmLite.IUntypedSqlExpression

Parameters​
TypeName
System.StringrawSql
System.Object[]filterParams

And(String, Object[])​

View Source​
Declaration
IUntypedSqlExpression And(string sqlFilter, params object[] filterParams)
Returns​

ServiceStack.OrmLite.IUntypedSqlExpression

Parameters​
TypeName
System.StringsqlFilter
System.Object[]filterParams

UnsafeOr(String, Object[])​

View Source​
Declaration
IUntypedSqlExpression UnsafeOr(string rawSql, params object[] filterParams)
Returns​

ServiceStack.OrmLite.IUntypedSqlExpression

Parameters​
TypeName
System.StringrawSql
System.Object[]filterParams

Or(String, Object[])​

View Source​
Declaration
IUntypedSqlExpression Or(string sqlFilter, params object[] filterParams)
Returns​

ServiceStack.OrmLite.IUntypedSqlExpression

Parameters​
TypeName
System.StringsqlFilter
System.Object[]filterParams

AddCondition(String, String, Object[])​

View Source​
Declaration
IUntypedSqlExpression AddCondition(string condition, string sqlFilter, params object[] filterParams)
Returns​

ServiceStack.OrmLite.IUntypedSqlExpression

Parameters​
TypeName
System.Stringcondition
System.StringsqlFilter
System.Object[]filterParams

GroupBy()​

View Source​
Declaration
IUntypedSqlExpression GroupBy()
Returns​

ServiceStack.OrmLite.IUntypedSqlExpression

GroupBy(String)​

View Source​
Declaration
IUntypedSqlExpression GroupBy(string groupBy)
Returns​

ServiceStack.OrmLite.IUntypedSqlExpression

Parameters​
TypeName
System.StringgroupBy

Having()​

View Source​
Declaration
IUntypedSqlExpression Having()
Returns​

ServiceStack.OrmLite.IUntypedSqlExpression

Having(String, Object[])​

View Source​
Declaration
IUntypedSqlExpression Having(string sqlFilter, params object[] filterParams)
Returns​

ServiceStack.OrmLite.IUntypedSqlExpression

Parameters​
TypeName
System.StringsqlFilter
System.Object[]filterParams

OrderBy()​

View Source​
Declaration
IUntypedSqlExpression OrderBy()
Returns​

ServiceStack.OrmLite.IUntypedSqlExpression

OrderBy(String)​

View Source​
Declaration
IUntypedSqlExpression OrderBy(string orderBy)
Returns​

ServiceStack.OrmLite.IUntypedSqlExpression

Parameters​
TypeName
System.StringorderBy

GetModelDefinition(FieldDefinition)​

View Source​
Declaration
ModelDefinition GetModelDefinition(FieldDefinition fieldDef)
Returns​

ServiceStack.OrmLite.ModelDefinition

Parameters​
TypeName
ServiceStack.OrmLite.FieldDefinitionfieldDef

OrderByFields(FieldDefinition[])​

View Source​
Declaration
IUntypedSqlExpression OrderByFields(params FieldDefinition[] fields)
Returns​

ServiceStack.OrmLite.IUntypedSqlExpression

Parameters​
TypeName
ServiceStack.OrmLite.FieldDefinition[]fields

OrderByFieldsDescending(FieldDefinition[])​

View Source​
Declaration
IUntypedSqlExpression OrderByFieldsDescending(params FieldDefinition[] fields)
Returns​

ServiceStack.OrmLite.IUntypedSqlExpression

Parameters​
TypeName
ServiceStack.OrmLite.FieldDefinition[]fields

OrderByFields(String[])​

View Source​
Declaration
IUntypedSqlExpression OrderByFields(params string[] fieldNames)
Returns​

ServiceStack.OrmLite.IUntypedSqlExpression

Parameters​
TypeName
System.String[]fieldNames

OrderByFieldsDescending(String[])​

View Source​
Declaration
IUntypedSqlExpression OrderByFieldsDescending(params string[] fieldNames)
Returns​

ServiceStack.OrmLite.IUntypedSqlExpression

Parameters​
TypeName
System.String[]fieldNames

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

View Source​
Declaration
IUntypedSqlExpression OrderBy<Table>(Expression<Func<Table, object>> keySelector)
Returns​

ServiceStack.OrmLite.IUntypedSqlExpression

Parameters​
TypeName
Expression<Func<<Table>,System.Object>>keySelector
Type Parameters​
  • Table

ThenBy(String)​

View Source​
Declaration
IUntypedSqlExpression ThenBy(string orderBy)
Returns​

ServiceStack.OrmLite.IUntypedSqlExpression

Parameters​
TypeName
System.StringorderBy

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

View Source​
Declaration
IUntypedSqlExpression ThenBy<Table>(Expression<Func<Table, object>> keySelector)
Returns​

ServiceStack.OrmLite.IUntypedSqlExpression

Parameters​
TypeName
Expression<Func<<Table>,System.Object>>keySelector
Type Parameters​
  • Table

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

View Source​
Declaration
IUntypedSqlExpression OrderByDescending<Table>(Expression<Func<Table, object>> keySelector)
Returns​

ServiceStack.OrmLite.IUntypedSqlExpression

Parameters​
TypeName
Expression<Func<<Table>,System.Object>>keySelector
Type Parameters​
  • Table

OrderByDescending(String)​

View Source​
Declaration
IUntypedSqlExpression OrderByDescending(string orderBy)
Returns​

ServiceStack.OrmLite.IUntypedSqlExpression

Parameters​
TypeName
System.StringorderBy

ThenByDescending(String)​

View Source​
Declaration
IUntypedSqlExpression ThenByDescending(string orderBy)
Returns​

ServiceStack.OrmLite.IUntypedSqlExpression

Parameters​
TypeName
System.StringorderBy

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

View Source​
Declaration
IUntypedSqlExpression ThenByDescending<Table>(Expression<Func<Table, object>> keySelector)
Returns​

ServiceStack.OrmLite.IUntypedSqlExpression

Parameters​
TypeName
Expression<Func<<Table>,System.Object>>keySelector
Type Parameters​
  • Table

Skip(Nullable<Int32>)​

View Source​
Declaration
IUntypedSqlExpression Skip(int? skip = null)
Returns​

ServiceStack.OrmLite.IUntypedSqlExpression

Parameters​
TypeName
System.Nullable<System.Int32>skip

Take(Nullable<Int32>)​

View Source​
Declaration
IUntypedSqlExpression Take(int? take = null)
Returns​

ServiceStack.OrmLite.IUntypedSqlExpression

Parameters​
TypeName
System.Nullable<System.Int32>take

Limit(Int32, Int32)​

View Source​
Declaration
IUntypedSqlExpression Limit(int skip, int rows)
Returns​

ServiceStack.OrmLite.IUntypedSqlExpression

Parameters​
TypeName
System.Int32skip
System.Int32rows

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

View Source​
Declaration
IUntypedSqlExpression Limit(int? skip, int? rows)
Returns​

ServiceStack.OrmLite.IUntypedSqlExpression

Parameters​
TypeName
System.Nullable<System.Int32>skip
System.Nullable<System.Int32>rows

Limit(Int32)​

View Source​
Declaration
IUntypedSqlExpression Limit(int rows)
Returns​

ServiceStack.OrmLite.IUntypedSqlExpression

Parameters​
TypeName
System.Int32rows

Limit()​

View Source​
Declaration
IUntypedSqlExpression Limit()
Returns​

ServiceStack.OrmLite.IUntypedSqlExpression

ClearLimits()​

View Source​
Declaration
IUntypedSqlExpression ClearLimits()
Returns​

ServiceStack.OrmLite.IUntypedSqlExpression

Update(List<String>)​

View Source​
Declaration
IUntypedSqlExpression Update(List<string> updateFields)
Returns​

ServiceStack.OrmLite.IUntypedSqlExpression

Parameters​
TypeName
List<System.String>updateFields

Update()​

View Source​
Declaration
IUntypedSqlExpression Update()
Returns​

ServiceStack.OrmLite.IUntypedSqlExpression

Insert(List<String>)​

View Source​
Declaration
IUntypedSqlExpression Insert(List<string> insertFields)
Returns​

ServiceStack.OrmLite.IUntypedSqlExpression

Parameters​
TypeName
List<System.String>insertFields

Insert()​

View Source​
Declaration
IUntypedSqlExpression Insert()
Returns​

ServiceStack.OrmLite.IUntypedSqlExpression

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

View Source​
Declaration
IDbDataParameter CreateParam(string name, object value = null, ParameterDirection direction = null, DbType? dbType = null)
Returns​

IDbDataParameter

Parameters​
TypeName
System.Stringname
System.Objectvalue
ParameterDirectiondirection
System.Nullable<DbType>dbType

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

View Source​
Declaration
IUntypedSqlExpression Join<Source, Target>(Expression<Func<Source, Target, bool>> joinExpr = null)
Returns​

ServiceStack.OrmLite.IUntypedSqlExpression

Parameters​
TypeName
Expression<Func<<Source>,<Target>,System.Boolean>>joinExpr
Type Parameters​
  • Source
  • Target

Join(Type, Type, Expression)​

View Source​
Declaration
IUntypedSqlExpression Join(Type sourceType, Type targetType, Expression joinExpr = null)
Returns​

ServiceStack.OrmLite.IUntypedSqlExpression

Parameters​
TypeName
TypesourceType
TypetargetType
ExpressionjoinExpr

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

View Source​
Declaration
IUntypedSqlExpression LeftJoin<Source, Target>(Expression<Func<Source, Target, bool>> joinExpr = null)
Returns​

ServiceStack.OrmLite.IUntypedSqlExpression

Parameters​
TypeName
Expression<Func<<Source>,<Target>,System.Boolean>>joinExpr
Type Parameters​
  • Source
  • Target

LeftJoin(Type, Type, Expression)​

View Source​
Declaration
IUntypedSqlExpression LeftJoin(Type sourceType, Type targetType, Expression joinExpr = null)
Returns​

ServiceStack.OrmLite.IUntypedSqlExpression

Parameters​
TypeName
TypesourceType
TypetargetType
ExpressionjoinExpr

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

View Source​
Declaration
IUntypedSqlExpression RightJoin<Source, Target>(Expression<Func<Source, Target, bool>> joinExpr = null)
Returns​

ServiceStack.OrmLite.IUntypedSqlExpression

Parameters​
TypeName
Expression<Func<<Source>,<Target>,System.Boolean>>joinExpr
Type Parameters​
  • Source
  • Target

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

View Source​
Declaration
IUntypedSqlExpression FullJoin<Source, Target>(Expression<Func<Source, Target, bool>> joinExpr = null)
Returns​

ServiceStack.OrmLite.IUntypedSqlExpression

Parameters​
TypeName
Expression<Func<<Source>,<Target>,System.Boolean>>joinExpr
Type Parameters​
  • Source
  • Target

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

View Source​
Declaration
IUntypedSqlExpression CrossJoin<Source, Target>(Expression<Func<Source, Target, bool>> joinExpr = null)
Returns​

ServiceStack.OrmLite.IUntypedSqlExpression

Parameters​
TypeName
Expression<Func<<Source>,<Target>,System.Boolean>>joinExpr
Type Parameters​
  • Source
  • Target

CustomJoin(String)​

View Source​
Declaration
IUntypedSqlExpression CustomJoin(string joinString)
Returns​

ServiceStack.OrmLite.IUntypedSqlExpression

Parameters​
TypeName
System.StringjoinString

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

View Source​
Declaration
IUntypedSqlExpression Ensure<Target>(Expression<Func<Target, bool>> predicate)
Returns​

ServiceStack.OrmLite.IUntypedSqlExpression

Parameters​
TypeName
Expression<Func<<Target>,System.Boolean>>predicate
Type Parameters​
  • Target

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

View Source​
Declaration
IUntypedSqlExpression Ensure<Source, Target>(Expression<Func<Source, Target, bool>> predicate)
Returns​

ServiceStack.OrmLite.IUntypedSqlExpression

Parameters​
TypeName
Expression<Func<<Source>,<Target>,System.Boolean>>predicate
Type Parameters​
  • Source
  • Target

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

View Source​
Declaration
IUntypedSqlExpression Where<Target>(Expression<Func<Target, bool>> predicate)
Returns​

ServiceStack.OrmLite.IUntypedSqlExpression

Parameters​
TypeName
Expression<Func<<Target>,System.Boolean>>predicate
Type Parameters​
  • Target

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

View Source​
Declaration
IUntypedSqlExpression Where<Source, Target>(Expression<Func<Source, Target, bool>> predicate)
Returns​

ServiceStack.OrmLite.IUntypedSqlExpression

Parameters​
TypeName
Expression<Func<<Source>,<Target>,System.Boolean>>predicate
Type Parameters​
  • Source
  • Target

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

View Source​
Declaration
IUntypedSqlExpression And<Target>(Expression<Func<Target, bool>> predicate)
Returns​

ServiceStack.OrmLite.IUntypedSqlExpression

Parameters​
TypeName
Expression<Func<<Target>,System.Boolean>>predicate
Type Parameters​
  • Target

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

View Source​
Declaration
IUntypedSqlExpression And<Source, Target>(Expression<Func<Source, Target, bool>> predicate)
Returns​

ServiceStack.OrmLite.IUntypedSqlExpression

Parameters​
TypeName
Expression<Func<<Source>,<Target>,System.Boolean>>predicate
Type Parameters​
  • Source
  • Target

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

View Source​
Declaration
IUntypedSqlExpression Or<Target>(Expression<Func<Target, bool>> predicate)
Returns​

ServiceStack.OrmLite.IUntypedSqlExpression

Parameters​
TypeName
Expression<Func<<Target>,System.Boolean>>predicate
Type Parameters​
  • Target

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

View Source​
Declaration
IUntypedSqlExpression Or<Source, Target>(Expression<Func<Source, Target, bool>> predicate)
Returns​

ServiceStack.OrmLite.IUntypedSqlExpression

Parameters​
TypeName
Expression<Func<<Source>,<Target>,System.Boolean>>predicate
Type Parameters​
  • Source
  • Target

SqlTable(ModelDefinition)​

View Source​
Declaration
string SqlTable(ModelDefinition modelDef)
Returns​

System.String

Parameters​
TypeName
ServiceStack.OrmLite.ModelDefinitionmodelDef

SqlColumn(String)​

View Source​
Declaration
string SqlColumn(string columnName)
Returns​

System.String

Parameters​
TypeName
System.StringcolumnName

ToDeleteRowStatement()​

View Source​
Declaration
string ToDeleteRowStatement()
Returns​

System.String

ToCountStatement()​

View Source​
Declaration
string ToCountStatement()
Returns​

System.String

GetAllFields()​

View Source​
Declaration
IList<string> GetAllFields()
Returns​

IList<System.String>

FirstMatchingField(String)​

View Source​
Declaration
Tuple<ModelDefinition, FieldDefinition> FirstMatchingField(string fieldName)
Returns​

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

Parameters​
TypeName
System.StringfieldName