Add Entities using EF

Question

It would be great if someone can point me in the right direction on this topic

I have the following admx: http://img339.imageshack.us/img339/7817/entitydesignerdiagram2.png

And I have to add the (AccData, CntactData, PhnNumber, FnclDetail)entities to the database in one shot What’s the best practices to do the add operation for the above entities??

Answer 1

If you have Navigation properties created over foreign keys in your database then there should be no problems in assignment. Set the detail entities to the navigation properties of their masters, like this pseudo code:
//Create an accData instance in some way
accData.PhnNumbers.Add(phnNumber);
accData.CntactData.Add(cntData);
//Load the FnclMaster in some way, for example,
FnclMaster master = db.FnclMasters.Where(it=>it.FnclprdIdCode == myCode && it.AccNo == myAccNo);
master.FnclDetails.Add(fnclDetail);
context.AddToAccDatas(accData);
context.SaveChanges();