public static void UpdateUrlTrackerTable() { if (UrlTrackerRepository.GetUrlTrackerTableExists()) { var folderName = GetFolderName(); for (var i = 1; i <= 3; i++) { var alreadyAdded = false; if (DatabaseProvider == DatabaseProviders.SqlServerCE) { //Check if columns exists var query = EmbeddedResourcesHelper.GetString(string.Concat(folderName, "check-table-" + i + ".sql")); if (!string.IsNullOrEmpty(query)) { var reader = _sqlHelper.ExecuteReader(query); while (reader.Read()) { alreadyAdded = true; } } } if (!alreadyAdded) { var query = EmbeddedResourcesHelper.GetString(string.Concat(folderName, "update-table-" + i + ".sql")); if (!string.IsNullOrEmpty(query)) { _sqlHelper.ExecuteNonQuery(query); } } } } }