Entity Framework和MVC 实现增删改查的控制器代码

一.更新一条数据的关键代码

ExcrciseEntities db = new ExcrciseEntities();
db.Entry(user).State = EntityState.Modified;
//user是修改之后的条目对象
db.SaveChanges();

二.全部控制器代码

using MvcApp3.Models;
using System;
using System.Collections.Generic;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Mvc;

namespace MvcApp3.Controllers
{
public class Default1Controller : Controller
{
//
// GET: /Default1/

public ActionResult Index()
{
ExcrciseEntities db = new ExcrciseEntities();
return View(db.UserInfo);
}


public ActionResult Details(int id)
{
ExcrciseEntities db = new ExcrciseEntities();
var item = db.UserInfo.Where<UserInfo>(u => u.ID == id).FirstOrDefault();

ViewData.Model = item;
return View();
}

//
// GET: /Default1/Create
// 创建新条目，出现添加记录的表单
public ActionResult Create()
{
return View();
}

//
// POST: /Default1/Create
//接收用户填写的表单记录
[HttpPost]//标识该方法只能接受post请求
public ActionResult Create(UserInfo userInfo)
{
try
{
// TODO: Add insert logic here
ExcrciseEntities db = new ExcrciseEntities();
db.UserInfo.Add(userInfo);
db.SaveChanges();

return RedirectToAction("Index");
}
catch
{
return View();
}
}

//
// GET: /Default1/Edit/5
//展示一下要修改的条目
public ActionResult Edit(int id)
{
ExcrciseEntities db = new ExcrciseEntities();
var item = db.UserInfo.Where<UserInfo>(u => u.ID == id).FirstOrDefault();
db.UserInfo.Remove(item);

return View(item);
}

//
// POST: /Default1/Edit/5
[HttpPost]
public ActionResult Edit(int id, UserInfo user)
{
try
{
// TODO: Add update logic here
ExcrciseEntities db = new ExcrciseEntities();
db.Entry(user).State = EntityState.Modified;
db.SaveChanges();

return RedirectToAction("Index");
}
catch
{
return View();
}
}

//
// GET: /Default1/Delete/5
//把要删除的数据展示一下
public ActionResult Delete(int id)
{
ExcrciseEntities db = new ExcrciseEntities();
var item = db.UserInfo.Where<UserInfo>(u => u.ID == id).FirstOrDefault<UserInfo>();
return View(item);
}

//
// POST: /Default1/Delete/5

[HttpPost]
public ActionResult Delete(int id, FormCollection collection)
{
try
{
// TODO: Add delete logic here
ExcrciseEntities db = new ExcrciseEntities();
var item = db.UserInfo.Where<UserInfo>(u => u.ID == id).FirstOrDefault<UserInfo>();
db.UserInfo.Remove(item);
db.SaveChanges();
return RedirectToAction("Index");
}
catch
{
return View();
}
}
}
}