NHibernate was chosen as the data access layer because of the flexibility of the framework and ability to make adjustments at implementation. Now the developer does not have to be as concerned about the database but rather how the business domain stores the data. This tool has great power in its ability to dynamically create SQL based upon the mappings within your application. The ORM concepts of this layer make it adapt to the database based upon the database configuration.

The other power of the NHibernate framework exists in the fact that in the cases that basic SQL statements will not handle the business requirements, then a Named Query written with HQL could be applied. This has the same power and benefit of being database agnostic and dynamically changing the SQL to fit the database as needed.

Again, the developer does not have to worry (as much) about the database and how it is created. NHibernate has ability to connect SQL Server, Oracle and other popular databases. It is so flexible that it can even adapt to changes between SQL Server 2000 and SQL Server 2005 based upon your implemented configuration.

And to make the most out of these tools, we are using Active Record on top of the NHibernate libraries so that code generation is easier.

For more information about NHibernate, check out http://www.nhibernate.org

Last edited Nov 4, 2007 at 4:08 AM by pliekhus, version 3


No comments yet.