csharp c# crud - mysql

csharp c# crud - mysql.md

Select

// dotnet add package MySql.Data --version 9.0.0

using MySql.Data.MySqlClient;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

string query = "SELECT 1;";
string config = "server=localhost;username=root;password=;database=json";

MySqlConnection connection = new MySqlConnection(config);
MySqlCommand command = new MySqlCommand(query, connection);
connection.Open();
MySqlDataReader Reader = command.ExecuteReader();

while (Reader.Read())
{
  Console.WriteLine(Reader[0].ToString());
}