Solved

The Using reference for SQL in VS 2012 Windows Store.

Posted on 2013-06-06
3
308 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 62

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 62

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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

A short article about a problem I had getting the GPS LocationListener working.
This is about my first experience with programming Arduino.
Viewers will learn how to properly install Eclipse with the necessary JDK, and will take a look at an introductory Java program. Download Eclipse installation zip file: Extract files from zip file: Download and install JDK 8: Open Eclipse and …
In this fourth video of the Xpdf series, we discuss and demonstrate the PDFinfo utility, which retrieves the contents of a PDF's Info Dictionary, as well as some other information, including the page count. We show how to isolate the page count in a…

910 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

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now