I have been working on these for a while now. It all started  when I had to adapt to DBA style naming conventions. I wanted to automate everything because 16 tables with almost the same number of columns becomes a lot of text to write . Yeah I have to override a column name every now and then b... [More]

This is a very naive and silly attempt but it’s working. I suppose under high work load and supporting many databases I guess you need to shield the web servers from having to host too many SessionFactories. This was the simplest way I could think of. I am actually getting the connection string as ... [More]

If I had it my way we would probably have the whole darn thing in one and the same table but that would not work out long term. The problem I was facing was to fetch one entity based on values in the parent and 2 other (to the parent) related entities. Then I want to eagerly fetch information from t... [More]

It’s great for several reasons. I’ll try and cover some of them briefly It detects possible problems with your configuration / mappings and this is fantastic. You spot those N+1 and Unbounded result sets before someone complains about a crash or performance issues. It outputs the SQL... [More]

NHibernate performance sucked yesterday. Not because NHibernate itself is slow but because I wasn’t using it correctly. In a (by yours truly) newly created system I was not only using NHibernate for minimal performance. I was also using it in an unsafe manner. In case something went to hell there wa... [More]

First of all I just want to state that I have no idea what I am doing but by the looks of things it is working… :) I found a ICustomType that I was almost happy with except that it stored the XmlDocument as varchar(4000). I’ll add that code at the end because it is 100 something lines. Let’s start w... [More]

By coincidence I found something called Fluent NHibernatewow automatic mappings etc. After having a read up on NHibernateI also found something called NHibernate Validationthat seemed to serve my purposes well. The only reason for having a look around was to easily add validation to my classes. I fo... [More]