13. února 2006 6:18
I've been trying to find examples on how to work with the broker using ADO.Net and haven't found much.
14. února 2006 22:53Moderátor
Unfortunately we did not have time to ship a client ADO.Net programming model in this release. You can always use SqlCommand to execute the Broker statements like BEGIN DIALOG/SEND/END. RECEIVE returns a normal resultset which SqlDataReader will expose just as a SELECT resultset. For DDL (CREATE/DROP/ALTER of Service Broker objects), SMO has extensive support.
The External Activator sample at http://www.gotdotnet.com/codegallery/codegallery.aspx?id=9f7ae2af-31aa-44dd-9ee8-6b6b6d3d6319 has a CLR framework for Service Broker projects, but it is not a supported release.
15. února 2006 0:51
Look at the ServiceBrokerInterface sample that comes with official samples shipped with SQL Server 2005. It should be in the Service Broker directory under Database Engine samples.
The namespace was changed to Microsoft.SqlServer.Samples once we shipped it as a sample.