The table adapters are designed to be used with a dataset, to help you get data in and out of the DB using this dataset.
Idea is that you can use the
Dataset.NewYourTableNameRow() to create a new row for your dataset, then populate its fields and then call
DataSet.AddYourTableNameRow(row) to put it in the dataset.
Now you can
orderTableAdapter.update(DataSet) to transmit that new row into the database.
To delete or update a row, you would select it first into your dataset, perform a change to the object, then call the .update(ds) on the appropriate table adapter to send it back down.