Last post Sep 16, 2010 01:14 AM by toas1
Sep 15, 2010 05:54 AM|ziyad67|LINK
I have a WPF Windows application with sqlite database which we distribute to our clients. The application consists of some database table which changes every month. eg. the application users a exchange rate table which is valid for one month.
What is the best approach to update the data in these table. Please note that the whole application is not changing but only the data in it changing, no change to structur of the database or table.
Please guide me with some options how I can achieve this task.
Sep 15, 2010 06:58 AM|toas1|LINK
Why not have your application download a new database file using a web service when ever its needed?
The sqlite db is pretty compact and to stream over the complete db file couldnt be much more heavy then to downolad the data and update the data?
Sep 15, 2010 02:19 PM|ziyad67|LINK
The data base has records specific to clients it self. So if I provide the whole database as downlaod ,then the data entered by the users will be gone. I only need to update few tables.
Sep 16, 2010 01:14 AM|toas1|LINK
Then the easiest way I think would be to create some simple data transfer objects that reflect your tables and expose a method in a WCF service where you can fetch them.