Explicit construction of entity type [MyClass] in query is not allowed.
- by Code Sherpa
Hi. Like the title says, I have the following exception:
Description: Event code: 3005 Event
message: An unhandled exception has
occurred. Exception information:
Exception type: NotSupportedException
Exception message: Explicit construction of entity type
'Company.Project.Core.Domain.Friend'
in query is not allowed.
I am using LINQ and have the following code in my datacontext:
var friends2 = (dc.Friends
.Where(f => f.MyFriendsAccountId ==
accountId && f.AccountId != accountId)
.Select(f => new
{
f.FriendId,
AccountId = f.MyFriendsAccountId,
MyFriendsAccountId = f.AccountId,
f.CreateDate, f.Timestamp
})).Distinct();
result.AddRange(friends2
.Select(o => new Friend
{
FriendId = o.FriendId,
AccountId = o.AccountId,
CreateDate = o.CreateDate,
MyFriendsAccountId = o.MyFriendsAccountId,
Timestamp = o.Timestamp
}));
the final code block is throwing the error and I am pretty sure it is this statement
that is the culprit:
.Select( o => **new Friend**
How should I be reworking my code to avoid this error? Code illustration appreciated.
Thanks.
