UnitOfWork.CommitChangesAsync(AsyncCommitCallback) Method

Asynchronously commits all the changes made to persistent objects to a data store and notifies upon completion.

Namespace: DevExpress.Xpo

Assembly: DevExpress.Xpo.v23.2.dll

NuGet Packages: DevExpress.Win.PivotGrid, DevExpress.Win.TreeMap, DevExpress.Xpo

NuGet Package: DevExpress.Xpo

Declaration

C#

public object CommitChangesAsync(
    AsyncCommitCallback callback
)

VB.NET

Public Function CommitChangesAsync(
    callback As AsyncCommitCallback
) As Object

Parameters

Name	Type	Description
callback	AsyncCommitCallback	A AsyncCommitCallback delegate to be called after the changes have been saved. Use the callback to store the exception information passed as a parameter, and use this information later, to raise the exception again, within the original thread. Do not raise exceptions or modify persistent objects within a callback.

Returns

Type	Description
Object	An object identifying the current asynchronous operation, intended for internal use.

Remarks

A Unit of Work tracks every change to every persistent object during a transaction that can affect a data store. Its CommitChangesAsync method commits all the changes made to persistent objects to a data store. The only requirement for this is that the property setters call the XPBaseObject.OnChanged method.

Calling the CommitChangesAsync method automatically calls Session.CommitTransactionAsync (in explicit units of work, ExplicitUnitOfWork.CommitTransactionAsync is called).

If a save operation fails (for example, due to a database constraint violation), the following exceptions can be raised by XPO:

• LockingException
• SchemaCorrectionNeededException
• SqlExecutionErrorException
• ConstraintViolationException

Note

In a NestedUnitOfWork, calling the CommitChangesAsync method throws the System.NotSupportedException, since changes within these Units should be saved using only the main thread.

Example

The following example demonstrates how to asynchronously work with persistent objects.

In this example, a collection (xpcPersons) of Person objects is used as a data source for a grid control (gridPersons). The Update and Commit buttons (btnUpdate and btnCommit) allow users to update the grid control and store changes to a data store while continuing to interact with other UI elements. The accessibility of the grid control and these buttons is automatically updated within operation callbacks (CallBackLoadPersons and CallBackCommitChanges).

C#

using DevExpress.Xpo;
using DevExpress.Xpo.DB;

namespace AsyncOperations {

    // A custom XPObject
    class Person : XPObject {
       //...
    }

    public class AsyncLoading {
        UnitOfWork unitOfWork;
        // Initialize unitOfWork here.
        //...

        // An XPCollection to be used as a data source for the gridPersons grid control
        XPCollection xpcPersons;

        //...

        // The Click event handler of the Update button
        private void btnUpdate_Click(object sender, EventArgs e) {
            if (xpcPersons == null) {
                xpcPersons = new XPCollection(unitOfWork, typeof(Person));
                LoadAsyncPersons();
                gridPersons.DataSource = xpcPersons;
            } else {
                LoadAsyncPersons();
            }
        }

        // Disables buttons and the grid control and initiates asynchronous collection loading
        void LoadAsyncPersons() {
            btnUpdate.Enabled = false;
            btnCommit.Enabled = false;
            gridPersons.Enabled = false;
            xpcPersons.LoadAsync(new DevExpress.Xpo.Helpers.AsyncLoadObjectsCallback(
                CallBackLoadPersons));
        }
        // Called after collection loading is complete
        // Re-enables buttons and the grid control
        void CallBackLoadPersons(ICollection[] result, Exception ex) {
            btnUpdate.Enabled = true;
            btnCommit.Enabled = true;
            gridPersons.Enabled = true;
            if (ex != null) {
                MessageBox.Show(ex.Message);
            }
        }

        // The Click event handler of the Commit button
        // Disables buttons and the grid control and asynchronously commits changes
        private void btnCommit_Click(object sender, EventArgs e) {
            btnUpdate.Enabled = false;
            btnCommit.Enabled = false;
            gridPersons.Enabled = false;
            unitOfWork.CommitChangesAsync(new AsyncCommitCallback(CallBackCommitChanges));
        }

        // Called after changes have been saved
        // Re-enables buttons and the grid control
        void CallBackCommitChanges(Exception ex) {
            btnUpdate.Enabled = true;
            btnCommit.Enabled = true;
            gridPersons.Enabled = true;
            if (ex != null) {
                MessageBox.Show(ex.Message);
            }
        }
    }
}

VB.NET

Imports DevExpress.Xpo
Imports DevExpress.Xpo.DB

Namespace AsyncOperations

    ' A custom XPObject
    Friend Class Person
        Inherits XPObject
       '...
    End Class

    Public Class AsyncLoading
        Private unitOfWork As UnitOfWork
        ' Initialize unitOfWork here.
        '...

        ' An XPCollection to be used as a data source for the gridPersons grid control
        Private xpcPersons As XPCollection

        '...

        ' The Click event handler of the Update button
        Private Sub btnUpdate_Click(ByVal sender As Object, ByVal e As EventArgs)
            If xpcPersons Is Nothing Then
                xpcPersons = New XPCollection(unitOfWork, GetType(Person))
                LoadAsyncPersons()
                gridPersons.DataSource = xpcPersons
            Else
                LoadAsyncPersons()
            End If
        End Sub

        ' Disables buttons and the grid control and initiates asynchronous collection loading
        Private Sub LoadAsyncPersons()
            btnUpdate.Enabled = False
            btnCommit.Enabled = False
            gridPersons.Enabled = False
            xpcPersons.LoadAsync(New DevExpress.Xpo.Helpers.AsyncLoadObjectsCallback( _
                                                AddressOf CallBackLoadPersons))
        End Sub
        ' Called after collection loading is complete
        ' Re-enables buttons and the grid control
        Private Sub CallBackLoadPersons(ByVal result() As ICollection, ByVal ex As Exception)
            btnUpdate.Enabled = True
            btnCommit.Enabled = True
            gridPersons.Enabled = True
            If ex IsNot Nothing Then
                MessageBox.Show(ex.Message)
            End If
        End Sub

        ' The Click event handler of the Commit button
        ' Disables buttons and the grid control and asynchronously commits changes
        Private Sub btnCommit_Click(ByVal sender As Object, ByVal e As EventArgs)
            btnUpdate.Enabled = False
            btnCommit.Enabled = False
            gridPersons.Enabled = False
            unitOfWork.CommitChangesAsync(New AsyncCommitCallback(AddressOf CallBackCommitChanges))
        End Sub

        ' Called after changes have been saved
        ' Re-enables buttons and the grid control
        Private Sub CallBackCommitChanges(ByVal ex As Exception)
            btnUpdate.Enabled = True
            btnCommit.Enabled = True
            gridPersons.Enabled = True
            If ex IsNot Nothing Then
                MessageBox.Show(ex.Message)
            End If
        End Sub
    End Class
End Namespace