title: Selecting only a few columns from a table
body: <p>I had problems using c#, nhibernate and link. In the example bellow, I do a SELECT in the BrandTable, but I need only the "Name" and "Id" columns.
  But it always do a select with all columns of the table.
  Using EntityFramework, the same code bellow generates a select with only this two columns.</p>
  
  <p>How to do this in nhibernate?</p>
  
  <pre><code> using (ISession session = MyConnection.GetCurrentSession())
          {
              var brands = from b in session.QueryOver&lt;BrandTable&gt;().List()
                                   orderby b.Name
                                   select new Brand {Id = b.id, Name = b.Name};
  
              return brands.ToList();
          }
  </code></pre>