{"id":4874,"date":"2011-09-16T06:24:54","date_gmt":"2011-09-16T05:24:54","guid":{"rendered":"http:\/\/www.itwriting.com\/blog\/4874-data-access-in-windows-8-winrt.html"},"modified":"2011-09-16T06:24:54","modified_gmt":"2011-09-16T05:24:54","slug":"data-access-in-windows-8-winrt","status":"publish","type":"post","link":"https:\/\/www.itwriting.com\/blog\/4874-data-access-in-windows-8-winrt.html","title":{"rendered":"Data Access in Windows 8 WinRT"},"content":{"rendered":"<p>I\u2019ve been teasing out details about the Windows Runtime (WinRT) here at Microsoft\u2019s BUILD conference in Anaheim, California.<\/p>\n<p>WinRT is the runtime for touch-friendly Metro-style apps, in effect Microsoft\u2019s operating system for tablets, though it has a dual personality and full desktop Windows is also available.<\/p>\n<p>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 <a href=\"http:\/\/www.silverlight.net\/learn\/advanced-techniques\/wcf-ria-services\" target=\"_blank\">WCF RIA Services<\/a>, which is one option for this.<\/p>\n<p>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 <a href=\"http:\/\/www.w3.org\/TR\/IndexedDB\/\" target=\"_blank\">IndexedDB<\/a>. All these options read and write data to the app\u2019s isolated storage; they do not enable free access to the file system.<\/p>\n<p>LINQ (Language Integrated Query) is supported but of course that is only as useful as the data it can connect to.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>I\u2019ve been teasing out details about the Windows Runtime (WinRT) here at Microsoft\u2019s BUILD conference in Anaheim, California. WinRT is the runtime for touch-friendly Metro-style apps, in effect Microsoft\u2019s 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 &hellip; <a href=\"https:\/\/www.itwriting.com\/blog\/4874-data-access-in-windows-8-winrt.html\" class=\"more-link\">Continue reading <span class=\"screen-reader-text\">Data Access in Windows 8 WinRT<\/span> <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2,55,67],"tags":[586,858,999,1028],"class_list":["post-4874","post","type-post","status-publish","format-standard","hentry","category-net","category-microsoft","category-professional","tag-microsoft","tag-sql-server","tag-windows-8","tag-winrt"],"_links":{"self":[{"href":"https:\/\/www.itwriting.com\/blog\/wp-json\/wp\/v2\/posts\/4874","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.itwriting.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.itwriting.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.itwriting.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.itwriting.com\/blog\/wp-json\/wp\/v2\/comments?post=4874"}],"version-history":[{"count":0,"href":"https:\/\/www.itwriting.com\/blog\/wp-json\/wp\/v2\/posts\/4874\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.itwriting.com\/blog\/wp-json\/wp\/v2\/media?parent=4874"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.itwriting.com\/blog\/wp-json\/wp\/v2\/categories?post=4874"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.itwriting.com\/blog\/wp-json\/wp\/v2\/tags?post=4874"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}