Your application accesses a table named Orders from a Microsoft SQL Server database. The Orders table includes a primary key. You use DbDataAdapter to fill a DataTable with rows selected from the Orders table. You must configure the DbDataAdapter so that you can use it to update the Orders table with changes that your application makes to the DataTable.

What should you do?

When the SelectCommand property is specified dynamically at run time, such as through a query tool that takes a textual command from the user, you might not be able to specify the appropriate InsertCommand, UpdateCommand, or DeleteCommand at design time. If your DataTable maps to or is generated from a single database table, you can take advantage of the DbCommandBuilder object to generate the DeleteCommand, InsertCommand, and UpdateCommand of the DbDataAdapter automatically.

Setting the MissingSchemaAction property to AddWithKey ensures that schema information is retrieved. It does not configure DbDataAdapter to perform updates.

Calling the DataTable.AcceptChanges method commits changes to the DataTable. It does not configure DbDataAdapter to perform updates.