Simple SQLite DB With Dapper

CSharp · Console

/Program.cs

using System;
using System.Data.SQLite;
					
public class Program
{
	public static void Main()
	{
		string cs = "Data Source=database.sqlite;Cache Size=0";
		
		using(var con = new SQLiteConnection(cs))
		{
			con.Open();
			
			using (SQLiteCommand command = con.CreateCommand())
			{
				command.CommandText = "CREATE TABLE Test (NAME TEXT NOT NULL)";
				
				command.ExecuteNonQuery();
			}
		}
		
		using(var con = new SQLiteConnection(cs))
		{
			con.Open();
			
			using (SQLiteCommand command = con.CreateCommand())
			{
				command.CommandText = "INSERT INTO Test (NAME) VALUES ('marcOcram')";
				
				command.ExecuteNonQuery();
			}
		}
		
		using(var con = new SQLiteConnection(cs))
		{
			con.Open();
			
			using (SQLiteCommand command = con.CreateCommand())
			{
				command.CommandText = "SELECT NAME FROM Test";
				
				using (SQLiteDataReader dataReader = command.ExecuteReader())
				{
					while (dataReader.Read())
					{
						Console.WriteLine(dataReader["NAME"]);	
					}
				}
			}
		}
		
		using(var con = new SQLiteConnection(cs))
		{
			con.Open();
			
			using (SQLiteCommand command = con.CreateCommand())
			{
				command.CommandText = "UPDATE Test SET NAME = 'Kokujou' WHERE NAME = 'marcOcram'";
				
				command.ExecuteNonQuery();
			}
		}
		
		using(var con = new SQLiteConnection(cs))
		{
			con.Open();
			
			using (SQLiteCommand command = con.CreateCommand())
			{
				command.CommandText = "SELECT NAME FROM Test";
				
				using (SQLiteDataReader dataReader = command.ExecuteReader())
				{
					while (dataReader.Read())
					{
						Console.WriteLine(dataReader["NAME"]);	
					}
				}
			}
		}
	}
}