{"The EDM function 'Edm.Reverse' is not supported."} error

{"The EDM function 'Edm.Reverse' is not supported."} error

Postby asowmyan » Fri 02 Dec 2011 18:01

Hi

I am using the 5.30.196.0 version of dotConnect and I am getting the following error when using the EndsWith method

{"The EDM function 'Edm.Reverse' is not supported."}

Can you please help!

Thanks
Anandhi
asowmyan
 
Posts: 2
Joined: Wed 24 Aug 2011 13:47

Postby Shalex » Tue 06 Dec 2011 09:01

Please upgrade to the latest (5.50.250) version of dotConnect for PostgreSQL and notify us about the results.
Shalex
Devart Team
 
Posts: 7660
Joined: Thu 14 Aug 2008 12:44

Same problem using Telerik MVC Grid and latest dotconnect

Postby danielst » Fri 03 Feb 2012 20:06

Hi,

I'm experiencing the same problem using Telerik MVC Grid and dotconnect 5.70.293.0.
When I filter using Contains or StartsWith, it works fine, but EndsWith not.
The error occurs when calling:

source.Provider.Execute(
Expression.Call(
typeof(Queryable), "Count",
new Type[] { source.ElementType }, source.Expression));

source.Expression contains the following Debug View:

.Call System.Linq.Queryable.Where(
.Call System.Linq.Queryable.Select(
.Call

{
.Call (.Call ($item.cliIE).ToLower()).EndsWith(.Call "9".ToLower()) == True
}

Could you verify for me?

Thanks
danielst
 
Posts: 2
Joined: Fri 03 Feb 2012 19:20

Postby Shalex » Tue 07 Feb 2012 16:54

We cannot reproduce the problem in our environment (with both EF v 4.x and EF v1). Could you please localize the issue and
send us a small test project (without using Telerik components if possible)?
Shalex
Devart Team
 
Posts: 7660
Joined: Thu 14 Aug 2008 12:44

Sample project

Postby danielst » Wed 08 Feb 2012 13:49

Hi,

This error occurs using Where this way:

context.Product.Where(p => p.Description.ToLower().EndsWith(txtSearch.Text.ToLower())).ToList();

If I replace EndsWith with Contains or StartsWith, it runs correctly.

I'll send a sample project soon.

Thanks
danielst
 
Posts: 2
Joined: Fri 03 Feb 2012 19:20

Postby Shalex » Mon 13 Feb 2012 08:45

We have reproduced the issue. We will post here when it is fixed.
Shalex
Devart Team
 
Posts: 7660
Joined: Thu 14 Aug 2008 12:44

Postby Shalex » Thu 16 Feb 2012 15:21

The Edm.Reverse canonical function is supported for PostgreSQL servers of 9.1 and higher versions.
The conversion of .StartsWith, .Contains, .EndsWith to LIKE clause in the generated SQL for the case of expression-based condition is supported.
We will post here when the corresponding build of dotConnect for PostgreSQL is available for download.
Shalex
Devart Team
 
Posts: 7660
Joined: Thu 14 Aug 2008 12:44

Postby Shalex » Mon 27 Feb 2012 14:43

New build of dotConnect for PostgreSQL 5.70.311 is available for download now!
It can be downloaded from http://www.devart.com/dotconnect/postgr ... nload.html (trial version) or from Registered Users' Area (for users with active subscription only).
For more information, please refer to http://www.devart.com/forums/viewtopic.php?t=23471 .
Shalex
Devart Team
 
Posts: 7660
Joined: Thu 14 Aug 2008 12:44


Return to dotConnect for PostgreSQL