using System;

using System.Data.SQLite;

public class Program

{

    public static void Main()

    {

        string databasepath = @"URI=file:C\Users\Xovvo\databases\knowledgebase.db";

        using var conn = new SQLiteConnection(databasepath);

        conn.Open();

        using var cmd = new SQLiteCommand(conn);

        cmd.CommandText = @"CREATE TABLE Articles (id INT PRIMARY KEY,  title TEXT, article TEXT)";

        cmd.ExecuteNonQuery();

        cmd.CommandText = @"INSERT INTO Articles(id, title, article) VALUES (@id, @title, @article)";

        foreach (string id in list){

            cmd.Parameters.AddWithValue("@id", id);

            cmd.Parameters.AddWithValue("@title", articleTitle);

            cmd.Parameters.AddWithValue("@article", articleBody);

            cmd.Prepare();

            cmd.ExecuteNonQuery();

        }

    }

}