What is difference between CommandBuilder and DataAdapter class?
The **SqlCommandBuilder** opens the Connection associated with the DataAdapter and makes a round trip to the server each and every time it's asked to construct the action queries.
Check below linkCommand Object, Command Builder, Data Adapter object,https://www.c-sharpcorner.com/UploadFile/mahesh/command-object-command-builder-data-adapter-object-ado-net/
The SQL SELECT command is relatively simple to write. Even if you are unfamiliar with SQL SELECT commands, the Query Builder in Visual Studio can assist you. However, there are three other commands to build in figure 1: InsertCommand, UpdateCommand, and DeleteCommand. In.NET, these commands can become quite complex because they require complex parameter objects and frequently involve large lists of columns. ADO.NET includes a useful utility called the CommandBuilder that automatically generates these commands for you. The relationship between CommandBuilder and DataAdapter is depicted in Figure 1. CommandBuilder is built with DataAdapter and immediately generates the remaining Command objects, like elastic man.