markdown Copy code

Inventory Service Setup with PostgreSQL

This guide will help you set up the Inventory Service project using .NET and PostgreSQL. Follow the steps below to install the necessary tools and configure your project.

Prerequisites

• .NET SDK
• PostgreSQL

Installation Steps

1. Clone the Repository

First, clone the repository to your local machine:

git clone https://github.com/your-repo/project.git
cd project
2. Install .NET SDK
Ensure you have the .NET SDK installed. You can download it from the .NET downloads page.

3. Install Entity Framework Core
Install the Entity Framework Core package for PostgreSQL:

bash
Copy code
dotnet add package Microsoft.EntityFrameworkCore
dotnet add package Npgsql.EntityFrameworkCore.PostgreSQL
4. Install Npgsql
Npgsql is the .NET data provider for PostgreSQL:

bash
Copy code
dotnet add package Npgsql
5. Install EF Core Tools
EF Core tools are useful for running migrations and updating your database schema:

bash
Copy code
dotnet tool install --global dotnet-ef
Verify the installation:

bash
Copy code
dotnet ef
6. Install Microsoft.EntityFrameworkCore.Design
This package is required for the Entity Framework Core Tools to work:

bash
Copy code
dotnet add package Microsoft.EntityFrameworkCore.Design
7. Configure DbContext
Create a DbContext class (e.g., InventoryContext) to manage your database connections and entities. Ensure your connection string is added to the appsettings.json file:

json
Copy code
{
  "ConnectionStrings": {
    "DefaultConnection": "Host=your_host;Database=your_database;Username=your_username;Password=your_password"
  }
}
8. Create and Apply Migrations
Generate a migration to capture your model changes:

bash
Copy code
dotnet ef migrations add InitialCreate
Apply the migration to update the database schema:

bash
Copy code
dotnet ef database update
9. Build and Run the Project
Build your project to ensure everything is set up correctly:

bash
Copy code
dotnet build
Run the project:

bash
Copy code
dotnet run
Additional Configuration
Ensure that your DbContext is registered in the service collection (e.g., Startup.cs or Program.cs in .NET 6+):

csharp
Copy code
public void ConfigureServices(IServiceCollection services)
{
    services.AddDbContext<InventoryContext>(options =>
        options.UseNpgsql(Configuration.GetConnectionString("DefaultConnection")));
}
Summary
Following these steps will set up your Inventory Service project with a PostgreSQL database. For further customization and configuration, refer to the official documentation of .NET and Entity Framework Core.