SourceForge has been redesigned. Learn more.
Close

Diff of /System.Data.SQLite/SQLiteJournalModeEnum.cs [000000] .. [8e2213]  Maximize  Restore

Switch to side-by-side view

--- a
+++ b/System.Data.SQLite/SQLiteJournalModeEnum.cs
@@ -0,0 +1,36 @@
+ďťżnamespace System.Data.SQLite
+{
+    /// <summary>
+    /// This enum determines how SQLite treats its journal file.
+    /// </summary>
+    /// <remarks>
+    /// By default SQLite will create and delete the journal file when needed during a transaction.
+    /// However, for some computers running certain filesystem monitoring tools, the rapid
+    /// creation and deletion of the journal file can cause those programs to fail, or to interfere with SQLite.
+    /// 
+    /// If a program or virus scanner is interfering with SQLite's journal file, you may receive errors like "unable to open database file"
+    /// when starting a transaction.  If this is happening, you may want to change the default journal mode to Persist.
+    /// </remarks>
+    public enum SQLiteJournalModeEnum
+    {
+        /// <summary>
+        /// The default mode, this causes SQLite to create and destroy the journal file as-needed.
+        /// </summary>
+        Delete = 0,
+        /// <summary>
+        /// When this is set, SQLite will keep the journal file even after a transaction has completed.  It's contents will be erased,
+        /// and the journal re-used as often as needed.  If it is deleted, it will be recreated the next time it is needed.
+        /// </summary>
+        Persist = 1,
+        /// <summary>
+        /// This option disables the rollback journal entirely.  Interrupted transactions or a program crash can cause database
+        /// corruption in this mode!
+        /// </summary>
+        Off = 2,
+        /// <summary>
+        /// This option commits transactions by truncating the rollback journal to zero-length instead of deleting it. On many systems,
+        /// truncating a file is much faster than deleting the file since the containing directory does not need to be changed.
+        /// </summary>
+        Truncate = 3,
+    }
+}