sqlite check column exists c#

CheckIfColumnExists

private bool CheckIfColumnExists(string tableName, string columnName)
{
   using(var conn = new SQLiteConnection("Data Source=mydb.sqlite;"))
   {
     conn.Open();
     var cmd = conn.CreateCommand();
     cmd.CommandText = string.Format("PRAGMA table_info({0})", tableName);
           
     var reader = cmd.ExecuteReader();
     int nameIndex = reader.GetOrdinal("Name");
     while (reader.Read())
     {
         if (reader.GetString(nameIndex).Equals(columnName))
             return true;
     }
     conn.Close();
    }
    return false;
}

@karennk
reader.GetString expects an integer parameter, the index of the column in the result set.

In this case the index of the 'Name' column of the query PRAGMA table_info(mytable) is 1. So reader.GetString(nameIndex) will returns the value name of the column. This value is compared with the method parameter.

Thank you for the explanation.