title: Nhibernate 3 Linq - inner joins
body: <p>I'm testing out nhibernate 3 CR, but fails to create the following SQL using Linq:</p>
  
  <pre><code>select   *
       from        Users               as {user}
       inner join  Test                as test  on test.UserId   = user.Id
       inner join  Release             as release on release.TestId = test.TestId
       where Release.Status = 1
       order by    count(release.Status) desc;
  </code></pre>
  
  <p>I have not got so far, my current code is like this and gives me something complete different:</p>
  
  <pre><code>var users = from user in Session.Query&lt;User&gt;()
              join test in Session.Query&lt;Test&gt;() on user.Id equals test.User.Id
              join release in Session.Query&lt;Release&gt;() on test.Id equals release.Test.Id
              where release.Status == 1
              orderby release.Status
              descending 
              select user;
  </code></pre>
  
  <p>Is there any resources on how to use inner joins with linq? And what should I do with:</p>
  
  <pre><code>order by    count(release.Status)
  </code></pre>
  
  <p>Is this something that should be done with QueryOver instead?</p>