Where is the LightSwitch internal database?

Up vote 3 down vote favorite share g+ share fb share tw.

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 visual-studio-lightswitch link|improve this question edited Dec 1 '11 at 14:33SteveC1,4221032 asked Aug 11 '11 at 3:15NewLSdev162.

The following steps worked for me: From the solution folder of your sample application, open the bin\data folder You should see the ApplicationDatabase. Mdf file Open SQL Server Management Studio Use the attach functionality to open the mdf file After making your changes, detach it.

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.

That is true.. but while I am trying to open that, it is showing that the file is beng use by operating system.... so there is no way to truncate them – NewLSdev Aug 11 '11 at 4:57 More than likely because the file is attached as a user instance of SQL Server Express. You can try connecting to that instance from Sql Server Management Studio – Garett Aug 11 '11 at 5:45 1 It may be that LightSwitch itself still has the file open. It attaches the file as a user instance (as Garett mentioned) each time you run your project.

Try closing LightSwitch/Visual Studio before you try to use the database in SSMS. – Yann Dec 29 '11 at 3:42.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.