using System.Data.SqlClient; SqlConnection connection = new SqlConnection(connectionString); connection.Open(); SqlCommand command = new SqlCommand("INSERT INTO Customers (Name, City) VALUES ('John Smith', 'New York')", connection); command.ExecuteNonQuery(); connection.Close();
using System.Data.SqlClient; SqlConnection connection = new SqlConnection(connectionString); connection.Open(); SqlCommand command = new SqlCommand("SELECT * FROM Customers", connection); SqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { Console.WriteLine(reader["Name"].ToString()); } connection.Close();
using System.Data.SqlClient; SqlConnection connection = new SqlConnection(connectionString); connection.Open(); SqlCommand command = new SqlCommand("SELECT COUNT(*) FROM Customers", connection); int count = (int)command.ExecuteScalar(); Console.WriteLine("Number of customers: " + count); connection.Close();The SqlCommand class is part of the System.Data.SqlClient package which is included in the .NET Framework.