Agree that it is a bit of a nuisance. However, since it only needs to be
called once (per connection) you can use a factory method to create your
context and make the call there.
-----Original Message-----
From: Greg Keogh
Sent: 5/28/2011 12:38 AM
>"Assuming the library is compiled with foreign key constraints
enabled, it must still be enabled by the application at runtime, using
the PRAGMA foreign_keys
<http://www.sqlite.org/pragma.html#pragma_foreign_keys> command."
Good grief! I didn't realise it was a SQL command. I put the statement
before my INSERT statements and it does raise an error when I break
the FK. This is a nuisance, as I'd have to enable it continuously in
code. And since I'm planning to use the EF4 EDMX, lord knows I would
get down to that level.
>BTW, there is a newer version (1.0.72.0) at
http://system.data.sqlite.org/index.html/doc/trunk/www/downloads.wiki
Ooh, ta!
Greg
