A helper to ease the configuration of Entity Framework Cire database projects when using the IEntityTypeConfiguration
pattern.
In most Enterprise Software solutions database schemas and database design patterns usually comprise of the Star Schema or Snowflake Schema design patterns.
erDiagram
CUSTOMER }|..|{ DELIVERY-ADDRESS : has
CUSTOMER ||--o{ ORDER : places
CUSTOMER ||--o{ INVOICE : "liable for"
DELIVERY-ADDRESS ||--o{ ORDER : receives
INVOICE ||--|{ ORDER : covers
ORDER ||--|{ ORDER-ITEM : includes
PRODUCT-CATEGORY ||--|{ PRODUCT : contains
PRODUCT ||--o{ ORDER-ITEM : "ordered in"
Generally in these types of schema there are two types of table types to describe the entities:
- fact-type tables - describe business events
- dimension-type tables - describe business entities