C# Repository Pattern

This blog briefs you about C# repository pattern.

Repository Pattern

The repository pattern provides the common interface to extracting the business entities. The developer is always looking for good project architecture, which reduces repetitive code and separates the Data Access Layer and Business Logic Layer.

Now, we create an Employee entity and the code snippet, mentioned below is for an Employee entity.

using System;
using System.ComponentModel.DataAnnotations;
using System.ComponentModel.DataAnnotations.Schema;
namespace EntityDomain {
    public class Employee {
        [DatabaseGenerated(DatabaseGenerationOption.Identity)]
        [Key]
        public int Id {
            get;
            set;
        }
        public string LastName {
            get;
            set;
        }
        public string FirstName {
            get;
            set;
        }
        public DateTime BirthDate {
            get;
            set;
        }
    }
}

Now, we create class MyContext, The code snippet, mentioned below is for MyContext.

using System.Data.Entity;
namespace EntityDomain {
    public class MyContext: DbContext {
        public MyContext(): base("Dbconnection") {
            Database.SetInitializer < MyContext > (null);
        }
        public virtual DbSet < Employee > Employee {
            get;
            set;
        }
    }
}

Now, create a repository interface for the entity operations, so that we develop loosely coupled Application.

using Microsoft.EntityFramework;
using System;
using System.Collections.Generic;
using System.Linq;
namespace EntityDomain {
    public interface IRepository < T > where T: Class {
        IEnumerable < T > GetAll {
            get;
        }
        void Add(T entity);
        void Delete(T entity);
        void Update(T entity);
        T FindById(int Id);
    }
}

Now, create a Repository class and implementIRepository interface. This repository has a parameterized constructor with a parameter as MyContext.

using Microsoft.EntityFramework;
using System;
using System.Collections.Generic;
using System.Linq;
namespace EntityDomain {
    public class Repository: IRepository < T > where T: Class {
        private readonly MyContext context;
        private DbSet < T > DbSet;
        public Repository(MyContext _context) {
            this.context = _context;
            DbSet = context.Set < T > ();
        }
        public IEnumerable < T > GetAll() {
            return DbSet.AsEnumerable();
        }
        public void Add(T entity) {
            DbSet.Add(entity);
            context.SaveChanges();
        }
        public void Update(T entity) {
            DbSet.Attach(entity);
            context.Entry(entity).State = EntityState.Modified;
            context.SaveChanges();
        }
        public void Delete(T entity) {
            DbSet.Remove(entity);
            context.SaveChanges();
        }
        public T FindById(int id) {
            return DbSet.Find(id);
        }
    }
}

NOTE

Here T is an entity like an Employee.

I hope, you will enjoyed the blog. Happy coding.