in

System.Data.SQLite

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

Connection string bug in SQLiteConnection?

Last post 04-19-2010 4:48 PM by Robert Simpson. 2 replies.
Page 1 of 1 (3 items)
Sort Posts: Previous Next
  • 12-01-2009 1:47 PM

    • Paul
    • Top 25 Contributor
    • Joined on 09-12-2007
    • Posts 33

    Connection string bug in SQLiteConnection?

    In this code:

     

                defValue = FindKey(opts, "Journal Mode", "Delete");
                if (String.Compare(defValue, "Default", StringComparison.OrdinalIgnoreCase) != 0)
                {
                  cmd.CommandText = String.Format(CultureInfo.InvariantCulture, "PRAGMA journal_mode={0}", defValue);
                  cmd.ExecuteNonQuery();
                }

     

    shouldn't "Default" be "Delete"? There might be some other compares that are wrong.

     

     

  • 04-19-2010 10:50 AM In reply to

    • Paul
    • Top 25 Contributor
    • Joined on 09-12-2007
    • Posts 33

    Re: Connection string bug in SQLiteConnection?

     This bug is still there in 1.0.66.

     

    if (String.Compare(defValue, "Default", StringComparison.OrdinalIgnoreCase) != 0)

     

    should be

     if (String.Compare(defValue, "Delete", StringComparison.OrdinalIgnoreCase) != 0)

  • 04-19-2010 4:48 PM In reply to

    Re: Connection string bug in SQLiteConnection?

    Oops!  Sorry.

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