SqlExpressionFactory.In Method

Reference

Definition

Namespace:: Microsoft.EntityFrameworkCore.Query

Assembly:: Microsoft.EntityFrameworkCore.Relational.dll

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

In(SqlExpression, SelectExpression)	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, 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, SelectExpression)

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);

public virtual Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression 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.InExpression
override this.In : Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression * Microsoft.EntityFrameworkCore.Query.SqlExpressions.SelectExpression -> Microsoft.EntityFrameworkCore.Query.SqlExpressions.InExpression

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

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

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

Parameters

item: SqlExpression

An item to look into values.

subquery: SelectExpression

A subquery in which item is searched.

Returns

InExpression

SqlExpression

An expression representing an IN operation in a SQL tree.

Implements

In(SqlExpression, SelectExpression)

Applies to

In(SqlExpression, SqlParameterExpression)

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.SqlParameterExpression valuesParameter);

public virtual Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression 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.InExpression
override this.In : Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression * Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlParameterExpression -> Microsoft.EntityFrameworkCore.Query.SqlExpressions.InExpression

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

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

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

Parameters

item: SqlExpression

An item to look into values.

valuesParameter: SqlParameterExpression

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

Returns

InExpression

SqlExpression

An expression representing an IN operation in a SQL tree.

Implements

In(SqlExpression, SqlParameterExpression)

Applies to

In(SqlExpression, IReadOnlyList<SqlExpression>)

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, System.Collections.Generic.IReadOnlyList<Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression> values);

public virtual Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression 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.InExpression
override this.In : Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression * System.Collections.Generic.IReadOnlyList<Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression> -> Microsoft.EntityFrameworkCore.Query.SqlExpressions.InExpression

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

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

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

Parameters

item: SqlExpression

An item to look into values.

values: IReadOnlyList<SqlExpression>

A list of values in which item is searched.

Returns

InExpression

SqlExpression

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

Share via

SqlExpressionFactory.In Method

Definition

Overloads

In(SqlExpression, SelectExpression)

Parameters

Returns

Implements

Applies to

In(SqlExpression, SqlParameterExpression)

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

Additional resources