Order & Inventory Management API
Lightweight RESTful API built with ASP.NET Core and PostgreSQL — products, stock validation, idempotent orders, and audit logging. Hobby/learning project.
Lightweight ASP.NET Core (net8.0) service using Entity Framework Core with the Npgsql provider to talk to a local PostgreSQL database. It offers product CRUD, stock validation, and idempotent order placement for small stores.
Transactions with an inventory audit log ensure reliable updates while Postgres xmin optimistic concurrency prevents oversells.
NuGet packages like FluentValidation.AspNetCore, Microsoft.AspNetCore.OpenApi, Npgsql.EntityFrameworkCore.PostgreSQL, Serilog.AspNetCore with a console sink, and Swashbuckle.AspNetCore power the API. The default connection string points at a local PostgreSQL instance but can be overridden for other environments. EF Core migrations, RFC 7807 ProblemDetails, and integration tests against Dockerized Postgres prepare the project for Azure deployment.