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

by

The problem here is that your query is being translated into SQL and run on the database, and Entity Framework doesn’t know how to translate Double.Parse into valid SQL code. However, you can define a custom method to do the parsing, and tell Entity Framework how to translate that method to SQL. Here’s how it goes:

Define the translation

Open up your *.edmx file in a text editor, and look for the <edmx:ConceptualModels> tag. Under that you should see a <Schema Namespace="YourModel" ...> tag. Inside the Schema tag, add the following:

    <Function Name="ParseDouble" ReturnType="Edm.Double"> 
        <Parameter Name="stringvalue" Type="Edm.String" /> 
        <DefiningExpression> 
            cast(stringvalue as Edm.Double)
        </DefiningExpression> 
    </Function>

This defines the Enity-SQL code that your custom ParseDouble function is going to be translated into.

Create a method to be translated

Now we need to define a matching function in code that you can put in your LINQ statement. Your EDMX file is used to generate a partial class that inherits from ObjectContext. Since it’s a partial class, you can add your own methods to it without touching the generated code – just make sure the class names match.

using System.Data.Objects.DataClasses;

public partial class YourObjectContext
{
    /// <summary>
    ///     This method exists for use in LINQ queries,
    ///     as a stub that will be converted to a SQL CAST statement.
    /// </summary>
    [EdmFunction("YourModel", "ParseDouble")]
    public static double ParseDouble(string stringvalue)
    {
        return Double.Parse(stringvalue);
    }
}

Now you can go back to your LINQ statement, and replace any instances of Double.Parse with YourObjectContext.ParseDouble. Since this is an actual method that actually calls Double.Parse, it will work on LINQ to Objects calls, and since it is also defined in the EDMX file, it can be translated into SQL by LINQ to Entities as well.

But wait, you’re not done yet!

I noticed that your LINQ statement also includes a call to Math.Round. I don’t know off the top of my head if Entity Framework includes a translation for that method, but if it doesn’t, you’ll get the same error for that method after you fix the one for Double.Parse. Fortunately, the solution for that case is almost exactly the same, except the function defined in the EDMX file would look something like this:

    <Function Name="Round" ReturnType="Edm.Double"> 
        <Parameter Name="input" Type="Edm.Double" /> 
        <DefiningExpression> 
            Round(input)
        </DefiningExpression> 
    </Function>

You can use this list of EDM Canonical Functions to see what’s valid to put inside the <DefiningExpression> tags.

More Related Contents:

  1. VB Net Class in C# [closed]
  2. How do I apply OrderBy on an IQueryable using a string column name within a generic extension method?
  3. A circular reference was detected while serializing an object of type ‘SubSonic.Schema .DatabaseColumn’.
  4. Ignoring a class property in Entity Framework 4.1 Code First
  5. The cast to value type ‘Int32’ failed because the materialized value is null
  6. What difference does .AsNoTracking() make?
  7. What is the purpose of self tracking entities?
  8. Making Entity Class Closed for Changes
  9. Why is .Contains slow? Most efficient way to get multiple entities by primary key?
  10. Entity Framework/Linq EXpression converting from string to int
  11. Filter/Search using Multiple Fields – ASP.NET MVC
  12. linq to entities doesn’t recognize a method
  13. How to convert an expression tree to a partial SQL query?
  14. EF Data Context – Async/Await & Multithreading
  15. Enable Migrations with Context in Separate Assembly?
  16. Why would try/finally rather than a “using” statement help avoid a race condition?
  17. Retrieve an object from entityframework without ONE field
  18. How can I disable model compatibility checking in Entity Framework 4.3?
  19. Could not load file or assembly Microsoft.Extensions.DependencyInjection.Abstractions, Version=1.1.0.0
  20. DbContext discard changes without disposing
  21. Entity Framework 4: How to find the primary key?
  22. .Include() vs .Load() performance in EntityFramework
  23. Max return value if empty query
  24. Group by with multiple columns using lambda
  25. How to do an “in” query in entity framework?
  26. How to Specify Primary Key Name in EF-Code-First
  27. big issue in converting string to datetime using linq-to-entities
  28. Entity Framework: Duplicate Records in Many-to-Many relationship
  29. Keep Getting ‘The LINQ expression node type ‘Invoke’ is not supported in LINQ to Entities’ Exception
  30. Net Core: Using OData in Onion Architecture, Convert Query Parameters Into Linq

Leave a Comment