net core

PostgreSQL is a powerful, open source object-relational database system that is very easy to use. Dapper is a high performance micro-ORM, which is my favorite. Now, I will show you how to use this combination in .NET Core. Requirement Npgsql 3.1.9 Dapper 1.50.2 My Environment Visual Studio 2015 Community with update 3 PostgreSQL 9.6 pgAdmin 4 Demonstration Step 1 Create a new table in pgAdmin

CREATE TABLE public.customer(  
id serial NOT NULL,  
firstname character varying(45) NOT NULL,  
lastname character varying(45) NOT NULL,  
email character varying(50) NOT NULL,  
createtime timestamp without time zone NOT NULL,  
PRIMARY KEY (id)  
) WITH (OIDS = FALSE) TABLESPACE pg_default;  
ALTER TABLE  
public.customer OWNER to dev;

CREATE TABLE public.customer(

id serial NOT NULL,

firstname character varying(45) NOT NULL,

lastname character varying(45) NOT NULL,

email character varying(50) NOT NULL,

createtime timestamp without time zone NOT NULL,

PRIMARY KEY (id)

) WITH (OIDS = FALSE) TABLESPACE pg_default;

ALTER TABLE

public.customer OWNER to dev;

Step 2 Create a new Console Application (.NET Core).

Website Guides, Tips & Knowledge

Future Of .NET Core

Getting Started With PostgreSQL Using Dapper In .NET Core