Selecting records using Linq2sql into linq2sql classes?

Question

Hi there,

Been succcesfully adding records using Linq2Sql with the linq2sql genereated classes, works great..

But i need to now select the records, i can't seem to figure this out

This is how i am adding records - reservation is a generated linq2sql class

            TestDataContext db = new TestDataContext();

            db.Reservations.InsertOnSubmit(reservation);
            db.SubmitChanges();

So i wanted to pass in a reservation number (which is a field) a retrieve a populated Reservation class

Can anyone help?

Thanks

Answer 1

If you're using a strongly typed datacontext object you should be able to do something like this:

public Reservation GetReservation(int id) {

return db.Reservations.Where(r =>   r.ReservationId == id ).SingleOrDefault(); 

}

Answer 2

You can do something like:

Reservation reservation = 
    db.Reservations.Where(r => r.id == reservationId).Single();

or

// Use this if you're not positive the single record exists
Reservation reservation = 
    db.Reservations.Where(r => r.id == reservationId).SingleOrDefault();

You can now work with reservation and then db.SumbitChanges() will save any modifications to the object back to the database.