ignite-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Pavel Tupitsyn (JIRA)" <j...@apache.org>
Subject [jira] [Created] (IGNITE-4636) .NET: Support local collection joins in LINQ
Date Wed, 01 Feb 2017 10:11:52 GMT
Pavel Tupitsyn created IGNITE-4636:

             Summary: .NET: Support local collection joins in LINQ
                 Key: IGNITE-4636
                 URL: https://issues.apache.org/jira/browse/IGNITE-4636
             Project: Ignite
          Issue Type: Improvement
          Components: platforms
    Affects Versions: 1.8
            Reporter: Pavel Tupitsyn
             Fix For: 2.0

LINQ {{IN}} clause is implemented in IGNITE-4425 and maps from {{ICollection.Contains}}.

However, {{IN}} has some limitations in Ignite, and better alternative is temporary table

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

Add support in LINQ like this:

{code}persons.AsCacheQueryable().Join(new[] {1, 3}, p => p.Value.OrgId, x => x, (p,
x) => p);{code}

This message was sent by Atlassian JIRA

View raw message