Entity cannot be constructed in a LINQ to Entities query.

Question

using (var ctx = new MainWebsiteEntities())
                {
                    model = (IEnumerable<BoardMember>)ctx.BoardMembers.Where(s => s.id == id).Select(e => new BoardMember
                    {
                        BoardMemberName = e.BoardMemberName,
                        CompanyName = e.CompanyName,
                        Group = e.Group,
                        id = (int)e.id

                    }).FirstOrDefault();
}
I get the following error: cannot be constructed in a LINQ to Entities query.

Answer 1

@Mark Kopple , Welcome to Microsoft Q&A, based on my test, I reproduced your problem.

The error cannot be constructed in a LINQ to Entities query means that you could not (and should not be able to) project onto a mapped entity.

If you want to get the model of BoardMember, you could simplify your code into the following code:

var model = context.BoardMembers.Where(s => s.Id == 1).FirstOrDefault();

Best Regards,

Jack

---

If the answer is the right solution, please click "Accept Answer" and upvote it.If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.