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

[sqlite] Identifying rowid aliases

I'm trying to ensure that something that looks like a rowid alias is in fact a rowid alias. I think I have the correct procedure, but I wanted to run it by the people here in case I missed anything. Is the following correct? 1. Check pragma_table_info() for a single-column PK 2. Check that the

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