Re-ordering in breezejs SaveChanges

Question

I have object "Stage Details", when I create new Entity this object, Then breeze automatically create primary key like as -1,-2,-3,-4 etc. And when this object is saved then I saw that the first object saved is last, That is the record -4 which was last record into my object list. I need sequentially save in breezejs.

I want to manage order on the server side. i am using EFContextProvider, i want to mange order before save changes. my code is

public SaveResult Save(JObject saveBundle)
{           
    //i want to manage order in this position
    return _contextProvider.SaveChanges(saveBundle);
}

Is it possible? Thanks.

I have posted an answer about how to control the order of entity creation from the client side. If you are hoping to control the order on the server side somehow, then can you provide some more information? For example, what server-side context provider are you using? What data or knowledge would the server have available to it to control the order in which entities are saved? — chrisg
@chrisg, I want to manage order on the server side. i am using EFContextProvider, i want to mange order before save changes. my code is public SaveResult Save(JObject saveBundle) { //i want to manage order in this position return _contextProvider.SaveChanges(saveBundle); } — Shohel
I don't know any way to do that, although maybe somebody will come up with an idea. As far as I know the server treats the entities to be saved as an unordered set and entities will be created in an unspecified order. I'm not sure knowing this will help provide an answer, how would you like your server-side code determine which order the entities should be created in? — chrisg
Thanks brother @chrisg, i am getting a sequence like order[0].id = -1,order[0].id = -2,order[0].id = -3,order[0].id = -4, breeze saved at first order[0].id = -4, then order[0].id = -3. but i need the -1,-2,-3,-4 sequence — Shohel

chrisg chrisg · Accepted Answer · 2014-07-22T11:32:56

In a scenario where you must create records in the database in a particular order that only the client knows about, you can call EntityManager.saveChanges multiple times to save the entities in the order that your application requires. The following code illustrates an approach to force Breeze to save a set of entities in the backend database in the same order as they appear in an array of entities:

var entityManager = /* your Breeze entity manager */;
var arrayOfEntities = [/* array of entities that have been added to entityManager, in order they must be created */];

var saveEntities = function(i) {
    if (arrayOfEntities.length > i) {
        var e = arrayOfEntities[i];
        entityManager.saveChanges([e]).then(function() { saveEntities(i + 1); });
        // Error handling upon failure left as an exercise
    }
};

saveEntities(0);

This will obviously cause multiple HTTP operations to be performed, but since I assume it is the client code which is where the knowledge about the ordering exists, I think that will be inevitable. A better approach may be to consider whether you really need to save/create entities in a particular order: it sounds a little unusual to have a situation where the order of creation of otherwise unrelated entities of the same type really matters.

Re-ordering in breezejs SaveChanges

3 Answers