Here we will see about how to establish relationship among multiple tables using LightSwitch in Visual Studio 2012.Steps for showing relationship among multiple table in LightSwitch 2012Step 1Open the Solution Explorer.Step 2In the Solution Explorer, right click on the data source and choose Add Table option.Step 3The Table appears. In this way we are going to create three tables (Customer, Item and CustomerItemMap).Customer TableItem TableCustomerItemMap Table doesnot not contain any data.It means the table is emptyStep 4Under the Item Table, select the ItemDescription from the Table and go to the property window.In the property window, clear the Maximum Length value.Step 5Now we need to create the relationship. In order to create the relationship first select the CustomerItemMap table and click on the relationship button as shownStep 6Add New Relationship window will appear.Step 7Now we will create one to many relationship between the Customer and CustomerItemMap tables.When we click "OK" button.Similarily between the Item and the CustomerItemMap tables.When we click OK button.Step 8Now the relationship between the following tables is set.
You need to be a premium member to use this feature. To access it, you'll have to upgrade your membership.
Become a sharper developer and jumpstart your career.
$0
$
. 00
monthly
For Basic members:
$20
For Premium members:
$45
For Elite members: