db - bootcamp17122023

• dotnet new sln
• dotnet new webapi -n API
• dotnet new classlib -n Persistance
• dotnet new classlib -n Domain

• dotnet sln add API/API.csproj
• dotnet sln add Persistance/Persistance.csproj
• dotnet sln add Domain/Domain.csproj

• cd api
• dotnet add reference '../Persistance/Persistance.csproj'
• dotnet add reference '../Persistance/Persistance.csproj'
• cd API
• dotnet add reference '../Domain/Domain.csproj'
• cd Persistance
• dotnet add reference '../Domain/Domain.csproj'

• dotnet restore
• dotnet build

• dotnet watch --no-hot-reload
• должен открыться браузер с ссылкой http://localhost:XXXX/swagger/index.html

• https://www.docker.com/get-started/ скачать docker
• https://hub.docker.com/_/postgres образ postgresql
• https://t.me/iksergeyru/176 как создать контейнер
• https://www.pgadmin.org/download/ клиент pgAdmin

• cd persistance
• dotnet add package Npgsql.EntityFrameworkCore.PostgreSQL
• dotnet add package Microsoft.EntityFrameworkCore.Design
• cd api
• dotnet add package Microsoft.EntityFrameworkCore.Design
• dotnet add package Npgsql.EntityFrameworkCore.PostgreSQL.Design

• dotnet tool install --global dotnet-ef

Перед выполнением инструкций удалить папку Persistance/Migrations

• dotnet ef migrations add init-migration -s API -p Persistance
• dotnet ef database update -s API

============

SELECT
    c."Id" AS "UserId",
    c."FirstName",
    c."LastName",
    c."Description",
    c."TimeCerated" AS "UserCreatedTime",
    t."Id" AS "TelephoneId",
    t."Text" AS "TelephoneText",
    t."Create" AS "TelephoneCreatedTime",
    t."Telephone1",
    t."Telephone2",
    t."Telephone3"
FROM
    public."Contacts" c
JOIN
    public."UserTelephones" t ON c."Id" = t."UsernameId";

SELECT
    c."Id" AS "UserId",
    c."FirstName",
    c."LastName",
    c."Description",
    c."TimeCerated" AS "UserCreatedTime",
    t."Id" AS "TelephoneId",
    t."Text" AS "TelephoneText",
    t."Create" AS "TelephoneCreatedTime"
FROM
    public."Contacts" c
JOIN
    public."UserTelephones" t ON c."Id" = t."UsernameId"
-- WHERE c."Id" = '0a69e82e-c8ce-438e-b59d-ca7cbe6d039f';

-- -- -- SELECT count(*) FROM public."UserTelephones";