LINQ to Entities does not recognize the method

by

As you’ve figured out, Entity Framework can’t actually run your C# code as part of its query. It has to be able to convert the query to an actual SQL statement. In order for that to work, you will have to restructure your query expression into an expression that Entity Framework can handle.

public System.Linq.Expressions.Expression<Func<Charity, bool>> IsSatisfied()
{
    string name = this.charityName;
    string referenceNumber = this.referenceNumber;
    return p => 
        (string.IsNullOrEmpty(name) || 
            p.registeredName.ToLower().Contains(name.ToLower()) ||
            p.alias.ToLower().Contains(name.ToLower()) ||
            p.charityId.ToLower().Contains(name.ToLower())) &&
        (string.IsNullOrEmpty(referenceNumber) ||
            p.charityReference.ToLower().Contains(referenceNumber.ToLower()));
}

More Related Contents:

  1. Entity Framework 4 Single() vs First() vs FirstOrDefault()
  2. How to do SQL Like % in Linq?
  3. Like Operator in Entity Framework?
  4. Linq to Entities – SQL “IN” clause
  5. Linq int to string
  6. EF LINQ include multiple and nested entities
  7. LINQ to Entities does not recognize the method Int32 get_Item(Int32)
  8. Why use LINQ Join on a simple one-many relationship?
  9. The model backing the ‘ApplicationDbContext’ context has changed since the database was created
  10. Introducing FOREIGN KEY constraint may cause cycles or multiple cascade paths – why?
  11. Which method performs better: .Any() vs .Count() > 0?
  12. Dynamic where clause (OR) in Linq to Entities
  13. Why is .Contains slow? Most efficient way to get multiple entities by primary key?
  14. “Or” equivalent in Linq Where() lambda expression
  15. Undo changes in entity framework entities
  16. LINQ Single vs First
  17. ASP.NET MVC: Is Controller created for every request?
  18. Filter/Search using Multiple Fields – ASP.NET MVC
  19. Generate POCO classes in different project to the project with Entity Framework model
  20. How to work with Enums in Entity Framework?
  21. Does LINQ work with IEnumerable?
  22. How to use “contains” or “like” in a dynamic linq query?
  23. Max return value if empty query
  24. How to do an “in” query in entity framework?
  25. big issue in converting string to datetime using linq-to-entities
  26. Keep Getting ‘The LINQ expression node type ‘Invoke’ is not supported in LINQ to Entities’ Exception
  27. How to include() nested child entity in linq
  28. How to Convert Row to Column in Linq and SQL
  29. LINQ Query to Convert string to datetime
  30. Using Entity Framework entities as business objects?

Leave a Comment