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

Question

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();         }     } 

Answer 1

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() });