views:

162

answers:

2

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  A: 

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 :/

deltreme
1) Thanks, but that's hardly SQL, is it?2) Great, but the author's comment is 3 months old and the latest released version is over 8 months old. Once it's finally released it will be exactly what I was looking for.
wpfwannabe
I left out my feelings about SQLite on purpose; perhaps there are elegant solutions available, finding the syntax is the real challenge :P
deltreme
+1  A: 

select distinct sqlite_version() from sqlite_master;

Herman
Brilliant! Way to go! Works like a charm.
wpfwannabe