✅ Using SQLite with C#

private static readonly string dbFile = "habits.db";
public static void CreateDatabase()
{
  SQLiteConnection.CreateFile(dbFile);
  var sqlite = new SQLConnection("Data Source=" + dbFile);
  sqlite.Open();
  string sql = @"CREATE TABLE IF NOT EXISTS habits(
                  Id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
                  Name TEXT NOT NULL,
                  TrackType TEXT NOT NULL,
                  Description TEXT NOT NULL
                ";
  SQLiteCommand command = new SQLiteCommand(sql, sqlite);
  command.ExecuteNonQuery();
}
public static void SaveEntry(Habit newHabit)
{
  var slite = new SQLiteConnection("Data Source=" + dbFile);
  sqlite.Open();
  SQLiteCommand insertSQL = new SQLiteCommand(
    "INSERT INTO habits(Name, TrackType, Description) VALUES (?,?,?)",
    sqlite
  );
  insertSQL.Parameters.Add(newHabit.Name);
  insertSQL.Parameters.Add(newHabit.TrackType);
  insertSQL.Parameters.Add(newHabit.Description);

  try
  {
      insertSQL.ExecuteNonQuery();
  }
  catch (Exception ex)
  {
      throw new Exception(ex.Message);
}

public class Program
{
    public static void Main(string[] args)
    {
        string filePath = "habits.db";
        if (!File.Exists(filePath))
        {
            Database.CreateDatabase();
        }
        Habit newHabit = new()
        {
            Name = "Test",
            TrackType = "Count",
            Description = "Cigarettes Smoked"
        };
        Database.SaveEntry(newHabit);
     }
}