How can I create and menage two and more tables with SQLite - Windows Phone 8?

Question

I am working on my Diploma work (Windows Phone 8 project), but unfortunately reached an impasse and don't have much time for more searching, so I beg you for help. I am using the following Tutorial: https://code.msdn.microsoft.com/windowsapps/WindowsPhone-8-SQLite-96a1e43b. Everything here is clear, but can someone give me an example (where and how the code should be updated) how to create related table with one 'String' (City) for example, so I can display the data (in this case name and phone number) only for the chosen city.

Answer 1

I suggest you to use SQLite-Net (https://github.com/praeclarum/sqlite-net) You can install the library using Nuget and is very easy to use.

It has some limitations, but it will simplify the way you create tables, insert/read data, etc...

There are tons of documentation on How to use Sqlite-net...