Is There a Workaround for a Missing Table in the Choose Your Database Objects Dialog?

Question

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,

--rj

---

Microsoft Access 2010 In Depth (QUE Publishing)
OakLeaf Blog
Access 2010 Blog
Amazon Author Blog

Answer 1

Hi Roger, looking at your database diagram the Grade table does not seem to have a primary key defined.

---

Dave Baker | Xpert360 blog | twitter : @xpert360 Opinions are my own. Please mark as answer if this helps solve your problem.

Answer 2

That'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.

Answer 3

Dave,

You're right. How did I miss that???

Thanks for your help.

--rj

---

Microsoft Access 2010 In Depth (QUE Publishing)
OakLeaf Blog
Access 2010 Blog
Amazon Author Blog