I've uploaded a

PDF document
about my

SqlTx class library
 as
promised.
This is a first draft and I do need to put a little more effort
into it but I wanted to post what I'd done so far because I won't
have much time spare this week now to go further. I've tried to
explain the the justification for writing the library and the
assumptions that went into it. I've also described how the code
works to a degree but you should probably read this whilst also
looking at the source code.

One thing I didn't mention before is that the SQL scripts and
the C# code for the data components in the unit tests code were
generated automatically from a tool using an XML description
of the data and methods. I plan to release this VS.NET code
generator too once I've tidied up the source. It is amazing how
much more productive you feel when you can implement T-SQL stored
procedures and a C# data layer complete with transaction support
just by describing the data and operations you want leaving you to
get on with the business logic.

As always I would appreciate any feedback you have about this
project.