EF增删改查以及按ID查询

///
/// 查询所有信息
///
///
public static List<LE_Food> Select()
{
using (LoveEatingEntities db= new LoveEatingEntities())
{
var list = db.LE_Food.Include(“LE_FoodType”).ToList();//多表查询
return list;
}
}
public static int Delete(int id)
{
using (LoveEatingEntities db = new LoveEatingEntities())
{
var a = db.LE_Food.Where(s => s.FoodID == id).FirstOrDefault();
if (a!=null)
{
db.LE_Food.Remove(a);
}
return db.SaveChanges();
}
}
public static int Insert(LE_Food food)
{
using (LoveEatingEntities db = new LoveEatingEntities())
{
db.LE_Food.Add(food);
return db.SaveChanges();
}
}
///
/// 根据某个ID查找详细信息
///
///
public static LE_Food SelectbyID(int id)
{
using (