LINQ to Entities does not recognize the method ‘System.String ToString()’ method, and this method cannot be translated into a store expression

by

Just save the string to a temp variable and then use that in your expression:

var strItem = item.Key.ToString();

IQueryable<entity> pages = from p in context.pages
                           where  p.Serial == strItem
                           select p;

The problem arises because ToString() isn’t really executed, it is turned into a MethodGroup and then parsed and translated to SQL. Since there is no ToString() equivalent, the expression fails.

Note:

Make sure you also check out Alex’s answer regarding the SqlFunctions helper class that was added later. In many cases it can eliminate the need for the temporary variable.

More Related Contents:

  1. LINQ to SQL multiple tables left outer join
  2. convert sql query into lambda expression [closed]
  3. Error: You have an error in your SQL syntax – but SQL statement works
  4. Is there a good LINQ way to do a cartesian product?
  5. LINQ to SQL – Left Outer Join with multiple join conditions
  6. linq case statement
  7. Equivalent of SQL ISNULL in LINQ?
  8. Distinct in Linq based on only one field of the table
  9. Could not find an implementation of the query pattern
  10. Wildcard search for LINQ
  11. Get an IDataReader from a typed List
  12. Local sequence cannot be used in LINQ to SQL implementation of query operators except the Contains() operator
  13. Entity Framework. Delete all rows in table
  14. Use linq to generate direct update without select
  15. Join and Include in Entity Framework
  16. How to make LINQ execute a (SQL) LIKE range search
  17. Get affected rows on ExecuteNonQuery
  18. Calling a SQL User-defined function in a LINQ query
  19. Index (zero based) must be greater than or equal to zero
  20. Issues Doing a String Comparison in LINQ
  21. Convert SQL to LINQ Query [closed]
  22. Linq To Sql compare Time only
  23. Linq union usage?
  24. Difference Between Select and SelectMany
  25. How do I use LINQ Contains(string[]) instead of Contains(string)
  26. Func with out parameter
  27. Is it necessary to manually close and dispose of SqlDataReader?
  28. LINQ Inner-Join vs Left-Join
  29. How to sort a dictionary by key
  30. LINQ performance Count vs Where and Count

Leave a Comment