Is there a .NET API or object model for using SQL Server Service Broker?
相关问题
- sql execution latency when assign to a variable
- Generic Generics in Managed C++
- How to Debug/Register a Permanent WMI Event Which
- What is the best way to cache a table from a (SQL)
- php PDO::FETCH_ASSOC doesnt detect select after ba
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/
A easy to use queue library for SQL Service Broker based on rhino-queues
http://github.com/CoreyKaylor/servicebroker-queues
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):