sqlite2019

Sharp Develop –> Menu Project –> Manage Packages

nainstalovat balicky

System.Data.SQLite.Core.MSIL
System.Data.SQLite.Core.MSIL

zkopirovat packages/SQLite.Interop.1.0.0/lib/SQLite.Interop.dll do adresare k .EXE souboru

using System;
using System.Collections.Generic;
using System.Drawing;
using System.Windows.Forms;
 
using System.Data.SQLite;
 
namespace pokus
{
	public partial class MainForm : Form
	{
		public MainForm()
		{
			InitializeComponent();
		}
 
		void Button1Click(object sender, EventArgs e)
		{
			string db_path = "c:\\temp\\data.sqlite";
                        SQLiteConnection.CreateFile(db_path);
			SQLiteConnection conn = new SQLiteConnection("Data Source=" + db_path + ";Version=3;");
                        conn.Open();
                        SQLiteCommand cmd;
                        cmd = new SQLiteCommand ("CREATE TABLE nameindex (name TEXT, id INTEGER)", conn);
                        cmd.ExecuteNonQuery();
                        conn.Dispose();
		}
	}
}

https://medium.com/@alexandermlharris/sqlite-and-ef6-the-tutorial-that-works-181da420899f

https://github.com/damienbod/SQLiteExamples

https://github.com/icsharpcode/SharpDevelop/tree/master/src/AddIns/DisplayBindings/Data/ICSharpCode.Data.Addin

https://www.youtube.com/watch?v=iX0fYGy6_9A

Sharp Develop

DB Browser for SQLite

SQLite