Advertisement

03.19.2008 at 10:04AM PDT, ID: 23254363
[x]
Attachment Details

Linq Error: ... no supported translation to SQL

Asked by yourcous in Language Integrated Query - LINQ, Visual Studio 2008

Tags: ASP.net, ie

I am new with Linq to Sql.
I don't want to use "for each next",
because I am returning one record.
I tried,
Dim db As New Ticket_JCDataContext
                Dim ThisTicket = (From t In db.tblTickets Where t.ID = ViewState("strTicketID")).First

I got an error:
Method 'System.Object CompareObjectEqual(System.Object, System.Object, Boolean)' has no supported translation to SQL

How can I make it work?

ThanksStart Free Trial
[+][-]03.19.2008 at 12:07PM PDT, ID: 21164724

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zones: Language Integrated Query - LINQ, Visual Studio 2008
Tags: ASP.net, ie
Sign Up Now!
Solution Provided By: yourcous
Participating Experts: 0
Solution Grade: A
 
 
 
Loading Advertisement...
20080716-EE-VQP-32 - Hierarchy / EE_QW_2_20070628