Your Microsoft SQL Server database includes the stored procedures GetAllOrders, GetAllCompletedOrders, and GetAllOpenOrders. These stored procedures return result sets that adhere to the same schema.

You need to choose a type to execute these stored procedures and fill a strongly typed DataSet. The type also must group the calls to these queries.

Which type should you use?

TableAdapters provide communication between your application and a database. Specifically, a TableAdapter connects to a database, executes queries or stored procedures, and either returns a new data table populated with the returned data or fills an existing DataTable with the returned data. TableAdapters are also used to send updated data from your application back to the database. Think of a TableAdapter as a DataAdapter with a built-in connection object and the ability to contain multiple queries. Each query added to a typed TableAdapter is exposed as a public method that is simply called like any other method or function on an object.