System.Data.SQLite
View Ticket
Not logged in
Ticket UUID: 464e6cee2ff18149fe8e897df61227eb40ceecac
Title: Add foreign keys to connection string
Status: Closed Type: Feature_Request
Severity: Minor Priority: Immediate
Subsystem: Connection Resolution: Fixed
Last Modified: 2011-07-07 04:36:05
Version Found In: 1.0.66
Description:
Add foreign keys to connection string

<verbatim>
            defValue = FindKey(opts, "Foreign Keys", "OFF");
            if(String.Compare(defValue, "OFF", StringComparison.OrdinalIgnoreCase) != 0)
            {
                cmd.CommandText = String.Format(CultureInfo.InvariantCulture, "PRAGMA foreign_keys={0}", defValue);
                cmd.ExecuteNonQuery();
            }
</verbatim>

<hr /><i>mistachkin added on 2011-07-05 06:35:11 UTC:</i><br />
Support for this option appears to have been added with release 1.0.67.0.