Selecting records using Linq2sql into linq2sql classes?

Question

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

Robban · Accepted Answer · 2009-09-02 13:55:05Z

2

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(); 

}

answered Sep 2, 2009 at 13:55

Robban

6,8372 gold badges42 silver badges49 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

mark smith Over a year ago

Thanks! yes that worked but my reservation class has linked object i.e. I have a class called "Calls" and a Class called "Dropped" - both are actualy separate tables, I see properties of Count which is 1 on Calls and 3 on Dropped.. Do i need to explicitly create a calls object or something to view the details? Thanks again

mark smith Over a year ago

Actuall i saw there is a property called entities and under that is items but its "NOT" public..

Robban Over a year ago

No, as a matter of fact your Reservation object should have a propertie named Calls which is actually a list of all Calls linked to this Reservation. To get the Calls you could simply loop through each Call like this: foreach(Call call in Reservation.Calls) { //Do something with the call }

Justin Niessner · Accepted Answer · 2009-09-02 13:58:50Z

0

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.

answered Sep 2, 2009 at 13:58

Justin Niessner

246k40 gold badges416 silver badges546 bronze badges

Collectives™ on Stack Overflow

Selecting records using Linq2sql into linq2sql classes?

2 Answers 2

3 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related