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