How do I access SQL Server from Windows 8 apps?

Question

I realize that a local SQL Server instance is not accessible to my Windows 8 app. Instead, I have a SQL Server in Azure. In SQL Server Management Studio, I just change the querystring and interact with the Azure database like any other. How can I reference that database in my Windows 8 app?

Answer 1

This is what the Azure Mobile Services SDK is for. Scott Guthrie did a writeup on it a while back.

Undoubtedly you're aware that both ado.net and Entity Framework are missing from WinRT... Notice the glaring absence of support for System.Data.