选择基本模版
1.创建模型类Book
public class Book
{
public int id { get; set; }
public string BookName { get; set; }
public string Writer { get; set; }
public decimal Price { get; set; }
public DateTime Time { get; set; }
public int Amount { get; set; }
public virtual BookType bookTypes { get; set; }//外键一对多
}
2.创建模型类BookType
public class BookType
{
public int id { get; set; }
public string Booktype { get; set; }
public ICollection<Book> books { get; set; }//外键一对多
}
3.创建数据库上下文
public class BookContext2:DbContext
{
public DbSet<Book> books { get; set; }
public DbSet<BookType> booktypes { get; set; }
}
4.数据迁移:视图->其它窗口->程序包管理器
enable-
add-
update-
Webcofig中更改connectionstring与数据库上下文名字相同
5.创建控制器
强类型视图->模型类->数据库上下文类
public class HomeController : Controller
{
private BookContext2 db = new BookContext2();
public ActionResult Index()
{
return View(db.books.ToList());
}
public ActionResult Details(int id = 0)
{
Book book = db.books.Find(id);
if (book == null)
{
return HttpNotFound();
}
return View(book);
}
protected override void Dispose(bool disposing)
{
db.Dispose();
base.Dispose(disposing);
}
}
6.创建视图Index
@model IEnumerable<_2.Models.Book>
@{
ViewBag.Title = "Index";
}
<h2>Index</h2>
<ul>
@foreach(var item in Model){
<li>
@Html.ActionLink(@item.BookName, "Details", new { id=@item.id})
</li>
}
</ul>
创建视图Detail
选择强类型,Detail模板