ISqlExpressionFactory.Select Method
Definition
Important
Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.
Overloads
| Select(IEntityType) |
Creates a new SelectExpression which represents a SELECT in a SQL tree projecting an entity type from a table source created using default mapping in the model. |
| Select(SqlExpression) |
Creates a new SelectExpression which represents a SELECT in a SQL tree projecting a SqlExpression or 1 from no table and without any composition. |
| Select(IEntityType, TableExpressionBase) |
Creates a new SelectExpression which represents a SELECT in a SQL tree projecting an entity type from a table source. |
| Select(IEntityType, String, Expression) |
Obsolete.
Creates a new SelectExpression which represents a SELECT in a SQL tree projecting an entity type from a table source created using a custom SQL. |
Select(IEntityType)
Creates a new SelectExpression which represents a SELECT in a SQL tree projecting an entity type from a table source created using default mapping in the model.
public Microsoft.EntityFrameworkCore.Query.SqlExpressions.SelectExpression Select (Microsoft.EntityFrameworkCore.Metadata.IEntityType entityType);abstract member Select : Microsoft.EntityFrameworkCore.Metadata.IEntityType -> Microsoft.EntityFrameworkCore.Query.SqlExpressions.SelectExpressionPublic Function Select (entityType As IEntityType) As SelectExpressionParameters
- entityType
- IEntityType
An entity type to project.
Returns
An expression representing a SELECT in a SQL tree.
Applies to
Select(SqlExpression)
Creates a new SelectExpression which represents a SELECT in a SQL tree projecting a SqlExpression or 1 from no table and without any composition.
public Microsoft.EntityFrameworkCore.Query.SqlExpressions.SelectExpression Select (Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression projection);public Microsoft.EntityFrameworkCore.Query.SqlExpressions.SelectExpression Select (Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression? projection);abstract member Select : Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression -> Microsoft.EntityFrameworkCore.Query.SqlExpressions.SelectExpressionPublic Function Select (projection As SqlExpression) As SelectExpressionParameters
- projection
- SqlExpression
A SqlExpression to project.
Returns
An expression representing a SELECT in a SQL tree.
Applies to
Select(IEntityType, TableExpressionBase)
Creates a new SelectExpression which represents a SELECT in a SQL tree projecting an entity type from a table source.
public Microsoft.EntityFrameworkCore.Query.SqlExpressions.SelectExpression Select (Microsoft.EntityFrameworkCore.Metadata.IEntityType entityType, Microsoft.EntityFrameworkCore.Query.SqlExpressions.TableExpressionBase tableExpressionBase);abstract member Select : Microsoft.EntityFrameworkCore.Metadata.IEntityType * Microsoft.EntityFrameworkCore.Query.SqlExpressions.TableExpressionBase -> Microsoft.EntityFrameworkCore.Query.SqlExpressions.SelectExpressionPublic Function Select (entityType As IEntityType, tableExpressionBase As TableExpressionBase) As SelectExpressionParameters
- entityType
- IEntityType
An entity type to project.
- tableExpressionBase
- TableExpressionBase
A table source to project from.
Returns
An expression representing a SELECT in a SQL tree.
Applies to
Select(IEntityType, String, Expression)
Caution
Use overload which takes TableExpressionBase by passing FromSqlExpression directly.
Creates a new SelectExpression which represents a SELECT in a SQL tree projecting an entity type from a table source created using a custom SQL.
public Microsoft.EntityFrameworkCore.Query.SqlExpressions.SelectExpression Select (Microsoft.EntityFrameworkCore.Metadata.IEntityType entityType, string sql, System.Linq.Expressions.Expression sqlArguments);[System.Obsolete("Use overload which takes TableExpressionBase by passing FromSqlExpression directly.")]
public Microsoft.EntityFrameworkCore.Query.SqlExpressions.SelectExpression Select (Microsoft.EntityFrameworkCore.Metadata.IEntityType entityType, string sql, System.Linq.Expressions.Expression sqlArguments);abstract member Select : Microsoft.EntityFrameworkCore.Metadata.IEntityType * string * System.Linq.Expressions.Expression -> Microsoft.EntityFrameworkCore.Query.SqlExpressions.SelectExpression[<System.Obsolete("Use overload which takes TableExpressionBase by passing FromSqlExpression directly.")>]
abstract member Select : Microsoft.EntityFrameworkCore.Metadata.IEntityType * string * System.Linq.Expressions.Expression -> Microsoft.EntityFrameworkCore.Query.SqlExpressions.SelectExpressionPublic Function Select (entityType As IEntityType, sql As String, sqlArguments As Expression) As SelectExpressionParameters
- entityType
- IEntityType
An entity type to project.
- sql
- String
A custom SQL for the table source.
- sqlArguments
- Expression
An expression representing parameters passed to the custom SQL.
Returns
An expression representing a SELECT in a SQL tree.
- Attributes
Applies to
Entity Framework