Entity Framework Insert multiple foreign keys

Question

Patient.DivHospitalID (FK)
DivHospital.HospitalID (FK)
Hospital.HospitalID (PK)

I need to insert into DivHospital the Hospital and link/insert into Patient the DivHospital.

Patient tp = new Patient();
DivHospital dh = new DivHospital();

dh.HospitalReference.EntityKey =
     new EntityKey("transportPagerEntities.Hospital", "hospitalID", hospital);
         tp.DivHospitalReference.EntityKey = new  
         EntityKey("transportPagerEntities.DivHospital", "divHospitalID", hospitalref);

context.AddToDivHospital(dh);
context.AddToTransportPatient(tp);
context.SaveChanges();

Nix · Accepted Answer · 2010-08-10 13:51:28Z

1

Assuming you aren't dealing with PKs (ints) and since you are using an ORM you shouldn't be.

You don't need to do the EntityKey stuff, just set them directly.

Patient tp = new Patient();
DivHospital dh = new DivHospital();

dh.Hospital = hospital;
tp.DivHospital = hospitalref;

context.AddToDivHospital(dh);
context.AddToTransportPatient(tp);

context.SaveChanges();

answered Aug 10, 2010 at 13:51

Nix

58.8k31 gold badges154 silver badges206 bronze badges

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

1 Comment

tripdubroot Over a year ago

I am dealing with PKs. Patient.DivHospitalID (FK) => DivHospital.DivHospitalID (PK) DivHospital.HospitalID (FK) => Hospital.HospitalID (PK) I need to create the DivHospital "record" and then link that with Patient.

itchi · Accepted Answer · 2010-08-10 17:58:07Z

1

With EntityFramework this is really easy (if I understand your problem):

Patient tp = new Patient();
DivHospital dh = new DivHospital();

dh.Patient.Add(tp);  //magic

context.AddToDivHospital(dh);
context.SaveChanges();

answered Aug 10, 2010 at 17:58

itchi

1,71314 silver badges30 bronze badges

Collectives™ on Stack Overflow

Entity Framework Insert multiple foreign keys

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related