Why LINQ to Entities does not recognize the method 'System.String ToString()?

asp.net-mvc, entity-framework, linq

Solution

That can't be converted to SQL. I guess, in theory, it could, but isn't implemented.

You just need to perform your projection after you have your results:

var pricingSecurityID = (from m in dbContext.Reporting_DailyNAV_Pricing
                                     select m.PricingSecurityID).AsEnumerable()
    .Select(x => new SelectListItem{ Text = x.ToString(), Value = x.ToString() });

Problem

Getting error inside MVC3 web application. `LINQ to Entities does not recognize the method 'System.String ToString()' method, and this method cannot be translated into a store expression.` when i try to fetch values using EF from query : ``` public class DataRepository { public mydataEntities1 dbContext = new mydataEntities1(); public List<SelectListItem> GetPricingSecurityID() { var pricingSecurityID = (from m in dbContext.Reporting_DailyNAV_Pricing select new SelectListItem { Text = m.PricingSecurityID.ToString(), Value = m.PricingSecurityID.ToString() }); return pricingSecurityID.ToList(); } } ```

Original source

Related problems