public User GetByIdUsingDbContext(int id)
{
using (var db = new AppEntities())
{
return(db.Users.Find(id));
}
}
public void Update(User entity)
{
using (var db = new AppEntities())
{
db.Entry(entity).State = EntityState.Modified;
db.SaveChanges();
}
}
public void Add(User entity)
{
using (var db = new AppEntities())
{
db.Users.Add(entity);
db.SaveChanges();
}
}
public IEnumerable <User> GetAll()
{
using (var db = new AppEntities())
{
//Don't forget ToList or this will throw InvalidOperationException for disposing DbContext
return(db.Users.ToList());
}
}
public void Delete(int id)
{
using (var db = new AppEntities())
{
User userToDelete = db.Users.Find(id);
if (userToDelete != null)
{
db.Users.Remove(userToDelete);
db.SaveChanges();
}
}
}