NuGet packages:
System.Data.SQLite
using System.Data.SQLite; using System; using System.IO; namespace SQLite3_CSharp { /// <summary> /// This class contains some simple functions /// </summary> class Database { /// <summary> /// Return name of file /// </summary> public string Name { get; private set; } private SQLiteConnection connection; /// <summary> /// Creates new database. /// </summary> /// <param name="name">Name of database.</param> public Database(string name) { Name = name+".sqlite"; if (File.Exists(Name)) throw new Exception("File already exists"); SQLiteConnection.CreateFile(Name); Connect(); } /// <summary> /// Connects to existing file. /// </summary> /// <param name="path">Path to file.</param> /// <param name="dummy">Just dummy bool, you can put anything.</param> public Database (string path, bool dummy) { Name = path; Connect(); } /// <summary> /// Creates connection to database. /// </summary> private void Connect() { connection = new SQLiteConnection(string.Format("Data Source = {0}; Version = 3;",Name)); connection.Open(); } /// <summary> /// Just write standard SQL command /// </summary> /// <param name="input">Command for database.</param> public void Command(string input) { SQLiteCommand sql = new SQLiteCommand(input, connection); sql.ExecuteNonQuery(); } } }