All Questions
Tagged with postgresql c#
2,404
questions
1
vote
0
answers
42
views
Is a service opening a lot of connections to the database correct?
I have a small application which I have build into a Docker container, run in K8S and read from a PostgresQL database with Npgsql.
I hit it with 10K req / minute on a scale of 4 pods, so in best load ...
1
vote
1
answer
22
views
Query produces "function unnest(unknown) is not unique error", but is executed fine by the application
I was playing around with composite types in Postgres and Npgsql, and noticed interesting behaviour.
I have a UDT in the db created as follows:
CREATE TYPE ids_test AS (first int, second int);
In ...
- 1,057
1
vote
1
answer
65
views
How to do connection pooling in a multi tenant application?
I am writing on a multi-tenant, micro-service app in C#.Net. We are having 5 services which handle the tenant-sensible data (a bunch more for global data) and we want to go live soon with 8.000 ...
0
votes
1
answer
72
views
Entity Framework: could not create socket for "db_connection": listen unix /tmp/cloudsql-proxy-tmp/db_connection/.s.PGSQL.5432: bind: invalid argument
I'm using Google Cloud Run to host a .Net Core 8 application using the Google Cloud Functions Framework. THe entity framework version is 8.0.7. The PostgreSQL database is hosted on Google Cloud SQL. ...
- 245
1
vote
0
answers
20
views
How to sync elastic search with a multi tenant microservice domain splitted database?
we have an application developed within the last 3 years. The app has a multi tenant systen in which we have 2 kinds of data bases: global (e.g. users, 1 user can be working in several tenants) and ...
1
vote
1
answer
42
views
output values From Postgresql procedure
I have a working procedure in Postgresql with input and input/output vlaues. And now im trying to use this procedure in my code .net Framework 4. But i cant.
If i open connection and use ...
- 13
1
vote
0
answers
33
views
Seeding data in Entity Framework
I'm using Entity Framework to manage a Postgresql database, which has three tables - Products, ProductCategories and ProductImages.
These three tables are related to each other through foreign keys, ...
- 33
0
votes
0
answers
33
views
Primary Key Value conflict in Entity Framework
I'm using Entity Framework to mapping a Postgres database which has three tables - Products, ProductCategories and ProductImages. If I have a blank database, when I insert a new record, I can see the ...
- 33
2
votes
0
answers
85
views
Complex select from DB with EF Core without materializing the query
It seems that I need some help from EF guru. So, I have Postgres DB with EF Core in my project. There is a table RequestDbModel which might contain many rows with the same Id and different ts. I need ...
- 33
0
votes
0
answers
67
views
Cannot translate EF Core linq query (change SRID of point)
In the code below, I was trying to get geographic points from the database and filter them based on the distance to the user.
var pointQueryable = DbContext.Points.OrderBy(x => x.Title)....
- 3
0
votes
1
answer
131
views
Getting error connecting a Web API to PostgreSQL
I am switching from SQL Server to PostgreSQL, and have a Web API that I have updated as follows.
In the appsettings.json file, I have:
{
"ConnectionStrings": {
"MPmain":...
- 43
0
votes
0
answers
23
views
EnableRetryOnFailure() not working for "40001" Serialization
I'm working on a project based on Winforms, C# with Entity Framework, writing/reading data from a PostgreSQL database.
I'm going to have only a low number of clients (4/5) and low traffic, so I ...
- 195
0
votes
0
answers
34
views
I'm using ASP.NET Core 8.0 Web API with C# and Marten framework. Tables aren't auto-creating in PgAdmin 4 and migrations aren't happening. Any advice?
I'm using Marten with PostgreSQL in an ASP.NET Core application. I've configured Marten with AutoCreate.All to auto-create schemas, but tables aren't being created on first connection. Here's my ...
1
vote
0
answers
49
views
Testcontainers with Bitnami PostgreSql
I use Testcontainers with Bitnami PostgreSql docker image for integration tests. Container always crashes after I start running tests. I checked the container logs and saw these messages. What I can ...
- 118
0
votes
0
answers
38
views
Case sensitive on Nhibernate in Search Path Postgres
I trying use a string connection who have a Search Path and this one have a Schema who is Case sensitive. I already tried use " and ' but no of these helps me, anyone have see this?
Server=...
