Good morning,



I am revisiting a topic that may have been touched on before (I did search for it, but could not find any direct forum entries). I apologize if I am re-walking on some old ground.



I'd like to have a mechanism to alert the user that a database connection has been lost or regained. Is it possible to get this information from the DataLayer? Or, do I need to create my own test (perhaps in its own thread?) and bubble up the response to the currently running application thread? Ideally, I prefer a graceful message to the end-user that the connection to the database is down and all data access functionality has been temporarily stopped. After the connection is reestablished, the system would generate a message to the end-user that the connection is back online and work can continue normally. For a similar functionality, consider the message Outlook provides when the Exchange server cannot be communicated with.



Thanks!

Bill

Thanks Trent and Greg,



Our company has two locations with a dedicated T1 line between them. Over-utilization and other external factors bring down that line a little too often for comfort's sake. Remote users experience an annoying disconnect from the data server. Sometimes users will connect via a VPN. Occasionally, these types of connections have problems, too, for a myriad of reasons.



I have steered away from a base BO. The purist in me wants to utilize the framework "as is" as much as I can; however, I can see where the code outlined would be a real help. I'll look into this.



Sometimes, I pull data without using a BO, though (reporting, specialized grids, etc.). That's where I really need to try to incorporate a more global solution. The asynchronous class may provide the functionality that I am looking for. I have my homework to do.



Bill

If I create a BaseBO class from which all of my BOs inherit, does it need to have the "Serializable()" attribute?

Creating a Base BO is still using the framework as it is designed.  If you download the StrataFlix sample you will see a Base BO there.  But yes, include the serializable tag.