Connect to Sql Database and get data C#

1. Download Nuget package Mysql.Data
2. Import namespace MySql.Data.MySqlClient
3. Construct the connectionstring eg., server=localhost;user=root;password=secret;database=myDatabase

Employees has three rows 

EmployeeId, FirstName and LastName

var connectionString = $"server={dbCon.Server};user={dbCon.UserName};password={dbCon.Password};database={dbCon.DatabaseName}";

using var connection = new MySqlConnection(connectionString);

connection.Open();

string query = "select * from Employees";

    var cmd = new MySqlCommand(query, connection);

    var reader = cmd.ExecuteReader();

    while (reader.Read()){

        Console.WriteLine($"{reader.GetString(0)} {reader.GetString(1)} {reader.GetString(2)}");

    }