I know EF, nHibernate, Subsonic etc could do all this for me but in this case, for various reasons, I am having to roll my own. :)
I know EF, nHibernate, Subsonic etc could do all this for me but in this case, for various reasons, I am having to roll my own. :)
Why don't you use SubSonic or one of the other ORM mapping tools to define working conversions between Sql datatypes and .Net datatypes - and then roll your own solution using this information on the conversions as a basis?
I'm assuming that you can't use third-party software in the solution - but you can in coming to a solution.