title: Querying on collection of strings with NHibernate
body: <p>I have an "Item" class, and this class has a collection "Tags".</p>
  
  <pre><code>Item
      IList&lt;string&gt; Tags;
  </code></pre>
  
  <p>my DB looks like this:</p>
  
  <pre><code>Items
     Id
  
  Tags
     ItemId
     TagName
  </code></pre>
  
  <p>I am trying to get all Items which have the tags "x" and "y". How can I do this with NHibernate (preferably with criteria API)? Is it even possible?</p>
  
  <p>Thanks.</p>
  
  <p>EDIT:
  can I do it without mapping the Tag object? It doesn't have ti be 1 query.
  Something like </p>
  
  <ol>
  <li><p>var q = query that will return all id's of objects that have tag x or tag y".</p></li>
  <li><p>var res = query that will return all Items with Id in ( q.Execute())</p></li>
  </ol>