Share via


ISqlExpressionFactory.Select Method

Definition

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.SelectExpression
Public Function Select (entityType As IEntityType) As SelectExpression

Parameters

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.SelectExpression
Public Function Select (projection As SqlExpression) As SelectExpression

Parameters

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.SelectExpression
Public 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

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.SelectExpression
Public 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

An expression representing a SELECT in a SQL tree.

Attributes

Applies to