blocks|key|4119745|text|好了，这是一个很好的问题，我不得不通过艰苦的方式来学习。默认情况下，WinRT应用程序不能直接访问任何类型的数据库结构。这意味着没有快速、紧凑、CE、SQLite等。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4119746|有三种方法可以解决这个问题。不要使用数据库，而应使用存储和检索数据的本地文件结构。XML可以很好地利用这一点，因为您可以维护数据库提供的许多相同的特性。|4119747|第二种选择是使用IndexedDB。它类似于cookie样式的本地存储模型，其中文件保存在应用程序的本地应用程序文件夹中。|4119748|第三个也是最后一个选项是使用web服务。WinRT确实可以访问互联网，这意味着您可以编写可调用的API和WebServices。这确实意味着您需要有一个连接到master数据库的正在运行的服务器。当您的应用程序需要数据时，它会调用您的web服务并获取所需的数据。|4119749|总体而言，对于您描述的应用程序，第一个选项可能最适合您的需求。在应用程序文件夹中保留一个本地XML文件，并对其进行读/写操作。|4119750|entityMap^0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|M|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|N|8|@]|9|@]|A|$]]|$1|F|3|G|5|6|7|O|8|@]|9|@]|A|$]]|$1|H|3|I|5|6|7|P|8|@]|9|@]|A|$]]|$1|J|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|K|$]]

Ok, this is a great question that I had to learn the hard way. By default WinRT applications do NOT have access to, directly at least, to any type of database structure. This means no Express, Compact, CE, SQLite etc.

There are three ways around this. Do not use a database and instead use a local file structure where you store and retrieve your data. XML works very nicely with this because you can maintain many of the same features a database would give you. 

The second option is to use IndexedDB. It is similar to a cookie style local storage model where files are saved in your apps local apps folder. 

The third and final option is to use web services. WinRT does have access to the internet which means you can write API and WebServices that can be called. This does mean that you need to have a server running which is connected to a master database. When your app needs data it calls your web service and obtains what it needs. 

Overall, for the application you are describing the first option may best suite your needs. Keep a local XML file in your apps folder and read/write from it.

blocks|key|289732|text|WinRT支持SQLite。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|289733|http://visualstudiogallery.msdn.microsoft.com/23f6c55a-4909-4b1f-80b1-25792b11639e|offset|length|289734|entityMap|0|LINK|mutability|MUTABLE|url^0|0|0|2A|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|N|8|@]|9|@$D|O|E|P|1|Q]]|A|$]]|$1|F|3|-4|5|6|7|R|8|@]|9|@]|A|$]]]|G|$H|$5|I|J|K|A|$L|C]]]]

SQLite is supported for WinRT.

<a href="http://visualstudiogallery.msdn.microsoft.com/23f6c55a-4909-4b1f-80b1-25792b11639e" rel="noreferrer">http://visualstudiogallery.msdn.microsoft.com/23f6c55a-4909-4b1f-80b1-25792b11639e</a>

blocks|key|289760|text|SQLite是用于Win+8应用程序的推荐数据库。实现相同功能的链接|type|unstyled|depth|inlineStyleRanges|offset|length|style|BOLD|entityRanges|data|289761|http://timheuer.com/blog/archive/2012/08/07/updated-how-to-using-sqlite-from-windows-store-apps.aspx|289762|http://code.msdn.microsoft.com/windowsapps/Using-SQLite-Asynchronously-b8372137|289763|https://visualstudiogallery.msdn.microsoft.com/23f6c55a-4909-4b1f-80b1-25792b11639e|289764|entityMap|0|LINK|mutability|MUTABLE|url|1|2^0|0|6|0|0|2S|0|0|0|27|1|0|0|2B|2|0^^$0|@$1|2|3|4|5|6|7|U|8|@$9|V|A|W|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|X|8|@]|D|@$9|Y|A|Z|1|10]]|E|$]]|$1|H|3|I|5|6|7|11|8|@]|D|@$9|12|A|13|1|14]]|E|$]]|$1|J|3|K|5|6|7|15|8|@]|D|@$9|16|A|17|1|18]]|E|$]]|$1|L|3|-4|5|6|7|19|8|@]|D|@]|E|$]]]|M|$N|$5|O|P|Q|E|$R|G]]|S|$5|O|P|Q|E|$R|I]]|T|$5|O|P|Q|E|$R|K]]]]

SQLite is the recommended database to be used for Win 8 Apps.
Links for implementing the same

<a href="http://timheuer.com/blog/archive/2012/08/07/updated-how-to-using-sqlite-from-windows-store-apps.aspx" rel="nofollow">http://timheuer.com/blog/archive/2012/08/07/updated-how-to-using-sqlite-from-windows-store-apps.aspx</a>

<a href="http://code.msdn.microsoft.com/windowsapps/Using-SQLite-Asynchronously-b8372137" rel="nofollow">http://code.msdn.microsoft.com/windowsapps/Using-SQLite-Asynchronously-b8372137</a>

<a href="https://visualstudiogallery.msdn.microsoft.com/23f6c55a-4909-4b1f-80b1-25792b11639e" rel="nofollow">https://visualstudiogallery.msdn.microsoft.com/23f6c55a-4909-4b1f-80b1-25792b11639e</a>

blocks|key|5848519|text|我的question被标记为这个问题的副本(尽管它是关于C%2B%2B的，而不是C#)。我想我还是应该在这里发布我的发现。C%2B%2B应用程序还有另一种选择：|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|5848520|Extensible+Storage+Engine+(ESE)|5848521|可用于应用商店应用的所有此类应用程序接口的列表可以在this+link的Jet部分下找到。|5848522|entityMap|0|LINK|mutability|MUTABLE|url|https://stackoverflow.com/questions/18500763/using-a-database-for-a-windows-8-store-app-using-c|1|http://msdn.microsoft.com/en-us/library/gg269259%2528v=exchg.10%2529.aspx|2|http://msdn.microsoft.com/en-us/library/windows/apps/br205753.aspx^0|2|8|0|0|0|V|1|0|Q|9|2|0^^$0|@$1|2|3|4|5|6|7|T|8|@]|9|@$A|U|B|V|1|W]]|C|$]]|$1|D|3|E|5|6|7|X|8|@]|9|@$A|Y|B|Z|1|10]]|C|$]]|$1|F|3|G|5|6|7|11|8|@]|9|@$A|12|B|13|1|14]]|C|$]]|$1|H|3|-4|5|6|7|15|8|@]|9|@]|C|$]]]|I|$J|$5|K|L|M|C|$N|O]]|P|$5|K|L|M|C|$N|Q]]|R|$5|K|L|M|C|$N|S]]]]

My <a href="https://stackoverflow.com/questions/18500763/using-a-database-for-a-windows-8-store-app-using-c">question</a> was marked as a duplicate of this question (although it was about C++ not C#). I thought I should still post my findings here. C++ apps have another alternative:

<a href="http://msdn.microsoft.com/en-us/library/gg269259%28v=exchg.10%29.aspx" rel="nofollow noreferrer">Extensible Storage Engine (ESE)</a>

The list of all such API available for Store apps can be found on <a href="http://msdn.microsoft.com/en-us/library/windows/apps/br205753.aspx" rel="nofollow noreferrer">this link</a> under the section Jet.

blocks|key|5848545|text|作为变种之一：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|5848546|一个全功能、高性能的LinqConnect解决方案，用于开发使用LINQ或ADO.NET访问数据的Windows+Store应用程序。|5848547|http://code.msdn.microsoft.com/windowsapps/A-Simple-Windows-Store-85f29843#content|offset|length|5848548|或者下一个链接可以用来|5848549|http://social.technet.microsoft.com/wiki/contents/articles/18417.windows-store-app-with-a-sqlite-database.aspx|5848550|entityMap|0|LINK|mutability|MUTABLE|url|1^0|0|0|0|2A|0|0|0|0|32|1|0^^$0|@$1|2|3|4|5|6|7|T|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|U|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|V|8|@]|9|@$F|W|G|X|1|Y]]|A|$]]|$1|H|3|I|5|6|7|Z|8|@]|9|@]|A|$]]|$1|J|3|K|5|6|7|10|8|@]|9|@$F|11|G|12|1|13]]|A|$]]|$1|L|3|-4|5|6|7|14|8|@]|9|@]|A|$]]]|M|$N|$5|O|P|Q|A|$R|E]]|S|$5|O|P|Q|A|$R|K]]]]

As one of variant:

Devart LinqConnect for Metro – a fully-functional high-performance ORM solution for developing Windows Store applications using either of LINQ or ADO.NET to access data.

<a href="http://code.msdn.microsoft.com/windowsapps/A-Simple-Windows-Store-85f29843#content" rel="nofollow">http://code.msdn.microsoft.com/windowsapps/A-Simple-Windows-Store-85f29843#content</a>

or next link can be usefull to

<a href="http://social.technet.microsoft.com/wiki/contents/articles/18417.windows-store-app-with-a-sqlite-database.aspx" rel="nofollow">http://social.technet.microsoft.com/wiki/contents/articles/18417.windows-store-app-with-a-sqlite-database.aspx</a>

I'am programming a <code>Windows 8 Store App</code> (Metro Design) with <code>C#</code> and <code>XAML</code> using <code>Visual Studio 2012</code>.

There is no need for a database server with multi user support etc.

I want to store my data in a local database and don't know which database is suitable for my needs.
Maybe <code>SQLite</code>? Or are there solutions that fits better for Windows Store Apps and integrates better in Visual Studio?

The app is kind of a calender and the database should store the user data that consists of the dates, tasks and so on.

Which local database is suitable for Windows 8 Store Apps?

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

我正在编程一个Windows 8 Store App (地铁设计)与C#和XAML使用Visual Studio 2012。不需要具有多用户支持等的数据库服务器。我想将我的数据存储在本地数据库中，而不知道哪个数据库适合我的需求。也许是SQLite？或者，是否有更适合Windows应用商店应用并在Visual Studi...

问哪种本地数据库适用于Windows 8应用商店应用？
EN

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问哪种本地数据库适用于Windows 8应用商店应用？EN