LightSwitch An exception occurred when building the database for the application

Question

Hi All,

Just installed LS Beta on Win 7 VM running VS 2010 Pro SP1 Beta.

I get this error when building after creating a table or connecting to a database:
An exception occurred when building the database for the application.
Method not found: 'Void Microsoft.Data.Schema.Sql.SchemaModel.ISqlSimpleColumn.set_IsIdentity(Boolean)'. C:\Program Files\MSBuild\Microsoft\VisualStudio\LightSwitch\v1.0\Microsoft.LightSwitch.targets 95 10 Application3

Previous error leads to this part of "lightswitch.targets"  line 95 Character 10 is first code after comment:

 <!--The Development Database is built in the same location - Bin\Data - for all configurations.-->
    <BuildSchema Inputs="@(LightSwitchModel)"
           InstallDirectory="$(LightSwitchPath)"
           OutputDirectory="Bin\Data"/>
    <!--The _IntrinsicData connection string should be updated to use the absolute path 
      since the Development Database is not under build output directory.-->
    <SetConnectionString
     ConfigFile="$(OutputPath)\web.config"
     Name="_IntrinsicData"
     ConnectionString="Data Source=.\SQLEXPRESS;AttachDbFilename='$(MSBuildProjectDirectory)\Bin\Data\ApplicationDatabase.mdf';Integrated Security=True;Connect Timeout=30;User Instance=True;MultipleActiveResultSets=True"/>
   

 

This is the information on my VS installation from 'help->about':

Microsoft Visual Studio 2010
Version 10.0.31118.1 SP1Rel
Microsoft .NET Framework
Version 4.0.30319 SP1Rel

Installed Version: Professional

Microsoft Office Developer Tools   01018-532-2002102-70701
Microsoft Office Developer Tools

Microsoft Visual Basic 2010   01018-532-2002102-70701
Microsoft Visual Basic 2010

Microsoft Visual C# 2010   01018-532-2002102-70701
Microsoft Visual C# 2010

Microsoft Visual F# 2010   01018-532-2002102-70701
Microsoft Visual F# 2010

Microsoft Visual Studio 2010 Team Explorer   01018-532-2002102-70701
Microsoft Visual Studio 2010 Team Explorer

Microsoft Visual Studio LightSwitch Beta   01018-532-2002102-70701
Microsoft Visual Studio LightSwitch Beta

Microsoft Visual Web Developer 2010   01018-532-2002102-70701
Microsoft Visual Web Developer 2010

Crystal Reports Templates for Microsoft Visual Studio 2010  
Crystal Reports Templates for Microsoft Visual Studio 2010

Microsoft Package Manager   1.0
Package Manager in Visual Studio

Microsoft Visual Studio 2010 Professional - ENU Service Pack 1 (KB983509)   KB983509
This service pack is for Microsoft Visual Studio 2010 Professional - ENU.
If you later install a more recent service pack, this service pack will be uninstalled automatically.
For more information, visit http://support.microsoft.com/kb/983509.

Microsoft Visual Studio 2010 SharePoint Developer Tools   10.0.31118
Microsoft Visual Studio 2010 SharePoint Developer Tools

Telerik MVC VSExtensions   2010.03.1109.0
Telerik Extensions for ASP.NET MVC VSExtensions Package

Telerik OpenAccess ORM   2010.3.1125.1
Telerik OpenAccess ORM Copyright (C) 1996-2010 Telerik; OpenAccess is the Object-Relational Mapping Tool for the Microsoft .NET Platform. www.telerik.com

Telerik Reporting  
For more information please visit http://www.telerik.com/reporting. Copyright © 2005–2011 Telerik, Inc.

Telerik Silverlight VSExtensions   2010.03.1109.0
Telerik RadControls for Silverlight VSExtensions Package

Telerik UserSettings VSExtensions   1.0.0.0
Package for performing configuration of the Telerik VS Extensions

Telerik WebUI VSExtensions   2010.03.1214.0
Telerik RadControls for ASP.NET AJAX VSExtensions Package

Telerik WPF VSExtensions   2010.03.1109.0
Telerik RadControls for WPF VSExtensions Package

Thanks for any guidance you can give.

Dave

Answer 1

Facing the same "Method not found" error as well... Error 1 An exception occurred when building the database for the application. Method not found: 'Void Microsoft.Data.Schema.Sql.SchemaModel.ISqlSimpleColumn.set_IsIdentity(Boolean)'. C:\Program Files (x86)\MSBuild\Microsoft\VisualStudio\LightSwitch\v1.0\Microsoft.LightSwitch.targets 95 10 Application3

Answer 2

Update to my previous post!!

Tested in 3 different machines (Vista & Win7 - Visual Studio 2010) and getting the same error.  However by clicking "YES" to continue to see the Output brings the screen with another error, says "An attempt to attach an auto-named database for file <location>\DevelopmentDatabase.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share".

Answer 3

Format the PC and reinstalling OS and VS 2010 back solved the issue on all three machines.

 

It may not be the proper solution, but working for me.

Answer 4

The failure to auto attach a database sounds a little similar to the problem reported in the following thread.

http://social.msdn.microsoft.com/Forums/en/lightswitchgeneral/thread/219f42cf-5c99-4a72-9acb-249210c835e2

For anyone about to reformat their PCs, it might be worth clearing the files in the following folder to see if it fixes the problem.

%LOCALAPPDATA%\Microsoft\Microsoft SQL Server Data\SQLEXPRESS

Answer 5

Thank you Tim,

The advice and information in the thread you provided did the trick!

 

Thanks also to PowerBlaga for all the information you provided about how you got through your similar problem. 

 

Answer 6

Help Please!

I have the same problem as described above I have tried deleting files in (%LOCALAPPDATA%\Microsoft\Microsoft SQL Server Data\SQLEXPRESS) but it seems to have no effect. I am running Windows 7 32bit with Visual Studio 2010 Pro SP1 installed along with a whole host of other Apps so formatting the drive and reinstalling is not really an option. This appears to be a common problem and is not well documented. 

Does anyone have any other ideas or information? I am ready to give up on lightswitch.