blocks|key|2191690|text|在过去的几周里，我让SQLite在一个C%2B%2B/WinRT应用程序中工作。SQLite是内置在windows中的，但我没有很快发现，于是我走上了使用vcpkg中的官方版本并由sqlite.org发布的道路。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|2191691|我能够让库很容易地工作，但我无法掌握C接口的窍门。在vcpkg中也有一些很好的C%2B%2B包装，所以我尝试了其中的两个，并决定使用cpp。它似乎没有被积极的工作，但它只是一个接口，并很好地与版本3.28的sqlite。|2191692|为了开始使用sqlite或sqlite_modern_cpp，我使用了基本相同的方法。|2191693|1.使用vcpkg安装其中一个|style|BOLD|2191694|.\vcpkg.exe+install+sqlite-modern-cpp:x64-uwp|code-block|syntax|javascript|2191695|或|2191696|.\vcpkg.exe+install+sqlite3:x64-uwp|2191697|2.在vcpkg中启用用户范围的集成|2191698|.\vcpkg.exe+integrate+install|2191699|3.使用C%2B%2B/WinRT应用程序模板创建一个新项目|2191700|4.更改为x64+build|2191701|5.一旦更改为x64，就可以将以下内容添加到pch.h中|2191702|#include+"sqlite_modern_cpp.h"|2191703|2191704|#include+"sqlite3.h"|2191705|现在您可以创建sqlite并添加一个表。|2191706|此示例使用sqlit-现代型cpp，并将其放入空白应用程序模板的单击处理程序中，以便于放置。|2191707|void+MainPage::ClickHandler(IInspectable+const&,+RoutedEventArgs+const&)
{
++++myButton().Content(box_value(L"Clicked"));

++++//+path+for+the+temporary+database+file
++++hstring+path{+ApplicationData::Current().LocalFolder().Path()+%2B+L"\\temp.db"+};

++++//+store+the+file+name+for+use+later
++++std::string+fname+=+to_string(path.c_str());

++++//+open+a+connection+to+the+database+or+create+the+file+if+it+doesn't+exist
++++sqlite::database+db(fname);+//+default+is+READWRITE+%7C+CREATE

++++//+enable+foreign+keys
++++db+<<+"PRAGMA+foreign_keys+=+ON;";

++++//+create+a+new+table,+if+needed
++++db+<<+"CREATE+TABLE+IF+NOT+EXISTS+division+("
++++++++"+++id++++++++++INTEGER+PRIMARY+KEY+AUTOINCREMENT,"
++++++++"+++name++++++++TEXT++++NOT+NULL,"
++++++++"+++distance++++INTEGER+NOT+NULL,"
++++++++"+++size++++++++INTEGER+NOT+NULL,"
++++++++"+++lanes+++++++INTEGER+NOT+NULL,"
++++++++"+++rank++++++++INTEGER+NOT+NULL,"
++++++++"+++progression+TEXT++++NOT+NULL,"
++++++++"+++UNIQUE+(name,+distance,+size)"
++++++++");";
}|2191708|7.运行应用程序并单击按钮将生成db.。|2191709|使用上面的方法，文件将在app本地文件夹中创建。C:\Users\AppData\Local\Packages\LocalState\temp.db|2191710|entityMap|0|LINK|mutability|MUTABLE|url|https://github.com/Microsoft/vcpkg|1|https://www.sqlite.org/|2|https://github.com/SqliteModernCpp/sqlite_modern_cpp^0|21|5|0|2E|A|1|0|1Q|3|2|0|0|0|9|0|0|0|0|0|8|0|0|0|J|0|0|E|0|0|R|0|0|0|0|0|0|0|0|J|0|0^^$0|@$1|2|3|4|5|6|7|1V|8|@]|9|@$A|1W|B|1X|1|1Y]|$A|1Z|B|20|1|21]]|C|$]]|$1|D|3|E|5|6|7|22|8|@]|9|@$A|23|B|24|1|25]]|C|$]]|$1|F|3|G|5|6|7|26|8|@]|9|@]|C|$]]|$1|H|3|I|5|6|7|27|8|@$A|28|B|29|J|K]]|9|@]|C|$]]|$1|L|3|M|5|N|7|2A|8|@]|9|@]|C|$O|P]]|$1|Q|3|R|5|6|7|2B|8|@]|9|@]|C|$]]|$1|S|3|T|5|N|7|2C|8|@]|9|@]|C|$O|P]]|$1|U|3|V|5|6|7|2D|8|@$A|2E|B|2F|J|K]]|9|@]|C|$]]|$1|W|3|X|5|N|7|2G|8|@]|9|@]|C|$O|P]]|$1|Y|3|Z|5|6|7|2H|8|@$A|2I|B|2J|J|K]]|9|@]|C|$]]|$1|10|3|11|5|6|7|2K|8|@$A|2L|B|2M|J|K]]|9|@]|C|$]]|$1|12|3|13|5|6|7|2N|8|@$A|2O|B|2P|J|K]]|9|@]|C|$]]|$1|14|3|15|5|N|7|2Q|8|@]|9|@]|C|$O|P]]|$1|16|3|R|5|6|7|2R|8|@]|9|@]|C|$]]|$1|17|3|18|5|N|7|2S|8|@]|9|@]|C|$O|P]]|$1|19|3|1A|5|6|7|2T|8|@]|9|@]|C|$]]|$1|1B|3|1C|5|6|7|2U|8|@]|9|@]|C|$]]|$1|1D|3|1E|5|N|7|2V|8|@]|9|@]|C|$O|P]]|$1|1F|3|1G|5|6|7|2W|8|@$A|2X|B|2Y|J|K]]|9|@]|C|$]]|$1|1H|3|1I|5|6|7|2Z|8|@]|9|@]|C|$]]|$1|1J|3|-4|5|6|7|30|8|@]|9|@]|C|$]]]|1K|$1L|$5|1M|1N|1O|C|$1P|1Q]]|1R|$5|1M|1N|1O|C|$1P|1S]]|1T|$5|1M|1N|1O|C|$1P|1U]]]]

I've been getting SQLite working in a C++/WinRT app over the last couple of weeks. SQLite is built into the windows sdk but I didn't discover that soon enough and went down the path of using the official version available in <a href="https://github.com/Microsoft/vcpkg" rel="nofollow noreferrer">vcpkg</a> and put out by <a href="https://www.sqlite.org" rel="nofollow noreferrer">sqlite.org</a>.

I was able to get the library working fairly easily but I wasn't able to get the hang of the C interface. There are some good C++ wrappers also available in vcpkg so I tried 2 of them and settled on using <a href="https://github.com/SqliteModernCpp/sqlite_modern_cpp" rel="nofollow noreferrer">sqlite_modern_cpp</a>. It doesn't seem to be actively worked on but it's just an interface and works well with version 3.28 of sqlite.

To start using either sqlite or sqlite_modern_cpp I use basically the same method.

1. Install one of them using vcpkg

<pre><code>.\vcpkg.exe install sqlite-modern-cpp:x64-uwp
</code></pre>

or

<pre><code>.\vcpkg.exe install sqlite3:x64-uwp
</code></pre>

2. Enable user-wide integration in vcpkg

<pre><code>.\vcpkg.exe integrate install
</code></pre>

3. Create a new project using C++/WinRT Blank App template

4. Change to x64 build

5. Once you change to x64, you should be able to add the following to pch.h

<pre><code>#include "sqlite_modern_cpp.h"
</code></pre>

or

<pre><code>#include "sqlite3.h"
</code></pre>

6. Now you can create a sqlite db and add a table

This example uses sqlite-modern-cpp and was put in the click handler of the blank app template just to have somewhere to put it. 

<pre><code>void MainPage::ClickHandler(IInspectable const&amp;, RoutedEventArgs const&amp;)
{
 myButton().Content(box_value(L"Clicked"));

 // path for the temporary database file
 hstring path{ ApplicationData::Current().LocalFolder().Path() + L"\\temp.db" };

 // store the file name for use later
 std::string fname = to_string(path.c_str());

 // open a connection to the database or create the file if it doesn't exist
 sqlite::database db(fname); // default is READWRITE | CREATE

 // enable foreign keys
 db &lt;&lt; "PRAGMA foreign_keys = ON;";

 // create a new table, if needed
 db &lt;&lt; "CREATE TABLE IF NOT EXISTS division ("
 " id INTEGER PRIMARY KEY AUTOINCREMENT,"
 " name TEXT NOT NULL,"
 " distance INTEGER NOT NULL,"
 " size INTEGER NOT NULL,"
 " lanes INTEGER NOT NULL,"
 " rank INTEGER NOT NULL,"
 " progression TEXT NOT NULL,"
 " UNIQUE (name, distance, size)"
 ");";
}
</code></pre>

7. Running the app and clicking the button will generate the db.

Using the method above, the file will be created in the app local folder.
C:\Users\\AppData\Local\Packages\\LocalState\temp.db

I am trying to create C++/WinRT UWP app that connects to MySQL database but really any way of querying anything would be great; I just need to store and update my data in a convenient way and use it over LAN.

Learning about WinRT I was redirected to UWP docs where I've found ways to use System.Data.SQLite/SqlClient or MySQL.Data but all these return this:

<blockquote>
 You are trying to install this package into a project that targets 'native,Version=v0.0', but the package does not contain any assembly references or content files that are compatible with that framework.
</blockquote>

It means WinRT ("native") is not supported. 

I've found "SQLite for Windows Runtime (Windows 8.1)" but when I try to do <code>install-Package SQLite.WinRT</code> I'm getting the same error. What is the preferred way of storing relational data in WinRT or what am I doing wrong?

How to connect to SQL server from C++/WinRT UWP app?

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

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

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

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

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

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

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

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

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

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

我正在尝试创建连接到MySQL数据库的C++/WinRT应用程序，但是任何查询任何东西的方法都是很棒的；我只需要以一种方便的方式存储和更新我的数据，并在局域网上使用它。了解WinRT后，我被重定向到UWP文档，在那里我找到了使用System.Data.SQLite/SqlClient或MySQL.Data的方法，但所有...

如何从C++/WinRT UWP应用程序连接到SQL服务器？-腾讯云开发者社区-腾讯云

问如何从C++/WinRT UWP应用程序连接到SQL服务器？
EN

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何从C++/WinRT UWP应用程序连接到SQL服务器？EN

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何从C++/WinRT UWP应用程序连接到SQL服务器？
EN