SqlBuilder.WITH(String, SqlSet) Method
Appends the WITH clause using the provided subQuery as body named after alias.
Namespace: DbExtensions
Assembly: DbExtensions.dll
Overloads
| Name | Description |
|---|---|
| WITH(SqlBuilder.ClauseStringHandler<WITH>) | Appends the WITH clause using the provided interpolated string handler. |
| WITH(String) | Appends the WITH clause using the provided text. |
| WITH(String, SqlBuilder) | Appends the WITH clause using the provided subQuery as body named after alias. |
| WITH(String, SqlSet) | Appends the WITH clause using the provided subQuery as body named after alias. |
Syntax
public SqlBuilder WITH(
string alias,
SqlSet subQuery
)
Parameters
alias String
The alias of the sub-query.
subQuery SqlSet
The sub-query to use as the body of the WITH clause.
Return Value
SqlBuilder
A reference to this instance after the append operation has completed.