LightSwitch: Change Default Database Instance

I posted How to Change Development Database in LightSwitch which shows how to change the database at the project level. But if you are really bored repeating the process every single time you create a new project and you want to change the default instance of you database, you can follow these steps:

• Close Visual Studio (IMPORTANT!)
• Open the Windows Registry i.e. Regedit
• I am using Visual Studio Ultimate: Go to HKEY_CURRENT_USER\Software\Microsoft\VisualStudio\10.0\DataProject
• Change the value for the DefaultSSEName key with the database instance you want to use. For instance I replace SQLExpress with SQLExpress2k8R2
• Close Regedit
• Open Visual Studio
• Create new Lightswitch project
• Unload project then right click and select edit project
• Check SqlExpressInstanceName

About these ads