[
https://issues.apache.org/jira/browse/IGNITE-4425?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15847276#comment-15847276
]
Sergey Stronchinskiy edited comment on IGNITE-4425 at 2/2/17 4:39 PM:
----------------------------------------------------------------------
Hi,
After investigating the issue I think the best way to implement
"Array.Contains" is directly translating it to "IN (?,?,....?)" cause:
1. It is the most direct and expected mapping
2. Also there are some possible queries that can not be that easily translated
to "JOIN" clause (for example: .Where(entry => keys.Contains(entry.entry.Key)
|| _SomeBooleanCondition_))
So i would like to implement it that way in conjunction with enabling
"Enumerable.Join" with local collections.
was (Author: gurustron):
Hi,
After investigating the issue I think the best way to implement
"Array.Contains" is directly translating it to "IN (?,?,....?)" cause:
1. It is the most direct and expected mapping
2. Also there are some possible queries that can not be that easily translated
to "JOIN" clause (for example: .Where(entry => keys.Contains(entry.entry.Key)
|| _SomeBooleanCondition_))
So my i would like to implement it that way in conjunction with enabling
"Enumerable.Join" with local collections.
> .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)
