The entity or complex type ‘ ‘ cannot be constructed in a LINQ to Entities query [duplicate]

by

In Linq-to-Entities you can only project to an anonymous type or a regular class. You can’t project to an existing entity type. You can with linq-to-objects like so

var tasks = (from i in data.Incidents
            join a in data.Accounts on i.CustomerID equals a.Acct_CID
             select new
             {
               creator_id = a.ID,
               start_date = i.DateOpened,
               end_date = i.DateCLosed
              // ...
             }).AsEnumerable().Select(x => new Tasks {
               creator_id = x.creator_id,
               start_date = x.start_date,
               end_date = x.end_date              
             }).ToList();

More Related Contents:

  1. Problem with converting int to string in Linq to entities
  2. How to create LINQ Expression Tree to select an anonymous type
  3. Linq-to-Entities Join vs GroupJoin
  4. ‘Contains()’ workaround using Linq to Entities?
  5. LINQ to Entities case sensitive comparison
  6. How to use DbContext.Database.SqlQuery(sql, params) with stored procedure? EF Code First CTP5
  7. Method cannot be translated into a store expression
  8. “A lambda expression with a statement body cannot be converted to an expression tree”
  9. Bulk-deleting in LINQ to Entities
  10. The type of one of the expressions in the join clause is incorrect in Entity Framework
  11. Linq to Entities, random order
  12. C# – code to order by a property using the property name as a string [duplicate]
  13. LEFT JOIN in LINQ to entities?
  14. How to compare only date components from DateTime in EF?
  15. linq to entities doesn’t recognize a method
  16. Only parameterless constructors and initializers are supported in LINQ to Entities
  17. “NOT IN” clause in LINQ to Entities
  18. Simple Automapper Example
  19. How to tell if an IEnumerable is subject to deferred execution?
  20. How do I perform Date Comparison in EF query?
  21. Linq to Entity Join table with multiple OR conditions
  22. How to get first record in each group using Linq
  23. ‘Date’ is not supported in LINQ to Entities. Only initializers, entity members, and entity navigation properties are supported
  24. String.IsNullOrWhiteSpace in LINQ Expression
  25. Calling a SQL User-defined function in a LINQ query
  26. How to use SQL ‘LIKE’ with LINQ to Entities? [duplicate]
  27. Only parameterless constructors and initializers are supported in LINQ to Entities message
  28. LINQ to Entities group-by failure using .date
  29. Linq to Entities : using ToLower() on NText fields
  30. Is Injection Possible through Dynamic LINQ?

Leave a Comment