How to enable MS-SQL Compact Database encryption on first program run when using it with the Entity Framework?

Question

OK, here is the szenario:

I'm coding a .NET 3.5 WPF-Aapplication, using the Microsoft Entity Framework to use a compact database file (.sdf) for storing data. On my first program start a computer-based encryption key is calculated and saved into the registry and my sdf-File should become encrypted with this key (or rather with a somehow hashed version of this key).

My current proble

How can I encrypt my (until now unencrypted) sdf-file with the generated password?
How can I tell the ModelContainer of the Entity Framework to use this password to connect to the database instead of the connection string in the app.config where no password is saved?

I tried to clear all connection strings and create a new one with the password on-the-fly when starting, but I get an exception that my configuration is read-only.

Any ideas are greatly appreciated :-)

Community · Accepted Answer · 2017-05-23 12:11:47Z

1

To change the database from being unprotected to protected, you must use the SqlCeEngine Compact method (in the System.Data.SqlServerCe ADO.NET provider)

To modify the connectionstring, see this: SQL CE 3.5 & EntityFramework

SqlCeEngine engine = new SqlCeEngine("Data Source = AdventureWorks.sdf");
engine.Compact("Data Source=; Password =a@3!7f$dQ;");

edited May 23, 2017 at 12:11

CommunityBot

11 silver badge

answered Sep 30, 2010 at 12:40

ErikEJ

42.1k5 gold badges81 silver badges119 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to enable MS-SQL Compact Database encryption on first program run when using it with the Entity Framework?

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related