How to add a relationship between tables in LightSwitch internal database
In this article I describe how to use the LightSwitch data designer to add a relationship between two tables in the LightSwitch internal database.
The following describes the procedure for adding a relationship between tables in Visual Studio 2012 LightSwitch.
Step 1
Open the Solution Explorer.
Image 1
Step 2
In the Solution Explorer, double-click or right-click on the table to open it.
Image 2
Step 3
The table opens in Data Designer.
Image 3
Step 4
In the Data Designer on the command bar go to the relationship button.
Image 4
Step 5
The "Add New Relationship" dialog box appears.
Image 5
Step 6
In the Add New Relationship dialog box, go to the Name row and choose the two tables for which we want to apply a relationship (for example, EmployeeTabs and ProductTables).
Image 6
Step 7
In the multiplicity row we specify how we want these tables to be related. See http://msdn.microsoft.com/en-us/library/vstudio/ff852044.aspx#Multiplicity
Image 7
Step 8
On the Delete Behavior row we specify what we want our application to do if a user tries to delete a record in one table but data still exists in the related record in the other table. See: http://msdn.microsoft.com/en-us/library/vstudio/ff852044.aspx#Deletion
Image 8
Step 9
In the Navigation Property row, enter a name for each navigation property, and then choose the "OK" button. The Navigation properties help users to navigate among areas of a screen that display related data.
Image 9
Step 10
Since we began debugging we have the following output:
Image 10