ASP.NET MVC & Entity Framework: How to render a custom Model in a View?

Question

I have two tables Category 1..* Advertisement.

I want to get the advertisements Count for each category. To do so, I use that query:

var catList = (from c in DB.Category.Include("Advertisement")
                  select new { c.Name, c.Advertisement.Count }
                  ).ToList();

How to access the e.g the first element's property Name and Count via View ?

score 0 · Answer 1 · edited May 23 '17 at 12:19

0

You will have to use a collection of a strongly typed object instead of using anonymous types.

Please see Dynamic typed ViewPage for an explanation, but the readers' digest version is that anonymous types are internal.

edited May 23 '17 at 12:19

Community

1
1

answered Sep 13 '10 at 20:04

Josh

16,286
25
113
158

eglasius · Accepted Answer · 2010-10-06T17:07:42.513

I'd use a view model, like:

var catList = (from c in DB.Category.Include("Advertisement")
                  select new CategorySummaryViewModel{ Name = c.Name, AdsCount = c.Advertisement.Count }
                  ).ToList();

Unrelated & not sure: but I think you can take out the .Include in that linq query / since you are getting a projection, not a Category instance that you want it's Advertisement property populated.

ASP.NET MVC & Entity Framework: How to render a custom Model in a View?

2 Answers2