The specified type member 'Id' is not supported in LINQ to Entities.

[eminyuce]

I am getting the following exception when I tried to get single entity with method named 'GetSingle(Id)' .My entity class has integer identifier but it is not 'Id', it is SiteId.

The specified type member 'Id' is not supported in LINQ to Entities. Only initializers, entity members, and entity navigation properties are supported.

I think Linq is trying to use Id field to generate sql query to get data but my primary identifier field is 'SiteId'

Is there any way to specify entity identifier?

public partial class se_Sites : IEntity
{
public int Id { get { return SiteId; } set { SiteId = value; } }
public int SiteId { get; set; }
public string Name { get; set; }
public string ShortName { get; set; }

} 

[angus151]

eminyuce,
Perhaps you could try mapping the property Id to the SiteId column in your database table using DataAnnotations.

If you wanted to retain the SiteId property, you would set and get the value from the Id property (I have included this in the code sample below.

using System.ComponentModel.DataAnnotations.Schema;

public partial class se_Sites : IEntity 
{
    [Column("SiteId")]
    public int Id { get; set; }
    [NotMapped]
    public int SiteId { get { return Id; } set { Id = value; } }
    public string Name { get; set; }
    public string ShortName { get; set; }
} 

[eminyuce]

Thank you, I will take a look at it.

[boulaajaj]

@eminyuce did it work? it's not working for me, even with the data annotation. Using EF6 and Oracle 12.1.0.2.0