UnitOfWork : order of action

Posts   
 
    
Fabrice
User
Posts: 180
Joined: 25-May-2004
# Posted on: 31-Aug-2006 13:51:18   

Hi

I would like to know if it's possible to change the order of action when we do a Commit on a UnitOfWork ? Right if I've correctly understand its "insert-update-delete"

But I've a problem right now with unique constraint : - I delete a row with value "A" in a field with unique index - I add a row with value "A" in a the same field

With a "insert-delete" order, I've a sql exception due to the unique index.Is it possible to change somewhere to have a "delete-insert" order ? If not, maybe it's a good suggestion for the next versions ?

Thank you

Walaa avatar
Walaa
Support Team
Posts: 14995
Joined: 21-Aug-2005
# Posted on: 31-Aug-2006 15:12:13   

In this case you might use 2 UOW collections. One for the delete and another for the inserts

Fabrice
User
Posts: 180
Joined: 25-May-2004
# Posted on: 04-Sep-2006 10:58:30   

Ok I'll do like that, thanks for your help