Share via

SqlExpressionFactory.Select Method

  • Reference

Definition

Namespace:
Microsoft.EntityFrameworkCore.Query
Assembly:
Microsoft.EntityFrameworkCore.Relational.dll
Package:
Microsoft.EntityFrameworkCore.Relational v3.0.0
Package:
Microsoft.EntityFrameworkCore.Relational v3.1.0
Package:
Microsoft.EntityFrameworkCore.Relational v5.0.0
Package:
Microsoft.EntityFrameworkCore.Relational v6.0.0
Package:
Microsoft.EntityFrameworkCore.Relational v7.0.0
Package:
Microsoft.EntityFrameworkCore.Relational v8.0.0

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 virtual Microsoft.EntityFrameworkCore.Query.SqlExpressions.SelectExpression Select (Microsoft.EntityFrameworkCore.Metadata.IEntityType entityType);
abstract member Select : Microsoft.EntityFrameworkCore.Metadata.IEntityType -> Microsoft.EntityFrameworkCore.Query.SqlExpressions.SelectExpression
override this.Select : Microsoft.EntityFrameworkCore.Metadata.IEntityType -> Microsoft.EntityFrameworkCore.Query.SqlExpressions.SelectExpression
Public Overridable Function Select (entityType As IEntityType) As SelectExpression

Parameters

entityType
IEntityType

An entity type to project.

Returns

SelectExpression

An expression representing a SELECT in a SQL tree.

Implements

Select(IEntityType)

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 virtual Microsoft.EntityFrameworkCore.Query.SqlExpressions.SelectExpression Select (Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression projection);
public virtual Microsoft.EntityFrameworkCore.Query.SqlExpressions.SelectExpression Select (Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression? projection);
abstract member Select : Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression -> Microsoft.EntityFrameworkCore.Query.SqlExpressions.SelectExpression
override this.Select : Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression -> Microsoft.EntityFrameworkCore.Query.SqlExpressions.SelectExpression
Public Overridable Function Select (projection As SqlExpression) As SelectExpression

Parameters

projection
SqlExpression

A SqlExpression to project.

Returns

SelectExpression

An expression representing a SELECT in a SQL tree.

Implements

Select(SqlExpression)

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 virtual 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.SelectExpression
override this.Select : Microsoft.EntityFrameworkCore.Metadata.IEntityType * Microsoft.EntityFrameworkCore.Query.SqlExpressions.TableExpressionBase -> Microsoft.EntityFrameworkCore.Query.SqlExpressions.SelectExpression
Public Overridable Function Select (entityType As IEntityType, tableExpressionBase As TableExpressionBase) As SelectExpression

Parameters

entityType
IEntityType

An entity type to project.

tableExpressionBase
TableExpressionBase

A table source to project from.

Returns

SelectExpression

An expression representing a SELECT in a SQL tree.

Implements

Select(IEntityType, TableExpressionBase)

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 virtual 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 virtual 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
override this.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.SelectExpression
override this.Select : Microsoft.EntityFrameworkCore.Metadata.IEntityType * string * System.Linq.Expressions.Expression -> Microsoft.EntityFrameworkCore.Query.SqlExpressions.SelectExpression
Public Overridable Function Select (entityType As IEntityType, sql As String, sqlArguments As Expression) As SelectExpression

Parameters

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

SelectExpression

An expression representing a SELECT in a SQL tree.

Implements

Select(IEntityType, String, Expression)
Attributes
ObsoleteAttribute

Applies to