SqlExpressionFactory.In Method

Definition

Namespace:: Microsoft.EntityFrameworkCore.Query

Assembly:: Microsoft.EntityFrameworkCore.Relational.dll

Package:: Microsoft.EntityFrameworkCore.Relational v10.0.0

Package:: Microsoft.EntityFrameworkCore.Relational v8.0.0

Package:: Microsoft.EntityFrameworkCore.Relational v9.0.0

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

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

Name	Description
In(SqlExpression, SelectExpression)	Creates a new InExpression which represents an IN operation in a SQL tree.
In(SqlExpression, IReadOnlyList<SqlExpression>)	Creates a new InExpression which represents an IN operation in a SQL tree.
In(SqlExpression, SelectExpression, Boolean)	Creates a new InExpression which represents an IN operation in a SQL tree.
In(SqlExpression, SqlExpression, Boolean)	Creates a new InExpression which represents an IN operation in a SQL tree.
In(SqlExpression, SqlParameterExpression)	Creates a new InExpression which represents an IN operation in a SQL tree.

In(SqlExpression, SelectExpression)

Source:: SqlExpressionFactory.cs

Source:: SqlExpressionFactory.cs

Source:: SqlExpressionFactory.cs

Creates a new InExpression which represents an IN operation in a SQL tree.

public virtual Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression In(Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression item, Microsoft.EntityFrameworkCore.Query.SqlExpressions.SelectExpression subquery);

public virtual Microsoft.EntityFrameworkCore.Query.SqlExpressions.InExpression In(Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression item, Microsoft.EntityFrameworkCore.Query.SqlExpressions.SelectExpression subquery);

abstract member In : Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression * Microsoft.EntityFrameworkCore.Query.SqlExpressions.SelectExpression -> Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression
override this.In : Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression * Microsoft.EntityFrameworkCore.Query.SqlExpressions.SelectExpression -> Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression

abstract member In : Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression * Microsoft.EntityFrameworkCore.Query.SqlExpressions.SelectExpression -> Microsoft.EntityFrameworkCore.Query.SqlExpressions.InExpression
override this.In : Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression * Microsoft.EntityFrameworkCore.Query.SqlExpressions.SelectExpression -> Microsoft.EntityFrameworkCore.Query.SqlExpressions.InExpression

Public Overridable Function In (item As SqlExpression, subquery As SelectExpression) As SqlExpression

Public Overridable Function In (item As SqlExpression, subquery As SelectExpression) As InExpression

Parameters

item: SqlExpression

An item to look into values.

subquery: SelectExpression

A subquery in which item is searched.

Returns

SqlExpression

InExpression

An expression representing an IN operation in a SQL tree.

Implements

In(SqlExpression, SelectExpression)

Applies to

In(SqlExpression, IReadOnlyList<SqlExpression>)

Source:: SqlExpressionFactory.cs

Source:: SqlExpressionFactory.cs

Source:: SqlExpressionFactory.cs

Creates a new InExpression which represents an IN operation in a SQL tree.

public virtual Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression In(Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression item, System.Collections.Generic.IReadOnlyList<Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression> values);

public virtual Microsoft.EntityFrameworkCore.Query.SqlExpressions.InExpression In(Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression item, System.Collections.Generic.IReadOnlyList<Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression> values);

abstract member In : Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression * System.Collections.Generic.IReadOnlyList<Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression> -> Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression
override this.In : Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression * System.Collections.Generic.IReadOnlyList<Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression> -> Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression

abstract member In : Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression * System.Collections.Generic.IReadOnlyList<Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression> -> Microsoft.EntityFrameworkCore.Query.SqlExpressions.InExpression
override this.In : Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression * System.Collections.Generic.IReadOnlyList<Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression> -> Microsoft.EntityFrameworkCore.Query.SqlExpressions.InExpression

Public Overridable Function In (item As SqlExpression, values As IReadOnlyList(Of SqlExpression)) As SqlExpression

Public Overridable Function In (item As SqlExpression, values As IReadOnlyList(Of SqlExpression)) As InExpression

Parameters

item: SqlExpression

An item to look into values.

values: IReadOnlyList<SqlExpression>

A list of values in which item is searched.

Returns

SqlExpression

InExpression

An expression representing an IN operation in a SQL tree.

Implements

In(SqlExpression, IReadOnlyList<SqlExpression>)

Applies to

In(SqlExpression, SelectExpression, Boolean)

Source:: SqlExpressionFactory.cs

Source:: SqlExpressionFactory.cs

Source:: SqlExpressionFactory.cs

Source:: SqlExpressionFactory.cs

Source:: SqlExpressionFactory.cs

Creates a new InExpression which represents an IN operation in a SQL tree.

public virtual Microsoft.EntityFrameworkCore.Query.SqlExpressions.InExpression In(Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression item, Microsoft.EntityFrameworkCore.Query.SqlExpressions.SelectExpression subquery, bool negated);

abstract member In : Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression * Microsoft.EntityFrameworkCore.Query.SqlExpressions.SelectExpression * bool -> Microsoft.EntityFrameworkCore.Query.SqlExpressions.InExpression
override this.In : Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression * Microsoft.EntityFrameworkCore.Query.SqlExpressions.SelectExpression * bool -> Microsoft.EntityFrameworkCore.Query.SqlExpressions.InExpression

Public Overridable Function In (item As SqlExpression, subquery As SelectExpression, negated As Boolean) As InExpression

Parameters

item: SqlExpression

An item to look into values.

subquery: SelectExpression

A subquery in which item is searched.

negated: Boolean

A value indicating if the item should be present in the values or absent.

Returns

InExpression

An expression representing an IN operation in a SQL tree.

Implements

In(SqlExpression, SelectExpression, Boolean)

Applies to

In(SqlExpression, SqlExpression, Boolean)

Source:: SqlExpressionFactory.cs

Source:: SqlExpressionFactory.cs

Source:: SqlExpressionFactory.cs

Source:: SqlExpressionFactory.cs

Source:: SqlExpressionFactory.cs

Creates a new InExpression which represents an IN operation in a SQL tree.

public virtual Microsoft.EntityFrameworkCore.Query.SqlExpressions.InExpression In(Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression item, Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression values, bool negated);

abstract member In : Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression * Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression * bool -> Microsoft.EntityFrameworkCore.Query.SqlExpressions.InExpression
override this.In : Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression * Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression * bool -> Microsoft.EntityFrameworkCore.Query.SqlExpressions.InExpression

Public Overridable Function In (item As SqlExpression, values As SqlExpression, negated As Boolean) As InExpression

Parameters

item: SqlExpression

An item to look into values.

values: SqlExpression

A list of values in which item is searched.

negated: Boolean

A value indicating if the item should be present in the values or absent.

Returns

InExpression

An expression representing an IN operation in a SQL tree.

Implements

In(SqlExpression, SqlExpression, Boolean)

Applies to

In(SqlExpression, SqlParameterExpression)

Source:: SqlExpressionFactory.cs

Source:: SqlExpressionFactory.cs

Source:: SqlExpressionFactory.cs

Creates a new InExpression which represents an IN operation in a SQL tree.

public virtual Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression In(Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression item, Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlParameterExpression valuesParameter);

public virtual Microsoft.EntityFrameworkCore.Query.SqlExpressions.InExpression In(Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression item, Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlParameterExpression valuesParameter);

abstract member In : Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression * Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlParameterExpression -> Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression
override this.In : Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression * Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlParameterExpression -> Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression

abstract member In : Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression * Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlParameterExpression -> Microsoft.EntityFrameworkCore.Query.SqlExpressions.InExpression
override this.In : Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression * Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlParameterExpression -> Microsoft.EntityFrameworkCore.Query.SqlExpressions.InExpression

Public Overridable Function In (item As SqlExpression, valuesParameter As SqlParameterExpression) As SqlExpression

Public Overridable Function In (item As SqlExpression, valuesParameter As SqlParameterExpression) As InExpression

Parameters

item: SqlExpression

An item to look into values.

valuesParameter: SqlParameterExpression

A parameterized list of values in which the item is searched.

Returns

SqlExpression

InExpression

An expression representing an IN operation in a SQL tree.

Implements

In(SqlExpression, SqlParameterExpression)

Applies to

Feedback

Was this page helpful?

Share via

SqlExpressionFactory.In Method

Definition

Overloads

In(SqlExpression, SelectExpression)

Parameters

Returns

Implements

Applies to

In(SqlExpression, IReadOnlyList<SqlExpression>)

Parameters

Returns

Implements

Applies to

In(SqlExpression, SelectExpression, Boolean)

Parameters

Returns

Implements

Applies to

In(SqlExpression, SqlExpression, Boolean)

Parameters

Returns

Implements

Applies to

In(SqlExpression, SqlParameterExpression)

Parameters

Returns

Implements

Applies to

Feedback