when should use SqlCommand and SqlCommandBuilder

Question

Hello Senior/Friends i want to know that which scenario we should use SqlCommand and SqlcommandBuilder Thanks

Pranay Rana · 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 intsertupate 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 insertupdate and delete query using selectcommand and also listen for changes done in datatable.So commandbuilder object is helpful when you dont want to create insertupdate and delete query and when you want to update your datatable/dataset just using update method.