7

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

Joseph Daigle
  • 47,650
  • 10
  • 49
  • 73
duraid
  • 614
  • 7
  • 16

4 Answers4

5

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.

Joseph Daigle
  • 47,650
  • 10
  • 49
  • 73
  • It's been a while, but I've been looking for the file you mentioned and I cannot find it, would you mind offering another link? – hsim Sep 18 '14 at 19:54
5

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).

Ibrennan208
  • 1,345
  • 3
  • 14
  • 31
Remus Rusanu
  • 288,378
  • 40
  • 442
  • 569
1

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

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

Denis Bakharev
  • 959
  • 1
  • 9
  • 7
0

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

Ibrennan208
  • 1,345
  • 3
  • 14
  • 31
Rubens Farias
  • 57,174
  • 8
  • 131
  • 162