C# (CSharp) System.Data.SqlServerCe.SqlCeEngine.Shrink Examples

Example #1

File: ProductsDataSet.cs Project: ramilexe/tsdfamilia

        public void CleanDatabase()
        {
            using (System.Data.SqlServerCe.SqlCeConnection conn =
                new System.Data.SqlServerCe.SqlCeConnection(
                    Properties.Settings.Default.ProductsConnectionString))
            {
                conn.Open();

                using (System.Data.SqlServerCe.SqlCeCommand cmd
                     = new System.Data.SqlServerCe.SqlCeCommand())
                {
                    cmd.CommandText = "delete from  productsBinTbl";
                    cmd.Connection = conn;
                    cmd.ExecuteNonQuery();
                }

                this.ProductsTbl.Clear();
                this.ProductsBinTbl.Clear();
                this.AcceptChanges();
            }

            using (System.Data.SqlServerCe.SqlCeEngine engine
                 = new System.Data.SqlServerCe.SqlCeEngine(Properties.Settings.Default.ProductsConnectionString))
            {
                engine.Shrink();
            }
            

        }