Question about foreign-key relationship in Linq to Sql

Question

Hi

I have lots of tables and some of them have many relationships with other tables. I noticed the tables that have one relationship I am able to do what it is shown in NerdDinner Chapter 1.

Dinner dinner = db.Dinners.Single(d => d.DinnerID == 1);
RSVP myRSVP = new RSVP();
myRSVP.AttendeeName = "ScottGu";

dinner.RSVPs.Add(myRSVP);

So when I try something similar .add never shows up for me unless it has like one relationship.

So how do I make it work for multiple ones?

I am still not clear what this gets me anyways. Like does it save in typing? or what?

Answer 1

You need one add for each table in the relationship.

The Add method stages an object into the Linq to SQL data context, so that it can be added to its corresponding database table. The SubmitChanges method saves any pending changes to the database. So you can do all of your adds, and then commit them at once.