LINQ Update Statement

Phil Critchley · April 30th, 2011, 10:51 AM

Hi Imar

I understand were your coming from using the Enumerable 'Single()' Method but when I try to implement it within my code I get syntax errors

Code:

Using myLiteratureCatalogue As New Model1.Literature_Cataloguing_SystemEntities
            Dim getReservationStatus = (From publication In myLiteratureCatalogue.Publications Where publication.PublicationID = (PublicationID)
                                       Select publication.ReservationID).Single(), publication.StatusID).Single()

            ReservationID = getReservationStatus.ReservationID
            StatusID = getReservationStatus.StatusID


End Using

It doesn't look as thought this is possible within my build?

Imar · April 30th, 2011, 11:15 AM

I am not psychic nor can I use your code as-is in one of my own sites to reproduce the problem, so posting the actual error message you get might help ;-)

Cheers,

Imar

Imar · April 30th, 2011, 01:36 PM

Oh, BTW, check out my first example of Single. Notice how I am wrapping the entire query (starting with From all the way to the end) in parenthe4ses and then call Single() on the *query*, not the individual fieldws.

Cheers,

Imar