title: Linq to sql code for contains
body: <p>I have the below code for reading data from sql(linq to sql)</p>
  
  <p>For strSkillchk I may pass single value or more than 1 value based on the value provided I need the output</p>
  
  <pre><code> string[] strSkillchk = new string[] {"10,11"};
   var getskilldim = (from tblskilldim in Skill_Dimensions
   where tblskilldim.Status == true &amp;&amp; strSkillchk.Contains(tblskilldim.SkillSetId.ToString())
           select new Class
           {
               SkillDimenId = tblskilldim.SkillDimenId,
               SkillDimenName = tblskilldim.SkillDimenName
           }).ToList();
  </code></pre>
  
  <p>My sql table looks like</p>
  
  <pre><code>SkillDimenId    SkillDimenName   SkillSetId
    1                 Dimen1          10,11
    2                 Dimen2          11
    3                 Dimen3          10
  </code></pre>
  
  <p>But When I execute the above query it gives me only row 2 &amp; 3
  But I want the follwing output,</p>
  
  <pre><code>SkillDimenId      SkillDimenName      SkillSetId
    1                 Dimen1              10
    1                 Dimen1              11
    2                 Dimen2              11
    3                 Dimen3              10
  </code></pre>
  
  <p>Can any 1 help me fix this problem for linq to sql c#</p>