Several query methods of NHibernate

SQL: Normal SQL queries (i.e., query statements for databases such as Sqlserver,oracle,sybase, recommended for use based on TSQL-92)
Core object:createsqlquery
IList list = session. Createsqlquery (SELECT * from Tabuser). Addentity (typeof (Tabuser)). List ();

HQL: Hibernate query
Core object:createquery
IList list = session. CreateQuery ("from Tabuser t where T.id>:id"). SetString ("id", "10"). List ();

criteria: Standard or conditional query, Icriteria has a number of properties and methods to choose from, which facilitates the construction of dynamic run-time queries, meaning that this approach can build complex queries.
Core object:Createcriteria
IList list = session. Createcriteria (typeof (Tabuser)). List ();

Lambda: An expression query
In NHibernate 3.0 or higher, use lambdas strongly typed.
Core object:queryover
IList list = ISession. Queryover (typeof (Tabuser)). List ();

LINQ: LINQ Query
NHibernate 2 and 2.1:isession.linq
Core object:Linq
IList list = from T in session. Linq () select t;

NHibernate 3.0:isession.query
Core object:Query
IList list = from T in session. Query () select t;

spring.net: Spring.net Way
Using Spring.dao;
Using Spring.Data.NHibernate.Support;
Core object:hibernatetemplate
IList list = Hibernatetemplate.find (HQL);
Note The HQL statement here, please refer to the Hibernate query above

Note: Hibernatetemplate is not just find, but also the use of various save,update,delete and so on.
The same ISession object also has the use of save,update,delete and so on, just to finally need the session. Flush () To submit data, of course, these already belong to the database of CRUD statements, has exceeded the scope of this article, it is not described here.

Several query methods of NHibernate