Devart Forums

Posted: **Fri 22 May 2009 00:45**

This generates invalid SQL:

dataContext.Table
     .GroupBy(x => x.StringValue.Substring(0, 1))
     .Select(x => new { StringText= x.Key, 
                                 Count = x.Count(y => y.SomeFlag == true) });

Posted: **Fri 22 May 2009 08:17**

Thank you for the report. We have reproduced this problem too.
I will let you know when it's resolved.

Posted: **Tue 16 Jun 2009 14:21**

This problem is also fixed, look forward to the upcoming build of dotConnect for PostgreSQL.

Devart Forums

GroupBy SubString doesn't work

GroupBy SubString doesn't work