public T Get(Expression <Func <T, bool> > filter)
{
using (var context = new PortfolioContext())
{
return(context.Set <T>().SingleOrDefaultAsync(filter).Result);
}
}
public void Update(T entity)
{
using (var context = new PortfolioContext())
{
var update = context.Entry(entity);
update.State = EntityState.Modified;
context.SaveChanges();
}
}
public void Insert(T entity)
{
using (var context = new PortfolioContext())
{
var insert = context.Entry(entity);
insert.State = EntityState.Added;
context.SaveChanges();
}
}
public List <T> GetList(Expression <Func <T, bool> > filter = null)
{
using (var context = new PortfolioContext())
{
return(filter == null
? context.Set <T>().ToListAsync().Result
: context.Set <T>().Where(filter).ToList());
}
}
/*
* public List<T> List()
* {
* return _objectSet.ToList();
* }
* public List<T> List(Expression<Func<T, bool>> where)
* {
* return _objectSet.Where(where).ToList();
* }
* public int Insert(T obj)
* {
* _objectSet.Add(obj);
* return Save();
* }
*
* public int Update(T obj)
* {
* return Save();
* }
*
* public int Delete(T obj)
* {
* _objectSet.Remove(obj);
* return Save();
* }
*
* public int Save()
* {
* return db.SaveChanges();
* }
*/
public void Delete(T entity)
{
using (var context = new PortfolioContext())
{
var delete = context.Entry(entity);
delete.State = EntityState.Deleted;
context.SaveChanges();
}
}
protected static void CreatecoContext()
{
if (db == null)
{
lock (_locksyc)
{
if (db == null)
{
db = new PortfolioContext();
}
}
}
}
