Hello everybody, 

I have created a SQL Database in Azure and create some tables in it. I have also inserted and read data by using some queries in Azure. I have also succesfully added my sql server in Visual Studio and my tables are showing to me but How I have to insert and read data from those tables from windows strore application???

Hi,

You cannot access the SQL database directly from your store app so you have to create some sort of a "service layer". One option is to create an Web API, host that in Azure and access this API from your windows store app.

This example hopefully gives you a starting point.

Edward

• Marked as answer by Syed Mudassir Shah 16 hours 31 minutes ago

Hi,

You cannot access the SQL database directly from your store app so you have to create some sort of a "service layer". One option is to create an Web API, host that in Azure and access this API from your windows store app.

This example hopefully gives you a starting point.

Edward

• Marked as answer by Syed Mudassir Shah 16 hours 42 minutes ago

Hi,

I don't think ADO.NET is available from Windows Store Apps. The way I see it there are two options that immediately come to mind:

• There is a good post that illustrates how to expose SQL data from WebAPI for a Windows Store app.
• You can use the Windows 8 SDK for Mobile Services and hook up a Mobile Service to your database (this provides limitations about how you interact with your database to fit in with the Mobile Services structure, but means you don't have to implement a separate API).

• Marked as answer by Syed Mudassir Shah 16 hours 31 minutes ago

Hi,

I don't think ADO.NET is available from Windows Store Apps. The way I see it there are two options that immediately come to mind:

• There is a good post that illustrates how to expose SQL data from WebAPI for a Windows Store app.
• You can use the Windows 8 SDK for Mobile Services and hook up a Mobile Service to your database (this provides limitations about how you interact with your database to fit in with the Mobile Services structure, but means you don't have to implement a separate API).

• Marked as answer by Syed Mudassir Shah 16 hours 42 minutes ago

Hi,

You cannot access the SQL database directly from your store app so you have to create some sort of a "service layer". One option is to create an Web API, host that in Azure and access this API from your windows store app.

This example hopefully gives you a starting point.

Edward

• Marked as answer by Syed Mudassir Shah Tuesday, February 04, 2014 6:59 PM

Hi,

You cannot access the SQL database directly from your store app so you have to create some sort of a "service layer". One option is to create an Web API, host that in Azure and access this API from your windows store app.

This example hopefully gives you a starting point.

Edward

• Marked as answer by Syed Mudassir Shah Tuesday, February 04, 2014 6:59 PM

Hi,

You cannot access the SQL database directly from your store app so you have to create some sort of a "service layer". One option is to create an Web API, host that in Azure and access this API from your windows store app.

This example hopefully gives you a starting point.

Edward

• Marked as answer by Syed Mudassir Shah Tuesday, February 04, 2014 6:59 PM

Hi,

You cannot access the SQL database directly from your store app so you have to create some sort of a "service layer". One option is to create an Web API, host that in Azure and access this API from your windows store app.

This example hopefully gives you a starting point.

Edward

• Marked as answer by Syed Mudassir Shah Tuesday, February 04, 2014 6:59 PM

Hi,

You cannot access the SQL database directly from your store app so you have to create some sort of a "service layer". One option is to create an Web API, host that in Azure and access this API from your windows store app.

This example hopefully gives you a starting point.

Edward

• Marked as answer by Syed Mudassir Shah Tuesday, February 04, 2014 6:59 PM

Hi,

I don't think ADO.NET is available from Windows Store Apps. The way I see it there are two options that immediately come to mind:

• There is a good post that illustrates how to expose SQL data from WebAPI for a Windows Store app.
• You can use the Windows 8 SDK for Mobile Services and hook up a Mobile Service to your database (this provides limitations about how you interact with your database to fit in with the Mobile Services structure, but means you don't have to implement a separate API).

• Marked as answer by Syed Mudassir Shah Tuesday, February 04, 2014 6:59 PM

Hi,

I don't think ADO.NET is available from Windows Store Apps. The way I see it there are two options that immediately come to mind:

• There is a good post that illustrates how to expose SQL data from WebAPI for a Windows Store app.
• You can use the Windows 8 SDK for Mobile Services and hook up a Mobile Service to your database (this provides limitations about how you interact with your database to fit in with the Mobile Services structure, but means you don't have to implement a separate API).

• Marked as answer by Syed Mudassir Shah Tuesday, February 04, 2014 6:59 PM

Hi,

I don't think ADO.NET is available from Windows Store Apps. The way I see it there are two options that immediately come to mind:

• There is a good post that illustrates how to expose SQL data from WebAPI for a Windows Store app.
• You can use the Windows 8 SDK for Mobile Services and hook up a Mobile Service to your database (this provides limitations about how you interact with your database to fit in with the Mobile Services structure, but means you don't have to implement a separate API).

• Marked as answer by Syed Mudassir Shah Tuesday, February 04, 2014 6:59 PM

Hi,

I don't think ADO.NET is available from Windows Store Apps. The way I see it there are two options that immediately come to mind:

• There is a good post that illustrates how to expose SQL data from WebAPI for a Windows Store app.
• You can use the Windows 8 SDK for Mobile Services and hook up a Mobile Service to your database (this provides limitations about how you interact with your database to fit in with the Mobile Services structure, but means you don't have to implement a separate API).

• Marked as answer by Syed Mudassir Shah Tuesday, February 04, 2014 6:59 PM

Hi,

I don't think ADO.NET is available from Windows Store Apps. The way I see it there are two options that immediately come to mind:

• There is a good post that illustrates how to expose SQL data from WebAPI for a Windows Store app.
• You can use the Windows 8 SDK for Mobile Services and hook up a Mobile Service to your database (this provides limitations about how you interact with your database to fit in with the Mobile Services structure, but means you don't have to implement a separate API).

• Marked as answer by Syed Mudassir Shah Tuesday, February 04, 2014 6:59 PM