Together with
Where
you have to use
Any[
^] Linq method ;)
Check my past answer to the question:
Multiple values in 1 parameter using LINQ[
^]
My best guess:
var KeyWord = db.tblProfiles
.Where(x => words.Any(y=< y==x.tblCaste.Caste) ||
words.Any(y=< y==x.tblCountry.Country) ||
words.Any(y=< y==x.City) ||
words.Any(y=< y==x.tblOccupation.Occupation) ||
words.Any(y=< y==x.tblMotherTongue.MotherTongue))
.Select(...);
Note: not tested on large portion of data.