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

by

You cannot use properties that are not mapped to a database column in a Where expression. You must build the expression based on mapped properties, like:

var date = DateTime.Now.AddYears(-from);
result = result.Where(p => date >= p.DOB);
// you don't need `AsQueryable()` here because result is an `IQueryable` anyway

As a replacement for your not mapped Age property you can extract this expression into a static method like so:

public class clsProfileDate
{
    // ...
    public DateTime DOB { get; set; } // property mapped to DB table column

    public static Expression<Func<clsProfileDate, bool>> IsOlderThan(int age)
    {
        var date = DateTime.Now.AddYears(-age);
        return p => date >= p.DOB;
    }
}

And then use it this way:

result = result.Where(clsProfileDate.IsOlderThan(from));

More Related Contents:

  1. How to convert DbSet in Entity framework to ObjectQuery
  2. LINQ to Entities case sensitive comparison
  3. What’s the difference(s) between .ToList(), .AsEnumerable(), AsQueryable()?
  4. What effect(s) can the virtual keyword have in Entity Framework 4.1 POCO Code First?
  5. Entity Framework: Where do I extend the CSDL/MSL?
  6. Convert String to Int in EF 4.0
  7. LEFT JOIN in LINQ to entities?
  8. Entity Framework Simple Generic GetByID but has differents PK Name
  9. Entity Framework 4 / POCO – Where to start? [closed]
  10. Use Entity framework I want to include only first children objects and not child of child(sub of sub)
  11. The specified type member ‘Date’ is not supported in LINQ to Entities. Only initializers, entity members, and entity navigation properties
  12. Possible to default DateTime field to GETDATE() with Entity Framework Migrations?
  13. Entity Framework 4 Single() vs First() vs FirstOrDefault()
  14. Entity Framework 4: Does it make sense to create a single diagram for all entities?
  15. Entity Framework: Set Delete Rule with CodeFirst
  16. LINQ to Entities group-by failure using .date
  17. Entity Framework many-to-many self-reference
  18. Entity Framework VS LINQ to SQL VS ADO.NET with stored procedures? [closed]
  19. Disable lazy loading by default in Entity Framework 4
  20. Best way to check if object exists in Entity Framework? [closed]
  21. The mapping of CLR type to EDM type is ambiguous with EF 6 & 5?
  22. SQL to Entity Framework Count Group-By
  23. Entity Framework 4 selective lazy loading properties
  24. Internal .NET Framework Data Provider error 1025
  25. EF 4: Removing child object from collection does not delete it – why?
  26. Is DbContext the same as DataContext?
  27. EF Migrations: Rollback last applied migration?
  28. The object ‘DF__*’ is dependent on column ‘*’ – Changing int to double
  29. Change db table name in EF4 (entity framework 4)
  30. How do I create an expression tree for run time sorting?

Leave a Comment