Using separate user connection with UnitofWork

Unit of Work is a great capability in Microsoft Dynamics AX 2012 to reduce chattiness between AOS and SQL server. A high level overview of UoW is available in this informative blog post:

One of the cool things about unit of work (UoW) is the capability to use a custom user connection. If you would like a set of DML operations to be executed on a separate user connection then that is possible with UoW. If you have legacy code that uses RecordInsertList and want to use a custom user connection then you should rewrite the code using UoW.

Here is an example of how to use UoW with a custom user connection:

static void UoWTest(Args _args)
    Table1 table1;
    // Define a new user connection
    UserConnection uc= new UserConnection();
    // Define a new UoW
    unitOfWork uofw = new UnitofWork();        
    // Add a table buffer to insert on save changes in the UoW
    table1.Field1 = 'foo';
    // Perform additional interactions that you 
    // want to club together with the UoW
    // by calling insertonSaveChanges, updateonSaveChanges
    // and deleteonSaveChanges 

    // Finally pass the user connection to
    //the UoW to use on SaveChanges

Skip to main content