KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
I have a variable size array of strings, and I am trying to programatically loop through the array and match all the rows in a table where the column "Tags" contains at least one of the strings in the array. Here is some pseudo code: IQueryable<Songs> allSongMatches = musicDb.Songs; // all rows in the table I can easily query this table filtering on a fixed set of strings, like this: allSongMatches=allSongMatches.Where(SongsVar => SongsVar.Tags.Contains("foo1") || SongsVar.Tags.Contains("foo2") || SongsVar.Tags.Contains("foo3")); However, this does not work (I get the following error: "A lambda expression with a statement body cannot be converted to an expression tree") allSongMatches = allSongMatches.Where(SongsVar => { bool retVal = false; foreach(string str in strArray) { retVal = retVal || SongsVar.Tags.Contains(str); } return retVal; }); Can anybody show me the correct strategy to accomplish this? I am still new to the world of LINQ :-)
Tags (comma-separated)
Save Edits
Cancel