How to use Npgsql with TableAdapter in C #

Question

I have a PostgresQL database and I am developing an application for the interface using C # and Npgsql to connect to the database, how can I assign an Npgsql connection to the TableAdapter?

Thanks,

Answer 1

I am in the same boat with PostgreSQL.

I do not think this is possible. Npgsql has its own data adapter (see http://npgsql.projects.postgresql.org/docs/manual/UserManual.html and searching for a text "adapter"). The disadvantage of this is that you cannot use Visual Studio Designer.

So instead, I use the .NET ODBC DataSource. To do this, you will need to install the postgresql odbc driver, which is available here: http://www.postgresql.org/ftp/odbc/versions/msi/ . After installation, you can go to Control Panel → Administrative Tools → Data Accounting (ODBC) to add a DSN (data source name). Finally, in Visual Studio, go to Server Explorer, right-click "Data Connections" and select "Add Connection ..." and change the Microsoft ODBC data source data source. Here you can select the DSN you provided earlier and viola! You are in business.

(Note that for some crazy reason, bools come in as strings. You can change this in the ODBC Data Source Administrator by clicking “Configure” on your PostgreSQL data source, going to the data source settings and unchecking “Bools as Char”, .)