Do you have an example of using TMS.options.localfailover in a service application? I have a thread that inserts data into SQL Server and would like to use this option to ensure the service can recover from a connection loss. More specifically how do I handle the OnConnectionLost event?
Thanks,
Pat
Example of LocalFailOver in Service Application
Re: Example of LocalFailOver in Service Application
SDAC includes FailOver demo project of desktop application, showing how to use the TMSConnection.Options.LocalFailover property and handle the OnConnectionLost event. You can use this demo parts in your service project.
The FailOver demo project is in the "Demos\Miscellaneous\FailOver\" folder, relatively to the SDAC demo projects installation path.
In addition, we recommend to read the Working in an Unstable Network article in our help: http://www.devart.com/sdac/docs/index.h ... etwork.htm
If you have any questions remained after acquaintance with the article and investigation of the demo project, or new questions appear, please ask - we will answer them.
The FailOver demo project is in the "Demos\Miscellaneous\FailOver\" folder, relatively to the SDAC demo projects installation path.
In addition, we recommend to read the Working in an Unstable Network article in our help: http://www.devart.com/sdac/docs/index.h ... etwork.htm
If you have any questions remained after acquaintance with the article and investigation of the demo project, or new questions appear, please ask - we will answer them.