I'm trying to insert data with parameters to PostgreSQL 16 in C#. I have the following code: using (var myConnection = new NpgsqlConnection(myConnectionString)) { myConnection.Open(); var insertAllData = $@" DO $$ DECLARE new_production_item_id INTEGER; BEGIN INSERT INTO public.production_items (my_data_type_id, created_by,…
Problem Statement I am using Entity Framework (EF) Core and PostgreSQL. In my target table, there is a JSONB column that might contain a version number. My goal is to sort the query by this version number, but the version…
I'm trying to make my application work with Docker Compose but every time I run docker-compose up -d, my API crashes at startup (I am TRYING to migrate my database with EF Core in case I am not in production).…
I encountered an issue while attempting to modify my SQL query to address warnings about potential SQL injection. I aimed to parameterize the query and use raw string literals, but I received an error message instead. It seems the error…
I need to get the results of a query as JSON but I've been having issue if a column is a JSONarray: it gets converted to string The current code I'm using: var result = new List<Dictionary<string, object>>(); await using…
How to apply SET TIME ZONE to NpgsqlCommand? Attempt 1. SET TIME ZONE in CommandText, separated from select with ; using var cmd = connection.CreateCommand(); cmd.CommandText = "SET TIME ZONE '+02:00'; select "t0"."start_time" from "task"."tasks" "t0" where "t0"."number" = 217";…
Considering the case in which we've got two tables, say: SubscriptionPayments and OrderPayments inherit the shared table Payments. Is there a way to find out within the table Payments which table any record belongs to; in other words, is it…
I am saving a C# DateTime.MinValue to a PostgreSQL column of type timestamp with timezone with EFCore 7.05 and Ngpsql 7.04 Date = {1/01/0001 12:00:00 AM} Kind = Utc When I load the column, the value becomes Date = {1/01/0001…
I am developing a small application. I could not create the database as an idea. My data will be as follows, should I create separate tables for them or should I use them in a single table using The Adjacency…
I just wanted to know what would happen if there are multiple insert and update statements like (insert into sales(),insert into saledetails(), update sale etc.) getting executed and if any exception occurs then will be a rollback of all or…