title: NHibernate - Incorrect thinking? Subclassed Model based on Join
body: <p>I have a simple model class (Part), which pulls from it's information from a single table (t_Part).</p>
  
  <p>I would like a subclass of this model called (ProducedPart), that would still utilize NHibernate's caching mechanisms, but would only be instances of (Part) that have a foreign key relationship in a table called "t_PartProduction".  I do not <em>need</em> to have a model for this second table.</p>
  
  <p>I only need a read-only version of ProducedPart</p>
  
  <p>I could always implement a Facade/Repository over this, but I was hoping to setup a mapping that would pull "t_Part" joined with "PartProduction" when I asked for "ProducedPart" in NH.</p>
  
  <p>Is this the wrong way to use NH?</p>
  
  <p><strong>Edit</strong></p>
  
  <p>So, the SQL would look something like</p>
  
  <pre><code>SELECT p.* 
  FROM t_Part p 
  INNER JOIN t_PartProduction pp ON pp.PartID = p.PartID 
  WHERE pp.ProductionYear = '2009'
  </code></pre>