EntitySqlQueryProjection.AsReusableProjected<TRow,TResult> method (1 of 6)
Prepares a reusable flat projection. The source query must be a root query without existing SELECT columns.
public static IProjectedQuery<TResult> AsReusableProjected<TRow, TResult>(this SqlQuery query,
Expression<Func<TRow, TResult>> projection, bool takeOwnership = false)
where TRow : class, IRow
| parameter | description |
|---|---|
| TRow | The row type of the projected source. |
| TResult | The flat projection result type. |
| query | The query to prepare. |
| projection | A flat projection built from row field accesses or SQL expressions. |
| takeOwnership | Whether to prepare the source query in place. If false, a clone is prepared; an already-frozen source cannot be taken over. |
Return Value
A reusable projection that can be executed with different parameter values.
See Also
- interface IProjectedQuery<TResult>
- class SqlQuery
- interface IRow
- class EntitySqlQueryProjection
EntitySqlQueryProjection.AsReusableProjected<TRow,TResult> method (2 of 6)
Prepares a reusable projection using the specified row-fields source aliases.
public static IProjectedQuery<TResult> AsReusableProjected<TRow, TResult>(this SqlQuery query,
Expression<Func<TRow, TResult>> projection, IReadOnlyList<RowFieldsBase> sources,
bool takeOwnership = false)
where TRow : class, IRow
| parameter | description |
|---|---|
| query | The query to prepare. |
| projection | A flat projection built from row field accesses or SQL expressions. |
| sources | The row-fields sources for the projection parameters. |
| takeOwnership | Whether to prepare the source query in place. If false, a clone is prepared; a frozen source cannot be taken over. |
Return Value
A reusable projection that can be executed with different parameter values.
See Also
- interface IProjectedQuery<TResult>
- class SqlQuery
- class RowFieldsBase
- interface IRow
- class EntitySqlQueryProjection
EntitySqlQueryProjection.AsReusableProjected<TRow1,TRow2,TResult> method (3 of 6)
Prepares a reusable flat projection. The source query must be a root query without existing SELECT columns.
public static IProjectedQuery<TResult> AsReusableProjected<TRow1, TRow2, TResult>(
this SqlQuery query, Expression<Func<TRow1, TRow2, TResult>> projection,
bool takeOwnership = false)
where TRow1 : class, IRow
where TRow2 : class, IRow
| parameter | description |
|---|---|
| TRow1 | The row type of the first projected source. |
| TRow2 | The row type of the second projected source. |
| TResult | The flat projection result type. |
| query | The query to prepare. |
| projection | A flat projection built from row field accesses or SQL expressions. |
| takeOwnership | Whether to prepare the source query in place. If false, a clone is prepared; an already-frozen source cannot be taken over. |
Return Value
A reusable projection that can be executed with different parameter values.
See Also
- interface IProjectedQuery<TResult>
- class SqlQuery
- interface IRow
- class EntitySqlQueryProjection
EntitySqlQueryProjection.AsReusableProjected<TRow1,TRow2,TResult> method (4 of 6)
Prepares a reusable projection using the specified row-fields source aliases.
public static IProjectedQuery<TResult> AsReusableProjected<TRow1, TRow2, TResult>(
this SqlQuery query, Expression<Func<TRow1, TRow2, TResult>> projection,
IReadOnlyList<RowFieldsBase> sources, bool takeOwnership = false)
where TRow1 : class, IRow
where TRow2 : class, IRow
| parameter | description |
|---|---|
| query | The query to prepare. |
| projection | A flat projection built from row field accesses or SQL expressions. |
| sources | The row-fields sources for the projection parameters. |
| takeOwnership | Whether to prepare the source query in place. If false, a clone is prepared; a frozen source cannot be taken over. |
Return Value
A reusable projection that can be executed with different parameter values.
See Also
- interface IProjectedQuery<TResult>
- class SqlQuery
- class RowFieldsBase
- interface IRow
- class EntitySqlQueryProjection
EntitySqlQueryProjection.AsReusableProjected<TRow1,TRow2,TRow3,TResult> method (5 of 6)
Prepares a reusable flat projection. The source query must be a root query without existing SELECT columns.
public static IProjectedQuery<TResult> AsReusableProjected<TRow1, TRow2, TRow3, TResult>(
this SqlQuery query, Expression<Func<TRow1, TRow2, TRow3, TResult>> projection,
bool takeOwnership = false)
where TRow1 : class, IRow
where TRow2 : class, IRow
where TRow3 : class, IRow
| parameter | description |
|---|---|
| TRow1 | The row type of the first projected source. |
| TRow2 | The row type of the second projected source. |
| TRow3 | The row type of the third projected source. |
| TResult | The flat projection result type. |
| query | The query to prepare. |
| projection | A flat projection built from row field accesses or SQL expressions. |
| takeOwnership | Whether to prepare the source query in place. If false, a clone is prepared; an already-frozen source cannot be taken over. |
Return Value
A reusable projection that can be executed with different parameter values.
See Also
- interface IProjectedQuery<TResult>
- class SqlQuery
- interface IRow
- class EntitySqlQueryProjection
EntitySqlQueryProjection.AsReusableProjected<TRow1,TRow2,TRow3,TResult> method (6 of 6)
Prepares a reusable projection using the specified row-fields source aliases.
public static IProjectedQuery<TResult> AsReusableProjected<TRow1, TRow2, TRow3, TResult>(
this SqlQuery query, Expression<Func<TRow1, TRow2, TRow3, TResult>> projection,
IReadOnlyList<RowFieldsBase> sources, bool takeOwnership = false)
where TRow1 : class, IRow
where TRow2 : class, IRow
where TRow3 : class, IRow
| parameter | description |
|---|---|
| query | The query to prepare. |
| projection | A flat projection built from row field accesses or SQL expressions. |
| sources | The row-fields sources for the projection parameters. |
| takeOwnership | Whether to prepare the source query in place. If false, a clone is prepared; a frozen source cannot be taken over. |
Return Value
A reusable projection that can be executed with different parameter values.
See Also
- interface IProjectedQuery<TResult>
- class SqlQuery
- class RowFieldsBase
- interface IRow
- class EntitySqlQueryProjection