EntitySqlQueryProjection class
namespace: Serenity.Data assembly: Serenity.Net.Services
Extensions for SQL query projections.
public static class EntitySqlQueryProjection
Public Members
| name | description |
|---|---|
| static AsReusableProjected<TRow,TResult>(…) | Prepares a reusable flat projection. The source query must be a root query without existing SELECT columns. (2 methods) |
| static AsReusableProjected<TRow1,TRow2,TResult>(…) | Prepares a reusable flat projection. The source query must be a root query without existing SELECT columns. (2 methods) |
| static AsReusableProjected<TRow1,TRow2,TRow3,TResult>(…) | Prepares a reusable flat projection. The source query must be a root query without existing SELECT columns. (2 methods) |
| static ListProjected<TRow,TResult>(…) | Executes the query and materializes each result row into the specified flat projection. (2 methods) |
| static ListProjected<TRow1,TRow2,TResult>(…) | Executes the query and materializes each result row into the specified flat projection. (2 methods) |
| static ListProjected<TRow1,TRow2,TRow3,TResult>(…) | Executes the query and materializes each result row into the specified flat projection. (2 methods) |
| static ListProjectedAsync<TRow,TResult>(…) | Asynchronously executes the query and buffers the flat projection results. (2 methods) |
| static ListProjectedAsync<TRow1,TRow2,TResult>(…) | Asynchronously executes the query and buffers the flat projection results. (2 methods) |
| static ListProjectedAsync<TRow1,TRow2,TRow3,TResult>(…) | Asynchronously executes the query and buffers the flat projection results. (2 methods) |
| static QueryProjected<TRow,TResult>(…) | Executes the query and materializes each result row into the specified flat projection. The query must not already have SELECT columns. Each selector parameter must match one unambiguous row-fields source in the query, or sources can be supplied explicitly. (2 methods) |
| static QueryProjected<TRow1,TRow2,TResult>(…) | Executes the query and materializes each result row into the specified flat projection. When buffered is false, the data reader remains open until enumeration completes or the enumerator is disposed. (2 methods) |
| static QueryProjected<TRow1,TRow2,TRow3,TResult>(…) | Executes the query and materializes each result row into the specified flat projection. When buffered is false, the data reader remains open until enumeration completes or the enumerator is disposed. (2 methods) |
| static QueryProjectedAsync<TRow,TResult>(…) | Asynchronously streams the flat projection results. The data reader remains open until enumeration completes, is cancelled, or the async enumerator is disposed. (2 methods) |
| static QueryProjectedAsync<TRow1,TRow2,TResult>(…) | Asynchronously streams the flat projection results. The data reader remains open until enumeration completes, is cancelled, or the async enumerator is disposed. (2 methods) |
| static QueryProjectedAsync<TRow1,TRow2,TRow3,TResult>(…) | Asynchronously streams the flat projection results. The data reader remains open until enumeration completes, is cancelled, or the async enumerator is disposed. (2 methods) |
Remarks
Projection selectors currently support flat anonymous types, constructor projections, and object initializers whose values are direct row field accesses. Sources are inferred from query row fields when each selector parameter has one unique match, or can be supplied explicitly. Unbuffered results keep the data reader open until enumeration completes or the enumerator is disposed.
See Also
- Source: EntitySqlQueryProjection.cs