1

I'm working on a project and I want to protect information which is in SQLite database. I want to use algorithms such as RC4, DES, AES. I use C#. Please help me!

vgru
  • 49,838
  • 16
  • 120
  • 201
Blake
  • 149
  • 1
  • 8
  • In order to be helpful, it helps us to have way more context than that. Can you tell us a little about what you're trying to store in SQLite? – sblom Feb 01 '12 at 06:48
  • 2
    Just encrypt the data and store it in a blob column. If SQLite doesn't support blobs, encode the encrypted data with base64 and store it in a text field. If you're encrypting the whole thing, you should see this: http://stackoverflow.com/questions/1259561/encrypt-sqlite-database-in-c-sharp – Polynomial Feb 01 '12 at 06:52
  • What @Polynomial said is about it. Note that storing **passwords** in a database is a completely different problem and requires cryptographic *hashing* algorithms. You should clarify your question a bit, because security can be rather complex to implement properly, if you have no experience. – vgru Feb 01 '12 at 12:06
  • @Groo - Security *is* complex to implement properly, full stop. – Polynomial Feb 01 '12 at 21:05
  • using additional library – Blake Feb 02 '14 at 16:33

1 Answers1

1

As discussed here, the easiest way is to use the System.Data.Sqlite wrapper and include a password in the connection string. This old forum thread says that the wrapper uses RC4 via the Microsoft Crypto API.

Community
  • 1
  • 1
Ed Power
  • 8,310
  • 3
  • 36
  • 42