Prerequisites

The following prerequisites are required before moving on to the OpenESQL Managed Code tutorials.

Prepare the BookDemo SQL Server Database
All OpenESQL Managed tutorials use the same SQL Server database, named BookDemo. Here you create the database and a database connection, but you populate it on an as-needed basis depending on the tutorial. Each tutorial provides instructions for populating the required tables.
Create the BookDemo Database
  • Using SQL Server Management Studio or another preferred method, create a SQL Server database named BookDemo.
    Note: The user ID and password you provide must log you on to SQL Server with dbadmin or sysadmin permissions that enable you to create a SQL Server database.
Create a Database Connection
  1. Start the ADO.NET Connection Editor. If you need instructions, see To start the ADO.NET Connection Editor as a user.
  2. On the main screen of the ADO.NET Connection Editor, click Add.

    This starts the ADO.NET Connection Editor wizard.

  3. On the Add an ADO.NET Connection page, click Next.
  4. In the Data Source Name field, type SQLDemo; then click Next.
  5. On the .NET Data Providers page, select SqlClient Data Provider; then click Next.
  6. In the Data Source field, type . (dot) to specify your local SQL Server instance.
  7. In the Initial Catalog field, type BookDemo, which is the name of your SQL Server database.
  8. Do one of the following to set authentication for your SQL Server instance:
    • If you want to connect using Windows authentication (recommended), change the value for the Integrated Security key to True.
    • If you want to connect by providing SQL Server-specific login credentials, type your SQL Server user ID and password into the Value fields for the User ID and Password keys respectively.
  9. Click Next, and then Finish.
  10. After the new connection appears on the main window of the ADO.NET Connection Editor, click Test to verify that the connection works.
  11. Click the x icon in the upper right corner of the ADO.NET Connection Editor main window to close it.