Writing a C# desktop application that needs to embed an encrypted database. What type of database should I use?
c#, encryption, ms-access, rdbms, wpf
Solution
SQL Server Compact Edition and SQL Lite appear to be your main two options. SQL Server Compact has better .NET integration and Date/Time handling so I would go with that one. Also, the redistributable files are fairly low-weight (2-3MB IIRC).
SQL Server Compact will allow you to encrypt the database:
http://technet.microsoft.com/en-us/library/ms172901.aspx
...But you will have to be careful with your connection string because it is trivial to obtain an unencrypted password embedded in the client.
One last note: Selecting SQL Server Compact will enable you to use the built-in LINQ provider, which has the potential to make your life a lot easier.
Problem
Hey SO'ers, I'm making a C#/WPF app that needs to access a number of tables to generate some of the xaml code I will use in the app. The tables will also contain some floating point numerical data as well. The program is single-user, so the rdbms doesn't have to be very fancy, but the file does need to be encrypted as it will be "shrink-wrapped" and sent. I also can't force a user to install a separate program for this. So far I've been leaning towards using an encrypted .accdb database, but am open to better options. Does using accdb require the user to have access installed? (NOTE: I have also been looking at Database engine for a desktop application in C# and )