SqlExpressionFactory.In Method
Definition
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)
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);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.InExpressionPublic Overridable Function In (item As SqlExpression, subquery As SelectExpression) As InExpressionParameters
- item
- SqlExpression
An item to look into values.
- subquery
- SelectExpression
A subquery in which item is searched.
Returns
An expression representing an IN operation in a SQL tree.
Implements
Applies to
In(SqlExpression, SqlParameterExpression)
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);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.InExpressionPublic Overridable Function In (item As SqlExpression, valuesParameter As SqlParameterExpression) As InExpressionParameters
- item
- SqlExpression
An item to look into values.
- valuesParameter
- SqlParameterExpression
A parameterized list of values in which the item is searched.
Returns
An expression representing an IN operation in a SQL tree.
Implements
Applies to
In(SqlExpression, IReadOnlyList<SqlExpression>)
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);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.InExpressionPublic Overridable Function In (item As SqlExpression, values As IReadOnlyList(Of SqlExpression)) As InExpressionParameters
- item
- SqlExpression
An item to look into values.
- values
- IReadOnlyList<SqlExpression>
A list of values in which item is searched.
Returns
An expression representing an IN operation in a SQL tree.
Implements
Applies to
In(SqlExpression, SelectExpression, Boolean)
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.InExpressionPublic Overridable Function In (item As SqlExpression, subquery As SelectExpression, negated As Boolean) As InExpressionParameters
- 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
An expression representing an IN operation in a SQL tree.
Implements
Applies to
In(SqlExpression, SqlExpression, Boolean)
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.InExpressionPublic Overridable Function In (item As SqlExpression, values As SqlExpression, negated As Boolean) As InExpressionParameters
- 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
An expression representing an IN operation in a SQL tree.
Implements
Applies to
Entity Framework
Feedback
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see: https://aka.ms/ContentUserFeedback.
Submit and view feedback for