mardi 26 mai 2015

In SQLite, can you set the recursive_triggers pragma via the connection string?

I couldn't find any information in the official SQLite site about adding pragmas to the connection string, but I have seen other sites mention it.

Specifically we're trying to ensure that Recursive_Triggers is always enabled. We're using the latest version of System.Data.SQLite which supposedly has the latest version of the SQLite engine in it but even then, I've seen mixed information on whether it's enabled by default.

With it off, it makes using things like ADO.NET impossible, at least as far as having it auto-generate the SQL, but I guess we can always manually write/edit it ourselves, but if we can set it via the connection string, we wouldn't have to.

Aucun commentaire:

Enregistrer un commentaire