SQL Server Service Broker using DataSet

Question

I am converting a console application to run from Service Broker in SQL Server 2005.

The application makes heavy use of DataSet.

Are DataSets supposed to work in SQLCLR? How do I define the connection to use? Is there any documentation about this?

Thanks for your help!

What do you mean run FROM service broker? SB is in essence a message queuing system. — callisto, Sep 21 '09 at 12:10
He probably means Activation: http://msdn.microsoft.com/en-us/library/ms171617.aspx — Remus Rusanu, Sep 21 '09 at 22:31

score 0 · Answer 1 · answered Sep 22 '09 at 12:42

0

You question is a bit generic, but I hope this helps you: DataSet is contained in the assembly System.data.dll which is one of the approved assemblies for the SQLCLR. So, yes, you can use DataSets.

answered Sep 22 '09 at 12:42

Nestor

13,706
11
78
119

SQL Server Service Broker using DataSet

1 Answers1