GenericRepository Sample No. 2

  1. public class GenericRepo : IGeneric<Student, int>,IDisposable  
  2.    {  
  3.        private StudentContext db;  
  4.        public GenericRepo()  
  5.        {  
  6.            this.db = new StudentContext();  
  7.        }  
  8.        public List<Student> SelectAll()  
  9.        {  
  10.            return db.Students.ToList();  
  11.        }  
  12.        public Student SelectByID(int id)  
  13.        {  
  14.            return db.Students.Where(x => x.StId == id).SingleOrDefault();  
  15.        }  
  16.         
  17.        public void Insert(Student obj)  
  18.        {  
  19.            db.Students.Add(obj);  
  20.        }  
  21.        public void Update(Student obj)  
  22.        {  
  23.            db.Entry(obj).State = System.Data.Entity.EntityState.Modified;  
  24.        }  
  25.        public void Delete(int id)  
  26.        {  
  27.            Student obj = db.Students.Where(x => x.StId == id).SingleOrDefault();  
  28.            db.Students.Remove(obj);  
  29.        }  
  30.        public void Save()  
  31.        {  
  32.            db.SaveChanges();  
  33.        }  
  34.        public void Dispose()  
  35.        {  
  36.            db.Dispose();  
  37.        }  
  38.        
  39.    }  

Comments

Post a Comment

Popular posts from this blog

IGenricRepository

Image
public interface IRepository<T> { IEnumerable<T> GetAll(); IEnumerable<T> Find(Expression<Func<T, bool >> query); T GetByID( int id); void Add(T item); void Update(T item); void Delete(T item); } public interface IGenericRepository<T> where T : class { IQueryable<T> GetAll(); IQueryable<T> FindBy(Expression<Func<T, bool>> predicate); void Add(T entity); void Delete(T entity); void Edit(T entity); void Save(); }
Read more

Summary of All Data Source Patterns

Simple Active Record (No Repository ) == RDG++ Simple Data Mapper (No Repository) ==  TDG++ Respository Based Active Record = Simple Active Record++ Repository Based Data Mapper = Simple Data Mapper++ Respository (Active Record) = Simple Active Record++ Repository (Data Mapper) = Simple Data Mapper++ When we are using ADO.NET and writing our own DAL, we are not using any ORM. We are dealing ourself with all dirty work of Data Access Writing SQL,Connections, Resultset fetching n mapping, exceptions, messaging, casting, transactions,updating the database schema and domain model ourself ORMs try to abstract these things out and make our life easy Linq like language for quering data. No connection management No Result set dealing and mapping to Domain Model No exception handling No messages to upper layers No Data type casting No Transation Mgmt, it is done by UOW and Change Tracker Database schema and Domain is synched by Code First Migrations Two Types of ...
Read more