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

Input

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

Output

Solution

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.

Advertising