Getting Started with "NHibernate" hql

In NHibernate HQL can help us to turn into the final dependent database query script;

Syntax is also very strong, suitable for the mainstream database, HQL does not support union, to take multiple table data can do two separate queries.

IQuery query =                nhibernatehelper.opensession ()                    . CreateQuery (                        @ "select p from Product as p,product as pp where p.name=pp. Name");                                    = query. List ();             = result. GetEnumerator ();              while (ENU. MoveNext ())            {                object[] obj = (object[]) enu. Current;                 }

HQL

Select  from  as  as where p.name=pp. Name

MSSQL

Select  as  as  as  as  from where product0_. Name=product1_. Name

Getting Started with "NHibernate" hql