NHUnit 1.0.0

NHUnit

NHUnit is a simple but powerful Unit of Work and Repository pattern implementation for NHibernate which fixes proxy issues and simplifies child nodes loading. NHUnit provides sync and async versions for each method.

Eager loading

Using lambda expressions you can specify which child properties should be populated. The framework will determine the fastest approach to load the data: using join, future queries or by using batch fetching. Depending on the number of returned rows and the depth you might need to finetune your queries, but in most of the cases the framework takes the best decision.

var customer = await _dbContext.Customers.Get(customerId) //returns a wrapper to configure the query
               .Include(c => c.Addresses.Single().Country, //include Addresses and Country
                   c => c.PhoneNumbers.Single().PhoneNumberType) //include all PhoneNumbers with PhoneNumberType
               .Unproxy() //instructs the framework to strip all the proxy classes when the Value is returned
               .Deferred() //instructs the framework to delay execution
               .ValueAsync(token); //this is where the query gets executed

The expression c.Addresses.Single().Country will load all the nested child objects. Addresses is a colection and you need to use Addresses.Single() to include the nested children. The whole collection will be populated, not just the first item.

Unproxy

You can use IUnitOfWork.Unproxy, ISingleEntityWrapper.Unproxy or IEntityListWrapper.Unproxy

var customer = await _dbContext.Customers
                    .Get(customerId) //returns a wrapper to configure the query
                    .Unproxy() //instructs the framework to strip all the proxy classes when the Value is returned
                    .ValueAsync(token); //this is where the query gets executed

Transactions

IUnitOfWork exposes:

• BeginTransaction
• CommitTransactionAsync - pushes changes and commits transaction
• RollbackTransactionAsync
• SaveChangesAsync - pushes changes to DB but doesn't commit transaction (if any)
• ClearCache - evict all loaded instances and cancel all pending saves, updates and deletions

Procedures/Queries

In some rare cases you need to execute your own queries and NHUnit provides this functionality:

• ExecuteListAsync
• ExecuteScalarAsync
• ExecuteNonQueryAsync