[
https://issues.apache.org/jira/browse/IGNITE-4425?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15861166#comment-15861166
]
Sergey Stronchinskiy commented on IGNITE-4425:
----------------------------------------------
Known restrictions of current implementation:
1. "IEnumerable.Contains" is not supported for compiled queries.
2. Using methods, returning "IEnumerable" and using "Contains" is not
supported(can be replaced with calling the method first and saving result to
local variable or creating local Func<> variable and assigning method to it)
> .NET: Support "ICollection.Contains" in LINQ
> --------------------------------------------
>
> Key: IGNITE-4425
> URL: https://issues.apache.org/jira/browse/IGNITE-4425
> Project: Ignite
> Issue Type: Improvement
> Components: platforms
> Reporter: Pavel Tupitsyn
> Assignee: Sergey Stronchinskiy
> Labels: .NET, LINQ
> Fix For: 2.0
>
>
> SQL supports IN queries
> https://apacheignite.readme.io/docs/sql-performance-and-debugging#sql-performance-and-usability-considerations
> Example SQL:
> {code}
> new SqlFieldsQuery("select p.name from Person p where id in (?, ?)", 1, 3);
> {code}
> Add support in LINQ like this:
> {code}
> persons.AsCacheQueryable().Where(x => new[] {1,3}.Contains(x.Value.Id))
> {code}
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
