Instruction file imported from Raph8277/Hello_gRPC (.github/instructions/efcore.instructions.md). Copyright stays with the author.

EF Core Guidelines

Architecture

• Entities, DbContext, migrations, and seeding live in Hello_gRPC.Data (namespace HelloGrpc.Data)
• Business logic services live in Hello_gRPC.Service (namespace HelloGrpc.Service)
• gRPC services in Backend delegate to the Service layer

Entity Conventions

• Use required keyword for non-nullable string properties
• Use DateOnly for dates (not DateTime)
• Use DateTime only for CreatedAt / UpdatedAt timestamps
• Primary key: Id (int, auto-increment)
• Configure constraints via Fluent API in OnModelCreating

DbContext

• Use primary constructor for DbContextOptions injection
• Override SaveChangesAsync to auto-update timestamps
• Use Set<T>() expression-bodied DbSet properties
• SQLite connection string: Data Source=hello_grpc.db

Migrations

dotnet ef migrations add <Name> --project src/Hello_gRPC.Data/ --startup-project src/Hello_gRPC.Backend/
dotnet ef database update --project src/Hello_gRPC.Data/ --startup-project src/Hello_gRPC.Backend/

Seeding

• Check AnyAsync() before seeding to avoid duplicates
• Call Database.MigrateAsync() at startup before seeding
• Use the DatabaseSeeder.SeedAsync() static method in HelloGrpc.Data

Service Layer

• {Entity}Service with primary constructor injecting AppDbContext
• Async CRUD methods: GetAllAsync, GetByIdAsync, AddAsync, UpdateAsync, DeleteAsync
• DI registration via extension methods in ServiceCollectionExtensions