'CompareObjectEqual' has no supported translation to SQL

[pm620wh]

Hi

Environment:
I am developing on Windows XP using mySQL 5.0.45
I'm using the Entity Developer 1.0.53 in conjunction with VS2008 (with VB)

I have a standard LINQ query used against different tables in my application which work fine. When I try to use essentially the same query against one particular table, it results in the following error:

method 'CompareObjectEqual' has no supported translation to SQL

The LINQ query is

Dim certD = From cde In dataContext.certdetails _
Where cde.URN = lngcertdetailURN

I have no idea why this would fail here, and not elsewhere in my code when referencing other tables.

Any help would be greatly appreciated.

[pm620wh]

Hi

Further troubleshooting (and a good nights sleep) revealed that my variable 'lngcertdetailURN' had not been typed i.e.

Dim lngcertdetailURN As Long

The 'As Long' was missing

Caused a lot of upset.

Thanks for any time you may have spent looking at this one.

[AndreyR]

Could you please post here the table's definition script?
Or send it to me (andreyr * devart * com or support * devart * com with subject similar to your post subject).