.NET API for SQL Server Service Broker [closed]

问题:

Is there a .NET API or object model for using SQL Server Service Broker?

回答1:

There isn't an official supported API. There are some community samples though which are developed by the Service Broker team or related teams in MS which you can use as a starting point, but they are not officially supported (you cannot call product support and report a bug):

• WCF Transport Channel for SQL Server Service Broker
• SQL Server Service Broker Product Samples
• Service Broker Interface (a .Net API for programming SSB, part of the samples linked above)

回答2:

Checkout this file: https://github.com/jdaigle/servicebroker.net/blob/893a2d9c6a6ef6aed9c1d05dc6a253183a5d7470/ServiceBrokerDotNet/ServiceBrokerWrapper.cs

It's a small wrapper around the T-SQL calls that I wrote. The community samples that other mentioned are more complicated than it needs to be.

回答3:

A easy to use queue library for SQL Service Broker based on rhino-queues

http://github.com/CoreyKaylor/servicebroker-queues

回答4:

I just found a managed library sample (Readme_HelloWorld_CLR Sample) and a complete T-SQL reference here: SQL Server Service Broker.

Updated link: http://msftsbprodsamples.codeplex.com/