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;

Input

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

Output



                    

Solution

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.

Advertising