How do I order entities to w/c should be saved first to the database?

Example I have a table named tblOrders that has a primary key of Order ID.

When I add 3 orders it will looks like this:

 Order ID   Column A   Column B

- 100           Hello     Hello Again

- 101           Hi     Hi Again

- 102         H     H Again

When I call the save method of the entity manager, what will happen is that the orders will be saved in reverse order.

Why is that so? and how do we save it in the order we want? In this case, we want it to be saved in the order we see it right now..

Thanks,

Von 

 

Unfortunatelly there is no way to control the order of the entities being saved within one SaveChanges/SaveChangesAsync call.

 

What I'd suggest is to call SaveChanges for each of the entities in the desired order.

 

Regards,

   Silvio.

Hmmm.. I think that's not convenient in our part because if i have 1000 items, I'll save them one by one?

What we want to accomplish is simple, to save it in order we create it and not in reverse order.

Can you give us a workaround for this?

Thanks,

Von

 

Unfortunatelly, this is how EF handles the saves and there isn't really any other way to handle this issue.

 

You could create some sort of automated partial SaveChanges:

 

foreach (var entity in listOfEntitiesToBeSaved) {

   mgr.SaveChanges(entity):

}

 

bear in mind that listOfEntitiesToBeSaved must be properly ordered and you will need to properly handle any other entities related to the ones being saved that might not be in that list.

 

Regards,

   Silvio.

I'm trying to do your work around but it seems that there's no overload for SaveChanges() that accepts a single entity but rather an IEnumerable of entities.

Thanks,

Von

 

try an IEnumerable of entities:

 

mgr.SaveChanges(new Entity[] {entity});

 

Silvio.