Questions tagged [npgsql]
Npgsql provides .NET based programs, written e.g. in C#, Visual Basic or F#, access to PostgreSQL databases via ADO.NET.
0
votes
0answers
30 views
NpgsqlException: ERROR: 22P02: invalid input syntax for type json [migrated]
I have the following JSON string:
{"packedRecipeType":"DynamicCharacterAvatar","name":"Character","race":"HumanFemale","dna":[{"dnaType":"DynamicUMADna","dnaTypeHash":1932961400,"packedDna":"{\"...
0
votes
1answer
190 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 ...
3
votes
1answer
297 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 ...
3
votes
0answers
678 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 ...
0
votes
1answer
458 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
4answers
18k 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 ...
