when should use SqlCommand and SqlCommandBuilder

SqlCommand is object that allow to execute query like insert update and delete.

SqlCommandBuilder - Automatically generates single-table commands that are used to reconcile changes made to a DataSet with the associated SQL Server database. for generating query you need to create object of sqlcommand and need to attach it with SQLAdapter. IT make use of SelectCommand query to generate intsert,upate and delete query.

You can read more : https://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqlcommandbuilder%28v=vs.110%29.aspx

So basic difference is SqlCommand is just object to perform sql operation for which you need to create and assign sql query but SQLCommandBuilder is object that generates insert,update and delete query using selectcommand and also listen for changes done in datatable.So commandbuilder object is helpful when you dont want to create insert,update and delete query and when you want to update your datatable/dataset just using update method.

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Pranay Rana11y ago
Accepted answer
SqlCommand is object that allow to execute query like insert update and delete.

SqlCommandBuilder - Automatically generates single-table commands that are used to reconcile changes made to a DataSet with the associated SQL Server database. for generating query you need to create object of sqlcommand and need to attach it with SQLAdapter. IT make use of SelectCommand query to generate intsert,upate and delete query.

You can read more : https://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqlcommandbuilder%28v=vs.110%29.aspx

So basic difference is SqlCommand is just object to perform sql operation for which you need to create and assign sql query but SQLCommandBuilder is object that generates insert,update and delete query using selectcommand and also listen for changes done in datatable.So commandbuilder object is helpful when you dont want to create insert,update and delete query and when you want to update your datatable/dataset just using update method.