I am using fabulous LinqPad and its Sqlite driver.
1) Is there a way to obtain Sqlite version information by executing say "select version"?
2) Which driver specific connection string should I use to enable foreign key support in Sqlite?
I am using fabulous LinqPad and its Sqlite driver.
1) Is there a way to obtain Sqlite version information by executing say "select version"?
2) Which driver specific connection string should I use to enable foreign key support in Sqlite?
1) select sqlite_version()
2) on http://sqlite.phxsoftware.com/forums/p/2159/8788.aspx they say the connection string parameter is EnforceFKConstraints
, the SQLite documentation isn't as browsable as I would like it to be :/