Comparison of handwritten ADO / Sprocs with nHibernate

Question

I go back and forth between using nHibernate and the manually written ado.net/stored routines.

I am currently using codemith with templates that I wrote that spit out simple classes that display my database tables, and it transfers my stored procedures to my data level and a subtle level of business logic that just calls my data level and returns objects (1 object or collection).

This application is a web application used for online communities (mainly a forum).

I am watching a summer nhibernate video right now.

Will using nHibernate make my life easier? Will it be easier to update the database schema? What effects will affect performance?

Is nhibernate setup and provides her optimal headache?

I don’t need a complex or deep object model, I just want classes to display my tables and how to extract data from my other tables that have foreign keys to them. I do not need a very complex OOP model.

Answer 1

NHibernate can definitely make your life easier. Updating your database schema will certainly be easier, because when you use ORM, you do not have stored procedure APIs that prevent the reorganization of your database schema to fit the changes in your business model.

LOT, , , DBA.

DBA , , . , , - , (.. , , DBA... , .)

( SQL Server... Oracle), , - , . SQL Server, , , .

OR mappers , ... , , . LINQ to SQL , - , DBA . DBA, L2S, , . , , ( ) , , , ( 30 L2S 400 ).

DBA , , ORM SQL, . (, , SQL Server), SQL Server ( , , ..), , . , , SQL Server 2005 -, Plan Guides, ( proc, sql ..). , , , , ( .)

, OR-, NHibernate (LLBLGen , ). LINQ to Sql Entity Framework - Microsoft (L2S EF 4.0 .NET 4.0... , , , outpace, NHibernate.) ORM ORM, , . ( /... ... ), ORM .

Answer 2

NHibernate , . . "Fluent NHibernate" XML-, .