Share via

ISqlExpressionFactory.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

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:
ISqlExpressionFactory.cs
Source:
ISqlExpressionFactory.cs

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

public Microsoft.EntityFrameworkCore.Query.SqlExpressions.InExpression In (Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression item, Microsoft.EntityFrameworkCore.Query.SqlExpressions.SelectExpression subquery);
public 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
abstract member In : Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression * Microsoft.EntityFrameworkCore.Query.SqlExpressions.SelectExpression -> Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression
Public Function In (item As SqlExpression, subquery As SelectExpression) As InExpression
Public 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.

Applies to

In(SqlExpression, SqlParameterExpression)

Source:
ISqlExpressionFactory.cs
Source:
ISqlExpressionFactory.cs

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

public Microsoft.EntityFrameworkCore.Query.SqlExpressions.InExpression In (Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression item, Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlParameterExpression valuesParameter);
public 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
abstract member In : Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression * Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlParameterExpression -> Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression
Public Function In (item As SqlExpression, valuesParameter As SqlParameterExpression) As InExpression
Public 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.

Applies to

In(SqlExpression, IReadOnlyList<SqlExpression>)

Source:
ISqlExpressionFactory.cs
Source:
ISqlExpressionFactory.cs

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

public Microsoft.EntityFrameworkCore.Query.SqlExpressions.InExpression In (Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression item, System.Collections.Generic.IReadOnlyList<Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression> values);
public 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
abstract member In : Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression * System.Collections.Generic.IReadOnlyList<Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression> -> Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression
Public Function In (item As SqlExpression, values As IReadOnlyList(Of SqlExpression)) As InExpression
Public 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.

Applies to

In(SqlExpression, SelectExpression, Boolean)

Source:
ISqlExpressionFactory.cs

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

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

Applies to

In(SqlExpression, SqlExpression, Boolean)

Source:
ISqlExpressionFactory.cs

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

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

Applies to