Alessandro Del Sole's Blog

/* A programming space about Microsoft® .NET® */
posts - 159, comments - 0, trackbacks - 0

My Links


Your host

This is me! This space is about Microsoft® .NET® and Microsoft® Visual Basic development. Enjoy! :-)

These postings are provided 'AS IS' for entertainment purposes only with absolutely no warranty expressed or implied and confer no rights.

Microsoft MVP

My MVP Profile

I'm a VB!

Watch my interview in Seattle

My new book on VB 2015!

Pre-order VB 2015 Unleashed Pre-order my new book "Visual Basic 2015 Unleashed". Click for more info!

My new book on LightSwitch!

Visual Studio LightSwitch Unleashed My book "Visual Studio LightSwitch Unleashed" is available. Click the cover!

Your visits

Follow me on Twitter!

CodePlex download Download my open-source projects from CodePlex!

Article Categories


Post Categories

.NET Framework


Help Authoring

Microsoft & MSDN

Setup & Deployment

Visual Basic 2005/2008/2010

Visual Studio LightSwitch: connecting to SQL Azure databases

Among the available data sources that Visual Studio LightSwitch allows connecting to, since the current beta, we can find SQL Azure databases. SQL Azure is the database "on the cloud" of the Windows Azure Services Platform. The cool thing is that once you have your database on SQL Azure, the way you connect to it does not change.

Once LightSwitch is running, click "Attach to an external database". Next select Database as the data source:


Next you have to specify connection parameters such as the SQL Azure server name, user name and password (you work with SQL authentication) and, of course, the database name:

In my case I have a database with three tables. I can select them all or just some:

Finally LightSwitch defines for you entities based on the SQL Azure's database tables:

At this point you could simply create screens based upon the new entities. That's it!


Print | posted on domenica 21 novembre 2010 12:37 | Filed Under [ Visual Studio 2010 Visual Basic Windows Azure Visual Studio LightSwitch ]


No comments posted yet.

Post Comment

Please add 1 and 3 and type the answer here:

Powered by:
Powered By Subtext Powered By ASP.NET