How to get EntityFramework to add rows in order?

Question

In my SQL Server database, I use the auto-increment field for Id. Whenever I add new rows to this table with the SQL Server entity, I want these identifiers to maintain the order in which these rows were added in the Entity Framework, but for some reason they are random.

Answer 1

Call SaveChanges()after each AddObject. This is the only way to control the order.