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=********;