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