To generate a DECLARE DATATABLE statement

  1. Start the OpenESQL Assistant.
  2. Connect to a data source.
  3. Check the box next to a table name.
  4. Click Generate DataTable.

This feature is available only when you set the following Visual Studio options for OpenESQL Assistant as follows:

  • Mode option set to ADO.NET
  • Generate option set to EXEC ADO - disconnected model