Solved

The Using reference for SQL in VS 2012 Windows Store.

Posted on 2013-06-06
3
314 Views
Last Modified: 2013-06-07
The following link states it is the following..

       using System.Data.SqlClient;

But that has an error at .Data.. Trying to hand type it, the intellasense says there is no .Data as a choice.. Neither did I see any other winning combos.. Except For system.IO  and it doesn't work by itself and after system.IO the only next step in system.IO.Compression (which isn't it)..

Also opp. clicking on the error for SQLConnection or SQLCommand brings up no "Resolve" help where it will just add the Reference needed..
0
Comment
Question by:moosetracker
  • 2
3 Comments
 
LVL 63

Accepted Solution

by:
Fernando Soto earned 500 total points
ID: 39227881
Hi moosetracker;

Please read this article on MSDN Magazine on Data Access and Storage Options in Windows Store Apps. Window Store apps does not support MS SQL Server, Express or LocalDb.
0
 
LVL 1

Author Closing Comment

by:moosetracker
ID: 39228482
Thank you so much..  I have spent literally weeks looking for an async SQL solution and asking questions..  I got little response to my questions, but I thought after all that searching from bits & pieces of different articles I was ready to pull this together until I immediately hit a rock with the using statement..

You are the real help to point me to looking away from local SQL, to perhaps SQL lite or perhaps an index DB.. Although this article gives some basic commands hopefully surfing the net looking for different criteria will give me some good examples also..

Of course now I fear what SQL lite does not have that SQL had, problem being this Windows App is for my company who will have an in-house SQL asp.net program, which will be pushing & pulling data to their sales force who will have tablets with the Window Store app on them..
0
 
LVL 63

Expert Comment

by:Fernando Soto
ID: 39229406
Hi moosetracker;

You may want to look into Web Services and the ASP.NET Web API as outlined in the article I posted. This is where the database lives on another machine the Web Service has functions that can be called by the Windows Store app and the results of that function/query returned to you via HTTP response as XML or JSON.

Good Luck.
0

Featured Post

Networking for the Cloud Era

Join Microsoft and Riverbed for a discussion and demonstration of enhancements to SteelConnect:
-One-click orchestration and cloud connectivity in Azure environments
-Tight integration of SD-WAN and WAN optimization capabilities
-Scalability and resiliency equal to a data center

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
ASP/VB email question 4 46
Winforms -- Capture CTRL+SHIFT+D at the form not working? 3 26
Using Third Party DLL with Access VBA 14 41
programming a polycom voip phone 3 32
In this post we will learn how to connect and configure Android Device (Smartphone etc.) with Android Studio. After that we will run a simple Hello World Program.
Today, the web development industry is booming, and many people consider it to be their vocation. The question you may be asking yourself is – how do I become a web developer?

820 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question