Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

The Using reference for SQL in VS 2012 Windows Store.

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

The top UI technologies you need to be aware of

An important part of the job as a front-end developer is to stay up to date and in contact with new tools, trends and workflows. That’s why you cannot miss this upcoming webinar to explore the latest trends in UI technologies!

Question has a verified solution.

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

Computer science students often experience many of the same frustrations when going through their engineering courses. This article presents seven tips I found useful when completing a bachelors and masters degree in computing which I believe may he…
The SignAloud Glove is capable of translating American Sign Language signs into text and audio.
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…
Simple Linear Regression

715 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