Questions tagged [npgsql]
Npgsql provides .NET based programs, written e.g. in C#, Visual Basic or F#, access to PostgreSQL databases via ADO.NET.
9
questions
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 ...
- 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), ...
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, ...
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 ...
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 ...
- 165
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 ...
- 141
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 ...
- 175
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.
...
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 ...
- 63