Create database and tables
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))