{"The EDM function 'Edm.Reverse' is not supported."} error
{"The EDM function 'Edm.Reverse' is not supported."} error
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
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
Same problem using Telerik MVC Grid and latest dotconnect
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
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
Sample project
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
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
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.
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.
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 .
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 .