I got the following error while executing the linq query "LINQ to Entities does not recognize and this method cannot be translated into a store expression."
LINQ Query:
var queryresult = (from x in db.Specifications
where x.Brand.Name.Contains(brand)
select
new specsModel { specificationid = x.SpecificationId, Title = x.Title,
Picture = System.Configuration.ConfigurationManager.AppSettings["BlogUrl"] + db.Pictures.Where(p =>
p.SetActive == true && p.SpecificationId == x.SpecificationId).ToList().
FirstOrDefault().Path }).ToList();
Solution:
var stringURL = System.Configuration.ConfigurationManager.AppSettings["BlogUrl"];
I assigned the value to the string variable and passed in to the linq query and executed. It works fine.
var queryresult = (from x in db.Specifications
where x.Brand.Name.Contains(brand)
select
new specsModel { specificationid = x.SpecificationId, Title = x.Title,
Picture = stringURL + db.Pictures.Where(p =>
p.SetActive == true && p.SpecificationId == x.SpecificationId).ToList().
FirstOrDefault().Path }).ToList();
Post your comments / questions
Recent Article
- How to programmatically modifying the AppSetting value in web.config using c#?
- TypeError [ERR_INVALID_CALLBACK]: Callback must be a function. Received undefined
- How to calculate the age from jQuery ui datepicker using c#?
- How to calculate days difference between two dates in c#?
- Changing date format in jQuery ui datepicker
- How to set value to nicedit textarea using jQuery?
- How to load data from json file in angular?
- cannot find module consider using '--resolvejsonmodule' to import module with json extension angular
Related Article