"Although I feel perfectly comfortable in a set-based world writing SQL, it has traditionally been one of my least favorite areas of coding. Besides being relatively repetitive and tedious, at least when it comes to basic CRUD operations, sprocs are much more difficult to handle when it comes to source control, versioning, debugging, and unit testing."

and

"Regardless of the approach taken, I definitely no longer believe that sprocs should play any significant role in any application."

I couldn't agree more!  Read the full article: http://www.caffeinatedcoder.com/just-say-no-to-manual-crud/

Barry

this has taken me a lttle while to work out today so this might save time for you guys....

The most likely use of precision sql data types is in the use of "Money".... This is not a valid .Net/C# datatype but maps to a "Decimal(19,4)".  Use the Decimal as the property datatype for moeny fields because it iis more precise, this can then be mapped using the following in NHibernate:

<property name="[Property Name]" type="Decimal(19,4)">

      <column name="[Column Name]" sql-type="Money" />

</property>