Been asked to look at designing an application for engineers in our work place. Basically they need to download a fairly large dataset (lets say 100+ jobs, which maybe be installing one of 30,000 stock items). All the data captured needs to be done in a disconnected fashion with uploads and downloads happening when they have signal.
At the moment the current app which is being replaced downloads a dataset from a webservice and saves each job as an xml files (reads the dataset into memory when they start editing). This is ok, but at the requirements have changed we now need to send a much bigger dataset down to the devices.
Just so you know:
Hardware = Windows Mobile (HD2). This cannot be changed. We are a Microsoft based company.
Language = C# (any version... can upgrade to .Net 4 if required).
After looking around a lot of people seem to suggest SQL Server CE, but they go on about syncing with the main database etc. I don't really want this - I just want to send DTOs (or POJO or what ever they're called) to and from a web service. But if I can inject or extract these from a local SQL Server CE then I don't mind.
Has anyone done anything like this. What works / doesn't work? I've experiemented with xml files and datasets... but with the former especially, when they grow large and you load them into memory there are OOM exception / performance issues galore.
At the moment the current app which is being replaced downloads a dataset from a webservice and saves each job as an xml files (reads the dataset into memory when they start editing). This is ok, but at the requirements have changed we now need to send a much bigger dataset down to the devices.
Just so you know:
Hardware = Windows Mobile (HD2). This cannot be changed. We are a Microsoft based company.
Language = C# (any version... can upgrade to .Net 4 if required).
After looking around a lot of people seem to suggest SQL Server CE, but they go on about syncing with the main database etc. I don't really want this - I just want to send DTOs (or POJO or what ever they're called) to and from a web service. But if I can inject or extract these from a local SQL Server CE then I don't mind.
Has anyone done anything like this. What works / doesn't work? I've experiemented with xml files and datasets... but with the former especially, when they grow large and you load them into memory there are OOM exception / performance issues galore.
