Questions tagged [npgsql]

Npgsql provides .NET based programs, written e.g. in C#, Visual Basic or F#, access to PostgreSQL databases via ADO.NET.

Filter by
Sorted by
Tagged with
0 votes
0 answers
106 views

ADO.NET entity data model wizard crashes when creating a Postgresql data model

I am having trouble creating an ado.net data model from an existing Postgres database. I have used Npgsql and connected successfully but the wizard crashes without any error when I try to add a new ...
user avatar
  • 3
0 votes
0 answers
183 views

How to efficiently do partial updates on huge dataset in Postgresql

Disclaimer: I am a total "newb" in regards to PgSql, but due to some unfortunate aligment of circumstances I am in charge of this project which I have to rewrite/migrate away from SqlServer (alone), ...
user avatar
0 votes
0 answers
80 views

SQL fast in PSQL, very slow using MS.NET driver

There's thread with exact same title and problem, but with no answer, NPGSQL driver takes very long time to execute queries, but other language drivers or terminal works fine. From what I've found, ...
user avatar
0 votes
1 answer
37 views

postgres npgsql DDL statement success or failure

I am using npgsql with a postgres DB, writing a DB updater that will need to execute a series of (usually) DDL statements like "ALTER TABLE ADD COLUMN blah..." and the like. The simple way to do this ...
user avatar
2 votes
1 answer
1k views

Concurrency / Transaction Concerns with PostgreSQL Copy (bulk insert)

We're building a CQRS system backed by Postgres. As part of this, we generate 'readmodels' which are precalculated projections of event sourced data. We regularly need to create new tables, query ...
user avatar
4 votes
2 answers
905 views

Postgres 11 - Fetching results after a transactiom

With the recent update of Postgres 11. It now supports procedures. Transactions are finally supported in stored procedures in Postgres. However, I have been trying to perform a transaction and ...
user avatar
3 votes
0 answers
3k views

Npgsql Timeout for simple query when run in parallel

I'm struggling to determine the cause of an exception when the code is run in parallel, but works fine when run one at a time. As background information, I'm running a set of unit tests, where each ...
user avatar
0 votes
1 answer
895 views

What is the relationship between ADO.NET and Npgsql?

There is a sentence in the Npgsql official page: Npgsql is an open source ADO.NET Data Provider for PostgreSQL. I know that I can access a Postgresql database using Npgsql with the .NET framework. ...
user avatar
4 votes
4 answers
19k views

Trying to connect to PostgreSQL with Entity Framework via Npgsql and C#

So, I'm new to databases and only have done a little with PostgreSQL before. I have C# (visual studio 2012) and have downloaded the Entity framework (6). I have also downloaded the latest Npgsql data ...
user avatar
  • 63