Winforms VS 2015 Community with encrypted SQLite
-
Hello All, I am building a C# windows app using SQLite database. I built the database in DB Browser SQLite. I used the built in SQLcipher that comes with the new version of SQLite and added a password (testing123). Once I created a datasource in VS 2015 Community I used the wizard to browse to the database and supplied the password to add the database to my project. When I click the Test Connection it says everything is fine. However, when I expand the database in the datasource pane of VS I get an error that says something about File is encrypted or is not a database, even though the password is in the connection string in the Apps settings of the VS project. If I do not encrypt the database in DB Browser SQLite everything works fine. Also, if I create the database file as a new database in VS and put in the password upon creation VS allows the file to be encrypted and opening up in SQLite I must supply the PW to connect, however, after I build the database tables and put back in VS it does connect any more. Does anyone have any advise and do I need SQLcipher in my project to decrypt the database? If so, where would I get this and how do I use it? I do not have code since this is design time and I haven't even started to code since all I am doing is attaching the database and trying to navigate in the datasource to see my tables.