开发者

Using Pragma-s of SQLite in C#

I 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 开发者_如何学Pythondone asynchronously. So is there any way while launching connection to sqlitedb I can lock the table or db. If possible, can anyone give me links or a sample of how it can be done? "

For this, I got a reply to use Pragma -s. Can anyone tell me how to implement PRagma-s of SQLlite in C#?


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

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜