1. Course
  2. SQLite Databases
  3. Create database and tables

Create database and tables

Last updated: 8/23/2020 Difficulty: Intermediate

Create a C# program that creates a version 3 SQLite 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 connection against the database file, 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


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



SQLite Databases

2 / 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.