Where does Orchard CMS create its built-in SQL Server Compact Database

Question

You can configure Orchard CMS to use a built-in SQL Server Compact database.

I want to connect to, and query, this database.

Where does Orchard create it?

Answer 1

The database is created in:

src/Orchard.Web/App_Data/sites/YourSiteName

To connect to it I use the following plugin for Visual Studio:

SQL Server /SQLite Toolbox

For other ways to open SQL Compact databases see this SO question:

How do you open an SDF file (SQL Server Compact Edition)?