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 

No Comments