GENRIC REPO
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using ApiDemo.Models;
using System.Data;
using System.Data.Entity;
namespace ApiDemo.GenericRepository
{
public class GenericRepository<TEntity> where TEntity : class
{
internal TestServiceEntities context;
internal DbSet<TEntity> dbset;
public IQueryable<TEntity> Query
{
get
{
return dbset;
}
}
public GenericRepository(TestServiceEntities context)
{
this.context = context;
this.dbset = context.Set<TEntity>();
}
public virtual IEnumerable<TEntity> get()
{
IQueryable<TEntity> query = dbset;
return query;
}
public virtual TEntity GetById(object Id)
{
return dbset.Find(Id);
}
public virtual void Insert(TEntity entity)
{
dbset.Add(entity);
}
public virtual void Delete(object Id)
{
TEntity entityToDelete = dbset.Find(Id);
}
public virtual void Delete(TEntity entityToDelete)
{
if (context.Entry(entityToDelete).State == EntityState.Detached)
{
dbset.Attach(entityToDelete);
}
dbset.Remove(entityToDelete);
}
public virtual void Update(TEntity entityToUpdate)
{
dbset.Attach(entityToUpdate);
context.Entry(entityToUpdate).State = EntityState.Modified;
}
}
}
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using ApiDemo.Models;
using System.Data;
using System.Data.Entity;
namespace ApiDemo.GenericRepository
{
public class GenericRepository<TEntity> where TEntity : class
{
internal TestServiceEntities context;
internal DbSet<TEntity> dbset;
public IQueryable<TEntity> Query
{
get
{
return dbset;
}
}
public GenericRepository(TestServiceEntities context)
{
this.context = context;
this.dbset = context.Set<TEntity>();
}
public virtual IEnumerable<TEntity> get()
{
IQueryable<TEntity> query = dbset;
return query;
}
public virtual TEntity GetById(object Id)
{
return dbset.Find(Id);
}
public virtual void Insert(TEntity entity)
{
dbset.Add(entity);
}
public virtual void Delete(object Id)
{
TEntity entityToDelete = dbset.Find(Id);
}
public virtual void Delete(TEntity entityToDelete)
{
if (context.Entry(entityToDelete).State == EntityState.Detached)
{
dbset.Attach(entityToDelete);
}
dbset.Remove(entityToDelete);
}
public virtual void Update(TEntity entityToUpdate)
{
dbset.Attach(entityToUpdate);
context.Entry(entityToUpdate).State = EntityState.Modified;
}
}
}
No comments:
Post a Comment