SqlQuery.Select method (1 of 6)
Adds a subquery to the SELECT statement.
public SqlQuery Select(ISqlQuery expression)
| parameter | description |
|---|---|
| expression | A subquery. Must share the same root query (usually built via this query's SubQuery() method); an unrelated query's parameters are not available here, so embedding it may produce completely invalid results. |
Return Value
The query itself.
Exceptions
| exception | condition |
|---|---|
| InvalidOperationException | expression is an independent query with auto parameters. |
See Also
SqlQuery.Select method (2 of 6)
Adds a field name or an SQL expression to the SELECT statement.
public SqlQuery Select(string expression)
| parameter | description |
|---|---|
| expression | A field or an SQL expression. |
Return Value
The query itself.
Exceptions
| exception | condition |
|---|---|
| ArgumentNullException | expression is null or empty. |
Remarks
No column name is used for the field or expression.
See Also
- class SqlQuery
SqlQuery.Select method (3 of 6)
Adds a field of a given table alias to the SELECT statement.
public SqlQuery Select(IAlias alias, string fieldName)
| parameter | description |
|---|---|
| alias | A table alias that will be prepended to the field name with "." between |
| fieldName | A field name of the aliased table. |
Return Value
The query itself.
Remarks
No column name is used for the field or expression.
See Also
SqlQuery.Select method (4 of 6)
Adds a subquery to the SELECT statement.
public SqlQuery Select(ISqlQuery expression, string columnName)
| parameter | description |
|---|---|
| expression | A subquery. Must share the same root query (usually built via this query's SubQuery() method); an unrelated query's parameters are not available here, so embedding it may produce completely invalid results. |
| columnName | A column name |
Return Value
The query itself.
Exceptions
| exception | condition |
|---|---|
| InvalidOperationException | expression is an independent query with auto parameters. |
See Also
SqlQuery.Select method (5 of 6)
Adds a field name or expression to the SELECT statement with a column name
public SqlQuery Select(string expression, string columnName)
| parameter | description |
|---|---|
| expression | A field name or SQL expression. |
| columnName | A column name. |
Return Value
The query itself.
Exceptions
| exception | condition |
|---|---|
| ArgumentNullException | expression or columnName is null or empty. |
See Also
- class SqlQuery
SqlQuery.Select method (6 of 6)
Adds a field of a given table alias to the SELECT statement with a column name.
public SqlQuery Select(IAlias alias, string fieldName, string columnName)
| parameter | description |
|---|---|
| alias | A table alias that will be prepended to the field name with "." between |
| fieldName | A field name of the aliased table. |
| columnName | A column name |
Return Value
The query itself.