Using Pragma-s SQLite in C #

Question

I sent a question

"My projects have a C ++ dll in which a db is created in Sqllite with share deny = none. This DLL will insert data into Db, and I have aC # exe that needs to access the db and display it. Asynchronously. So so, when starting a connection with sqlitedb, I can lock the table or db. If possible, can someone give me a link or sample on how to do this "

for this, I got a response from using Pragma -s, can someone tell me how to implement PRagma-s SQLlite in C #.

Answer 1

In the connection string, you can install Pragmas

For example:
String conString = "Data Source=filename;Version=3;PRAGMA locking_mode = NORMAL;"

You can add more than one pragma to the connection string