Re: [sqlite] Best way to set default PRAGMA's in System.Data.SQLite

Sam Carleton wrote: > > I am trying out this approach right now and running into one minor issue, > the following cmd only builds the debug version: > > msbuild SQLite.NET.2015.MSBuild.sln /p:UseSqliteStandard=true > /p:UseInteropDll=false > Have you tried using the "build.bat" tool in the

Re: [sqlite] Best way to set default PRAGMA's in System.Data.SQLite

On Sat, Jun 1, 2019 at 7:35 PM Joe Mistachkin wrote: > > compile the System.Data.SQLite assembly in such a way that it uses a > "standard" SQLite > DLL, via setting the following MSBuild properties: > > /p:UseSqliteStandard=true /p:UseInteropDll=false > Joe, I am trying out this

Re: [sqlite] Best way to set default PRAGMA's in System.Data.SQLite

On 1 Jun 2019, at 9:54pm, Sam Carleton wrote: > 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? The simplest way is what you say: execute those two

Re: [sqlite] Best way to set default PRAGMA's in System.Data.SQLite

Sam Carleton wrote: > > 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

Re: [sqlite] Best way to set default PRAGMA's in System.Data.SQLite

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

Re: [sqlite] Best way to set default PRAGMA's in System.Data.SQLite

Sam Carleton wrote: > > My .net application which uses System.Data.SQLite relies on the > foreign_keys to be enabled and recursive_trigger to be disabled. In my > searching, I found documentation on DefaultFlags_SQLiteConnection, setting > that in the appSettings. Here is what it says: > In

Re: [sqlite] Best way to set default PRAGMA's in System.Data.SQLite

On 1 Jun 2019, at 4:34pm, Sam Carleton 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

[sqlite] Best way to set default PRAGMA's in System.Data.SQLite

My .net application which uses System.Data.SQLite relies on the foreign_keys to be enabled and recursive_trigger to be disabled. In my searching, I found documentation on DefaultFlags_SQLiteConnection, setting that in the appSettings. Here is what it says: If this environment variable is set