linq to entities doesn’t recognize a method

by

When using linq-to-entities you cannot use arbitrary .NET methods in query. Each method used in the query must be translatable to SQL. It will not help you to return Expession<Func<entityType, bool>> because where condition must be evaluated for each record on the database server.

For EF your code means something like:

SELECT COUNT(*)
FROM ...
LEFT JOIN ...
WHERE IsMatch(....)

Because EF validates function names passed to the query it will throw exception because it doesn’t know IsMatch equivalent on SQL server.

The only possible functions which can be used in Linq-to-entities are:

EdmFunctions are methods marked with EdmFunctionAttribute which maps .NET function to SQL counterpart. Those functions usually cannot be executed in common .NET code because they do nothing or throw exception. They are only function place holder for Linq-to-entities. Available EdmFunctions are:

  • Predefined EdmFunctions in System.Data.Objects.EntityFunctions
  • Predefined EdmFunctions for SQL Server (not compact) in System.Data.Objects.SqlClient.SqlFunctions
  • Custom mapped SQL functions – import wizard in Entity designer allows you import SQL functions (except table valued functions). You can after that write custom static .NET function and map it by EdmFunction attribute to the SQL function imported to designer.
  • Custom model defined functions – this is special function written manually in EDMX file (opened as XML). It is custom reusable part of Entity SQL.

I have already described how to create model defined function in another answer. Creating mapped SQL function is pretty similar. Instead of manually creating Function element in EDMX you will map EdmFunctionAttribute properties to imported SQL function.

More Related Contents:

  1. The cast to value type ‘Int32’ failed because the materialized value is null
  2. big issue in converting string to datetime using linq-to-entities
  3. Decimal precision and scale in EF Code First
  4. ‘Contains()’ workaround using Linq to Entities?
  5. Method cannot be translated into a store expression
  6. How can I automatically filter out soft deleted entities with Entity Framework?
  7. EntityType has no key defined error
  8. LINQ to Entities only supports casting EDM primitive or enumeration types with IEntity interface
  9. C# – code to order by a property using the property name as a string [duplicate]
  10. How to compare only Date without Time in DateTime types in Linq to SQL with Entity Framework?
  11. LEFT JOIN in LINQ to entities?
  12. Insert data using Entity Framework model
  13. How to compare only date components from DateTime in EF?
  14. How to get property change notifications with EF 4.x DbContext generator
  15. Entity Framework with XML Files [closed]
  16. How to disable cascade delete for link tables in EF code-first?
  17. EF 6 – How to correctly perform parallel queries
  18. Problems using Entity Framework 6 and SQLite
  19. ef4 cause Circular reference in web service
  20. Join and Include in Entity Framework
  21. Entity framework raw SQL Query
  22. Global setting for AsNoTracking()?
  23. EF5 Getting this error message: Model compatibility cannot be checked because the database does not contain model metadata
  24. Remove item from list based on condition
  25. Unable to find the requested .Net Framework Data Provider. It may not be installed
  26. Entity Framework Multiple Object Contexts
  27. How to force LINQ Sum() to return 0 while source collection is empty
  28. Linq Query keeps throwing “Unable to create a constant value of type System.Object….”, Why?
  29. How to include() nested child entity in linq
  30. LINQ Query to Convert string to datetime

Leave a Comment