Must-to-know before diving into NHibernate

Our company won’t allow developers directly write data into tables, everything must through stored procedure. Although hibernate does support sql-insert, sql-update and sql-delete in mapping file, but please keep in mind what Ayende said,

The disadvantages – You take away from NHibernate the ability to comprehend the structure of the tables, this mean that it can’t do joins, eager fetching, etc. This is extremely important capability that just vanished. Likewise for queries, NHibernate’s abilities to query your objects is being severly limited using this method of operation.

It seems ActiveRecord combined domain layer and data access layer together, which might cause problem when unit-testing. Jay found a way to use stub to unit-test ActiveRecord based on ActiveRecord::ConnectionAdapters::Column. But does dotnet have similar object? Don’t know, is that a reason why Active Record is not very popular in dotnet community?


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s