C# How to connect PostgreSql database | C# CRUD | PostGreSql Function

#CSharp, #PostgreSql, #Connect, #CRUD This tutorial show how to connect C# PostgreSql, using Postgres Function. C# CRUD CRUD function: 1. Select function CREATE OR REPLACE FUNCTION ( ) RETURNS TABLE(id integer, firstname character varying, midname character varying, lastname character varying) LANGUAGE ’plpgsql’ COST 100 VOLATILE ROWS 1000 AS $BODY$ begin return query select st_id, st_firstname, st_midname, st_lastname from Students order by st_id; end $BODY$; 2. Insert function: CREATE OR REPLACE FUNCTION ( _firstname character varying, _midname character varying, _lastname character varying) RETURNS integer LANGUAGE ’plpgsql’ COST 100 VOLATILE AS $BODY$ begin insert into Students(st_firstname, st_midname, st_lastname) values(_firstname, _midname, _lastnam