Use NHibernate to execute raw SQL

In some cases it’s a lot easier to just write a simple SQL statement instead of using LINQ, HQL or one of the other syntaxes that NHibernate supports.

Executing a raw SQL:

	var query = "SELECT TOP 10000 o.* "
	+ " from ORDERS o where o.Year in (:orderYear));";
	var session = sessionFactory.OpenSession();
	var result =session.CreateSQLQuery(query)
	.SetInt32("orderYear",2012)
	.List();

view raw NHibernateRawSQL.cs hosted with ❤ by GitHub

Converting the result to a typed object:

	var query = "SELECT TOP 10000 o.* "
	+ " from ORDERS o where o.Year in (:orderYear));";
	var session = sessionFactory.OpenSession();
	var result =session.CreateSQLQuery(query)
	.AddEntity(typeof(Order))
	.SetInt32("orderYear",2012)
	.List<Order>();

view raw NHIbernateConvertRawSQLResultToEntity.cs hosted with ❤ by GitHub