In LINQ to SQL, how do you determine what column elements is a sub-set of another column (i.e. Like-Sql statement)

Question

Here is some code:

//all possible search terms of interest 
searchTerms = from s in dc.SearchTerms
              select s.term;

//all possible  results  
var results = from r in dc.Data
              select r.hyperlinks;

I want to perform an operation where I get all "r.hyperlinks" that contains s.term. It is something like r.hyperlinks.Contains(s.term). How can I do this?

Answer 1

Hi! It's almost as you wrote it in english:

var results = from r in dc.Data
              where searchTerms.Any(x => r.hyperlinks.Contains(x))
              select r.hyperlinks;

That's all!

You can put any condition you might come up inside a where clause. Actually, you can put whatever returns a boolean.

Answer 2

Local sequences cannot be used in many LinqToSql operators. But your original question didn't require a local sequence.

var results =
    from r in dc.Data
    where dc.SearchTerms.Any(s => r.hyperlinks.Contains(s.Term))
    select r.hyperlinks;