Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Is it possible to access SQL Server Service Broker from a C# app?

I want to use the SQL Server Service Broker to generate a message (inside SQL Server) and for it to be read in an external C# app.

I am limited to Windows 2003 running SQL Server 2005. I've read a bunch of articles, that allude to this being a possibility, but I do not see an example anywhere. Is this possible?

like image 473
AngryHacker Avatar asked Sep 11 '12 16:09

AngryHacker


People also ask

How can I access my SQL Server database from another computer?

To connect to the Database Engine from another computer On a second computer that contains the SQL Server client tools, log in with an account authorized to connect to SQL Server, and open Management Studio. In the Connect to Server dialog box, confirm Database Engine in the Server type box.


1 Answers

T-SQL has statements for accessing Service Broker: SEND, RECEIVE and others. You can use ADO.NET to execute them.

like image 194
usr Avatar answered Sep 28 '22 04:09

usr