Articles → Light Switch 2011 → Creation Of Data Entity In Light Switch 2011

Creation Of Data Entity In Light Switch 2011






Software Requirements


  1. Visual studio 2010 ultimate(or premium)
  2. Visual studio 2010 service pack 1
  3. Silverlight 5 exe which you will get from http://go.microsoft.com/fwlink/?LinkID=198365
  4. Light switch 2011 which you can download from http://www.microsoft.com/visualstudio/en-us/lightswitch

Implementation




Picture showing the lightswitch application from the visual studio installed project templates

Click to Enlarge





Picture showing create new table link to create a table in the lightswitch application

Click to Enlarge





Picture showing renaming the table name from the Table1Item to Employee

Click to Enlarge





Picture showing the fields added in the lightswitch tables

Click to Enlarge





Picture showing Relationship button for adding the relationship between the tables

Click to Enlarge





Picture showing the popup window for adding relationship between the entites

Click to Enlarge





SectionNameMultiplicity
FromDepartmentOne
ToEmployeeMany




SectionNameMultiplicity
FromDepartmentZero or one
ToEmployeeMany








DepartmentOn Delete BehaviorDescription
DepartmentRestrictedRecords in Department cannot be deleted if there is any associated record present in Employee table
EmployeeNA 


DepartmentOn Delete BehaviorDescription
DepartmentCascade DeleteIf any record in Department is deleted then delete all the associated records from the Employee table also.
EmployeeNA 


DepartmentOn Delete BehaviorDescription
DepartmentDisassociateIf the records in Department table deleted then the records in Employee table will remain intact.
EmployeeNA 




Picture showing the relationship established between the tables in lightswitch

Click to Enlarge


Error

















Posted By  -  Karan Gupta
 
Posted On  -  Monday, December 19, 2011

Query/Feedback


Your Email Id  
 
Subject 
 
Query/FeedbackCharacters remaining 250