How to lock the database (I am using c# with DbContext) between HTTP calls to my server so nobody in between my two HTTP function calls operates on the database (particularly on one table). Is there any mechanism for that provided by the database (I am using SQLite DB).
1 Answers
If you start a transaction, the database will be locked until you end it. But SQLite is not designed for multiuser environment. If you have the problem you described, you may not be using the right database.
Related