entity framework inserting multiple objects

Question

I am trying to insert multiple objects into my db.

foreach (employee employeedata in employeelist) { objectcontext.employees.AddObject(employeedata); } objectcontext.SaveChanges();

I call objectcontext.savechanges outside the loop so that it is efficient. The problem is that I would like to get a list of primary keys that are generated by the db.

If I am inserting a single object using objectcontext.employees.AddObject(employeeA) I could get the id after saving changes as employeeA.id. I am not sure of how to go about this now that I am adding a list of objects to the object context and then calling savechanges that inserts these into the db. Am I missing something obvious here? Thanks,

Ladislav Mrnka · Accepted Answer · 2011-01-13 17:40:21Z

6

Just iterate through your list again and check Ids. If you are using autogenerated column in DB, Ids will be filled.

answered Jan 13, 2011 at 17:40

Ladislav Mrnka

365k60 gold badges666 silver badges673 bronze badges

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

Comments

Singleton · Accepted Answer · 2011-01-13 18:14:30Z

1

do some thing like this

foreach (employee employeedata in employeelist)
{
 employeeA.id // Will give you id
}

answered Jan 13, 2011 at 18:14

Singleton

3,6443 gold badges27 silver badges37 bronze badges

Collectives™ on Stack Overflow

entity framework inserting multiple objects

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related