Where to put savechanges in unit of work pattern with asp.net mvc?

Question

I am using a generic repository pattern in asp.net mvc. I am familiar with repository pattern but not with Unit of work. I am reading several articles from google about this. But I am not sure if I use unit of work with asp.net mvc, where would I use Commit() method that will call the ef SaveChanges() method? Will I use it on repository layer or service layer or in Controller. Also, many others are saying that, Microsoft is already using Unit Of work built in with Entity Framework. So no need to use it separately or use it controller level or anywhere?

Thanks, Abdus Salam Azad.

I am voting to close this as there are already dozens of SO threads on that with different opinions. — Wiktor Zychla
– Wiktor Zychla, Commented Oct 15, 2016 at 13:16

Sampath · Accepted Answer · 2016-10-15 13:33:43Z

1

Yes,you have to do it inside the UnitOfWork.cs class.

UnitOfWork.cs

 public sealed class UnitOfWork : IUnitOfWork
   {

       private DbContext _dbContext;

       public UnitOfWork(DbContext context)
       {         
          _dbContext = context;
       }

       public int Commit()
       {
           return _dbContext.SaveChanges();// Save changes 
       }

       public void Dispose()
       {
           Dispose(true);
           GC.SuppressFinalize(this);
       }

      private void Dispose(bool disposing)
       {
           if (disposing)
           {
               if (_dbContext != null)
               {
                   _dbContext.Dispose();
                   _dbContext = null;
               }
           }
       }
   }

After that you can call UnitOfWork's Commit method inside the Service Layer.

EntityService.cs

public abstract class EntityService<T> : IEntityService<T> where T : BaseEntity
   {
       IUnitOfWork _unitOfWork;
       IGenericRepository<T> _repository;

       public EntityService(IUnitOfWork unitOfWork, IGenericRepository<T> repository)
       {
           _unitOfWork = unitOfWork;
           _repository = repository;
       }  

     public virtual void Create(T entity)
           {
               _repository.Add(entity);
               _unitOfWork.Commit(); //saving point        
           }

}

You can learn more about this pattern : Generic Repository and Unit of Work Pattern

edited Oct 15, 2016 at 13:33

answered Oct 15, 2016 at 13:21

Sampath

66.2k70 gold badges329 silver badges462 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Ionut Enache Over a year ago

What if you want to make multiple changes and save all the modifications at the end? How would you handle that? I'm in this situation and I cannot find a proper way to do the save method

Sampath Over a year ago

@IonutEnache You need to use Transactions then: learn.microsoft.com/en-us/ef/core/saving/transactions

user10351929 · Accepted Answer · 2018-09-13 06:31:20Z

0

If you have multiple operation on a same transaction. Then after finishing all your operation, you will need to put your savechanges() finally. If it succeeded, all operation will be succeeded and if failed, all operations will be failed and reverted.

            _employeeService.UpdateVehicleDetail(model);
            _employeeService.UpdateLicenseDetail(model);
            await CurrentUnitOfWork.SaveChangesAsync();

answered Sep 13, 2018 at 6:31

user10351929

Collectives™ on Stack Overflow

Where to put savechanges in unit of work pattern with asp.net mvc?

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related