ASP.NET MVC3 Music Store 簡易中文教程.(四)

2011-09-06

1775
0

ASP.NET MVC3 Music Store 簡易中文教程.(四)數據訪問

依照「ASP.NET MVC3 Music Store 簡易中文教程.(四)數據訪問」這篇文章做，最後卻都會跟大家一樣出現"ProviderManifestToken"錯誤。

我猜想應該是Library Package Reference的問題，實在懶得去偵錯，就從這裡下載了了SQL Script，然後建立一個資料實體(來源為資料庫)。

把範例專案中Models目錄內的類別全砍了，接著就開始修改原始的程式碼...

StoreController.cs


    {
		MusicStoreEntities db = new MusicStoreEntities();
		//
		// GET: /Store/
		public ActionResult Index()
		{
			var genres = from g in db.Genres
							 select g;
			return View(genres);
		}
		//
		// GET: /Store/Browse?genre=Disco 
		public ActionResult Browse(string genre)
		{
			var genreModel = db.Genres.Include("Albums").Single(g=>g.Name==genre);
			return View(genreModel);
		}
		//
		// GET: /Store/Details/5 
		public ActionResult Details(int id)
		{
			var album = from a in db.Albums
							where a.AlbumId==id
							select a;
			return View(album.First());
		} 

    }

Browse.cshtml



@{
    ViewBag.Title = "Browse";
    Layout = "~/Views/Shared/_Layout.cshtml";
}

<h2>Browsing Genre: @Model.Name</h2>
<ul>
    @foreach (var album in Model.Albums) { 
        <li>@Html.ActionLink(album.Title,"Details",new {id=album.AlbumId})</li>
    }
</ul>

回首頁