.NET Data Management Web App

I am building a web-based application in .NET and need help completing the data-management layer. The system must store and manipulate two primary datasets—user information and transaction records—while enforcing role-based access for Admin and standard User accounts.

Here is what I need from you:
• Design or refine the database schema so both datasets are structured for scalability and easy reporting.
• Build the API and back-end logic in ASP.NET (Core 6 or later preferred) with Entity Framework for data access.
• Implement CRUD operations, search, basic filtering, and pagination for each data type.
• Add role checks so Admins can see, create, update, and delete everything, while Users have read/write rights only to their own records.
• Integrate simple front-end views (Razor Pages or Blazor Server is fine) that let me test all endpoints end-to-end.

Acceptance criteria
1. All endpoints return 200/201 and the correct JSON when hit from Postman.
2. Admin and User roles are enforced through an attribute-based authorization policy.
3. A short README explains how to run a local build and apply migrations with dotnet ef.

If you have production experience with ASP.NET Core, Entity Framework, and SQL Server (or PostgreSQL), I’m ready to get started right away.