private static void CreateDatabaseFromJson(string dbFileName) { //CleverWeather.SiteListUtils.ForecastTest(System.Console.Out); var connection = new SQLite.Net.SQLiteConnection(new SQLite.Net.Platform.Win32.SQLitePlatformWin32(), dbFileName); //Create tables and populate city table if needed if (connection.RowCount <City>() == 0) { //Create tables connection.CreateTable <City>(); connection.CreateTable <CurrentConditions>(); connection.CreateTable <Forecast>(); var assembly = System.Reflection.Assembly.GetAssembly(typeof(CleverWeather.SiteListUtils)); connection.InsertAll(CleverWeather.SiteListUtils.GetEmbeddedCitiesResource(assembly), typeof(City)); } }