Articles → Light Switch 2011 → Connect To External Database In Lightswitch 2011

Connect To External Database In Lightswitch 2011

Software Requirement

1. Visual studio 2010 is installed on your machine.
2. Visual Studio 2010 service pack 1 is installed on your machine.
3. Microsoft Visual Studio Light switch 2011 is installed on your machine.
4. Silverlight runtime version 4 or 5 is installed on your machine

Prerequisite Knowledge

1. How to create a new project using visual studio?
2. How to create database, tables etc. in MS SQL server?
3. What are screens and entities in lightswitch?
4. How to create a screen in lightswitch application?

Steps Of Execution

1. Create a new project
2. Create a new database
3. Connect with the existing database
4. Create a new screen

Create A New Project

Create A New Database

Connect With The Existing Database

1. Right click on the ‘Data sources’ folder and click ‘Add Data source..’.
2. A window appears as shown in figure below. From the window select ‘Database’ and click on next

Click to Enlarge


3. A window appears to allow user to enter the database credentials.

Click to Enlarge


4. Once the credentials are entered and database is selected click on Ok.
5. Another window appears which displays the list of tables in the selected database (and views if any)

Click to Enlarge


6. Click on Finish.
7. A popup window appears for giving warning about the issues in data source

Click to Enlarge


8. Click continue
9. Data source is added in the project. See the screen shot below

Click to Enlarge

Create A New Screen

Output