SQLCipher with NHibernate using Microsoft.Data.Sqlite.Core

SQLCipher
41

Hi @pkumbhar,

If your application restarts (as in a new running process is started), then yes you would need to execute the PRAGMA cipher_license command as it would no longer be in memory at that time.

42

Hi @developernotes ,

While uninstall I am not able to delete .db file as It is readonly mode and showing message another service is using the file.
related service was uninstalled and all files from installation location folder also deleted but not able to delete .db file. Please suggest me ways to close all connections forcefully and change the readonly mode of the file?

43

Hi @developernotes ,

Can you please help me for the same

44

Hi @pkumbhar,

To shutdown the NHibernate plumbing, you should be able to call Close() and Dispose() on all ISession instances you have, then you can invoke Dispose() on the ISessionFactory as well.

This implies you have another process which is accessing the database file. You will need to terminate that process before you can delete the database file.

45

Hi @developernotes ,

I am using below commands to establish connections with SQLite
$“PRAGMA cipher_license = ‘{lisc}’;”;
$“PRAGMA key = '” + Key + “';”;
$“PRAGMA journal_mode = wal;”;

It is slowing performance while executing the Multiple queries from multiple threads
Is there any other thing which wants to be applied while connecting database?

46

Hi @developernotes ,

I purchased enterprise Is there any communication channel for enterprise users? so that I can conclude my all development ASAP.

47

Hi @pkumbhar,

As a Commercial license holder, please write to us directly at support@zetetic.net to receive private support for SQLCipher. Thank you.