Ok, that is good to know. If I am not mistaken, System.Data.SQLite takes part in the .Net connection pooling, What is the best way to ensure that these two features are set correctly? Does the program simply need to make sure it issues the pragma after each connection, assuming it is always new?
I do use SQLite in C/C++ application where I have recompiled SQLite DLL to force these settings. In looking through the .net code, it looks like it simply a wrapper around the SQLite dll, Is it possible to have the .Net application simply use that version of the DLL rather than the one that came with System.Data.SQLite? Pax vobiscum, Sam Carleton On Sat, Jun 1, 2019 at 1:47 PM Simon Slavin <slav...@bigfraud.org> wrote: > On 1 Jun 2019, at 4:34pm, Sam Carleton <scarle...@miltonstreet.com> wrote: > > > What I cannot find is what to set to enable foreign keys and disable > > recursive triggers. > > Only flags which can be supplied in connection strings can be set in > DefaultFlags_SQLiteConnection . And you cannot set those two settings in > connection strings because they are not related to file handling. Sorry. > _______________________________________________ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
