//建立控制器
public class BookController : Controller
{BookShopPlusEntities db = new BookShopPlusEntities();
//
// GET: /Book/
public ActionResult Index()
{
List<Books> list=db.Books.Take(10).ToList(); //获取书籍表里的10条数据
return View(list);
}
//根据id删除数据
public ActionResult Delete(int id)
{Books mod = (from b in db.Books where b.Id == id select b).FirstOrDefault();
//Books mod=db.Books.Where(b => b.Id == id).FirstOrDefault();
if (mod != null)
{
db.Books.Remove(mod);
db.SaveChanges();
return Redirect("/Book/Index");
}
return Content("not found");
}
}
//视图调用方法
@{
Layout = null;
}
@using MvcApplication2.Models
<!DOCTYPE html>
<html>
<head>
<meta name="viewport" content="width=device-width" />
<title>Index</title>
</head>
<body>
<div>
<table>
@foreach (var item in Model as List<Books>)
{
<tr>
<td>@item.Title</td>
<td><a href="/Book/Delete/@item.Id">删除</a></td>
</tr>
}
</table>
</div>
</body>
</html>