SQLite3 in C # .NET

Question

I am trying to use SQLite3 in C # .NET. I googled around and found several different APIs. I also checked the SQLite site for wrappers. I like them, but I want to write my own shell without using the added dependency. All the wrappers that I discovered do not require additional dependency, are not free.

I am wondering how you can read, execute and write to sqlite3 database. Is this a socket connection (tcp? Udp? Etc.?)? I tried looking for this answer on Google, and all I get is answers to specific libraries.: / SQLite site docs don't help much.

EDIT: I also found a COM interface while searching the web, but is this a specific library?

Thanks!:)

Answer 1

Have you looked at the System.Data.SQLite library ? This is a free ADO.NET library for interacting with SQLite and does not require anything else to run, because it has an integrated engine.

I have been using it for some time and find it very easy to work with. It even has a plugin for Visual Studio if you decide to use some strongly typed tables with it or want to use it to add / create tables.

Answer 2

(Answer to the question "Connecting a socket.")

SQLite , - , , .

Answer 3

SQLite .NET, System.Data.SQLite, ADO.NET SQLite

Answer 4

System.Data.SQLite , , SqlClient. .

throw P/Invoke, SQLite. P/Invoke , DataReader