Where is the LightSwitch internal database?

Question

I've just downloaded VS LightSwitch and I'm doing a sample application for myself. I have created a new table by using Create new table option and have inserted some data. So after I inserted 3 records, the ID is obviously showing 3, which is correct.

Now I want to truncate the data from the table.

My question is, where is the internal table or the internal database (ApplicationData) ?

Thanks

Answer 1

The following steps worked for me:

1. From the solution folder of your sample application, open the bin\data folder
2. You should see the ApplicationDatabase.mdf file
3. Open SQL Server Management Studio
4. Use the attach functionality to open the mdf file
5. After making your changes, detach it

Answer 2

It seems that LightSwitch uses SQL Server Express for its internal database. Try looking in the bin\data folder of your project for an ApplicationDatabase.mdf file.