GenricRepository Sample No. 3

  1. using Microsoft.EntityFrameworkCore;  
  2. using System;  
  3. using System.Collections.Generic;  
  4. using System.Linq;  
  5. namespace GR.Data {  
  6.     public class Repository < T > : IRepository < T > where T: BaseEntity {  
  7.         private readonly ApplicationContext context;  
  8.         private DbSet < T > entities;  
  9.         string errorMessage = string.Empty;  
  10.         public Repository(ApplicationContext context) {  
  11.             this.context = context;  
  12.             entities = context.Set < T > ();  
  13.         }  
  14.         public IEnumerable < T > GetAll() {  
  15.             return entities.AsEnumerable();  
  16.         }  
  17.         public T Get(long id) {  
  18.             return entities.SingleOrDefault(s => s.Id == id);  
  19.         }  
  20.         public void Insert(T entity) {  
  21.             if (entity == null) {  
  22.                 throw new ArgumentNullException("entity");  
  23.             }  
  24.             entities.Add(entity);  
  25.             context.SaveChanges();  
  26.         }  
  27.         public void Update(T entity) {  
  28.             if (entity == null) {  
  29.                 throw new ArgumentNullException("entity");  
  30.             }  
  31.             context.SaveChanges();  
  32.         }  
  33.         public void Delete(T entity) {  
  34.             if (entity == null) {  
  35.                 throw new ArgumentNullException("entity");  
  36.             }  
  37.             entities.Remove(entity);  
  38.             context.SaveChanges();  
  39.         }  
  40.     }  
  41. }  

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