MySqlConnection connection = new MySqlConnection(connectionString); MySqlCommand command = new MySqlCommand("SELECT * FROM users", connection); connection.Open(); MySqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { Console.WriteLine(reader.GetString("username")); } connection.Close();
public ListThis code creates a method to retrieve all employees from the database, creates a new MySqlConnection object with the provided connection string, creates a MySqlCommand object with the SQL query, opens the connection, executes the query using the ExecuteReader method, creates a new Employee object for each row in the result set, sets its properties using the reader object, adds it to a list, and returns the list of employees. Package library: The MySqlCommand class is a part of the MySql.Data package library which is used for interacting with MySQL databases in .NET applications.GetEmployees() { List employees = new List (); using (MySqlConnection connection = new MySqlConnection(connectionString)) { string sql = "SELECT * FROM employees"; MySqlCommand command = new MySqlCommand(sql, connection); connection.Open(); MySqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { Employee employee = new Employee(); employee.Id = reader.GetInt32("id"); employee.Name = reader.GetString("name"); employee.Position = reader.GetString("position"); employees.Add(employee); } connection.Close(); } return employees; }