how to get the details from select query like where in

Question

Hi All, I'm New to LINQ, can you help me how to get the details from select query like where in clause ex: public List GetLocationsListDB( string [] areaId) { using (DbHelper db = new DbHelper()) { var locationList = (from location in db.LocationMasters where areaId.Contains(location.AreaId.ToString()) //Ids.Contains(location.AreaId) select new LocationDetailInfo { LocationId = location.LocationId, LocationName = location.LocationDesc }).OrderBy(o => o.LocationName).Distinct().ToList(); return locationList; } } but this logic is not get the details

Ashutosh Gupta · Answer

var locationList = (from location in db.LocationMasters where areaId.FirstOrDefault(c => c.ToString() == location.AreaId.ToString()) != null select new LocationDetailInfo { LocationId = location.LocationId, LocationName = location.LocationDesc }).OrderBy(o => o.LocationName).Distinct().ToList(); you could try Any(), First(), FirstOrDefault extension if contains does not solve your purpose.

Dhara Patel · Answer

Hi,Pleace change where condition, Where areaId.Any(location.AreaId)

Laxmidhar Sahoo · Answer

Almost you are currect ,may a minor mistake

Salman Beg · Answer

Can you try these links, https://pastebin.com/f30868a36 https://stackoverflow.com/questions/194930/how-do-i-use-linq-containsstring-instead-of-containsstring Thanks.

yesubabu k · Answer

sir string [] areaId has values like [1,2,3,4,5,6] so i tried like what you said there conversion error facing

yesubabu k · Answer

sir is there any alternate to contains in LINQ

Salman Beg · Answer

Hi. Can you change this line, where location.AreaId.Contains(areaId) Thanks.