What is the use of CommandBuilder?

What is the use of CommandBuilder?

CommandBuilder builds “Parameter” objects automatically.

Example:
Dim pobjCommandBuilder As New OleDbCommandBuilder(pobjDataAdapter)
pobjCommandBuilder.DeriveParameters(pobjCommand)

If DeriveParameters method is used, an extra trip to the Datastore is madewhich can highly affect the efficiency.

What is the use of CommandBuilder?

CommandBuilder is used to build complex queries. It can even build commands that are based on the returned results. CommandBuilder is less error prone and more readable than the command object.
Difference between Optimistic and Pessimistic locking
In pessimistic locking, when a user opens a data to update it, a lock is granted..
What is connection pooling and what is the maximum Pool Size in ADO.NET Connection String?
A connection pool is created when a connection is opened the first time...
Can you explain how to enable and disable connection pooling?
To disable connection pooling set Pooling=false in connection string if it is an ADO.NET Connection..
Post your comment