This thread looks to be a little on the old side and therefore may no longer be relevant. Please see if there is a newer thread on the subject and ensure you're using the most recent build of any software if your question regards a particular product.
This thread has been locked and is no longer accepting new posts, if you have a question regarding this topic please email us at support@mindscape.co.nz
|
Hi, I was wondering if Lightspeed can handle online/offline datasource swapping with synchronisation? The use-case I had in mind is: A telephone directory application which when run from inside the corporate LAN uses the SQL database, when the user is offline the application uses a local copy of the data (SQL Compact, XML, etc). When the user is on the LAN their local database needs to be synchronised and any "Favourites" that the user set whilst offline need to be send back to the main SQL database. Thanks,
|
|
|
|
|
Hi Jon, Yes, LightSpeed certainly supports multiple data sources for the same model through the LightSpeedContext, you would need structure you application in such a way that the LightSpeedContext could be switched in response to the network online/offline events being raised and any active Units of Work flushed and refreshed. In terms of the syncronization, we dont provide any direct facilities to assist with this, so unfortunately for now you would need to look at crafting your own solution around this. If you are using SQL Server you could look at the Sync Framework to provide you with a good solution to cover this. How does this sound in relation to what you are trying to achieve?
Jeremy |
|
|
|
|
Thanks Jeremy, point one certainly covers the data side of things, it's a shame about the sync'ing though. I've not found the Sync Framework that friendly to work with and instructions for its use seem to be a bit sparse. It's a shame that you haven't got the feature in LightSpeed as it would save me a lot of coding and would provide a supported solution. I take it there are no plans for something like this in LightSpeed v3? Thanks for your quick reply. Jon. |
|
|
|
|
Hi Jon :) No, we don't have any fixed plans to build a synchronization engine into LightSpeed, however this is something which has come up a few times now from queries on the forums, so it is something we would be looking to provide a better story around going forward or possibly provide a "simple provider" with pluggable model around similar to what we do for full text search. In your particular case what would you be expecting from a synchronization solution?
Jeremy |
|
|
|
|
We would need a two-way sync keeping a mirror of the whole of the master database(s) on the local machine. For some of our applications we would probably also need a mechanism to handle concurrency - I guess that will be the trickiest part (there would still be some use without the concurrency checker). Most of the applications we write for the organisation need to be able to go off-line on Tablet PC's so the staff can go and work out on farms, etc. They then return to the office later in the day and need to store the new records/changed records back to the master database as well as download the latest changes from the master. It would be great if LightSpeed could offer most of that out-of-the box so you just flag the data model as "Available Offline" and the rest of the logic is handled for you. That would certainly be the selling point that would draw me into switching to LightSpeed. Thanks, |
|
|
|
