title: Where all List values are equal to column List
body: <p>Hello I have a problem and i cant solve it for 3 days. I've red many posts here and in google, but I cant find the solution.</p>
  
  <p>In db I have column "Gener" - nvarchar(350) which contains for example this:</p>
  
  <pre><code>row 1: 1,4,32,11
  row 2: 32,11
  row 3: 1
  row 4: 4,56,1,23
  row 5: 4
  </code></pre>
  
  <p>From checkboxlist I check this values: 1,4 which add to  </p>
  
  <pre><code>List&lt;string&gt; gnr = new List&lt;string&gt;();
  </code></pre>
  
  <p><strong>The result which I want is row 1 and row 4.</strong></p>
  
  <p>I've made (take from stackoverflow) code which result is row 3 and row 4:</p>
  
  <pre><code> var result = from m in db.Movies
                where gnr.Contains(m.Gener)
                select m;
  </code></pre>
  
  <p>And code which result is row 1, row 3, row 4 and row 5:</p>
  
  <pre><code>foreach (string term in gnr)
  {
      var trb = db.movies.Where(o =&gt; o.Gener.Contains(term));
  }
  </code></pre>
  
  <p>With Ole DB I can make it, but with LINQ I can't here is the code there:</p>
  
  <pre><code>List&lt;string&gt; Gener = new List&lt;string&gt;();
  Gener = Action,Comedy
  
  StringBuilder builder = new StringBuilder();
  string lastItem = Gener[Gener.Count - 1];
  
  // Here I made string Which I'll add to cmd string
  foreach (string safePrime in Gener)
  {
      if (safePrime != lastItem)
      {
          builder.Append("((gener LIKE '%" + safePrime + "%')) AND").Append(" ");
      }
      else
      {
          builder.Append("((gener LIKE '%" + safePrime + "%')) ORDER By ID DESC").Append(" ");
      }
  }
  
  string dbSelect = builder.ToString();
  
  //The result from loop
  dbSelect = "((GenerLIKE '%Action%')) AND ((GenerLIKE '%Comedy%')) ORDER By ID"
  //Add dbSelect to exist cmd
  Cmd1.CommandText = "SELECT * FROM movies WHERE " + dbSelect;
  </code></pre>
  
  <p>And the result here is what I want with LINQ, select all movies that are Action and Comedy
  Thanks for the time you red this, I'll be very thankful for some help. Sorry for my english I hope it is readable.</p>