Types of Relationship in LightSwitch 2012

Here we will see how to establish relationships between tables in LightSwitch Applications (Visual C#) in Visual Studio 2012.

The following is the procedure for establishing a relationship between tables.

Step 1

Open the Solution Explorer.



Step 2

In the Solution Explorer, right-click on the Server and choose "Add Table".



Step 3

The table appears.

Employee Table



Item Table



Step 4

Go to the menu bar and click on the "Add Relationship" button.



The relationship dialog box appears on the screen.



Step 5

There are various types of relationships; they are:

1. One to Many
2. Zero or One to One
3. Many to One

Step 6

Establishing a one to many relationship between tables.



The relationship between two tables is as in the following:



Step 7

Establishing a many to one relationship between tables.



The relationship between two tables is as in the following:



Step 8

Establishing one to one relationship between tables.



The relationship shown between two tables is not supported in LightSwitch 2012.



Step 9

Establishing a zero or one to one relationship between tables.



The relationship between two tables is as in the following: