SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Service Broker: Receiving TCP/UDP messages from .Net TcpListener


Service Broker: Receiving TCP/UDP messages from .Net TcpListener

Author
Message
Drikus Roux
Drikus Roux
SSC Journeyman
SSC Journeyman (82 reputation)SSC Journeyman (82 reputation)SSC Journeyman (82 reputation)SSC Journeyman (82 reputation)SSC Journeyman (82 reputation)SSC Journeyman (82 reputation)SSC Journeyman (82 reputation)SSC Journeyman (82 reputation)

Group: General Forum Members
Points: 82 Visits: 236
Architecturally I am a bit stuck and am hoping to get some help from the forum.

I would like to bridge between a .Net TcpListener object and SQ Server Service Broker\WCF to receive messages onto a queue and to perform subsequent downstream communication and processing. (WCF service as stepping stone if it is required)

It would seem that for both Service Broker and WCF one needs to have compatible end points on each server, in my case on the other end of the TCP/UDP line, i.e. the origin of the messages. This, in my mind means that I either have to have another SQL Server on the other end or a WCF service? I have no control over the technology at the message origin and merely recieve fixed formatted strings, according to a defined specification.

To bridge the gap, I want to keep the current TcpListener object (receiving the messages) but potentially tap into it from Service Broker/ WCF to grab the messages onto a Service Broker queue instead of an MSMQ.

Once on the Service Broker Queue, all the functionality of Service Broker becomes available and subsequent routing is facilitated within SQL Server, where I can also use the CLR for manipulation etc.

Does anyone have some pointers that can aid me in understanding the integration between Service Broker/ WCF and the .Net TcpListener class, thus crossing from .Net into SQL Server for the received messages on a messaging basis?

Your help is much appreciated.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search