ADO.NET Entity Data Model - order of executing query

Question

When I run this code:

        korlenEntities2 _db = new korlenEntities2();
        for (int i = 0; i < 10; i++)
        {
            klienci klient = new klienci();
            klient.nazwa = "Janek_" + i.ToString();
            klient.miejscowosc = "-";
            _db.AddToklienci(klient);

        };
        _db.SaveChanges();

records are added to database in random order, so my field ID is not filled correctly. this is important to me since I want to use it for later ordering

Answer 1

You cannot control the order of query execution unless you call SaveChanges after every query. Nor can you depend on auto-incremented keys to be sequential in all cases (consider replication). If order is important, you should add a field for that.