Articles → Light Switch 2011 → Connect to external database in lightswitch 2011

Connect to external database in lightswitch 2011






















Software requirement













Prerequisite knowledge













Steps of execution















Create a new project




Picture showing the sample lightswitch project in visual studio

Click to Enlarge


Create a new database




Picture showing the country, state and city tables in sql server database

Click to Enlarge


Connect with the existing database








Picture showing the wizard to select the data source type

Click to Enlarge



Picture showing a popup window to enter the database credentials and validate them

Click to Enlarge





Picture showing the list of tables to be selected from the data source

Click to Enlarge





Picture showing the warning message when trying to add the table in the lightswitch project

Click to Enlarge





Picture showing the country, state and city lightswitch tables in visual studio solution explorer

Click to Enlarge


Create a new screen




Picture showing a popup window for adding a new data screen

Click to Enlarge


Output




Picture showing the data coming from the sql server database tables

Click to Enlarge


Posted By  -  Karan Gupta
 
Posted On  -  Wednesday, August 7, 2013

Query/Feedback


Your Email Id  
 
Subject 
 
Query/FeedbackCharacters remaining 250