These projects were developed as part of the learning process for Avalonia and PostgreSQL.
- CRUD: This project focuses on basic CRUD (Create, Read, Update, Delete) operations using Avalonia and PostgreSQL.
- ChitChat: ChitChat is a project showcasing chat functionality developed with Avalonia and PostgreSQL. This system is designed to support the transmission of messages between individual employees and groups of employees.
- Hospital: Hospital provides a comprehensive view of hospital wards, allowing you to efficiently manage patient occupancy. With our intuitive drag-and-drop feature, you can seamlessly move patients between words (drag&drop).
- Statistic: This project aims to implement various charts using Live Charts 2, a powerful charting library for .NET applications.
- TestApi: This API is designed for CRUD operations. Data transmission occurs via the request body.
- Usb device driver: using System.IO.Ports in Avalonia. Feel free to explore each project for more details and contributions.
We need to install the following packages in the Avalonia project:
Microsoft.EntityFrameworkCore.Design
To install Microsoft.EntityFrameworkCore.Design package using .NET CLI, run the following command:
dotnet add package Microsoft.EntityFrameworkCore.Design --version 9.0.0-preview.2.24128.4
To install Microsoft.EntityFrameworkCore.Design package using Package Manager, run the following command:
NuGet\Install-Package Microsoft.EntityFrameworkCore.Design -Version 9.0.0-preview.2.24128.4
Npgsql.EntityFrameworkCore.PostgreSQL
To install Npgsql.EntityFrameworkCore.PostgreSQL package using .NET CLI, run the following command:
dotnet add package Npgsql.EntityFrameworkCore.PostgreSQL --version 9.0.0-preview.1
To install Npgsql.EntityFrameworkCore.PostgreSQL package using Package Manager, run the following command:
NuGet\Install-Package Npgsql.EntityFrameworkCore.PostgreSQL -Version 9.0.0-preview.1
This command is used for reverse engineering PostgreSQL databases and automatically generating model classes based on the existing database schema.
dotnet ef dbcontext scaffold "Host=0.0.0.0;Username=postgres;Password=password;Database=DataBaseName" Npgsql.EntityFrameworkCore.PostgreSQL --output-dir <Folder where you want to generate classes>
To overwrite existing classes, use the --force option.
dotnet ef dbcontext scaffold "Host=0.0.0.0;Username=postgres;Password=password;Database=DataBaseName" Npgsql.EntityFrameworkCore.PostgreSQL --output-dir <Folder where you want to generate classes> --force
dotnet tool install --global dotnet-ef --version 7.*