Npgsql.PostgresException:42601 : at or near "schemaname": syntax error. Detail redacted as it may contain sensitive data (Error getting while calling Stored procedure from .Net core 8.0 used Npgsql.EntityframeworkCore.PostgreSQL.

[SpandhanaKandukuri]

No description provided.

[SpandhanaKandukuri]

I am working on a project where i am connecting to CockRoachDB Procedure using .Net Core 8.0 along with Npgsql.EntityFrameworkCore.PostgrSQL. I have written logic to call procedure but while execute "var datareader = await cmd.ExecuteReaderAsync(). i am getting above error syntax error. I am not able to figure out the issue and Could you please provide me any source code file or repositories connecting to "CockroachDb" using .net core and Entityframeowrk core

[roji]

You're going to have to provide more detail than that - opening an issue with just an exception message isn't enough. Please post at least the LINQ query and SQL (from the logging), or preferably isolate the issue down to a minimal, runnable console program.