Exemplo n.º 1
0
        public static Database InitDatabase(string databaseFile, IHelperLogger logger)
        {
            Database db;

            if (!File.Exists(databaseFile))
            {
                SQLiteConnection.CreateFile(databaseFile);
                db = new Database(GetConnectionString(databaseFile), providerName: "System.Data.SQLite");
                try
                {
                    db.BeginTransaction();
                    db.Execute(RuntimeTableSQLite.CreateSQLScript);
                    db.Execute(PrivateCards.Site.SiteCardsTableAdapter.CreateSQLScript);
                    db.Execute(PrivateCards.Note.NoteCardsTableAdapter.CreateSQLScript);
                    db.Execute(PrivateCards.Device.DeviceCardsTableAdapter.CreateSQLScript);
                    db.Execute(PrivateCards.DataBase.DatabaseCardsTableAdapter.CreateSQLScript);
                    db.Execute(PrivateCards.CreditCard.CreditCardsTableAdapter.CreateSQLScript);
                    db.CompleteTransaction();
                }
                catch// (Exception)
                {
                    db.AbortTransaction();
                    throw;
                }
            }
            else
            {
                db = new Database(GetConnectionString(databaseFile), providerName: "System.Data.SQLite");
            }

            return(db);
        }
Exemplo n.º 2
0
        public static bool UpdateDB(Database db, int currentDbVersion, IHelperLogger logger)
        {
            //try
            //{
            //    db.BeginTransaction();

            //    db.CompleteTransaction();
            //}
            //catch (Exception ex)
            //{
            //    db.AbortTransaction();
            //    return false;
            //}

            return(true);
        }