Generate SQL command automatically from SqlCommandBuilder and SqlDataAdapter : SqlCommandBuilder « Database ADO.net « C# / C Sharp





Generate SQL command automatically from SqlCommandBuilder and SqlDataAdapter

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:\n{0}\n", thisAdapter.SelectCommand.CommandText);

         SqlCommand updateCommand = thisBuilder.GetUpdateCommand();
         Console.WriteLine("SQL UPDATE Command is:\n{0}\n", updateCommand.CommandText);

         SqlCommand insertCommand = thisBuilder.GetInsertCommand();
         Console.WriteLine("SQL INSERT Command is:\n{0}\n", insertCommand.CommandText);

         SqlCommand deleteCommand = thisBuilder.GetDeleteCommand();
         Console.WriteLine("SQL DELETE Command is:\n{0}", deleteCommand.CommandText);

         thisConnection.Close();

  }
}



           
       










Related examples in the same category

1.new SqlConnectionStringBuilder(conString)
2.InitialCatalog
3.IntegratedSecurity
4.MinPoolSize
5.MaxPoolSize
6.LoadBalanceTimeout
7.ConnectionReset