Why SQL Server CE does not recognize DB when my app is deployed

Question

I am struggling with how to make my app work when deployed - it keeps saying the file is invalid no matter what I do: What I have now is:

Data Source="\MyDb.sdf"

The DB should be in the directory where the executable is located.

That is a relative path, does MyDb.sdf exist in the application directory? — Pete Garafano
– Pete Garafano, Commented Jan 31, 2014 at 15:36

Pete Garafano · Accepted Answer · 2014-01-31 16:09:38Z

2

You probably need to use an absolute path to access the file.

var pathToExe = System.Reflection.Assembly.GetExecutingAssembly().Location;
var path = Path.GetDirectoryName(pathToExe);
var pathToDb = Path.Combine(path, "MyDb.sdf");

pathToDb should now be an absolute path to your database object, assuming it is always in the directory of the executing assembly.

edited Jan 31, 2014 at 16:09

answered Jan 31, 2014 at 15:44

Pete Garafano

4,9331 gold badge25 silver badges41 bronze badges

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

4 Comments

KhDonen Over a year ago

Hmm in the exception, it shows the correct path but still says that the path is invalid.

Pete Garafano Over a year ago

I hate to ask again, but you're absolutely sure that the file MyDb.sdf explicitly exists in the path?

KhDonen Over a year ago

Oh, actually your code returns the folder AND the exe file so the output us XX.exe\\MyDb.sdf

Pete Garafano Over a year ago

I updated the answer, I forgot that .Location returned the full path to the assembly. That update should fix it to remove the XX.exe.

Collectives™ on Stack Overflow

Why SQL Server CE does not recognize DB when my app is deployed

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related