Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

The Using reference for SQL in VS 2012 Windows Store.

Posted on 2013-06-06
3
Medium Priority
?
338 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 64

Accepted Solution

by:
Fernando Soto earned 2000 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 64

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

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

This article will show how Aten was able to supply easy management and control for Artear's video walls and wide range display configurations of their newsroom.
Hello there! As a developer I have modified and refactored the unit tests which was written by fellow developers in the past. On the course, I have gone through various misconceptions and technical challenges when it comes to implementation. I would…
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 …
Introduction to Processes

877 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