Question

在MVC音乐店的样本中,Im试图在册前加上基因,但只读了该书的具体数据,而不是完整的实体。

The EF query:

public ActionResult Browse(string genre)
{
   // Retrieve Genre and its Associated Albums from database
   var genreModel = storeDB.Genres.Include("Albums").Single(g => g.Name == genre);
   return View(genreModel);
}

我的看法是:

public class AlbumViewModel
{ 
   public string Title { get; set; }
   public decimal Price { get; set; } 
}

我将如何改变EF LINQ的询问,以便既了解信息,又包括《汇辑》,而只是选择《观点模式》中所列的数据,而不是实体?

为了完成《观点模式》的部分,我已经做了如下工作:

From a In storeDB.Albums
Where a.Genre = genre
Select New AlbumViewModel With {
     .Title = a.Title,
     .Price = a.Price,
})

Answer 1

应当:

(from g in storeDB.Genres
where g.Name == genre
select new {
    Genre = g,
    Albums = g.Albums.Select(a => new { Title = a.Title, Price = a.Price })
})

友情链接