Network programming in C#, Network Programming in VB.NET, Network Programming in .NET
Available now!
Buy at Amazon US or
Buy at Amazon UK



Articles

» Windows API reference
» Webcam streaming in VB.NET
» Remoting with firewalls
» RSA from first principles
» Key & MouseLogger in .NET
» Networking Resource Kit for .NET
» Migrating VB6 Winsock to VB.NET
» Migrating C++ sockets to C#
» RFC Reference guide
» COM Reference guide
» WMI Reference guide
» SQL stored procedures
» TCP & UDP port reference
» NET Framework reference
» Ethernet Type codes
» MAC address assignments
» DLL entry point reference
» Boost SQL performance
» Free SMS UK
» Free SMS Ireland
» Free SMS South Africa
» Internet Explorer

Contact us

12. “NoDelay” database inserts, with MSMQ & COM+

COM+ / MSMQ Queued components are a means by which methods written in .NET classes can be executed remotely and asynchronously, through the use of MSMQ (Microsoft Message Queue). The benefit of this architecture is that the calling application does not need to wait for a response from the callee.

Like the “NoDelay” construct in MySQL, but unfortunately absent in Microsoft database implementations, such as SQL server or Access, this example permits a calling application to make an asynchronous database insert. This means that an application can make bulk database inserts without slowing down the client application, by delegating the task to MSMQ and COM+.

To use the application, type in DSN (Data source name) into the space provided and an Update or Insert SQL statement. Then press ‘execute’. The program will return immediately, and the message will be queued for execution in MSMQ. Then executed against the database by COM+ component services.

The underlying architecture of COM+, as the name would suggest is COM, however, through the use of .NET interop, it is possible to implement the system in .NET, using implicit RCW’s (Runtime Callable Wrappers)

(Source code availabile in the book Network Programming in .NET (Buy at Amazon UK) (Buy at Amazon US), No Screenshot available)

Page 2  Page 3  Page 4  Page 5  Page 6  Page 7  Page 8  Page 9  Page 10  Page 11  Page 12  Page 13 



Google

Copyright 2015 Open Merchant Account Ltd.