How to write the given query in pattern repository

Question

User1661386615 posted

this is code of with out pattern repository

 var expenseOrderDetails = db.ExpenseOrderDetails.Include(e => e.ExpenseOrder).Include(e => e.ExpenseType).Include(e => e.Vendor);
            return View(await expenseOrderDetails.ToListAsync());

this is the code of with Unit of work but it give error i dnt know why kindly suggest me the correct way to write a query for it in Pattern Respository

 var expenseOrderDetails=_unitOfWork.ExpenseOrderDetails.Include(e => e.ExpenseOrder).Include(e => e.ExpenseType).Include(e => e.Vendor);
 return View(await _unitOfWork.ExpenseOrderDetails.GetAllAsync());

Answer 1

User-939850651 posted

Hi Syed Ammar Bukhari,

Based on your description, could you describe the general content of db and _unitOfWork? This will help us to reproduce the problem you encountered.

And the repository and unit of work patterns are intended to create an abstraction layer between the data access layer and the business logic layer of an application, So I think the unit of work is not equal to DbContext.

You could also refer to the following two links for more detailed information:

Implementing the Repository and Unit of Work Patterns in an ASP.NET MVC Application

Repository Pattern C#

Best regards,

Xudong Peng