Using Pragma-s of SQllite in C#

Question

Hi All ,

I had posted a question

"My Projects has c++ dll in which a db is created in Sqllite with share deny = none . This dll will insert data into Db and I have a c# exe which must access the db and display it . Display needs to be done asynchronously. So there any way while launching connection to sqlitedb i can lock the table or db. if Possible can anyone give me links or sample on how it can be done "

for this I got a reply of of using Pragma -s can any one tell me on how to implement PRagma-s of SQLlite in C#.

Answer 1

Pragmas can be set in your connection string

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

You can append more than one pragma to the connection string