The specified member of type "Title" is not supported in LINQ to Entities
I got an error when using a property Title
in my Linq to Entity:
The specified member of type 'Title' is not supported in LINQ to Entities. Only initializers, entities, and property entities are supported.
my request:
var db = FaraWorkspaceEntity.GetEntity();
var query = from item in db.ProjectManagers
where item.ProjectID == projectID
select new UserListItem
{
ID = item.UserID,
Title = item.User.Title // Here is error
};
return query.ToList();
public class User : IdentityUser<string, UserLogin, UserRole, UserClaim>
{
[Required]
[Display(Name = "نام")]
[StringLength(50)]
public string Firstname { get; set; }
[Required]
[Display(Name = "نام خانوادگی")]
[StringLength(50)]
public string Lastname { get; set; }
public string Title
{
get { return this.Firstname + " " + this.Lastname; }
}
}
source to share
Title
is a property in your organization. There is no such column in your table. Entity Framework
cannot convert your code to Sql
. So you have to change your code like:
var query = from item in db.ProjectManagers
where item.ProjectID == projectID
select new UserListItem
{
ID = item.UserID,
Title = item.User.Firstname + " " + item.User.Lastname;
};
But I suggest you select FirstName
and LastName
, and when you want to get the value Title
, your getter will work:
var query = from item in db.ProjectManagers
where item.ProjectID == projectID
select new UserListItem
{
ID = item.UserID,
Firstname = item.User.Firstname
Lastname = item.User.Lastname;
};
source to share