TransactionalHandler.cs

    /// <summary>
    /// Decorator that applies save changes after a command is successfully run
    /// </summary>
    /// <typeparam name="TRequest"></typeparam>
    /// <typeparam name="TResponse"></typeparam>
    public class TransactionalHandler<TRequest, TResponse>
    : IRequestHandler<TRequest, TResponse>
    where TRequest : IRequest<TResponse>
    {
        private readonly IAfaemsDbContext _context;
        private readonly IRequestHandler<TRequest, TResponse> _inner;

        public TransactionalHandler(IAfaemsDbContext context, IRequestHandler<TRequest, TResponse> inner)
        {
            _context = context;
            _inner = inner;
        }

        TResponse IRequestHandler<TRequest, TResponse>.Handle(TRequest message)
        {
            using (var transaction = _context.Database.BeginTransaction(IsolationLevel.ReadCommitted))
            {
                try
                {
                    var result = _inner.Handle(message);

                    _context.SaveChanges();
                    transaction.Commit();

                    return result;
                }
                catch (Exception)
                {
                    transaction.Rollback();
                    throw;
                }

                
            }
        }

    }