NHibernate for .NET

NHibernate is a port of Hibernate Core for Java to the .NET Framework. It handles persisting plain .NET objects to and from an underlying relational database. Given an XML description of your entities and relationships, NHibernate automatically generates SQL for loading and storing the objects. Optionally, you can describe your mapping metadata with attributes in your source code.

NHibernate supports transparent persistence, your object classes don't have to follow a restrictive programming model. Persistent classes do not need to implement any interface or inherit from a special base class. This makes it possible to design the business logic using plain .NET (CLR) objects and object-oriented idiom.

NHibernate key features:

Natural programming model - NHibernate supports natural OO idiom; inheritance, polymorphism, composition and the .NET collections framework

Native .NET - NHibernate API uses .NET conventions and idioms.

Support for fine-grained object models - a rich variety of mappings for collections and dependent objects

No build-time bytecode enhancement - there's no extra code generation or bytecode processing steps in your build procedure

The query options - NHibernate addresses both sides of the problem; not only how to get objects into the database, but also how to get them out again

Support for "conversations" - NHibernate supports long-lived persistence contexts, detach/reattach of objects, and takes care of optimistic locking automatically

Free/open source - NHibernate is licensed under the LGPL (Lesser GNU Public License)

Lets Start Coding :

Download NHibernate DLL and refer in Project

http://umn.dl.sourceforge.net/sourceforge/nhibernate/nhibernate-1.0.4.0.zip

NHibernate Create,Update,Delete Document [Simple example is explained]:
http://sdesmedt.wordpress.com/2006/06/13/nhibernate-part-2-crud-with-nhibernate/

NHibernate Create,Update,Delete SourceCode :

http://www.box.net/index.php?rm=box_v2_download_shared_file&file_id=f_13824980

[you will get a different Configurations for different database]
http://www.hibernate.org/361.html?cmd=prntdoc


Very Good Document :
http://www.hibernate.org/hib_docs/nhibernate/html_single/