woensdag 3 oktober 2012

Trace in SQLite. SQLiteTraceEventHandler

To activate Tracing in C# in Sqlite, there is a trick. The connection must be open.

 conn.Open();
 conn.Trace += new SQLiteTraceEventHandler(this.SqliteWriteLog);
 conn.Close();

        private void SqliteWriteLog(object sender, TraceEventArgs e)
        {
            File.AppendAllText("c:\\sqlitelog.txt", e.Statement+"\r\n");
        }