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

Maybe this reply http://stackoverflow.com/questions/2433934/opening-an-sql-ce-file-at-runtime-with-entity-framework-4 — ErikEJ, Dec 28 '11 at 15:51

score 0 · Answer 1 · answered Dec 28 '11 at 14:52

0

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

answered Dec 28 '11 at 14:52

SLaks

868,454
176
1,908
1,964

How do I set this SqlCeConnectionStringBuilder to be my connectionstring? – Objective Coder Dec 28 '11 at 14:55
Use its `ConnectionString` property to get the assembled string. – SLaks Dec 28 '11 at 15:36

Load and save .sdf at runtime

1 Answers1