The entity cannot be constructed in a LINQ to Entities query

by

You cannot (and should not be able to) project onto a mapped entity. You can, however, project onto an anonymous 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();
}

More Related Contents:

  1. How to call Stored Procedure in Entity Framework 6 (Code-First)?
  2. Solving “The ObjectContext instance has been disposed and can no longer be used for operations that require a connection” InvalidOperationException
  3. How can I retrieve Id of inserted entity using Entity framework? [closed]
  4. The entity type is not part of the model for the current context
  5. Getting data from stored procedure with Entity Framework
  6. Many-to-many self referencing relationship
  7. Entity Framework – Code First – Can’t Store List
  8. A specified Include path is not valid. The EntityType does not declare a navigation property with the name *
  9. EF Code First: How to get random rows
  10. Non-static method requires a target
  11. Using Asp.Net Identity DataBase first approach
  12. Fluent API, many-to-many in Entity Framework Core
  13. Entity Framework Code First Lazy Loading
  14. How to add the same column to all entities in EF Core?
  15. DbArithmeticExpression arguments must have a numeric common type
  16. Dynamically changing schema in Entity Framework Core
  17. ‘No database provider has been configured for this DbContext’ on SignInManager.PasswordSignInAsync
  18. Enable Migrations with Context in Separate Assembly?
  19. Enable-Migrations Exception calling “SetData” with “2” argument(s)
  20. Save detached entity in Entity Framework 6
  21. How do you check if a string contains any strings from a list in Entity Framework?
  22. update-database: “A network-related or instance-specific error occurred while establishing a connection to SQL Server”
  23. Better way to query a page of data and get total count in entity framework 4.1?
  24. Calling a SQL User-defined function in a LINQ query
  25. Why is EF returning a proxy class instead of the actual entity?
  26. How does the SQLite Entity Framework 6 provider handle Guids?
  27. System.Data.Entity.Core.EntityCommandExecutionException Occurred in MVC app Using EF
  28. How to set Identity Seed value in code-first?
  29. How to write this EF Mock setup code as a reusable Generic Boilerplate?
  30. .NET Managing Layers Relationships

Leave a Comment