Devart Forums

Posted: **Thu 26 May 2011 12:12**

I'm have simple query:

using(var entities = new DataEntities())
{
    var test = entities.TestItems.Where(o=>o.Name.EndsWith("v")).ToList();
}

After runnings this code I catch this exception:
System.Data.EntityCommandCompilationException: An error occurred while preparing the command definition. See the inner exception for details.

System.NotSupportedException: The EDM function 'Edm.Reverse' is not supported.
at Devart.Common.Entity.ay.e(b7 A_0)
at Devart.Common.Entity.bd.a(b7 A_0)
at Devart.Common.Entity.b7.Accept[TResultType](EV`1 visitor)
at Devart.Common.Entity.bd.a(br A_0, br A_1, ck A_2)
at Devart.Common.Entity.bd.a(b7 A_0, br A_1, ck A_2)
at Devart.Common.Entity.bd.a(cl A_0)
at Devart.Common.Entity.cl.Accept[TResultType](EV`1 visitor)
at Devart.Common.Entity.bd.a(aq A_0, br A_1, Boolean A_2)
at Devart.Common.Entity.bd.a(bh A_0)
at Devart.Common.Entity.bh.Accept[TResultType](EV`1 visitor)
at Devart.Common.Entity.bd.a(br A_0, String A_1, TypeUsage A_2, q& A_3)
at Devart.Common.Entity.bd.a(ci A_0)
at Devart.Common.Entity.ci.Accept[TResultType](E...).
.....................

Methods "Contains" and "StartsWith" is work perfectly.

dotConnect for PostgreSql 5.30.160.

Posted: **Fri 27 May 2011 08:52**

We will investigate the issue and notify you about the results as soon as possible.

Posted: **Tue 31 May 2011 09:19**

Thank you for the assistance, the error is fixed.
The build containing the fix will be available in a week or so.

Posted: **Tue 31 May 2011 10:14**

Thank you. We will wait.

Posted: **Wed 01 Jun 2011 17:02**

We have released the new 5.30.165 build of dotConnect for PostgreSQL. This build can be dowloaded from here (the trial version) or from Registered Users' Area (for users with active subscription only).
For the detailed information about the improvements and fixes available in dotConnect for PostgreSQL 5.30.165, please refer to this announcement.

Devart Forums

EntityFramework query with string.EndsWith throw exception

EntityFramework query with string.EndsWith throw exception