What replaces System.Data ?

Question

Have a c# project written in 2009, trying to bring into the windows store universal app (windows 8.1 VS 2013, c#).  The old project has references to Microsoft.sql.server.types (SurveySegments), and System.Data.  Was getting errors - Error 1 Cannot find type System.SystemException in module mscorlib.dll. 

 that led me to this link...https://social.msdn.microsoft.com/forums/windowsapps/en-us/eac6e48e-ff8a-46b4-9482-04cba37245be/systemdatadll-error.

This says "System.Data not found in windows store. you should do database proccess with WebServices in windows store".

Has this been address in any new dll's?

How to fix this?

Answer 1

Hi mobilelou,

Sorry System.Data is not supported in Windows Store App. You may also see this Class is not supported via MSDN documentation.

To use database you may need use SQLite or some Web Service( for instance WCF).

--James

---

We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
Click HERE to participate the survey.

Answer 2

Ok . So, will SQLite (or other), have  Microsoft.sql.server.types\SurveySegments ?  It is not that I have a thing for System.data, rather than I want to do Metes and Bounds?  Thanks.

Answer 3

Hi mobilelou,

Sorry for a late response, base on the documentation: Microsoft.SqlServer.Types, the namespace is not intended to be used in your code.

Besides if you need to know how to work with SQLite, you may ref to some documentation: http://blogs.msdn.com/b/robertgreen/archive/2012/11/13/using-sqlite-in-windows-store-apps.aspx also SQLite

--James

---

We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
Click HERE to participate the survey.