NServiceBus - Use different database catalog on same database server instance with connection sharing

UpdateDataInDifferentCatalogHandler.cs

using System.Data.Entity;
using System.Threading.Tasks;
using NServiceBus;

public class UpdateDataInDifferentCatalogHandler
    : IHandleMessages<CompleteOrder>
{
    public async Task Handle(MyMessage message, IMessageHandlerContext context)
    {
        var sharedSession = context.SynchronizedStorageSession.SqlPersistenceSession();
        var connection = sharedSession.Connection;
        var dbName = connection.Database; // Store current catalog
        connection.ChangeDatabase("Sales");

        try
        {
            using (var dbContext = new MyDbContext(connection))
            {
                dbContext.Database.UseTransaction(sharedSession.Transaction);
                
                // Do your usual operations on your DbContext

                await dataContext.SaveChangesAsync()
                    .ConfigureAwait(false);
            }
        }
        finally
        {
            sharedSession.ChangeDatabase(dbName); // Revert to previous catalog
        }
    }
}