Muhammad Imran Ansari
What is difference between CommandBuilder and DataAdapter class?

What is difference between CommandBuilder and DataAdapter class?

By Muhammad Imran Ansari in .NET on Mar 27 2023
  • Burhan Yousuf
    Dec, 2023 14

    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.

    • 0
  • Mayooran Navamany
    Jun, 2023 24

    • 0
  • Serena Watson
    Apr, 2023 3

    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.

    • 0


Most Popular Job Functions


MOST LIKED QUESTIONS