Insert Order

[rubenalves]

I have noticed that when i add several items to a DbSet, example,

db.Products.Add(new Product{ID = 1, Name = "Product 1"});
db.Products.Add(new Product{ID = 2, Name = "Product 2"});
db.Products.Add(new Product{ID = 3, Name = "Product 3"});

When db.SaveChages() is called the data is inserted in the database but the order is random, not the order that the products where inserted in the collection.

Is it possible to make the ID column not identity and specify the ID manually as in my example?

[rowanmiller]

Hey Ruben,

Yes you can override the 'integer primary keys are identity' convention by configuring the entity:

modelBuilder.Entity<Product>()
    .Property(p => p.ID)
    .GenerateValuesOnAdd(false);

You'll also be able to use the [DatabaseGenerated] attribute once Data Annotation support is enabled in EF7.

We do also have #703 tracking the ability to explicitly insert values into a column that is configured as identity (for a set of well-known seed data etc.).