This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Download Microsoft Edge
More info about Internet Explorer and Microsoft Edge
Microsoft.Data.Sqlite is a lightweight
ADO.NET
provider for SQLite. The
Entity Framework Core
provider for SQLite is built on top of this library. However, it can also be used independently or with other data access libraries.
Installation
The latest stable version is available on
NuGet
.
.NET Core CLI
Visual Studio
Usage
This library implements the common ADO.NET abstractions for connections, commands, data readers, and so on.
using (var connection = new SqliteConnection("Data Source=hello.db"))
connection.Open();
var command = connection.CreateCommand();
command.CommandText =
SELECT name
FROM user
WHERE id = $id
command.Parameters.AddWithValue("$id", id);
using (var reader = command.ExecuteReader())
while (reader.Read())
var name = reader.GetString(0);
Console.WriteLine($"Hello, {name}!");
You can see the full code for this example at HelloWorldSample.
See also
Connection strings
API Reference
SQL Syntax
