WINRT / Metro Apps & .net System.Data - DataTable

Oct 19, 2012 at 1:58 AM

Can the .Net DataTable / DataSet object be used/referenced in WinRT / Metro application development?

We are currently working on a series of WPF applications that connect to WCF Services... We are trying to expose complex types and typed collections in place of DataTables & DataSets, but we have not removed all responses that do return DataSet/DataTables...

What are the best practices and type limitations (specifically DataSet/DataTable) regarding consuming remote data?


Oct 19, 2012 at 6:31 AM

To be honest I haven't used DataSets since probably around 2005, so I am not sure what the best prectise is. I can only speculate that WinStore apps are often more focused on a single task and porting entire libraries from WPF is not the best idea. Also there is no direct database access in WinRT, so you can use something like SQLite if you need a local database, but there is no ADO.NET or anything like that. If you want to work with existing databases - and you already use WCF - you would probably want to add a service reference to your WinStore app and let it generate the data access components for the new platform, since that should give you classes that support the new async/await keywords (based on this article, since I haven't had to do it yet).

I would also ask your question in the MSDN Forums and Stack Overflow, since these are my first go to places for such questions.

Mar 13, 2013 at 2:44 PM

Here is a database compatible with WinRT: