SqlLite.Net: Tables creation and schema changes strategies

Hello,

I'm looking for best practices on when and where to create/initialize your tables when using SqlLite.Net as well as how to properly handle schema changes from one version to another.

It seems I could roll my own using large SQL files or use some library that can do the updates for me…
I have found some code on the internet but I do not seem to have the right references:


Core.Instance.dbConn = new SQLiteConnection (Core.Instance.DatabaseName, true);

Core.Instance.dbConn.CreateTable<tblSettings> ();

Where can I find the CreateTable, and is it re-entrant, and so it can run on every launch of my program?  Any help is appreciated.

Thanks
Andy

Sent from Mail<https://go.microsoft.com/fwlink/?LinkId=550986> for Windows 10

_______________________________________________
sqlite-users mailing list
[email protected]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users