Define data in LightSwitch Application


Prologue:

VisualStudio LightSwitch is a new development tool designed specially for rapid application development (RAD) techniques in line of business application development. Data centric application can be easily developed by simply designing data structures and related UI.

Defining the data in lightSwitch:

We can easily define the data in VisualStudio LightSwitch. We just have to define the DataStructures and defining the relationships among the tables.

Step 1: Create a new LightSwitch application in Visual Studio 2010.

LightSwitch application

Step 2: Click on create new table.

create table in LightSwitch

Step 3: Change the table name to company and add the attribute name and their corresponding types.

create table in LightSwitch

Step 4: By clicking on data sources add another table and change its name to employee add the attributes and their datatypes.

LightSwitch application

Step 4: By clicking on data sources add another table and change its name to joining add the attributes and their datatypes.

LightSwitch table

Step 5: Define the relationship Between employees and joining as many to one by click on relationship tab.

relation ship in LightSwitch

Step 6: By clicking on data sources add another table and change its name to salarydetails add the attributes and their datatypes.

LightSwitch tables

Step 7: Define the relationship Between employees and salarydetails as many to one by click on relationship tab.

LightSwitch relationship

Summary

This is the procedure how to define the data in VisualStudio LightSwitch.