public List <T> GetAll()
{
using (var context = DbContextCreator.Create())
{
return(context.Set <T>().ToList());
}
}
public T GetByPK(K key)
{
using (DbContext context = DbContextCreator.Create())
{
return(context.Set <T>().Find(key));
}
}
public int GetCount()
{
using (var context = DbContextCreator.Create())
{
return(context.Set <T>().Count());
}
}
public T GetByPK(K1 key1, K2 key2, K3 key3)
{
using (var context = DbContextCreator.Create())
{
return(context
.Set <T>()
.Find(key1, key2, key3));
}
}
public T GetByPK(K key)
{
using (var context = DbContextCreator.Create())
{
return(context.Set <T>()
.Where(IsKey(key))
.FirstOrDefault());
}
}
public void Delete(T entity)
{
using (var context = DbContextCreator.Create())
{
context.Entry(entity).State = System.Data.Entity.EntityState.Deleted;
context.SaveChanges();
}
}
public void Insert(T entity)
{
using (var context = DbContextCreator.Create())
{
context.Set <T>().Add(entity);
context.SaveChanges();
}
}
public void Update(T entity)
{
using (var context = DbContextCreator.Context())
{
context.Entry(entity).State = System.Data.Entity.EntityState.Modified;
context.SaveChanges();
}
}
public K GetMaxKey()
{
using (var context = DbContextCreator.Create())
{
var query = context.Set <T>()
.OrderByDescending(KeySelector)
.Select(KeySelector);
return(query.FirstOrDefault());
}
}
public T GetByPK(K1 key1, K2 key2, K3 key3)
{
using (var context = DbContextCreator.Create())
{
var query = context
.Set <T>()
.Where(IsKey(key1, key2, key3))
.Select(x => x);
return(query.FirstOrDefault());
}
}
