You will get a SQL Server database schema designed and built with EF Core
Project details
A badly designed database is expensive to fix once your app is built on top of it. This gets the foundation right first.
For two years I was a Software Developer at the Agricultural Bank of Egypt, using Entity Framework Core and SQL Server to keep transaction and ledger data accurate. When the data has to balance, schema design stops being theoretical.
What you get:
• Up to 10 tables, normalised, with proper keys and constraints
• Relationships modelled correctly - one-to-many, many-to-many, cascade rules
• Entity Framework Core models and migrations, ready to run in your .NET project
• Indexes on the columns your queries actually filter on
• Seed data so you can test the moment it lands
• SQL scripts plus a short note explaining the design decisions
I confirm the table design with you before writing any SQL, so nothing is a surprise at delivery.
Tell me what your system needs to store and I will tell you honestly whether 10 tables covers it.
For two years I was a Software Developer at the Agricultural Bank of Egypt, using Entity Framework Core and SQL Server to keep transaction and ledger data accurate. When the data has to balance, schema design stops being theoretical.
What you get:
• Up to 10 tables, normalised, with proper keys and constraints
• Relationships modelled correctly - one-to-many, many-to-many, cascade rules
• Entity Framework Core models and migrations, ready to run in your .NET project
• Indexes on the columns your queries actually filter on
• Seed data so you can test the moment it lands
• SQL scripts plus a short note explaining the design decisions
I confirm the table design with you before writing any SQL, so nothing is a surprise at delivery.
Tell me what your system needs to store and I will tell you honestly whether 10 tables covers it.
Database Type
MS SQLWhat's included $180
These options are included with the project scope.
$180
- Delivery Time 4 days
- Number of Revisions 2
- Source Code
About Abdelrhman
.NET Backend Developer | ASP.NET Core REST APIs & Payment Systems
Cairo, Egypt - 3:32 am local time
For two years I worked as a Software Developer at the Agricultural Bank of Egypt, building RESTful APIs with ASP.NET Core Web API for wallet transactions, balance inquiries, and payment processing. I implemented CRUD operations for transaction records using Entity Framework Core and SQL Server to keep ledger data accurate, and unit tested and debugged every endpoint before deployment. I also trained 500+ bank employees on the Finacle core banking system, earned a Super User badge, and supported 20+ branches - so I understand banking workflows from both the code side and the operations side.
WHAT I CAN BUILD FOR YOU
- REST APIs with ASP.NET Core Web API - clean, versioned, and documented with Swagger
- Payment, wallet, and transaction processing flows
- JWT authentication and role-based authorization
- SQL Server database design, Entity Framework Core, Dapper, migrations and seeding
- Redis caching and API performance optimization
- Real-time features with SignalR
- Maintainable code using Onion Architecture, SOLID, and design patterns (Repository, Unit of Work, Singleton, Factory, Observer)
- Deployment to IIS, with Git and Azure DevOps CI/CD
SELECTED PROJECTS (full code and details in my portfolio below)
Talabat API - E-Commerce Web API
Secure login, cart, and order management APIs built with ASP.NET Core and SQL Server. Added JWT authentication and Redis caching, which cut API response time by 25%. Built on Onion Architecture and SOLID principles.
Order Management System API
Customer and product management with full CRUD and stock control, JWT role-based access, order processing with automatic stock validation, tiered discounts, and multi-payment support (credit card, PayPal, bank transfer, cash), plus automated invoice generation and email notifications.
TECH STACK
C# | ASP.NET Core | ASP.NET MVC | Web API | Entity Framework Core | Dapper | LINQ | SignalR | SQL Server | Redis | AutoMapper | Swagger | Postman | Git | Azure DevOps | IIS
I also teach backend development to 400+ computer science students as a Teaching Assistant at Lotus University, so I can explain technical decisions in plain language and write code other developers can actually maintain.
I am available 30+ hours per week and reply to messages within a few hours. Tell me what you are building or what is broken, and I will give you an honest assessment of whether I am the right fit.
Steps for completing your project
After purchasing the project, send requirements so Abdelrhman can start the project.
Delivery time starts when Abdelrhman receives requirements from you.
Abdelrhman works on your project following the steps below.
Revisions may occur after the delivery date.
Map out the entities and confirm the design
I turn what you described into a table list with relationships and send it to you as a diagram. You approve the design before I write any SQL, so we do not discover a mismatch at the end.
Build the schema and EF Core migrations
I create the tables, keys, constraints and indexes in SQL Server, then generate matching Entity Framework Core models and migrations so your .NET project can run against it straight away.