I have a query and two parameters. uuid and text. NpgsqlParameter is converting values into single quotes, which causes a syntax error. There must be double quotes in jsonb_path_exists. code: var idParam = new NpgsqlParameter("id", NpgsqlDbType.Uuid) { Value = id};…
We are using .NET Core 3.1, Microsoft.EntityFrameworkCore 3.1.9 and Npgsql 4.1.9. We have the following simple TestExecution scaffolded class: [Table("test_execution", Schema = "test")] public partial class TestExecution { [Key] [Column("id")] public int Id { get; set; } [Column("test_result")] public string…
I have a problem similar to Entity Framework 5: Using DatabaseGeneratedOption.Computed option. I want to have a creation and modification dates on every table in database. This is what I have now: public class BaseEntity { [NotNull] [Key] [DatabaseGenerated(DatabaseGeneratedOption.None)] public…
I am using Dapper with Postgres npgsql and I am having trouble executing an SQL command using INTERVAL. The command works fine outside my code. I get the error Npgsql.PostgresException: '42601: syntax error at or near "$1" POSITION: 85' Position…
I can't seem to be able to create migration with simplest sql to create PostgreSQL procedure. Error is: Exception data: Severity: ERROR SqlState: 42601 MessageText: syntax error at end of input Position: 186 File: scan.l Line: 1184 Routine: scanner_yyerror Sql…
Could somebody explain how rewrite this SQL query to linq expression. What I'm trying to achieve: there is a jobs table which may have rows be active or not (is active bool column), also there is batch table which works…
What I want is to send encypted data from my app to PostgreSQL database via formatted string (query) by using Npgsql. Problem is that after sha256.ComputeHash() I get byte array which I'm trying to send by inserting it into my…
So I've actually got two issues with PostgreSQL. I actually use npgsql.NET to create queries, connections, other with PostgreSQL, however I am new to this database software. First Issue I got the error: Npgsql.PostgresException: '42601: syntax error at or near…
My context: I need creating an web-app use ASP.NET Core WebAPI .NET 6, Entity Framework Core 6, PostgreSQL 14.5 with JWT authentication/authorization. I mimics a sample at https://github.com/patrickgod/AuthenticationWebApi , then fork to me https://github.com/donhuvy/AuthenticationWebApi . This source code use .NET…
So, I am using C#/.NET and am using Npgsql. Basically, I keep running into the error System.InvalidCastException: 'Can't write CLR type System.String with handler type NumericHandler' and I can't seem to resolve it. The error seems pretty self-explanatory. Basically, I'm…