MVC-EF-增删改查

从数据库更新实体模型

添加

 using (LxEntities db = new LxEntities())
            {
                var p = new Phon() {
                    name="",
                    url=""
                };
                db.Phon.Add(p);
                db.SaveChanges()
                return View();
            }

删除

using (LxEntities2 db = new LxEntities2())
            {
                var p = db.Phon.Find(int.Parse(id));
                db.Phon.Remove(p);
                db.SaveChanges();
        	    return View();
            }

修改

using (LxEntities2 db = new LxEntities2())
            {
                var p = db.Phon.Find(int.Parse(id));
                p.name = "123";
                db.SaveChanges();
        	    return View();
            }

查询

using (LxEntities2 db = new LxEntities2())
{
    List<Phon> List = db.Phon.Where(a => a.id > 0).ToList();
}
	ViewBag.List = List;
    return View();