npgsql Questions
12
For a couple of months i had no issue generating the model from DB by deleting it and recreating it . After a pull from git, an issue has been occurred while trying to make the same process . After...
Fornix asked 4/4, 2019 at 6:59
2
Solved
Using EF-Core for PostgresSQL, I have an entity with a field of type byte but decided to change it to type byte[]. But when I do migrations, on applying the migration file generated, it threw the f...
Horary asked 23/9, 2018 at 4:7
3
Solved
I am using EF Core 2.0 and Postgres 9.6. Whenever I insert data I get the error
PostgresException: 23505: duplicate key value violates unique
constraint "PK_country"
By tracing it looks like ...
Gawlas asked 24/12, 2017 at 14:42
1
I have read about this for in Npgsql and Entity Framework Query PostgreSQL with Npgsql and Entity Framework using unaccent, BUT Entity Framework CORE.
Is it posible to do a select for postgresql u...
Ealing asked 6/4, 2020 at 10:16
14
I have common problem.
Cannot write DateTime with Kind=UTC to PostgreSQL type 'timestamp
without time zone'
And I want to enable Legacy Timestamp behavoour as is documented here:
https://github.c...
2
Solved
I am using Entity Framework Core with npgsql postgresql for Entity Framework Core.
and i'm working with .net core 3
My question is, when i try to update a MyTableRelated element from the MyTableCl...
Fredrick asked 26/5, 2020 at 11:33
10
Solved
I have a web project build on .net framework 4.5.1. We are trying to added PostgreSQL support for the project. Using Nuget, I have installed 4.0.4 npgsql to the project. Under references, I see the...
3
Solved
I am using Entity Framework Core with npgsql postgresql for Entity Framework Core.
My question is, using migrations, how do I mark a class property to generate a JSONB column type?
For example:
...
Wilheminawilhide asked 29/3, 2017 at 9:5
2
Solved
Before:
public class MyEntity
{
public string Id { get; set; }
//...
}
Config:
protected override void OnModelCreating(ModelBuilder modelBuilder)
{
//...
modelBuilder.Entity<MyEntity>()...
Trouper asked 15/11, 2020 at 17:41
2
Solved
I am using PostgreSQL as my database. I have an application that is written in
ASP.NET
C#
WebForms
Using Npgsql with PostgreSQL
I have table named tblAppt in my database, in that table I have...
Swett asked 16/8, 2018 at 13:9
3
I am getting this error intermittently in my code. Sometimes it happens time-after-time-after-time. Sometimes it happens 1-out-of-10 times. I am not doing anything unique or special in my SQL unlik...
Standard asked 1/11, 2016 at 16:36
2
Solved
Is possible to use Npgsql and Entity Framework 6 for query PostgreSQL ignoring accents? In play SQL it's possible to use the unaccent extension and could be indexed with a index also based in unacc...
Commentary asked 27/4, 2016 at 13:20
3
As far as I've understood it, there is no option in EF (and EF Core) to explicitly lock resources which I'm querying, but I'll need this functionality quite often and don't really feel like falling...
Schnook asked 23/6, 2016 at 6:57
4
Trying to use SQLTypeProvider with postgres I get the following errorwhen running
dotnet build
error FS3033: The type provider 'FSharp.Data.Sql.SqlTypeProvider'
reported an error: Could not l...
Katzenjammer asked 22/12, 2018 at 3:37
5
Solved
I'm trying to create a small POC for my boss about the hybrid of npgsql 12 and ef6,
created a new project on visual studio
created a sample database
created the corresponding classes and the ...
Sieve asked 25/11, 2013 at 23:11
3
I am currently using postgres enum
CREATE TYPE http_action_enum AS ENUM ('GET', 'HEAD', 'POST', 'PUT', 'DELETE', 'CONNECT', 'OPTIONS', 'TRACE', 'PATCH');
CREATE TABLE IF NOT EXISTS response
(
id U...
Herbarium asked 26/8, 2020 at 4:59
3
Solved
I'm trying to select a number of fields, one of which needs to be an array with each element of the array containing two values. Each array item needs to contain a name (character varying) and an I...
Buckboard asked 3/2, 2012 at 14:5
3
Solved
So far I read the docs, tutorials google brought up and other SO questions but it seems I miss something and I don't get it (to work).
I try to implement a really tiny PostgreSQL database for a .N...
Strictly asked 14/11, 2018 at 10:29
0
var sqlDbLink = $"SELECT * FROM example;";
foreach ( var db in databases ) {
var connStr = sqlConnectionService.GetConnectionString(db.Name);
using (var conn = new NpgsqlConnection(con...
Erumpent asked 27/6, 2022 at 20:53
2
Solved
The Simple Preparation example in the docs (https://www.npgsql.org/doc/prepare.html#simple-preparation) shows an example where parameters are set after the command is prepared.
var cmd = new Npgs...
Longhair asked 14/2, 2019 at 13:28
4
Solved
i have problem when im trying to add integer to Postgresql database. Varchars works fine, but when i use code:
var parameter = cmd.CreateParameter();
parameter.Value = Int32.Parse(x.Value.ToString(...
Ceceliacecil asked 3/12, 2018 at 11:9
5
Solved
Let's say we have an entity class that looks like this:
public class SerializedEntity
{
public JsonDocument Payload { get; set; }
public SerializedEntity(JsonDocument payload)
{
Payload = pay...
Learned asked 2/4, 2020 at 10:43
3
Solved
I'm currently trying to start a new project with ASP.NET Core 6 MVC and Entity Framework Core 6 and npgsql.
When I try to add one entity which has a foreign identity the ModelState.IsValid keeps re...
Hainaut asked 19/12, 2021 at 21:2
2
Solved
I am attempting to run a background worker for a web app that I am developing. I am using Npgsql as my EF Core provider.
For clarification, I have injected my DbContext with a Transient lifetime, ...
Orthostichy asked 6/4, 2020 at 3:52
5
Solved
I want to create this query:
select * from products where number in ('123', '234', '456');
but I can't find any example of achiving this with Npgsql and NpgsqlParameter. I tried like this:
stri...
Mendive asked 18/4, 2011 at 10:23
1 Next >
© 2022 - 2025 — McMap. All rights reserved.