使用C# 压缩 SQLite 数据库注意事项

                try
                {
                    SQLiteConnection cnn = new SQLiteConnection(@"Data Source=G:\App_Data\Data.sqlite;");
                    cnn.Open();
                    using (SQLiteTransaction dbTrans = cnn.BeginTransaction())
                    {

                        using (SQLiteCommand cmd = cnn.CreateCommand())
                        {

                            try
                            {

                                cmd.CommandText = @"INSERT INTO Students (Name, Description) VALUES   (‘1‘, ‘2‘)";

                                for (int n = 0; n < 100000; n++)
                                {
                                    cmd.ExecuteNonQuery();
                                }

                                dbTrans.Commit();
                            }
                            catch
                            {
                                dbTrans.Rollback();
                            }

                        }

                    }
                }
                catch (Exception ex)
                {
                    Clipboard.SetText(ex.Message + "\r\n\r\n" + ex.StackTrace);
                }

            using (SQLiteConnection connection = new SQLiteConnection(connectionString))
            {
                using (SQLiteCommand cmd = new SQLiteCommand("VACUUM", connection))
                {
                    try
                    {
                        connection.Open();
                        cmd.ExecuteNonQuery();
                    }
                    catch (System.Data.SQLite.SQLiteException E)
                    {
                        connection.Close();
                    }
                }
            }