Where to store query result from mysql, buffering?

Question

C++ / C#

1) Now I'm just outputting data, but where is it usually stored? In structure, collection?

MySqlConnection connect = new MySqlConnection("server=localhost;user=root;password=1;database=test");
connect.Open();
 string sql = "SELECT * FROM TABLE1";
MySqlCommand command = new MySqlCommand(sql, connect);
MySqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
                for (int i = 0; i < reader.FieldCount; i++)
                {
                    Console.Write($"{reader[i]}\t");
                }
                Console.WriteLine();
}
reader.Close();
connect.Close();

2) is the reader buffered? As I understand it, the result is stored on the server side and then line by line we get the results from it? Is it possible to get the whole query result?
Can I create a second reader without closing it and get the result?

Answer 1

If you received line by line from the server, then the method Readwould be asynchronous, but it is not. For storage, you describe the data model and fill it.

Answer 2

Change to any ORM, for example, EF, Dapper (if lightness is needed). And work immediately with models and collections.