Greetings,



I've read several posts about SF serialization, but could not find one complete solution to help me figure out a way of working an online/offline application.

An WMS mobile application or even a simple Point of Sale, that works online with ES, but in case of failure, changes the stream to local storage, binary or XML. Using serialization.



My main question is the approach to BO binding and ES connection status control.

May I have to use 2 BO(online/offline) or may I change the stream type on-the-fly according to ES connection status?



If you could point a pretty simple example in C# will help a lot.

Thanks for the attention,



Alex

I've checked if the db was available just using a normal ADO.NET Connection object. I retrieved the connection string from the DataLayer.DataSources dictionary, then just attempted to open it (inside a try/catch). This keeps connection info encapsulated within the DataSources dictionary.



This won't work with Enterprise Server, as it isn't using an ADO connection.



Just an idea for you to ponder!

With the ES, you could try to do a fill on a business object... something with a WHERE clause of 0=1 so no records are returned is fine.  If you get an exception, then you need to swap to local datasets.  You can do the same for a the SqlDataSourceItem, too, so if you're using ES/Sql and swapping back and forth, then this would be the way to go.