如何在Visual Studio中连接到Sqlite并创建数据库？ [英] How to connect to Sqlite in Visual Studio and create database?

问题描述

我找不到在Visual Studio（Winform项目）中连接到Sqlite的任何方法。

我已经使用Nget管理器安装了Sqlite库。

在数据源（左侧栏）中，我看不到Sqlite的连接，只有SQL：

我应该安装Slite吗用户计算机上的数据库还是数据库将内置到.exe程序中？

我尝试使用SqliteMaestro创建数据库，它将databse文件保存在程序目录中，没有扩展名，例如数据库。我可以将此文件添加到解决方案C＃中吗？

解决方案

以防有人遇到相同的问题。您可能需要通过从

I can not find any way to connect to Sqlite in Visual Studio(Winform project).

I have installed libraries Sqlite using Nget manager.

In data source(left sidebar) I can not see connection to Sqlite, only SQL:

Should I install a Slite database on the user's computer or the database will be built into the .exe program?

I tried to create database using SqliteMaestro, it saved databse file in program directory without extension as database. May I add this file to solution C#?

解决方案

In case somebody had the same issue. You may need to install SQLite Data Provider by downloading the suitable version from here. You can follow this tutorial to setup everything.

Check SQLite/SQL Server Compact Toolbox, it is a great tool to manage SQLite databases in Visual Studio (like SQL Server Explorer).

这篇关于如何在Visual Studio中连接到Sqlite并创建数据库？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！