What's the best type of TSql/CLR Integration in Sql Server 2005
One of the questions that came up when I was in South Bend is what is the best way to use CLR Objects? Assuming that your solution needs a CLR Object, should you use a Dataset, Generic List (what I tend to show), or a TSQL/CLR integrated solution. Honestly, I don't have an answer to that question, right now. However, I should have something in a couple of days. I have just completed writing the three scenarios that I have. I am going to do some testing and I will be posting my findings after I complete my testing.
Hint: I am seeing a difference in the speed depending on how I structure things.
Cross posted from: http://morewally.com/cs/blogs/wallym/archive/2006/11/27/505.aspx