I am trying something, and i am confused as far as i can be.
I only want that SQlite would enforce foreign key constraint by default. I
don't want to use PRAGMA foreign_keys every time i mada a connection. After
searching on net, i found that i can compile with
SQLITE_DEFAULT_FOREIGN_KEYS.
I downloaded full source from
http://system.data.sqlite.org/index.html/doc/trunk/www/downloads.wiki.
I recompiled it, add reference to System.Data.SQlite and
System.Data.SQLite.Linq to my project and run. I get: The type initializer
for 'System.Data.SQLite.SQLiteFactory' threw an exception.
I try to add SQLite.Interop.Static.2010  SQLITE_DEFAULT_FOREIGN_KEYS in
preprocessor definitions, still same problem.

I can't beleive it that there is not precompiled library
with SQLITE_DEFAULT_FOREIGN_KEYS on the download page. I am sure that
everyone is using pragma for now.
Any help would be appreciated.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to