1. Course
  2. SQLite Databases
  3. Create in memory database

Create in memory database

Last updated: 8/23/2020 Difficulty: Intermediate

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;


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




SQLite Databases

3 / 4

Android App

Practice C# anywhere with the free app for Android devices.

Android App

Exercises C# by difficulty

Learn C# at your own pace, the exercises are ordered by difficulty.

Make a donation

Your donations support our work and contribute to the maintenance of the app.