Difference between Sqlcommand and Sqlcommand builder Class

Question

Brief describe where we can use sqlcommand class and where sqlcommand builder because I think both class have the same work.

RanjithKumar chiguruvada · Answer

Hi Satya, SqlCommand : SqlCommand is used to execute Query involving Select, Update, Delete operation and to Execute SQL Stored procedures SqlCommandBuilder : SqlCommandBuilder provides the feature of reflecting the changes made to a DataSet or an instance of the SQL server data.The object of the SqlCommandBuilder acts as a listener for RowUpdating events, whenever the DataAdapter property is set. a) SQLCommand is used to execute all kind of SQL queries like DML(Insert, update,Delete) & DDL like(Create table, drop table etc) b) SQLCommandBuilder object is used to build & execute SQL (DML) queries like select, insert, update & delete. SqlCommandBuilder example as follows, DataSet ds = new DataSet(); SqlConnection cn = new SqlConnection("strSomeConnectionString"); //Autogenerate Insert, Update & Delete commands SqlDataAdapter da = new SqlDataAdapter("Select from t_Something", cn); SqlCommandBuilder scb = new SqlCommand(da);

Raman Ghantiyala · Answer

a) SQLCommand is used to execute all kind of SQL queries like DML(Insert, update,Delete) & DDL like(Create table, drop table etc) b)SQLCommandBuilder object is used to build & execute SQL (DML) queries like select, insert, update & delete.

Dorababu Meka · Answer

check here http://www.c-sharpcorner.com/forums/thread/150689/sqlcommandbuilder-class-in-ado-net.aspx

Difference between Sqlcommand and Sqlcommand builder Class

Answers (3)