New to Android and IOS device apps and Xamarin, but years of experience with C# and Windows Phone/desktop apps, but this has stumped me.
I have an application (Android to start with, then the IOS and Win versions later) that will be used for safety testing equipment in the field.
An XML gets downloaded to the tablet once a day with a Windows PC application (via USB/Wireless - there will be no webservices involved).
This XML I need to then "import" into a SQLite database on the tablet. The App will update the data in the database throughout the day. At the end of the day, the updated data gets extracted from the database and placed into an "export" xml file that gets re-imported into the PC app
With the apps I have written over the years, I just easily load the XML into a Dataset and use the Dataset. Obviously, cant do this under Android/IOS hence using a DB.
I have looked at code for creating the SQLite DB and to de-serialize the XML (haven't put anything together yet) but most of it seems doable but with a lot of code to get the desired result.
So, some questions.
1) Have others done this how did they accomplish it.
2) Is loading this into a SQLite database the best way (I hate json but if you suggest that and provide a sample then I will experiment).
3) I need to create the Database from scratch everyday as the Database will only contain data relevant for that days work.
4) Do I need to de-serialize the XML to get the fields/data from the XML file to update the DB, or can it be done a different way. The reason I ask is that I have looked at Xamarin's Working with Files document. In their example, they only seem to be using 1 field called Monkey in their LIST Type to de-serialise the XML into, BUT, my exported XMLs (there will be one per DB table) contain multiple fields and data and I am stumped at how can it be de-serialized if I don't know all the "fields" or have a "LIST Type" (well, I know them from the PC app side, but I was hoping I didn't have to hard code them).
I'm not after a full coded solution, just some ideas on how you would go about this. Maybe I am trying to make this too complicated (or more likely confused from all the different samples I have seen).