✅ Catching different errors using System.Data.SQLite

public void CreateSomeTable()
{
  Using SQLiteConnection conn = new(_dbFile);
  Using SQLiteCommand cmd = conn.CreateCommand();

  conn.Open();

  cmd.CommandText = @"CREATE TABLE IF NOT EXISTS
                      [login] (
                      [Username] VARCHAR(15),
                      [Password] VARCHAR(30),
                      UNIQUE(Username)
                      )";
  try
  {
      cmd.ExecuteNonQuery();
  }
  catch (SQLiteException ex)
  {
      throw new SQLiteExecption ex;
  }
}

public void InsertNewUser(UserModel user)
{
  Using SQLiteConnection conn = new(_dbFile);
  ...

  cmd.CommandText = @"INSERT INTO login(Username, Password) VALUES ($un, $pw)";
  cmd.Parameters.AddWithValue("$un", user.Username);
  cmd.Parameters.AddWithValue("$pw", user.Password);

  try
  {
      cmd.ExecuteNonQuery();
  }
  catch (SQLiteException ex)
  {
      throw new SQLiteException(ex.Message);
  }
}

public class DatabaseErrorHandler()
{
  public void HandleUniqueEntryError()
  {
      // some code here
  }
}