how to get the details from select query like where in

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

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

Hi,Pleace change where condition,

Where areaId.Any(location.AreaId)

Almost you are currect ,may a minor mistake

Can you try these links,

https://pastebin.com/f30868a36

https://stackoverflow.com/questions/194930/how-do-i-use-linq-containsstring-instead-of-containsstring

Thanks.

sir

string[] areaId has values like [1,2,3,4,5,6]

so i tried like what you said there conversion error facing

sir is there any alternate to contains in LINQ

Hi.

Can you change this line,

where location.AreaId.Contains(areaId)

Thanks.