README.md

MVFC.SQLCraft.SQLite

🇧🇷 Leia em Português

Driver for SQLite access using [MVFC.SQLCraft] and System.Data.SQLite.

Installation

dotnet add package MVFC.SQLCraft.SQLite

Features

• Connection with SQLite
• Integration with SqlKata
• Support for .NET 9.0+

Example

using MVFC.SQLCraft.SQLite;

SQLiteCraftDriver driver = new(connectionString);

driver.Execute("CREATE TABLE IF NOT EXISTS Persons (Id INTEGER PRIMARY KEY AUTOINCREMENT, Name TEXT NOT NULL);");
var insertQ = new Query("Persons")
                    .AsInsert(new 
                    {
                         Name = "Alice" 
                    });

var affected = driver.Execute(insertQ);

License

MIT