VisualStudio LightSwitch is a new development tool designed especially 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.

We can easily define the data in Visual Studio LightSwitch.

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



2. Click on create new table.



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



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



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



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



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



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