C# Class MicroLite.Builder.SelectSqlBuilder

Inheritance: SqlBuilderBase, ISelectFrom, IFunctionOrFrom, IWhereOrOrderBy, IAndOrOrderBy, IGroupBy, IOrderBy, IWhereSingleColumn, IHavingOrOrderBy, IWhereExists

Show file Open project: TrevorPilley/MicroLite Class Usage Examples

Public Methods

Method	Description
AndWhere ( string predicate ) : IAndOrOrderBy
AndWhere ( string column ) : IWhereSingleColumn
Average ( string columnName ) : IFunctionOrFrom
Average ( string columnName, string columnAlias ) : IFunctionOrFrom
Between ( object lower, object upper ) : IAndOrOrderBy
Count ( string columnName ) : IFunctionOrFrom
Count ( string columnName, string columnAlias ) : IFunctionOrFrom
Distinct ( ) : IFunctionOrFrom
Distinct ( string column ) : IFunctionOrFrom
Exists ( SqlQuery subQuery ) : IAndOrOrderBy
From ( Type forType ) : IWhereOrOrderBy
From ( string table ) : IWhereOrOrderBy
GroupBy ( ) : IHavingOrOrderBy
GroupBy ( string column ) : IHavingOrOrderBy
Having ( string predicate, object value ) : IOrderBy
In ( ) : IAndOrOrderBy
In ( SqlQuery subQuery ) : IAndOrOrderBy
IsEqualTo ( SqlQuery subQuery ) : IAndOrOrderBy
IsEqualTo ( object comparisonValue ) : IAndOrOrderBy
IsGreaterThan ( object comparisonValue ) : IAndOrOrderBy
IsGreaterThanOrEqualTo ( object comparisonValue ) : IAndOrOrderBy
IsLessThan ( object comparisonValue ) : IAndOrOrderBy
IsLessThanOrEqualTo ( object comparisonValue ) : IAndOrOrderBy
IsLike ( object comparisonValue ) : IAndOrOrderBy
IsNotEqualTo ( SqlQuery subQuery ) : IAndOrOrderBy
IsNotEqualTo ( object comparisonValue ) : IAndOrOrderBy
IsNotLike ( object comparisonValue ) : IAndOrOrderBy
IsNotNull ( ) : IAndOrOrderBy
IsNull ( ) : IAndOrOrderBy
Max ( string columnName ) : IFunctionOrFrom
Max ( string columnName, string columnAlias ) : IFunctionOrFrom
Min ( string columnName ) : IFunctionOrFrom
Min ( string columnName, string columnAlias ) : IFunctionOrFrom
NotBetween ( object lower, object upper ) : IAndOrOrderBy
NotExists ( SqlQuery subQuery ) : IAndOrOrderBy
NotIn ( ) : IAndOrOrderBy
NotIn ( SqlQuery subQuery ) : IAndOrOrderBy
OrWhere ( string predicate ) : IAndOrOrderBy
OrWhere ( string column ) : IWhereSingleColumn
OrderByAscending ( ) : IOrderBy
OrderByAscending ( string column ) : IOrderBy
OrderByDescending ( ) : IOrderBy
OrderByDescending ( string column ) : IOrderBy
Sum ( string columnName ) : IFunctionOrFrom
Sum ( string columnName, string columnAlias ) : IFunctionOrFrom
Where ( string predicate ) : IAndOrOrderBy
Where ( ) : IWhereExists
Where ( string column ) : IWhereSingleColumn

Private Methods

Method	Description
AddExists ( SqlQuery subQuery, bool negate ) : void
AddFunctionCall ( string functionName, string columnName, string columnAlias ) : void
AddOrder ( string column, string direction ) : void
AddWithComparisonOperator ( SqlQuery subQuery, string comparisonOperator ) : void
From ( IObjectInfo objectInfo ) : IWhereOrOrderBy
SelectSqlBuilder ( SqlCharacters sqlCharacters ) : System	Initialises a new instance of the SelectSqlBuilder class with the starting command text 'SELECT *'.
SelectSqlBuilder ( SqlCharacters sqlCharacters, string column ) : System	Initialises a new instance of the SelectSqlBuilder class with an optional list of columns to select.

Method Details

AndWhere() public method

public AndWhere ( string predicate ) : IAndOrOrderBy
predicate	string
return	IAndOrOrderBy

AndWhere() public method

public AndWhere ( string column ) : IWhereSingleColumn
column	string
return	IWhereSingleColumn

Average() public method

public Average ( string columnName ) : IFunctionOrFrom
columnName	string
return	IFunctionOrFrom

Average() public method

public Average ( string columnName, string columnAlias ) : IFunctionOrFrom
columnName	string
columnAlias	string
return	IFunctionOrFrom

Between() public method

public Between ( object lower, object upper ) : IAndOrOrderBy
lower	object
upper	object
return	IAndOrOrderBy

Count() public method

public Count ( string columnName ) : IFunctionOrFrom
columnName	string
return	IFunctionOrFrom

Count() public method

public Count ( string columnName, string columnAlias ) : IFunctionOrFrom
columnName	string
columnAlias	string
return	IFunctionOrFrom

Distinct() public method

public Distinct ( ) : IFunctionOrFrom
return	IFunctionOrFrom

Distinct() public method

public Distinct ( string column ) : IFunctionOrFrom
column	string
return	IFunctionOrFrom

Exists() public method

public Exists ( SqlQuery subQuery ) : IAndOrOrderBy
subQuery	SqlQuery
return	IAndOrOrderBy

From() public method

public From ( Type forType ) : IWhereOrOrderBy
forType	System.Type
return	IWhereOrOrderBy

From() public method

public From ( string table ) : IWhereOrOrderBy
table	string
return	IWhereOrOrderBy

GroupBy() public method

public GroupBy ( ) : IHavingOrOrderBy
return	IHavingOrOrderBy

GroupBy() public method

public GroupBy ( string column ) : IHavingOrOrderBy
column	string
return	IHavingOrOrderBy

Having() public method

public Having ( string predicate, object value ) : IOrderBy
predicate	string
value	object
return	IOrderBy

In() public method

public In ( ) : IAndOrOrderBy
return	IAndOrOrderBy

In() public method

public In ( SqlQuery subQuery ) : IAndOrOrderBy
subQuery	SqlQuery
return	IAndOrOrderBy

IsEqualTo() public method

public IsEqualTo ( SqlQuery subQuery ) : IAndOrOrderBy
subQuery	SqlQuery
return	IAndOrOrderBy

IsEqualTo() public method

public IsEqualTo ( object comparisonValue ) : IAndOrOrderBy
comparisonValue	object
return	IAndOrOrderBy

IsGreaterThan() public method

public IsGreaterThan ( object comparisonValue ) : IAndOrOrderBy
comparisonValue	object
return	IAndOrOrderBy

IsGreaterThanOrEqualTo() public method

public IsGreaterThanOrEqualTo ( object comparisonValue ) : IAndOrOrderBy
comparisonValue	object
return	IAndOrOrderBy

IsLessThan() public method

public IsLessThan ( object comparisonValue ) : IAndOrOrderBy
comparisonValue	object
return	IAndOrOrderBy

IsLessThanOrEqualTo() public method

public IsLessThanOrEqualTo ( object comparisonValue ) : IAndOrOrderBy
comparisonValue	object
return	IAndOrOrderBy

IsLike() public method

public IsLike ( object comparisonValue ) : IAndOrOrderBy
comparisonValue	object
return	IAndOrOrderBy

IsNotEqualTo() public method

public IsNotEqualTo ( SqlQuery subQuery ) : IAndOrOrderBy
subQuery	SqlQuery
return	IAndOrOrderBy

IsNotEqualTo() public method

public IsNotEqualTo ( object comparisonValue ) : IAndOrOrderBy
comparisonValue	object
return	IAndOrOrderBy

IsNotLike() public method

public IsNotLike ( object comparisonValue ) : IAndOrOrderBy
comparisonValue	object
return	IAndOrOrderBy

IsNotNull() public method

public IsNotNull ( ) : IAndOrOrderBy
return	IAndOrOrderBy

IsNull() public method

public IsNull ( ) : IAndOrOrderBy
return	IAndOrOrderBy

Max() public method

public Max ( string columnName ) : IFunctionOrFrom
columnName	string
return	IFunctionOrFrom

Max() public method

public Max ( string columnName, string columnAlias ) : IFunctionOrFrom
columnName	string
columnAlias	string
return	IFunctionOrFrom

Min() public method

public Min ( string columnName ) : IFunctionOrFrom
columnName	string
return	IFunctionOrFrom

Min() public method

public Min ( string columnName, string columnAlias ) : IFunctionOrFrom
columnName	string
columnAlias	string
return	IFunctionOrFrom

NotBetween() public method

public NotBetween ( object lower, object upper ) : IAndOrOrderBy
lower	object
upper	object
return	IAndOrOrderBy

NotExists() public method

public NotExists ( SqlQuery subQuery ) : IAndOrOrderBy
subQuery	SqlQuery
return	IAndOrOrderBy

NotIn() public method

public NotIn ( ) : IAndOrOrderBy
return	IAndOrOrderBy

NotIn() public method

public NotIn ( SqlQuery subQuery ) : IAndOrOrderBy
subQuery	SqlQuery
return	IAndOrOrderBy

OrWhere() public method

public OrWhere ( string predicate ) : IAndOrOrderBy
predicate	string
return	IAndOrOrderBy

OrWhere() public method

public OrWhere ( string column ) : IWhereSingleColumn
column	string
return	IWhereSingleColumn

OrderByAscending() public method

public OrderByAscending ( ) : IOrderBy
return	IOrderBy

OrderByAscending() public method

public OrderByAscending ( string column ) : IOrderBy
column	string
return	IOrderBy

OrderByDescending() public method

public OrderByDescending ( ) : IOrderBy
return	IOrderBy

OrderByDescending() public method

public OrderByDescending ( string column ) : IOrderBy
column	string
return	IOrderBy

Sum() public method

public Sum ( string columnName ) : IFunctionOrFrom
columnName	string
return	IFunctionOrFrom

Sum() public method

public Sum ( string columnName, string columnAlias ) : IFunctionOrFrom
columnName	string
columnAlias	string
return	IFunctionOrFrom

Where() public method

public Where ( string predicate ) : IAndOrOrderBy
predicate	string
return	IAndOrOrderBy

Where() public method

public Where ( ) : IWhereExists
return	IWhereExists

Where() public method

public Where ( string column ) : IWhereSingleColumn
column	string
return	IWhereSingleColumn