Solved

The Using reference for SQL in VS 2012 Windows Store.

Posted on 2013-06-06
3
319 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Enroll in July's Course of the Month

July's Course of the Month is now available! Enroll to learn HTML5 and prepare for certification. It's free for Premium Members, Team Accounts, and Qualified Experts.

Question has a verified solution.

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

It was really hard time for me to get the understanding of Delegates in C#. I went through many websites and articles but I found them very clumsy. After going through those sites, I noted down the points in a easy way so here I am sharing that unde…
This article will inform Clients about common and important expectations from the freelancers (Experts) who are looking at your Gig.
With the power of JIRA, there's an unlimited number of ways you can customize it, use it and benefit from it. With that in mind, there's bound to be things that I wasn't able to cover in this course. With this summary we'll look at some places to go…
Six Sigma Control Plans

617 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