using System; using System.Data; using System.Data.SqlClient; class Class1{ static void Main(string[] args){ SqlConnection thisConnection = new SqlConnection("server=(local)SQLEXPRESS;database=MyDatabase;Integrated Security=SSPI"); thisConnection.Open(); SqlDataAdapter thisAdapter = new SqlDataAdapter("SELECT ID from Employee", thisConnection); SqlCommandBuilder thisBuilder = new SqlCommandBuilder(thisAdapter); Console.WriteLine("SQL SELECT Command is: {0} ", thisAdapter.SelectCommand.CommandText); SqlCommand updateCommand = thisBuilder.GetUpdateCommand(); Console.WriteLine("SQL UPDATE Command is: {0} ", updateCommand.CommandText); SqlCommand insertCommand = thisBuilder.GetInsertCommand(); Console.WriteLine("SQL INSERT Command is: {0} ", insertCommand.CommandText); SqlCommand deleteCommand = thisBuilder.GetDeleteCommand(); Console.WriteLine("SQL DELETE Command is: {0}", deleteCommand.CommandText); thisConnection.Close(); } }