There is an entity type called Product that is generated by entity framework.
I have written this query

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

The code below throws the following error :

“The entity or complex type Shop.Product cannot be constructed in a
LINQ to Entities query”

var products = productRepository.GetProducts(1).Tolist();

But when I use select p instead of select new Product { Name = p.Name}; it works correctly.

How can I preform a custom select section?

14 Answers
14

Leave a Reply

Your email address will not be published. Required fields are marked *