NHibernate 使用 SqlQuery

var db = this.ObjectContainer.Resolve<NorthwindContext>();

var sqlQuery = db.Session.CreateSQLQuery("select count(0) as c from categories");
sqlQuery.AddScalar("c", NHibernateUtil.Int32);
var count = sqlQuery.UniqueResult<int>();

var db = this.ObjectContainer.Resolve<NorthwindContext>();
var sqlQuery = db.Session.CreateSQLQuery("select {c.*} from categories {c}")
    .AddEntity("c", typeof(Category));
var result = sqlQuery.List<Category>();

var db = this.ObjectContainer.Resolve<NorthwindContext>();
var sql = "select {p.*}, {c.*} from products {p} join categories {c} on p.CategoryID = c.CategoryID";
var sqlQuery = db.Session.CreateSQLQuery(sql)
   		.AddEntity("p", typeof(Product))
   		.AddJoin("c", "p.Category");
var result = sqlQuery.List<Product>();