Click here to Skip to main content
12,406,124 members (72,216 online)
Click here to Skip to main content
Add your own
alternative version

Stats

15.4K views
4 bookmarked
Posted

Attaching an External DataSource in LightSwitch Application

, 24 Mar 2011 CPOL
Rate this:
Please Sign up or sign in to vote.
Attaching an External DataSource in LightSwitch Application

You might know that LightSwitch is now in Beta 2 stage. Microsoft released it few days ago. I have a series of Tutorials on LightSwitch Beta 1 where we discussed on creating database tables using the LightSwitch table designer.

In this tutorial, we will discuss how to attach an existing database table available in your SQL server database. This was also available in Beta 1 release. This time, we will discuss with the latest version. Read the full post and at the end, leave your feedback.

If you are new to LightSwitch, you may like to read my previous chapters too. You can find them here: "Beginners Guide to Visual Studio LightSwitch". I appreciate your feedback.

Setting up Environment

To start with, we need Visual Studio LightSwitch. Currently it is in Beta 2 stage, which you can download from Microsoft download site. Click the below image to download the installer:

Make sure that, you already have Visual Studio 2010 SP1 installed in your machine. If you don't have SP1, you can also download it from here:

Once your development machine is ready with LightSwitch Beta 2, open Visual Studio 2010 and create a new LightSwitch project as shown below:

image

Once you hit "OK", it will take some time to generate the project.

Quick Look into Existing Table

Let us create a new table called "EmployeeTable" in our SQL Server database. You can use your existing table too. If you don't have SQL Server installed in your PC, you can use the SQLExpress also for working with that.

Here is our table definition which we will use to attach to our LightSwitch application:

image

In our table, we have "EmpID" as the Primary key, some strings and one date field. You can see the definition in the above screenshot.

Connecting External DataSource

Now once you have your table ready, it is the time to connect to it from your application. To do this, in the Visual Studio IDE home page, you will find one option called "Attach to external Data Source" (as shown below):

image

Click the link to open the connection Wizard. Alternatively, you can right click on the "Data Sources" folder inside your solution Explorer (as shown below) and from the context menu, click "Add Data Source...". This will also do the same trick from you.

image

Ok, let us click the link from the Home Page (if you are unable to find it, you can open it from View -> Home Page). Have a look at it here:

image

Let's click on the link in the Home Page to continue attaching on the external data source.

image

This will open up the "Attach Data Source Wizard" dialog in the screen.

image

From the above screen, chose "Database" and click "Next". This will open another dialog called "Connection Properties" for you. In this dialog, you will be able to configure your database connection settings.

image

Select the "Server name", "Authentication information" and "Database name" from the dialog. Click "Test Connection" to check whether the connection established. On success, click "OK" to continue.

image

Now, it will start retrieving your database tables for you and show them in the screen.

image

Select the appropriate table that you want to connect from the above dialog and give your proper name to the DataSource name. For this tutorial, we will use our existing table named "EmployeeTable". Click "Finish" to attach the table with your solution.

Once you click "Finish", it will import the table information and show it up on the screen (as shown below):

image

Here you will see that it kept the proper Data Type that we have in our original table. That's all about attaching an existing table in LightSwitch application.

image

Now open the Solution Explorer. You will see that it actually created the Data Source named "employeeData", and in that data source we have the table called "EmployeeTable". Hey, all this without writing a single piece of code, as you can see.

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Share

About the Author

_Kunal Chowdhury_
Software Developer (Senior)
India India
Kunal Chowdhury is a Microsoft "Windows Platform Development" MVP (Most Valuable Professional), a Codeproject Mentor, Telerik Developer Expert, Nokia Developer Champion, Windows 10 Champion, Microsoft Rockstar, Speaker in various Microsoft events, Author, passionate Blogger and a Software Engineer by profession.

He is currently working in an MNC located in India. He has a very good skill over XAML, C#, Silverlight, Windows Phone, WPF and Windows Store (WinRT) app development. He posts his findings, articles, tutorials in his technical blog and CodeProject.

Technical Blog: http://www.kunal-chowdhury.com
Facebook: http://facebook.com/blog.kunal
Twitter : http://twitter.com/kunal2383

You may also be interested in...

Comments and Discussions

 
GeneralMy vote of 5 Pin
mbcrump25-Mar-11 7:37
membermbcrump25-Mar-11 7:37 
GeneralRe: My vote of 5 Pin
Kunal_Chowdhury2-Apr-11 19:33
mvpKunal_Chowdhury2-Apr-11 19:33 
GeneralMy vote of 5 Pin
Durgaprasadtb25-Mar-11 7:11
memberDurgaprasadtb25-Mar-11 7:11 
GeneralRe: My vote of 5 Pin
Kunal_Chowdhury2-Apr-11 19:32
mvpKunal_Chowdhury2-Apr-11 19:32 
GeneralMy vote of 5 Pin
Brij24-Mar-11 21:41
mvpBrij24-Mar-11 21:41 
GeneralRe: My vote of 5 Pin
Kunal_Chowdhury24-Mar-11 23:40
mvpKunal_Chowdhury24-Mar-11 23:40 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.

| Advertise | Privacy | Terms of Use | Mobile
Web01 | 2.8.160726.1 | Last Updated 25 Mar 2011
Article Copyright 2011 by _Kunal Chowdhury_
Everything else Copyright © CodeProject, 1999-2016
Layout: fixed | fluid