Where Is The Sql Server Compact File?

I have an ASP.NET MVC project that uses a SQL Server Compact database. I have the following connection string for my FoobarContext:

Solution 1:

It definitely should be ~/App_Data by default, but you can try running AppDomain.CurrentDomain.GetData("DataDirectory") to see where ASP.Net thinks the directory exists.

If this reveals nothing of interest, you may want to make sure your windows explorer is set to show hidden files, just in case that's why you don't see the file.

Solution 2:

It should be in a folder called App_Data off the root of your MVC project.

Solution 3:

you should be stingy on the app folder in your project, the database file you'll find inside.

Regards

Share