Export SDF database contents as JSON file

Vote count:

0

I have a C# Windows Forms project which uses a Sql Server Compact (SDF) database for only retrieving data. My application does not update the database. Thus the database is static. I recently read somewhere that for such kind of static work it is best to use XML or JSON as they reduce the I/O time which is spent on connecting to the database, retrieving,and closing the database. Is this true?

If So, is there a way by which I can directly convert my database contents to that of a JSON file? It has 7 tables(relations) now and total of 850 rows(tuples) of data. The data is in Kannada language and not English(if this makes any diff).

asked 31 secs ago

bboyetricks

21

Export SDF database contents as JSON file