Sunday, October 07, 2012 5:38 PM
Specifying an existing SQL Server 2012 Express database (created by attaching SQL Server 2008 *.mdf and *.ldf files) as the data source for a new LightSwitch project to start the Attach Data Source Wizard resulted in all but one (Grades) of the database's eight tables in the Choose Your Database Objects dialog.
The table and its relationships appear as expected in SSMS 2012.
Full details of the process I used and a link to download the files from my SkyDrive account are in my A Visual Studio 2012 LightSwitch “Course Manager” Application Clone with Real-World Data: Part 1 blog post of 10/7.
I'd like to know what caused the problem and how to add the table to the project manually so I don't need to start over with the project.
Thanks in advance,
- Edited by Roger JenningsMVP Sunday, October 07, 2012 5:40 PM
Sunday, October 07, 2012 7:20 PM
Hi Roger, looking at your database diagram the Grade table does not seem to have a primary key defined.
Monday, October 08, 2012 3:33 AMModeratorThat'll be it..
Yann - LightSwitch Central - Click here for FREE Themes, Controls, Types and Commands If you find a reply helpful, please click "Vote as Helpful", if a reply answers your question, please click "Mark as Answer" By doing this you'll help people find answers faster.
Monday, October 08, 2012 4:08 PM