Npgsql - .Net Provider for PostGreSQL - is an excellent driver. If you have used the more traditional ADO.NET framework you are really in luck here. I have code that connects to Oracle that looks almost identical to the PostGreSQL connections. Easier to transition off of Oracle and reuse brain cells.

How do I connect C# with Postgres? I installed the npgsql data provider but couldn't make it work. Are there more examples than the ones in the Postgres site?

Почему происходит ошибка ClassNotFound: org.postgresql.Driver в веб-приложении, хотя в обычном все работает? Задать вопрос Вопрос задан 7 лет 5 месяцев назад Изменён 7 лет 5 месяцев назад

An ODBC driver, on the other hand, will have a deeper stack. A call has to go through the ODBC .NET provider, which then makes an unmanaged call to the ODBC driver manager, which then calls the PostgreSQL ODBC driver. Whether or not this would actually have an impact on performance would depend on the application and usage.

You can only set the connection timeout on the connection string, the timeout for your query would normally be on the command timeout. (Assuming we are talking .net here, I can't really tell from your question). However the command timeout has no effect when the command is executed against a context connection (a SqlConnection opened with "context connection=true" in the connection string).

Magnus Hagander, a Postgresql developer, elaborates on this: "All users connecting from the local machine, your domain, or a trusted domain will be automatically authenticated using the SSPI configured authentication (you can enable/disable things like NTLMv2 or LM using Group Policy - it's a Windows configuration, not a PostgreSQL one). You still need to create the login role in PostgreSQL ...

This is now possible through the Npgsql.EntityFrameworkCore.PostgreSQL NuGet package and associated Entity Framework Core packages. Apparently the PostgreSQL team was tired of waiting around for ODBC support (which still isn't available in the latest netstandard2.0 yet) and wrote their own driver using netstandard - back in the November timeframe.

Needs sqlalchemy, postgresql, and psycopg2 to get it to work. PS: The question is about a postgres://... URL, but this would not work here. Instead, you need postgresql, and what is run in the end in Python is dialect+driver (see Database URLs) = postgresql+psycopg2, without having to write it like this.

Last time I used Npgsql, i.e., version 1.0, it worked very slow. Is there any other alternative to Npgsql?

I have a data table with 1000 of records. I want to perform a bulk insert operation from C# to PGSQL. I know one way which copies a text file to pgtable. The example syntax is as follows: using (