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?
Thanks
Start Free Trial