• Главная
• MicroLite
• Builder
• SelectSqlBuilder

C# Класс MicroLite.Builder.SelectSqlBuilder

Показать файл Открыть проект Примеры использования класса

Открытые методы

Метод	Описание
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

Приватные методы

Метод	Описание
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.

Описание методов