System.Data.SQLite

Hello, I am using shared connection in my application.When two Users try to insert data in one table one of the user gets error "Database not open" due to Unique Constraint Violated" and so due to this exception the user cannot access other tables from the database and it gives error "Database not open" and does not allow to insert record in table even does not allow to read data (SELECT statement) from other table? Only after closing and again re executing the application, it works fine for such error. How can I handle this exception ?

How can two users share the same connection?

I'd need to know what your insert looks like, what the table schema is, and what the exact error messages are, hopefully including the stack trace.

 Possibly you are using the same connection among multithread. I think you need to add lock(conn) to execute the CURD operation. Thus can avoid the database lock issue.