NHibernate is a open source Object-Relational Mapping (ORM) tool. This ORM tool hides sql query complexities by replacing query with mapping and class object.
Every .Net Project can use Nhibernate to work with database.
The purpose of NHibernate is to save developers work time thus increasing productivity. Large application may get more benefit from NHibernate than small app.
This blog post gives Asp.Net & NHibernate dummy examples. These examples cover select / retrieve records and insert a new record.
First thing first, we need to download Nhibernate files. Please download the zip file from http://sourceforge.net/projects/nhibernate/
As a brief, we need xml mapping file, a class which representates DB table, Nhibernate dll file, NHibernate xml configuration file, and Asp.Net file it self that contains NHibernate configuration object, NHibernate session etc to provide data to UI.
I use VS 2010 Express & SQL Server 2008 R2 to build this example.