Skip to content

JCaeta/crud-csharp-postgresql

Repository files navigation

Documentation

https://caetaworks.web.app/blog/crud-postgresql-csharp

How to use

  1. Create a database in PostgreSQL.
  2. Create the following tables using the provided queries:
CREATE TABLE models_a (
	id bigserial NOT NULL PRIMARY KEY,
	name text
);

CREATE TABLE models_b (
	id bigserial NOT NULL PRIMARY KEY,
	name text
);

CREATE TABLE rel_mod_a_mod_b (
	id bigserial NOT NULL PRIMARY KEY,
	id_model_a int,
	id_model_b int,
	CONSTRAINT fk_model_a FOREIGN KEY(id_model_a) REFERENCES models_a(id),
	CONSTRAINT fk_model_b FOREIGN KEY(id_model_b) REFERENCES models_b(id)
);
  1. Execute the repository's code
  • At the very first you will get a error message if you don't have the database information configured image
  • Click Ok and continue
  1. Configure database information
  • Go to "configure" option

image

image

  1. Search for your PostgreSQL database information

image

  1. Enter the information and press ok

image

image

About

CRUD architecture guide

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages