x

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?
more ▼

asked Sep 06 '12 at 09:54 PM in Default

xarzu gravatar image

xarzu
60 6 8 9

(comments are locked)
10|1200 characters needed characters left

3 answers: sort voted first

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

more ▼

answered Sep 07 '12 at 03:53 PM

KenJ gravatar image

KenJ
19.1k 1 3 11

Does one have to download a LightSwitch SDK? I do not see it as an option for a new project in Visual Studio.
Sep 07 '12 at 07:38 PM xarzu
Is lightswitch still available? I cannot use Visual Studio 2012
Sep 07 '12 at 07:48 PM xarzu

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/
Sep 07 '12 at 08:17 PM KenJ
(comments are locked)
10|1200 characters needed characters left

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 http://i67.photobucket.com/albums/h292/Athono/AZURE/lightswitch2-1.png

But with this update tool I found, you can have it:

![IMG]http://i67.photobucket.com/albums/h292/Athono/AZURE/LightswitchAfterall.png/IMG

more ▼

answered Sep 09 '12 at 08:47 PM

xarzu gravatar image

xarzu
60 6 8 9

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
Sep 09 '12 at 10:27 PM KenJ
(comments are locked)
10|1200 characters needed characters left

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.
more ▼

answered Sep 10 '12 at 07:31 AM

xarzu gravatar image

xarzu
60 6 8 9

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x20
x4

asked: Sep 06 '12 at 09:54 PM

Seen: 698 times

Last Updated: Sep 10 '12 at 07:31 AM