Entity Framework Core v2.1 is still having its fair share of limitations. Below is a list of limitations you might run into with the generated code. We have done our best to keep this to a minimum, but some things are simply unavoidable.
- Unique constraints are not generated as indexes nor as alternative keys. The designer doesn't support alternate keys and unique constraints have no real value to the Entity Framework Core engine. The constraint is already defined in the DB where it is enforced, so it's not really useful to generate the index, as LLBLGen Pro doesn't generate relational model meta data into the mappings.
- Cascade rules for OnDelete are determined from the rule set on the relationship in the model. EF core supports 3 forms (SetNull, Cascade, Restrict) instead of the 4 we support (SetDefault isn't supported on EF Core). We'll fall back to None if a value not supported by EF core is chosen.
- Value Type Definitions are mapped as 'Owned types'. Fields which type is set to a ValueTypeDefinition can't be optional/nullable.