Using stored procedures in PostgreSQL for CRUD operations in C# Code | Simple Example

preview_player
Показать описание
This video demonstrates how a stored procedure is called from C# code to create, read, update and delete operations in PostgreSQL.

For select operation in C#, please refer to following video:

For connecting to PostgreSQL from C#, please refer to follow video:

Technologies used:
Visual Studio 2019,
C# programming language
Npgsql NuGet Package,
PostgreSQL database management system
  1. Gautam Mokal
  2. C# and PostgreSQL stored procedure
  3. PostgreSQL stored procedure
  4. Insert update delete postgres in C#
  5. Simple example of stored procedure of PostgreSQL in C#
  6. how to call stored procedure in C# and PostgreSQL
Рекомендации по теме
How To Create 0:07:13

How To Create And Call A Stored Procedure In PostgreSQL Using pgAdmin4 || Procedure In PostgreSQL

Advanced SQL Tutorial 0:06:15

Advanced SQL Tutorial | Stored Procedures + Use Cases

Procedure Tutorial in 1:06:21

Procedure Tutorial in SQL | SQL Stored Procedure | Procedure in SQL

Stored Procedures are 0:07:58

Stored Procedures are Better than Raw SQL

How to Create 0:10:13

How to Create table ,procedure , get data in PostgreSQL

Insert Stored Procedure 0:06:27

Insert Stored Procedure for Postgresql. Step-by-step instructions to build your first procedure.

PostgreSQL Stored Procedures 0:22:59

PostgreSQL Stored Procedures | what is procedure in postgreSQL |CALL procedure | Proc Postgres VD#18

Stored Procedures in 0:12:37

Stored Procedures in MySQL | Advanced MySQL Series

PostgreSQL PGAdmin Insert 0:07:41

PostgreSQL PGAdmin Insert Into Multiple Tables Using Stored Procedure

PostgreSQL Stored Procedures 0:32:00

PostgreSQL Stored Procedures

How to View 0:01:07

How to View Stored Procedure in PostgreSQL

Functions Or Stored 0:08:10

Functions Or Stored Procedures in Database #Postgresql #PL/SQL

SQL Stored Procedures 0:44:34

SQL Stored Procedures - What They Are, Best Practices, Security, and More...

How To Create 0:08:10

How To Create A Simple Stored Procedure In PostgreSQL And Call Using pgAdmin || PL/pgSQL Tutorials

2017-11 Java Stored 0:26:06

2017-11 Java Stored Procedures In PostgreSQL

Using stored procedures 0:12:48

Using stored procedures in PostgreSQL for CRUD operations in C# Code | Simple Example

MySQL: STORED PROCEDURES 0:08:02

MySQL: STORED PROCEDURES

Procedures in PL-SQL 0:07:18

Procedures in PL-SQL | Local Procedure vs Stored Procedure

How To Create 0:14:13

How To Create A Stored Procedure With Parameter Modes IN INOUT OUT Modes In Postgresql || PL/pgSQL

How Stored Procedures 0:12:31

How Stored Procedures make databases FAST

PostgreSQL Demonstration: Stored 0:05:52

PostgreSQL Demonstration: Stored Procedures

How To Create 0:13:14

How To Create A Stored Procedure And Return Multiple Values From The Stored Procedure In PostgreSQL

09 JDBC with 0:10:25

09 JDBC with Postgresql Stored procedure

How To Create 0:07:41

How To Create A Simple Parameterized Stored Procedure In PostgreSQL And Call || PL/pgSQL Tutorials

Комментарии
Автор

Why do you say CRUD although read not found?

engalibadouin
Автор

Hi!
Why their is no Read operation? It is the one I am struggling with. I learned myself how to Create, Delete and Update but I have no idea how to get with Postgres. I can’t be considered as CRUD without Read operation. Title is misleading unfortunately.

torrvic
Автор

int aff = cmd.ExecuteNonQuery();
saved = aff == 1;

I always received aff = -1. Can you check your code?

truongkhoan
Автор

Why you are taking command type as text, instead of procedure?, SQL injection may help hackers in this case..

sravana