Alessandro Del Sole's Blog

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

My Links

News

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 2012

Order my book about VB 2012 on Amazon My book "Visual Basic 2012 Unleashed" is available. Click the cover!

My new book on LightSwitch!

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

Your visits

campusMVP.NET - Tutored online training for Microsoft developers

Follow me on Twitter!

Messenger me!


CyberInstaller Beta Tester

Download CIS 2008!!

CodePlex download Download my open-source projects from CodePlex!

Search the blog



Article Categories

Archives

Post Categories

.NET Framework

Blogroll

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!

Alessandro

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

Feedback

No comments posted yet.

Post Comment

Title  
Name  
Email
Url
Comment   
Please add 3 and 8 and type the answer here:

Powered by:
Powered By Subtext Powered By ASP.NET