I still haven't had the chance to use SQL2005 yet but this seems like quite a slow and painful way to do something that could be done so much easier in T-SQL, any reason on why you would go to all this trouble? Until you get down to the level of calling COM objects from your T-SQL I can't see any benefit from using C# or .Net to write SPs.

Anyone agree / disagree?