LINQ to Entities does not recognize the method ‘System.String ToString()’ method in MVC 4

by

You got this error because Entity Framework does not know how to execute .ToString() method in sql. So you should load the data by using ToList and then translate into SelectListItem as:

var query = dba.blob.ToList().Select(c => new SelectListItem
    {
    Value = c.id.ToString(),
    Text = c.name_company,
    Selected = c.id.Equals(3)
});

Edit: To make it more clear, Entity framework converts your use of query operators such as Select, Where ETC into an sql query to load the data. If you call a method like ToString(), which Entity Framework does not have an equivalent in sql, it will complain. SO the idea is to defer the use of such functions post data load. ToList, ToArray ETC force execution of the query thus loading of data. Once the data is loaded, any further operation (such as Select, Where ETC) is performed using Linq to Objects, on the data already in memory.

More Related Contents:

  1. How to get DropDownList SelectedValue in Controller in MVC
  2. How to get the public IP address of a user in C#
  3. Passing data between different controller action methods
  4. How to update a claim in ASP.NET Identity?
  5. Proper JSON serialization in MVC 4
  6. Windows Authentication and add Authorization Roles through database – MVC asp.net
  7. {version} wildcard in MVC4 Bundle
  8. How to route EVERYTHING other than Web API to /index.html
  9. MVC4 – Bundling does not work when optimizations are set to true
  10. How to create Select List for Country and States/province in MVC
  11. Display string as html in asp.net mvc view
  12. MVC Form not able to post List of objects
  13. How do I create a custom membership provider for ASP.NET MVC 2?
  14. Could not find a part of the path … bin\roslyn\csc.exe
  15. How to get current user, and how to use User class in MVC5?
  16. How to call another controller Action From a controller in Mvc
  17. prevent property from being serialized in web API
  18. ASP.NET MVC Global Variables
  19. Adding your own HtmlHelper in ASP.NET MVC 3
  20. ASP.NET MVC Razor render without encoding
  21. How to get current page URL in MVC 3
  22. Assign format of DateTime with data annotations?
  23. POST string to ASP.NET Web Api application – returns null
  24. How to manually validate a model with attributes?
  25. Redirect to another page when user is not authorized in asp.net mvc3
  26. How to add and get Header values in WebApi
  27. Web API in MVC solution in separate project
  28. Dealing with large file uploads on ASP.NET Core 1.0
  29. Specify Date format in MVC5 (dd/MM/yyyy)
  30. There is no ViewData item of type ‘IEnumerable’ that has the key country

Leave a Comment