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

by

in Linq to Entity, you should use the methods in your query which is supported by your provider to convert them to expression tree to run on your Data Base side.

all providers must support some methods by default called Canonical Functions (Read More Here), and also you can define your user defined function and stored procedure as edm functions to use in linq query (Read More Here) and (Here).

in addition you can use methods which is supported by providers and can be converted to expression tree which are in EntityFunctions and SqlFunctions.

and finally about your question, you can convert UserID and ClassID before your query, like this:

var UID = int.Parse(UserID);
var CID = int.Parse(ClassID);
var record = context.enrollments.SingleOrDefault
    (row => row.userId == UID && row.classId == CID);

More Related Contents:

  1. What is the effect of AsEnumerable() on a LINQ Entity?
  2. Select parsed int, if string was parseable to int
  3. Data binding directly to a store query (DbSet, DbQuery, DbSqlQuery) is not supported
  4. C# int, Int32 and enums
  5. How to display words that appear more than 'x' times in a text? [closed]
  6. Getting same numbers from random number generator even though it’s out of the loop. Why? [closed]
  7. Can’t use Count() in C#
  8. Retrieving Property name from lambda expression
  9. How do I apply OrderBy on an IQueryable using a string column name within a generic extension method?
  10. When to use BlockingCollection and when ConcurrentBag instead of List?
  11. How can I get every nth item from a List?
  12. How do I invoke an extension method using reflection?
  13. Use LINQ to group a sequence of numbers with no gaps
  14. What is LINQ and what does it do? [closed]
  15. LINQ: combining join and group by
  16. Add two Lists of different length in C#
  17. Deferred execution and eager evaluation
  18. Number of occurrences of a character in a string [duplicate]
  19. Linq query built in foreach loop always takes parameter value from last iteration
  20. “The LINQ expression node type ‘Invoke’ is not supported in LINQ to Entities” – stumped!
  21. Rotate – Transposing a List using LINQ C#
  22. High memory consumption with Enumerable.Range?
  23. How to await a list of tasks asynchronously using LINQ?
  24. Use linq to generate direct update without select
  25. Why are ToLookup and GroupBy different?
  26. How to find List has duplicate values in List [duplicate]
  27. Max return value if empty query
  28. Sort one list by another
  29. Get sum of two columns in one LINQ query
  30. Convert DataTable to Generic List in C#

Leave a Comment