[
https://issues.apache.org/jira/browse/IGNITE-4425?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Pavel Tupitsyn updated IGNITE-4425:
-----------------------------------
Description:
SQL supports IN queries and, as a better alternative, temporary table join, as
described in the docs:
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 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}
was:
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}
> .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
> Labels: .NET, LINQ
> 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/sql-performance-and-debugging#sql-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)
