- NHibernate Linq's Fetch with Inner JoinNHibernate implementation for Linq's Fetch will only produce outer join. Unfortunately even with its latest version NHibernate 4.0, it doesn't support inner join yet. I found this open source library that is an extension to NHibernate to create inner join.
read more ...Linq NHibernate 4.0 and paging in Sql Server 2008 Vs. Sql Server 2012Sql Server 2012 changed the way doing the paging to make it faster and better, but it changed the syntax as well.
Adding to that NHibernate's Linq implementation for Take and Skip before version 4.0 didn't optimize the generation of sql paging, specially if you are using IQueryable to build the sql statement.
read more ...Some NHibernate Magic: Joining two tables on computed columnsLook at this Linq to Nhibernate code, and see how it is translated to sql for Microsoft Access database:
read more ...NHibernate Mapping: all details of mapping one to manyThere are lots of details on how to map list of Items with NHibernate.
This an in-depth look at what all of the options and details.
read more ...NHibernate Unit Testing: Test mapping using NHibernate built-in unit testBecause testing NHibernate mapping between objects, and database, is something everyone who is using NHibernate has to do. NHibernate community provides a ready helper that will just do that for us.
read more ...NHibernate Unit Testing: Using SqLite for in memory database unit test.SqLite with memory storage is a very good option when it comes to unit test data access layer.
read more ...NHibernate Mapping: Map composite keyLet us have the following domain model example:
read more ...NHibernate auditingHow to use NHibernate features to audit transactions to database?
I am going to list some steps, which you can follow to enable NHibernate auditing:
read more ...NHibernate Mapping: Map a list of componentsA "Component" in NHibernate is a way of modeling an object that has bunch of properties, but it is not a separate entity, because it doesn't have an ID.
read more ...