Load and save .sdf at runtime

Question

I'm building an C#-application that uses an SQL Server Compact 4.0 database (.sdf) with Entity Framework for data. I want to be able to load/save-files from within this application so that the user can load a different database or backup the database to an USB eg.

I know you can create an sdf in code, but how can i load it at runtime (The connectionstring)?

My question is that this must be a common thing to do, what is the best way to go about it? is there any guides out there to do this?

or do you reccomend another way to go about my problem?

//ObjectiveCoder

Answer 1

You should use a SqlCeConnectionStringBuilder to create a connection string containing your file path.