Which is the best way to use SQLite DB? RRS feed

  • General discussion

  • Hi,

    am developing a Windows Store 8.1 app.

    I want to save some data locally in my app, so am using SQLite i created a DB and added few tables in that and i have added some data to that from Code.

    Which one is the best option from the following?

    1) Creating the DB from the code for the first time opening the app

    2) Attaching  the DB file with predefined structure in the app with in the solution folder.

    Please suggest me the best solution for this.

    Friday, November 21, 2014 6:25 AM

All replies

  • it really boils down to how much data you want to include initially or you can do it from scratch with code at startup for the first time then populate from outside source. 

    if you have a lot of information that would be beneficial to have in the app at runtime then a pre-seeded database would probably best.

    On the other hand if that data can be pulled from an outside source (azure for example), then it would help keep the install sized down to a minimum level.

    Choice of design is left up to you in the end.  What works for you basically.

    Morgan Vermef

    Friday, November 21, 2014 6:59 AM