MVC,C#,LINQ.............

Question

Hello all.. im complete beginner to MVC, im just stared learning Mvc through a book Hands on mvc.. and in that book a sample project is there.., it is "MovieReview" in which I used EF code first approach..so why im here is that i got exception while im doing that project... it throws an Exception when i run home controler index action "{"The entity or complex type 'MovieReview.Models.MovieViewModel' cannot be constructed in a LINQ to Entities query."}".. i just upload my solution below MovieReview.rar file... plz Help me anyonee.. Thanks for advancee...

Nilesh Sawardekar · Accepted Answer

You cannot (and should not be able to) project onto a mapped entity. You can, however, project onto an annonymous type or onto a DTO:

public class ProductDTO { public string Name { get; set; } // Other field you may need from the Product entity }

And your method will return a List of DTO's.

public List<ProductDTO> GetProducts(int categoryID) { return (from p in db.Products where p.CategoryID == categoryID             select new ProductDTO { Name = p.Name }).ToList(); }

Have a look on above e.g.

Shakti Singh Dulawat · Answer

Read this https://msdn.microsoft.com/en-us/magazine/ee236638.aspx#id0080022 for more understanding