VB.NET - What is the use of Command builder?

What is the use of Command builder?

- Command builder generates insert/update/delete commands for data adapter based on select command.

- Automatic creation of insert/update/delete commands hinders performance.

- The command builder uses select command property of data adapter to determine values for other commands.

- Command builder builds “Parameter” objects automatically.

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

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

- It is used to build complex queries.

- It can even build commands that are based on the returned results.

- Command builder is less error prone and more readable than the command object.
VB.NET - Significance of Import and Using statement
Significance of Import and Using statement - To have same names declared and used in one or more namespaces, import aliases can be used.......
VB.NET - COM+ services
COM+ services - Queued components provide asynchronous message queuing.Object Pooling provides a pool of ready-made objects......
VB.NET - Shared member of the class
Shared member of the class - It is member of the class which can be access without creating instance of the class........
Post your comment