Using the ADO.NET Driver

Npgsql is an ADO.NET data provider that you can use to access a Yellowbrick database server from a program developed for the ADO.NET framework. You can develop ADO.NET applications that create tables, load data from local files, and run queries.

To connect to a Yellowbrick database from an ADO.NET application:

  1. Download the npgsql driver.
  2. Develop your ADO.NET program by following the guidelines in the npgsql documentation.
  3. Define a connection to the Yellowbrick server. The connection string must contain the following parameters:
    • Host
    • Port (5432)
    • Database
    • User
    • Password
    For example: 
    Host=yb007;Port=5432;Username=ybd;Database=premdb";Password=********;