using System; using System.Data.SqlClient; class Program { static void Main() { string connectionString = "Data Source=(local);Initial Catalog=Northwind;Integrated Security=True"; using (SqlConnection connection = new SqlConnection(connectionString)) { string query = "SELECT * FROM Customers"; using (SqlCommand command = new SqlCommand(query, connection)) { connection.Open(); using (IDataReader reader = command.ExecuteReader()) { while (reader.Read()) { Console.WriteLine("{0}\t{1}\t{2}", reader.GetString(0), reader.GetString(1), reader.GetString(2)); } } } } } }
using System; using MySql.Data.MySqlClient; using ConsoleTables; class Program { static void Main() { string connectionString = "Server=localhost;Database=mydatabase;Uid=root;Pwd=password;"; using (MySqlConnection connection = new MySqlConnection(connectionString)) { string query = "SELECT * FROM employees"; using (MySqlCommand command = new MySqlCommand(query, connection)) { connection.Open(); using (IDataReader reader = command.ExecuteReader()) { var table = new ConsoleTable("ID", "First Name", "Last Name", "Department"); while (reader.Read()) { table.AddRow(reader.GetInt32(0), reader.GetString(1), reader.GetString(2), reader.GetString(3)); } Console.WriteLine(table.ToString()); } } } } }In Example 1, the package library would be the System.Data.SqlClient namespace, which is included with the .NET framework. In Example 2, the package library would be the MySql.Data.MySqlClient namespace, which is provided by the MySql.Data package.