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 <[email protected]> wrote: > On 1 Jun 2019, at 4:34pm, Sam Carleton <[email protected]> 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 > [email protected] > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
