You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@ignite.apache.org by "Pavel Tupitsyn (JIRA)" <ji...@apache.org> on 2016/12/14 08:12:58 UTC

[jira] [Created] (IGNITE-4425) .NET: Support "Array.Contains" in LINQ

Pavel Tupitsyn created IGNITE-4425:
--------------------------------------

             Summary: .NET: Support "Array.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
             Fix For: 2.0


SQL supports IN queries and, as a better alternative, temporary table join, as described in the docs:
https://apacheignite.readme.io/docs/performance-and-debugging#performance-and-usability-considerations

Example SQL:
{code}
new SqlFieldsQuery("select p.name from Person p join table(id bigint = ?) i on p.OrgId = i.id", new object[] { new object[] {1,3}})
{code}

Add support in LINQ like this:

{code}
persons.AsCacheQueryable().Where(x => new[] {1,3}.Contains(x.Value.OrgId))
{code}




--
This message was sent by Atlassian JIRA
(v6.3.4#6332)