I have List Of string Like as "one" , "two" , "three" ,...
I want Search From DataBase and select All Items Where have At least On of them , I wnat do this by Entity framwork , To do this I use :
if (SearchVM.Tags.Count > 0) //SourceList= SourceList.Where(x=>x.Tags.Where(...));
its dont work, its wrong and Incomplete.
By T-sql is :
select * from SourceList where tagname in (select name from SearchList)