Entity Framework: auto-generate primary keys after initializing tables

Asked Dec 11 '14 at 23:22

Active Dec 11 '14 at 23:22

Viewed 96 times

I'm using Entity Framework (6) in a code-first arrangement to create a database and pre-populate it from a set of CSV files. Because the tables are coming from another application, they already have primary keys, and relationships embedded in the data make reference to those keys.

For that reason I've been using [DatabaseGenerated(DatabaseGeneratedOption.None)] when defining these tables, so that the PKs already in place get used.

However, after the data have been imported, I want to be able to add new records to the tables. How do I get the DB to assign new sequential PKs for the new records?

asked Dec 11 '14 at 23:22

Brandon Kuczenski

Switching identity on and off in Entity Framework is not straightforward http://stackoverflow.com/a/18917348/150342 – Colin Dec 12 '14 at 09:09
1

But it can be done: http://romiller.com/2013/04/30/ef6-switching-identity-onoff-with-a-custom-migration-operation/ – Colin Dec 12 '14 at 09:10
This seems relevant: http://stackoverflow.com/questions/25317799 – Brandon Kuczenski Dec 12 '14 at 17:59
It does not seem practical. I have abandoned this effort. – Brandon Kuczenski Dec 17 '14 at 01:16
Another approach is make it an identity field from the start and set `IDENTITY INSERT OFF` during the initial import – Colin Dec 17 '14 at 09:22

Entity Framework: auto-generate primary keys after initializing tables

0 Answers0