Use SQL Server/SSB
Implement pub/sub
Integration Mode
In the field of software development, new development tools often introduce new and reliable mature platforms. This technology applies to SQL Server 2005 service brokers. Service Brokers bring about asynchronous messaging technology on the SQL Server database platform. Enterprise integration patterns (edited by Gregor hohpe and Bobby Wolf) is one of the best books on Asynchronous Messaging mechanisms. By interpreting asynchronous messages, the book divides different message design ideas into different software design patterns. According to this book, asynchronous messages are considered to be the communication mechanism between application-to-application, which allows applications with different transaction volumes and processing capabilities. Program Reliable data exchange between applications. By using service brokers, some new T-SQL scripts, some new concepts, and existing SQL Server knowledge, a T-SQL developer can take full advantage of SQL Server 2005's asynchronous messaging capabilities. With the service broker development and design mode, you can select an appropriate solution to implement SQL Server 2005 asynchronous messages. This article Article Shows how to use service broker to implement the general software mode in the enterprise integration patterns book. Because the detailed description of enterprise integration patterns and asynchronous messages is beyond the scope of this article, we will focus on the idea of pub/sub asynchronous message mode. Entlib.comOpen Source Forum team Key recommendations. Visit the following address and read Original English article To understand the overall design concept.
Using SQL Server to implement the publish-subscribe integration pattern Http://forum.entlib.com/default.aspx? In addition, we recommend an article :《 Based onWCFAndMSMQBuild release/Subscribe to message bus (Pub/sub message Bus) , Explains how to build a pub/sub asynchronous message model based on WCF/MSMQ. Http://forum.entlib.com/default.aspx? G = posts & t = 57