Re: [sqlite] Encryption

2016-11-14 Thread Richard Andersen
te. I use SQLITE Expert. It allows you > to replace the standard library which does not support encryption to one > from the system.data.sqlite that does. It is the interop dll that you > replace. Then after entering the password, the encryption and decryption > becomes transparent

Re: [sqlite] Encryption

2016-11-15 Thread Richard Andersen
t; supporting the encryption scheme of your choice. For example, > - SQLCipher (https://github.com/sqlcipher/sqlcipher), you have to build the > DLL yourself > - wxSQLite3 (https://github.com/utelle/wxsqlite3/releases), Windows binaries > are provided > Other SQLite3 management to

[sqlite] Encryption

2016-11-11 Thread Richard Andersen
I'm using the ADO.NET version (System.Data.SQlite). I've created an RSA encrypted database using SQLite2009 and that is working fine, but I can't find any tools for editing the table in SQLite2009 once it's been created. Is it possible at all? In DB Browser for SQlite I can edit the table but

Re: [sqlite] Updating multiple records in C#

2016-12-07 Thread Richard Andersen
Wednesday, December 7, 2016, 3:12:05 AM, you wrote: >> On Dec 6, 2016, at 5:40 PM, Richard Andersen <r...@taosoft.dk> wrote: >> >> cmd.CommandText = @"UPDATE pdata SET FileName = @fileName WHERE FileName = >> 'filename.zip'"; > You can add other

[sqlite] Updating multiple records in C#

2016-12-06 Thread Richard Andersen
I have a table with several thousand records each with multiple fields. One field contains a filename, this is the only unique field so I use it to identify the different records. What I need is a way to update all fields that have changed in any record, at once. There's no need to check IF a

Re: [sqlite] Updating multiple records in C#

2016-12-07 Thread Richard Andersen
Wednesday, December 7, 2016, 9:15:57 AM, you wrote: Thanks Ryan, this looks very useful, think I've got what I need now to make it work! Richard >> But how do I do this for multiple records and mutiple fields? I >> imagine I need to use SQLiteTransaction here but I'm not sure about >> the