Create in memory database

Create a C# program that creates a SQLite version 3 in memory database with two tables (Person and Teacher). Use the SQL statements in the entry to create the tables.

To connect to SQLite open a new in memory connection, then create a new command using the SQLiteCommand object and finally run the command once for each table.

Remember that to connect to SQLite you will need the reference of System.Data.SQLite, you can get it from official page or install it directly in your project using the Nuguet package manager, executing the following command in the console:

Install-Package System.Data.SQLite -Version 1.0.112

The connection string required to connect in memory is as follows:

Data Source=:memory:;Version=3;New=True;

Input

create table person (name varchar(20), age int)
create table teacher (name varchar(20))

Output

Solution

using System.Data.SQLite;

public class CreateDatabaseInMemorySQLite
{
    public static string ConnectionString = "Data Source=:memory:;Version=3;New=True;";
    
    public static void Main(string[] args)
    {
        CreateTables();
    }

    public static void CreateTables()
    {
        using (SQLiteConnection cnx = new SQLiteConnection(ConnectionString))
        {
            cnx.Open();

            string sqlTablePerson = "create table person (name varchar(20), age int)";
            using (SQLiteCommand cmd = new SQLiteCommand(sqlTablePerson, cnx))
            {
                cmd.ExecuteNonQuery();
            }

            string sqlTableTeacher = "create table teacher (name varchar(20))";
            using (SQLiteCommand cmd = new SQLiteCommand(sqlTableTeacher, cnx))
            {
                cmd.ExecuteNonQuery();
            }
        }
    }
}