C# SQLiteConnection.Dispose方法代码示例

 public void InserindoListaFabricantes(List<Fabricante> fabricantes)
 {
     using (var dbConn = new SQLiteConnection(DB_path))
     {
         dbConn.DropTable<Fabricante>();
         dbConn.Dispose();
         dbConn.Close();
     }
     foreach (Fabricante f in fabricantes)
         this.Inserindo(f);
 }

 async void Login_Loaded()
 {
     try
     {
         await ApplicationData.Current.LocalFolder.CreateFileAsync("Shopping.db3");
         var path = Path.Combine(ApplicationData.Current.LocalFolder.Path, "Shopping.db3");
         using (var db = new SQLite.SQLiteConnection(path))
         {
             // Create the tables if they don't exist
             db.CreateTable<ShopLists>();
             db.CreateTable<ShopAdmins>();
             db.Commit();
             db.Dispose();
             db.Close();
         }
         ServiceReference1.SoapServiceSoapClient sc=new SoapServiceSoapClient();
         sc.AllCouponsCompleted += (a, b) => MessageBox.Show(b.Result);
         sc.AllCouponsAsync("hacking");
       
     }
     catch (Exception ex)
     {
         FaultHandling(ex.StackTrace);
     }
 }

        private void getFromDB(out Dictionary<string, string> dict, string Parent)
        {
            string dbPath = "test.sqlite";
            var db = new SQLiteConnection(dbPath, true);
            var temp = db.Query<Tag>("SELECT * FROM Tag WHERE Parent='" + Parent + "'");
            dict = new Dictionary<string, string>();
            foreach (Tag el in temp)
            {

                dict.Add(el.Path, el.Name);
            }

            db.Dispose();
        }

 //Delete all contactlist or delete Contacts table 
 public void DeleteAllContact()
 {
     using (var dbConn = new SQLiteConnection(App.DB_PATH))
     {
         //dbConn.RunInTransaction(() => 
         //   { 
         dbConn.DropTable<GhiChu>();
         dbConn.CreateTable<GhiChu>();
         dbConn.Dispose();
         dbConn.Close();
         //}); 
     }
 }

 }//DELETE CONTACT THAT I CHOSE
 //DELETE ALL
 public void DeleteAllContact()
 {
     using (var dbConn = new SQLiteConnection(App.DB_PATH))
     {
         dbConn.DropTable<Contactos>();
         dbConn.CreateTable<Contactos>();
         dbConn.Dispose();
         dbConn.Close();
     }
 }

        void CreateDatabase(string dbPath)
        {
            #if __ANDROID__
            var s = Application.Context.Assets.Open(originalDBLocation);
            var writeStream = new FileStream(dbPath, FileMode.OpenOrCreate, FileAccess.Write);
            ReadWriteStream(s, writeStream);
            writeStream.Close();

            #elif __IOS__
            var appDir = NSBundle.MainBundle.ResourcePath;
            var originalLocation = Path.Combine (appDir, originalDBLocation);
            File.Copy (originalLocation, dbPath);
            #endif

            //copies profiles and selected eigenschappen from the old database to the new one
            if (File.Exists(OldDatabasePath)) {
                SQLiteConnection oldDb = new SQLiteConnection(OldDatabasePath);
                SQLiteConnection newDB = new SQLiteConnection(dbPath);

                var oldProfielen = oldDb.Query<Profiel>("SELECT * FROM profiel");
                var oldEigenschappenSer = oldDb.Query<Profiel_eigenschappen>("SELECT * FROM profiel_eigenschappen");
                foreach(Profiel p in oldProfielen)
                    newDB.Execute("INSERT INTO profiel (name, nid) values (?, ?)", p.name, p.nid);

                foreach (Profiel_eigenschappen pe in oldEigenschappenSer)
                    newDB.Execute("INSERT INTO profiel_eigenschappen (name, eigenschappen_ser) values (?, ?)", pe.name, pe.eigenschappen_ser);

                oldDb.Dispose();
                newDB.Dispose();
                File.Delete(OldDatabasePath);
            }
        }

 //~~~delete all activities
 public void DeleteActivities ()
 {
     using (var dbConn = new SQLiteConnection(this.KreyosDBPath))
     {
         //dbConn.RunInTransaction(() => 
         //   { 
         dbConn.DropTable<Kreyos_User_Activities>();
         dbConn.CreateTable<Kreyos_User_Activities>();
         dbConn.Dispose();
         dbConn.Close();
         //}); 
     }
 }