C#.NET中的SQLite3 [英] SQLite3 in C#.NET

问题描述

我正在尝试在C#.NET中使用SQLite3.我四处搜寻，发现了一些不同的API.我还检查了SQLite网站上的包装器.我喜欢它们，但是想编写自己的包装而不使用附加的依赖项.我发现所有不需要添加依赖项的包装器都不都是免费的.

I'm trying to use SQLite3 in C#.NET. I've googled around and found some different API's. I also checked SQLite's website for wrappers. I like them, but want to write my own wrapper without using an added dependency. All wrappers I find that don't require an added dependency aren't free.

我想知道如何读取，执行和写入sqlite3数据库.它是套接字连接(tcp或udp等吗?)?我尝试在google上搜索此答案，而我得到的都是特定于库的答案.://SQLite的网站文档也没有太大帮助.

I'm wondering how one would read from, execute, and write to a sqlite3 database. Is it a socket connection(tcp? udp? etc?)? I've tried searching this answer on google and all I get are library-specific answers. :/ SQLite's website docs aren't much help either.

编辑:我还找到了

I also found a COM interface while googling, but is that library specific?

谢谢！:)

推荐答案

您是否看过 System.Data.SQLite 库?这是一个免费的ADO.NET库，可以与SQLite进行交互，并且不需要任何其他操作即可运行，因为它内置了引擎.

Have you looked at the System.Data.SQLite library? It's a free ADO.NET library to interact with SQLite and requires nothing else in order to run, since it has the engine built into it.

我已经使用了一段时间了，发现它真的很容易使用.如果您决定与其一起使用某些强类型表，或者想要使用它来添加/创建表，它甚至还具有Visual Studio插件.

I've been using it for a while now and find it really easy to work with. It even has a plugin for Visual Studio should you decide to use some strongly-typed tables with it or want to use it to add/create tables.

这篇关于C#.NET中的SQLite3的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！