Skip to content

EntitySqlQueryProjection.ListProjected<TRow,TResult> method (1 of 6)

Executes the query and materializes each result row into the specified flat projection.

public static List<TResult> ListProjected<TRow, TResult>(this SqlQuery query, 
    IDbConnection connection, Expression<Func<TRow, TResult>> projection, 
    IReadOnlyDictionary<string, object?>? parameters = null, 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 execute.
connection The connection.
projection A flat projection built from direct row field accesses.
parameters Values that override the source query's parameters for this execution.
takeOwnership Whether to prepare the source query in place instead of cloning it. The source must not be frozen.

Return Value

The projected results.

See Also

EntitySqlQueryProjection.ListProjected<TRow,TResult> method (2 of 6)

Executes and buffers a projection using the specified row-fields source aliases.

public static List<TResult> ListProjected<TRow, TResult>(this SqlQuery query, 
    IDbConnection connection, Expression<Func<TRow, TResult>> projection, 
    IReadOnlyList<RowFieldsBase> sources, IReadOnlyDictionary<string, object?>? parameters = null, 
    bool takeOwnership = false)
    where TRow : class, IRow

See Also

EntitySqlQueryProjection.ListProjected<TRow1,TRow2,TResult> method (3 of 6)

Executes the query and materializes each result row into the specified flat projection.

public static List<TResult> ListProjected<TRow1, TRow2, TResult>(this SqlQuery query, 
    IDbConnection connection, Expression<Func<TRow1, TRow2, TResult>> projection, 
    IReadOnlyDictionary<string, object?>? parameters = null, 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 execute.
connection The connection.
projection A flat projection built from direct row field accesses.
parameters Values that override the source query's parameters for this execution.
takeOwnership Whether to prepare the source query in place instead of cloning it. The source must not be frozen.

Return Value

The projected results.

See Also

EntitySqlQueryProjection.ListProjected<TRow1,TRow2,TResult> method (4 of 6)

Executes and buffers a projection using the specified row-fields source aliases.

public static List<TResult> ListProjected<TRow1, TRow2, TResult>(this SqlQuery query, 
    IDbConnection connection, Expression<Func<TRow1, TRow2, TResult>> projection, 
    IReadOnlyList<RowFieldsBase> sources, IReadOnlyDictionary<string, object?>? parameters = null, 
    bool takeOwnership = false)
    where TRow1 : class, IRow
    where TRow2 : class, IRow

See Also

EntitySqlQueryProjection.ListProjected<TRow1,TRow2,TRow3,TResult> method (5 of 6)

Executes the query and materializes each result row into the specified flat projection.

public static List<TResult> ListProjected<TRow1, TRow2, TRow3, TResult>(this SqlQuery query, 
    IDbConnection connection, Expression<Func<TRow1, TRow2, TRow3, TResult>> projection, 
    IReadOnlyDictionary<string, object?>? parameters = null, 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 execute.
connection The connection.
projection A flat projection built from direct row field accesses.
parameters Values that override the source query's parameters for this execution.
takeOwnership Whether to prepare the source query in place instead of cloning it. The source must not be frozen.

Return Value

The projected results.

See Also

EntitySqlQueryProjection.ListProjected<TRow1,TRow2,TRow3,TResult> method (6 of 6)

Executes and buffers a projection using the specified row-fields source aliases.

public static List<TResult> ListProjected<TRow1, TRow2, TRow3, TResult>(this SqlQuery query, 
    IDbConnection connection, Expression<Func<TRow1, TRow2, TRow3, TResult>> projection, 
    IReadOnlyList<RowFieldsBase> sources, IReadOnlyDictionary<string, object?>? parameters = null, 
    bool takeOwnership = false)
    where TRow1 : class, IRow
    where TRow2 : class, IRow
    where TRow3 : class, IRow

See Also

Previous Page Next Page