Data Access in Windows 8 WinRT

I’ve been teasing out details about the Windows Runtime (WinRT) here at Microsoft’s BUILD conference in Anaheim, California.

WinRT is the runtime for touch-friendly Metro-style apps, in effect Microsoft’s operating system for tablets, though it has a dual personality and full desktop Windows is also available.

Microsoft experts told me that there is no client for SQL Server or other network databases in WinRT. To access such databases, you have to create a web service and call that. This is similar to the Silverlight model. The .NET Framework in WinRT will support WCF RIA Services, which is one option for this.

If you only want to store and retrieve data locally, there seems to be a JET API, or you could use something like SQLite or roll your own simple database manager. HTML and JavaScript apps support IndexedDB. All these options read and write data to the app’s isolated storage; they do not enable free access to the file system.

LINQ (Language Integrated Query) is supported but of course that is only as useful as the data it can connect to.

VN:F [1.9.18_1163]
Rate this post
Rating: 7.7/10 (3 votes cast)
Data Access in Windows 8 WinRT, 7.7 out of 10 based on 3 ratings

Related posts:

  1. Using Windows Runtime (WinRT) APIs from desktop applications
  2. Windows 8 sideloading and Embarcadero’s Metropolis fake-WinRT framework
  3. Not allowed in Windows 8 Metro: porn, ads in live tiles, bugs, or opt-out data collection
  4. Fixing slow access to SharePoint mapped drives in Windows 7
  5. Switching from Windows will not protect your data, says Trusteer CEO

1 comment to Data Access in Windows 8 WinRT