EF Core 101

Ensure base knowledge on the subject and provide real worl example / case

Content

Configuration

• Model context
  • Convention
  • Fluent API
  • [] Data Annotation
• Logs
• [] Miscellaneous
  • Sequence
  • [] TVF

Concept

• [] IQueryable vs IEnumerable
• [] Configuration
  • [] Relationship
    • [] 0 - 1
    • [] 0 - N
    • [] N - N
    • [] Weak entity / Owned type
    • [] Value Typed N - N
  • [] Enums
  • [] Misc
• [] Change tracker
  • First vs Find
  • [] Update
  • [] Delete
  • [] Basic Application
• [] Shadow properties
  • [] Soft delete
• [] primitive collection
• [] Db Interceptor
• [] Json column
• [] Global Query filters
• [] (Optional) Compiled query
• [] Hierarchy
  • [] Hierarchical Id
  • [] Recursion
• [] Direct SQL call
  • [] Raw
  • [] Interpolated
  • [] Concrete Use
• [] Inheritance
  • [] TPH -> Big table
  • [] TPT -> Lot of Joins
  • [] TPC -> Unions
• [] Applied FP
• [] Applied Gridify
• [] EF core 9+ -> dbset per database + join on several database
• [] Migration tools
• [] dotnet ef core dbcontext optmize

Mistakes (?)

• [] Update
• [] Cascade delete