forum

Home / DeveloperSection / Forums / How to use generic repository pattern in mvc code first.

Ask Question

How to use generic repository pattern in mvc code first.

Anonymous User 1756 26-Oct-2015
Can anyone please help me how to solve this problem.
.net mvc  entity framework 
Updated on 26-Oct-2015
Anonymous User

Anonymous User

Follow
I am a content writter !

Can you answer this question?

Answer

1 Answers

Anonymous User

Anonymous User

26-Oct-2015 
answer 415872610105558



We have first created core class library project and I mentioned database model structure in master.cs.



using System;

using System.Collections.Generic;

using System.ComponentModel.DataAnnotations;

using System.ComponentModel.DataAnnotations.Schema;

using System.Linq;

using System.Text;

using System.Threading.Tasks;

namespace Core
{    publicclassUserMaster
    {
        [Key]
        [DatabaseGeneratedAttribute(DatabaseGeneratedOption.Identity)]
        publicint UserId { get; set; }
        publicstring LoginName { get; set; }
        publicstring password { get; set; }
        publicstring UserName { get; set; }
        publicstring ReturnUrl { get; set; 
    }
    publicclassCustomerProduct
    {
        [Key]
        [DatabaseGeneratedAttribute(DatabaseGeneratedOption.Identity)]
        publicint Id { get; set; }
        publicint ProductId { get; set; }
        publicdecimal Price { get; set; }
        publicdecimal Quantity { get; set; }
        publicdecimal TotalAmount { get; set; }
        publicvirtualProductMaster ProductMaster { get; set; }
    }
    publicclassProductMaster
    {
        public ProductMaster()
        {
            CustomerProducts = newHashSet<CustomerProduct>();
        }
        [Key]
        [DatabaseGeneratedAttribute(DatabaseGeneratedOption.Identity)]
        publicint ProductId { get; set; }
        publicstring ProductName { get; set; }
        publicdecimal Price { get; set; }
        publicint CategoryId { get; set; }
        publicvirtualCategotyMaster CategotyMaster { get; set; }
        publicvirtualICollection<CustomerProduct> CustomerProducts { get; set; }
    }
    publicclassCategotyMaster
    {
        public CategotyMaster()
        {
            ProductMasters = newHashSet<ProductMaster>();
        }
        [Key]
        [DatabaseGeneratedAttribute(DatabaseGeneratedOption.Identity)]
        public int CategoryId { get; set; }

        public string CategoryName { get; set; }

        public virtual ICollection<ProductMaster> ProductMasters { get; set; }

    }

}

answer 415872610105558


Second  we have created data class library project and mention Repository pattern and
 codefirst entity framework .

Create IRepository interface 

using System;
using System.Collections.Generic;

using System.Linq;

using System.Text;

using System.Threading.Tasks;

namespace Data

{
    public interface IRepository<T> where T : class

    {
        IQueryable<T> GetAll();
        void Add(T obj);
        void Delete(object Id);
        void Update(T obj);
        T GetById(object id);       
    }
}
Next create a new repository class which is implement IRepository interface . 
using System;
using System.Collections.Generic;
using System.Data.Entity;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
namespace Data
{
    publicclassRepository<T> :IRepository<T> where T : class
    {
         privateDataContext context = null;
         privateDbSet<T> table = null;
         public Repository()
        {            this.context = newDataContext();
            this.context.Configuration.ProxyCreationEnabled = false;
            table = context.Set<T>();
        }
         public Repository(DataContext context)
        {
            this.context = context;
            this.context.Configuration.ProxyCreationEnabled = false;
            table = context.Set<T>();
        }
         publicIQueryable<T> GetAll()
         {
              return table;
         }
         publicvoid Add(T obj)
         {
             table.Add(obj);
             context.SaveChanges();
         }
         publicvoid Delete(object Id)
         {
             T existing = table.Find(Id);
             table.Remove(existing);
             context.SaveChanges();
         }
         publicvoid Update(T obj)
         {
             table.Attach(obj);
             context.Entry(obj).State = EntityState.Modified;
         }
         public T GetById(object id)
         {
             return table.Find(id);        
         }
    }
}
Next create a new DataContext class which is implement entity framework. 
using System;
using System.Collections.Generic;
using System.Data.Entity;
using System.Linq;
using System.Text;
using System.Threading.Tasks; 
using System.Data.Entity.ModelConfiguration;
using System.Reflection;
using System.Configuration;
using Core;
namespace Data
{
   publicclassDataContext : DbContext
    {
        public DataContext()
        : base(ConfigurationManager.ConnectionStrings["con"].ConnectionString)
        {            
        Database.SetInitializer<DataContext>(newCreateDatabaseIfNotExists<DataContext>());
        this.Configuration.LazyLoadingEnabled = false;
        }      
        publicDbSet<ProductMaster> ProductMasters { get; set; }
        publicDbSet<CustomerProduct> CustomerProducts { get; set; }
        publicDbSet<CategotyMaster> CategotyMasters { get; set; }
        publicDbSet<UserMaster> UserMasters { get; set; }
    }
}
Next create a new DMLRempsitory class which is set generic IRepository property.
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using Data;
using Core;
using System.Data.Entity;
using System.Configuration;
namespace Data
{
    publicclassDMLRempsitory
    {
       publicIRepository<CustomerProduct> CustomerProduct {
            get
            {               returnnewRepository<CustomerProduct>();
            }  
        }
        publicIRepository<ProductMaster> ProductMaster {
            get
            {
                returnnewRepository<ProductMaster>();
            }            }
        publicIRepository<CategotyMaster> CategotyMaster 
        { 
            get
            {
                return  new Repository<CategotyMaster>();

            }   

        }

        public IRepository<UserMaster> UserMaster

        {

            get

            {

                return new Repository<UserMaster>();

            }

        }

    }

}

answer 415872610105558


Next create a new
BaseController class which is inherits Controller where we create a property of
DMLRempsitory class which is get all property.



using Data;

using System;

using System.Collections.Generic;

using System.Configuration;

using System.Data.Entity;

using System.Linq;

using System.Web;

using System.Web.Mvc;

namespace ReposityPattern.Controllers
{
    publicclassBaseController : Controller
    {
        protectedDMLRempsitory Uow { get; set; }
        public BaseController()
        {
            Uow = newDMLRempsitory();
        }
    }
}
Next create a new HomeController class which is inherits BaseController help to access all property of DMLRempsitory class.
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.Mvc;
using Data;
using Core;
using ReposityPattern.Models;
using System.Data.Entity;
namespace ReposityPattern.Controllers
{
    publicclassHomeController : BaseController
    {
        publicActionResult Index()
        {
            return View();
        }
        publicJsonResult GetCategoty()
        {
            var Result = Uow.CategotyMaster.GetAll();
            return Json(Result, JsonRequestBehavior.AllowGet);
        }
        [HttpPost]
        publicActionResult Delete(CustomerProduct obj)
        {
            Uow.CustomerProduct.Delete(obj.Id);
            SaveChanges();
            returnnewEmptyResult();
        }
        publicActionResult GetProduct(int categoryId = 0)
        {
            var result = (from a in Uow.ProductMaster.GetAll().ToList()
                          where a.CategoryId == categoryId
                          selectnew
                          {
                              a.ProductId,
                              a.ProductName
                          });
            return Json(result, JsonRequestBehavior.AllowGet);
        }
        publicActionResult GetProductDetails(int ProductId = 0)
        {
            var result = (from a in Uow.ProductMaster.GetAll().ToList()
                          join b in Uow.CategotyMaster.GetAll().ToList() on a.CategoryId equals b.CategoryId
                          where a.ProductId == ProductId
                          selectnew
                          {
                              a.ProductId,
                              a.ProductName,
                              a.Price,
                              b.CategoryId,
                              b.CategoryName
                          });
            return Json(result, JsonRequestBehavior.AllowGet);
        }
        publicvoid Insert(IList<CustomerProduct> obj)
        {
            foreach (CustomerProduct o in obj)
            {
                Uow.CustomerProduct.Add(o)
            }
        }
    }
}

Liked By