.NET API for SQL Server Service Broker [closed]
Que开发者_StackOverflow中文版stions asking us to recommend or find a tool, library or favorite off-site resource are off-topic for Stack Overflow as they tend to attract opinionated answers and spam. Instead, describe the problem and what has been done so far to solve it.
Closed 8 years ago.
Improve this questionIs there a .NET API or object model for using SQL Server Service Broker?
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.
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).
A easy to use queue library for SQL Service Broker based on rhino-queues
http://github.com/CoreyKaylor/servicebroker-queues
I just found a managed library sample (Readme_HelloWorld_CLR Sample) and a complete T-SQL reference here: SQL Server Service Broker.
精彩评论