David:
I've run out of time for now but below is a sample of the direction I've gone.
Note that there is now no inheritance needed - all work is...

Sergiy:
Most of David's code is general C# so can be used at the front end. The code to use it as back-end is only a few additional lines.

For...

Still playing about with it but I've only looked at refactoring what is already there - ie single results - anything returning multiple results would have to return a string[]...

Hi David
I'm a bit late coming to this discussion - I'm not really a full on SQL developer - I mainly use SQL for storage - but I do...