public void GetProductsByCategoryId() { //IQuery query = UnitOfWork.CurrentSession.GetNamedQuery("GetProductsByCategoryId"); // query.SetInt32("CategoryId", 1); var query = UnitOfWork.CurrentSession.GetNamedQuery("GetProductsByCategoryId", new NHParameter("CategoryId", 1)); var products = query.List <Product>(); foreach (var product in products) { Console.WriteLine(ReflectionTool.ObjectToString(product, true)); Console.WriteLine("\t Category: " + product.Category.Name); Console.WriteLine("\t SuppliedBy: " + product.SuppliedBy.ContactTitle); } }