jt0DtmNA

1using (SqliteConnection db = new SqliteConnection("Filename=sqliteSample.db"))
2{
3    db.Open();
4    var tableCommand = "CREATE TABLE IF NOT EXISTS MyTable (Primary_Key INTEGER PRIMARY KEY AUTOINCREMENT, Text_Entry NVARCHAR(2048) NULL)";
5    var createTable = new SqliteCommand(tableCommand, db);
6    try
7    {
8        createTable.ExecuteReader();
9        db.Close();
10    }
11    catch (SqliteException e)
12    {
13        //Do nothing
14    }
15}
16	
17public Contexte()
18        {
19            if (!_created)
20            {
21                _created = true;
22                Database.EnsureDeleted();
23                Database.EnsureCreated();
24            }
25        }
26        protected override void OnConfiguring(DbContextOptionsBuilder optionbuilder)
27        {
28            optionbuilder.UseSqlite(@"Data Source=AideProf.db");
29        }