Top "Npgsql" questions

Npgsql is the .NET data provider for PostgreSQL.

INSERT data from Textbox to Postgres SQL

I just learn how to connect C# and PostgresSQL. I want to INSERT data from tb1(Textbox) and tb2 to …

c# .net postgresql npgsql
How to tell Entity Framework that my ID column is auto-incremented (AspNet Core 2.0 + PostgreSQL)?

Code is simple. Tag.cs entity: public partial class Tag { [Key] [DatabaseGenerated(DatabaseGeneratedOption.Identity)] public int Id { get; set; } public …

asp.net-core entity-framework-core auto-increment npgsql
PostgreSQL: 42883 Operator does not exist: timestamp without time zone = text

I am using Npgsql 3.0.3.0 and PetaPoco latest version. When I run this command: var dateCreated = DateTime.Now; // just an example …

c# postgresql npgsql petapoco
C# Query using Npgsql for Postgresql shows duplicate results and missing table data

I am checking out PostgreSQL as potential substitute to SQLServer, I created a test table in a test database in …

c# database postgresql datasource npgsql
Postgresql - Create Database & Table dynamically

This code is not working. Can anyone direct me where I can find examples of creating a Postgresql database and …

c# postgresql npgsql
How to query column names dynamically using Postgres/NpgSQL

I have a filter object to query a table with many columns, and rather than write a condition covering all …

sql postgresql data-access-layer npgsql
PostgreSQL - best way to return an array of key-value pairs

I'm trying to select a number of fields, one of which needs to be an array with each element of …

sql database postgresql npgsql
Unable to load System.Threading.Tasks.Extensions

I have a web project build on .net framework 4.5.1. We are trying to added PostgreSQL support for the project. Using …

c# nuget npgsql
Npgsql exception when connecting

I am using the Npgsql 2.0.11.94 in a C# .NET 4.0 application to connect to a PostgreSql database. I have formed the …

c# npgsql
Execute stored procedure with parameters postgresql

My Npgsql version 3.2.5 - Postgresql 9.6 I get this error with CommandType.StoredProcedure (but CommandType.Text works): Npgsql.PostgresException: '42883: function …

c# postgresql npgsql stored-functions