Namespaces

Types

Type SqlSelectBuilder

Namespace NHibernate.SqlCommand

Parent SqlBaseBuilder

Interfaces ISqlStringBuilder

Methods

Fields

Public instance methods

bool Equals(object obj)

Parameters
return bool
object obj

int GetHashCode()

Parameters
return int

Type GetType()

Parameters
return Type

SqlSelectBuilder SetFromClause(string fromClause)

Sets the text that should appear after the FROM
Parameters
return SqlSelectBuilder The SqlSelectBuilder
string fromClause The fromClause to set

SqlSelectBuilder SetFromClause(SqlString fromClause)

Sets the text that should appear after the FROM
Parameters
return SqlSelectBuilder The SqlSelectBuilder
SqlString fromClause The fromClause in a SqlString

SqlSelectBuilder SetFromClause(string tableName, string alias)

Sets the text that should appear after the FROM
Parameters
return SqlSelectBuilder The SqlSelectBuilder
string tableName The name of the Table to get the data from
string alias The Alias to use for the table name.

SqlSelectBuilder SetGroupByClause(string groupByClause)

Sets the text that should appear after the GROUP BY.
Parameters
return SqlSelectBuilder The SqlSelectBuilder
string groupByClause The groupByClause to set

SqlSelectBuilder SetLockMode(LockMode lockMode)

Parameters
return SqlSelectBuilder
LockMode lockMode

SqlSelectBuilder SetOrderByClause(string orderByClause)

Sets the text that should appear after the ORDER BY.
Parameters
return SqlSelectBuilder The SqlSelectBuilder
string orderByClause The orderByClause to set

SqlSelectBuilder SetOuterJoins(SqlString outerJoinsAfterFrom, SqlString outerJoinsAfterWhere)

Sets the SqlString for the OUTER JOINs.
All of the Sql needs to be included in the SELECT. No OUTER JOINS will automatically be added.
Parameters
return SqlSelectBuilder The SqlSelectBuilder
SqlString outerJoinsAfterFrom The outerJoinsAfterFrom to set
SqlString outerJoinsAfterWhere The outerJoinsAfterWhere to set

SqlSelectBuilder SetSelectClause(string selectClause)

Sets the text for the SELECT
Parameters
return SqlSelectBuilder The SqlSelectBuilder
string selectClause The selectClause to set

SqlSelectBuilder SetWhereClause(string tableAlias, String[] columnNames, IType whereType)

Parameters
return SqlSelectBuilder
string tableAlias
String[] columnNames
IType whereType

SqlSelectBuilder SetWhereClause(SqlString whereSqlString)

Sets the prebuilt SqlString to the Where clause
Parameters
return SqlSelectBuilder This SqlSelectBuilder
SqlString whereSqlString The SqlString that contains the sql and parameters to add to the WHERE

SqlString ToSqlString()

Parameters
return SqlString

string ToString()

Parameters
return string

Public fields

Dialect dialect

return Dialect