question

xarzu avatar image
xarzu asked

How do I put an API layer and a UI layer to my SQL Azure database?

How do I put an API layer and a UI layer to my SQL Azure database? I have created a SQL Azure database complete with ready-to-go tables on my Azure cloud. I have configured my Microsoft SQL Server Management Studio to load this database locally. Now what? How do I put an API layer and a UI layer to my SQL Azure database? Does anyone have any suggestions of some good sample code?
azuresql-azure
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

KenJ avatar image
KenJ answered
Here is a demo video of creating an application with MS LightSwitch that uses SQL Azure: http://www.microsoft.com/en-us/showcase/details.aspx?uuid=063dcd81-ecaf-4ca0-be0a-2befb8581ebf
3 comments
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Does one have to download a LightSwitch SDK? I do not see it as an option for a new project in Visual Studio.
0 Likes 0 ·
Is lightswitch still available? I cannot use Visual Studio 2012
0 Likes 0 ·
It's still available - http://www.microsoft.com/visualstudio/en-us/lightswitch You aren't allowed to use Visual Studio 2012? You can connect to SQL Azure from any language for which you have a driver. Java, for instance: http://www.windowsazure.com/en-us/develop/java/how-to-guides/using-sql-azure-in-java/
0 Likes 0 ·
xarzu avatar image
xarzu answered
I am not allowed to use Visual Studio 2012 on my machine because it seems to be difficult at best to use Visual Studio 2012 to make apps for Windows Phone. It seems that the SDK to make Windows Phone Apps does not play well with Visual Studio 2012. There seems to be some places on the Microsoft site where it tells you that you cannot have lightswitch by itself and there are other places where it suggests that you can. Here it says you cannot have it: ![ http://i67.photobucket.com/albums/h292/Athono/AZURE/lightswitch-1.png][1] ![ http://i67.photobucket.com/albums/h292/Athono/AZURE/lightswitch2-1.png][2] But with this update tool I found, you can have it: ![IMG] http://i67.photobucket.com/albums/h292/Athono/AZURE/LightswitchAfterall.png[/IMG][3] [1]: http://i67.photobucket.com/albums/h292/Athono/AZURE/lightswitch-1.png [2]: http://i67.photobucket.com/albums/h292/Athono/AZURE/lightswitch2-1.png [3]: http://i67.photobucket.com/albums/h292/Athono/AZURE/LightswitchAfterall.png
1 comment
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

I haven't tried it with VS2012, but I can use it with VS 2010. You might also download the trial version and see if it does what you're after
0 Likes 0 ·
xarzu avatar image
xarzu answered
KenJ, The links on that page goes to a 2012 download page for Visual Studio. Lightswitch is no longer available if you have a reason to stay with the older version of Visual Studio.
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.