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
|
I have two applications, a cashier program that uses a SQLCE database, and a back office program that uses SQL Server. We have a requirement to send a subset of the backoffice data to the cashier program, and the transaction information from the cashier program back to the back office program. There are two scenarios for sending this data, in scenario 1, the programs are hundreds of miles apart, and no direct internat access between them, so we need to serialise the data entities in someway and save them to a zip file for emailing. In scenario 2 the programs are on the same LAN, and can use some for of direct connection. Can someone advise me on the best way to serialise large amounts of data. An example of the subset of the data is as follows. On the backoffice there are two tables currencycodes, and currency rates. These tables are joined using the currencycode.Id field to the currencyrates.currencyId field. From these two tables we only need the Id, the currency code, the currency name, and the current exchange rate, for storing in the cashier database. I have tried to make a custom class, and use LINQ, but I cannot deserialize the List<>. I have tried binary serialisation of the currencycode entity, but this makes a very large file. I would welcome all help and ideas on this matter. PS. I have never used WCF, so I have no idea how to use this.
|
|
|
Hi MarkLFT,
Have a look at Microsoft's Sync Framework it might help. http://msdn.microsoft.com/en-us/sync/default.aspx
Johan |
|
|
Hi Johan, Thanks for the reply, but I fear you may have misunderstood my question. Both applications are already using Lightspeed, so I would prefer to continue along that path without switching to another technology. Also, as I understand it, Lightspeed also supports WCF. However, the main point is that, at least for scenario 1, I cannot use WCF, as there is no link between the sites. We transfer data via Flash Disk, the one site is in the jungle, no internet etc. For the second scenario, I guess WCF is a viable option, I am just not sure it is the right one, as all the computers are on the same LAN, and I am not familiar with, and have little time to study, WCF. Regards Mark |
|
|
Hi Mark, This is for your offline scenario What you could try to do add a reference to the System.ServiceModel LightSpeed will then generate the DTO objects for you and you can then load the data from the database and serialize the DTO object to xml or any other format that you need and the copy that to flash disk. The sync framework was a suggestion for you online scenario. I understand that you would want to do everything with LightSpeed. Kind regards, Johan |
|