Hi Roman, It is even hard to say what kind of SQL should we produce for such a query.
The general idea of Ignite LINQ provider is: Do not try to support every LINQ expression (which is not possible, because LINQ and SQL are quite different); but try to make most SQL scenarios possible to express in LINQ. So think SQL first. For your case, can you give more details? What is the SQL query you'd like to covert to LINQ? Thanks, Pavel On Thu, Jun 21, 2018 at 6:26 AM, Roman Guseinov <ro...@gromtech.ru> wrote: > Hi Team, > > Is there any plan to support LINQ queries like: > > var result = cache.AsCacheQueryable > .Where(entry => !entry.Value.Dirty.HasValue) > .GroupBy(entry => entry.Value.ContractId) > .Select(group => group.OrderByDescending(entry => > entry.Value.Version).First().Key) > .ToList(); > > It looks like such queries need be transformed to complex SQL like `SELECT > ... FROM (SELECT ... FROM (SELECT ...) JOIN ...)`. And probably that's why > it's not easy to implement such functionality, but users quite often want > to > use that. > > Will it be implemented in the near future? Is there any ticket for that? > > Thanks. > > Best Regards, > Roman > > > > -- > Sent from: http://apache-ignite-developers.2346864.n4.nabble.com/ >
