in

System.Data.SQLite

An open source ADO.NET provider for the SQLite database engine

Shrink / VACUUM Database - Sample Code C# or VB.NET

Last post 04-22-2008 7:51 AM by Nate. 1 replies.
Page 1 of 1 (2 items)
Sort Posts: Previous Next
  • 04-22-2008 4:24 AM

    Shrink / VACUUM Database - Sample Code C# or VB.NET

    Could someone provide a sample code which demonstrates, how to shink/vacuumize an SQLite Database in VB.NET or C#?

     

    i'd really appreciate!

     

    Christian 

    Christian
  • 04-22-2008 7:51 AM In reply to

    • Nate
    • Top 10 Contributor
    • Joined on 08-28-2005
    • Fort Collins, CO
    • Posts 68

    Re: Shrink / VACUUM Database - Sample Code C# or VB.NET

    Just execute a query of "vaccuum;".

    using (SQLiteCommand command = m_connection.CreateCommand())
    {
        command.CommandText = "vacuum;";
        command.ExecuteNonQuery();
    }

Page 1 of 1 (2 items)
Powered by Community Server (Commercial Edition), by Telligent Systems