Database & Domain Design

Master Entity Framework Core, domain modeling, and database optimization

4 Entities4 MigrationsConnected

Database Connectedmodernapi_development

Database Schema

Explore entity relationships and database structure

Show Relationships

PostgreSQL

User

7 props

users

IdGuid

Emailstring

DisplayNamestring

+4 more...

Product

5 props

products

IdGuid

Namestring

Pricedecimal

+2 more...

Order

5 props

orders

IdGuid

UserIdGuid

OrderDateDateTime

+2 more...

Migration Timeline

Database schema evolution history

InitialCreate

applied

Initial database schema with User entity and ASP.NET Core Identity

20250808_000001•1 operations

AddProductsAndCategories

applied

Add product catalog with categories and relationships

20250808_000002•3 operations

AddOrderSystem

applied

Complete order management system with user relationships

20250808_000003•2 operations

OptimizeQueries

pending

Add performance indexes and constraints for better query optimization

20250808_000004•2 operations

User Entity

Domain entity properties and database mapping

users

Properties

Guid

PRIMARY_KEY

• Required field

string

UNIQUEEMAIL_INDEX

• Required field

• Max length: 256

DisplayName

string

• Required field

• Max length: 100

FirstName

string

• Max length: 50

LastName

string

• Max length: 50

IsActive

bool

• Required field

• Default: true

CreatedAt

DateTime

DEFAULT_NOW

• Required field

Entity Framework Configuration

Fluent API configuration for database mapping

Configuration Features

• Table and column name mapping
• Data type precision and constraints
• Foreign key relationships
• Indexes for performance optimization
• Check constraints for data integrity

Query Performance Insights

Real-time database query analysis and optimization suggestions

low priority

2.3ms

SELECT * FROM orders WHERE user_id = ? ORDER BY order_date DESC

15 rows returned

1 indexes used

high priority

45.2ms

SELECT * FROM products WHERE name ILIKE ?

234 rows returned

No indexes

medium priority

8.7ms

SELECT p.*, c.name as category_name FROM products p JOIN categories c ON p.category_id = c.id

1248 rows returned

1 indexes used

Database Tools

Learning Resources

Complete EF Core documentation with domain modeling patterns and performance optimization guides.

🗄️