What is the difference between Command and CommandBuilder object?



What is the difference between Command and CommandBuilder object?..

Answer / Prateek Keshari

1. A Command represents an SQL statement or stored procedure, while a CommandBuilder generates the necessary commands for a DataAdapter based on the database schema.
2. A Command is directly used to execute SQL statements or calls to stored procedures, whereas a CommandBuilder is primarily used in conjunction with a DataAdapter.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More ADO.NET Interview Questions

Which components of a data provider is used to retrieve, insert, delete, or modify data in a data source?

1 Answers  


What are the Features and disadvantages of dataset

1 Answers   Microsoft,


What is dataset object? Explain the various objects in dataset.

1 Answers  


What is ODP.NET ?

1 Answers   TCS,


What are the advantages of ado.net?

1 Answers  


What is ado.net explain with diagram?

1 Answers  


How do you update a dataset in ado.net?

1 Answers  


How do you update a dataset in ado.net and how do you update database through dataset?

1 Answers  


ADO and ADO.NET differences ?

2 Answers   Microsoft,


Why is stored procedure used in ado.net?

1 Answers  


Difference between function and trigger?

1 Answers   HCL,


Where is adodb dll located?

1 Answers  


Categories