Improvements to model building and conventions

[ajcvickers]

This is a grouping of related issues. Feel free to vote (👍) for this issue to indicate that this is an area that you think we should spend time on, but consider also voting for individual issues for things you consider especially important.

---

This an "epic" issue for the theme of improving model building conventions. Specific pieces of work will be tracked by linked issues.

Done in 6.0

• Pre-convention model configuration #12229
• Mechanism/API to specify a default conversion for any property of a given type in the model #10784
• Support Ignore() for non entity type candidates #3867
• Add overloads of UsingEntity() that take advantage of conventions #21535
• Warn when uniquifying an FK column name #20435
• Uniquify and validate Check Constraint name #18958

Done in 7.0

• Allow applications to create model building conventions (aka public conventions) #214
• Uniquify and validate FK, Key and index names across tables #23144
• Attribute (Data Annotations) mapping for composite primary keys #11003
• Compiled model: Allow use of lazy loading and change tracking proxy types. #24902

Done in 8.0

• Add convention types for triggers #28687
• Generate compiled relational model #24896

Done in 9.0

• Improve ObjectRemovedFromModel exception message #28852
• Move detection of ColumnAttribute in RelationalTypeMappingInfo to conventions #11124
• Make existing model building conventions more extensible #28866
• Perf bottleneck because of SortedDictionary in Annotatable.FindAnnotation #25488
• Discover the compiled model automatically #24893
• Generate the compiled model during build #24894
• Compiled model: Use static binding instead of reflection for properties and fields #24900
• Compiled model: Generate lambdas used in change tracking #24904

Backlog

• Remove IRuntime* interfaces #24895
• Compiled model: Generate constructor bindings #24898
• Compiled model: Generate code for query filters when possible #24897
• ModelBuilder: API for removing indexes and foreign keys #7605
• Add support for provider convention types #19806
• Allow conventions to react to sequence operations #32709
• Add a way for providers to determine how metadata annotations are merged #28696
• Use layering to make conventions more robust #15898
• Add support for default value conventions #9329
• Allow DeleteBehavior to be reset to the default #15295
• Names and default names for keys, constraints and indices #12837
• Keep ColumnType up-to-date while model is being built #8624
• Customize Navigation_ naming convention for Owned Type columns #17152
• Add .Builder to Metadata API #15258
• Keep underlying Builder up-to-date for all public Fluent API classes #11108
• Better exception when using a stale builder #13519
• Add an API consistency test for conventions #20275
• Make CLR members lookup for Metadata consistent #15583
• Support optional/required dependents for all relationships #24977
• Allow to specify dependencies in IEntityTypeConfiguration #22035
• Add an IEntityTypeConfiguration equivalent for owned types #15681
• Make ICSharpRuntimeAnnotationCodeGenerator language-agnostic #25110
• Perf: Reduce the number of convention executions #15897
• Make more metadata and reflection helpers public so then can be used for public conventions #28854
• Store value generator types/factories in the the model and remove the selector #25926
• Add navigation configuration overloads for shared type entity types #23255
• Determine how to look up join entity types at model building time #21901
• Improve logging around context model caching #11608
• Consider moving log messages/warnings for requiredness of navigation properties to model validation #15539
• Conventions should honor [MetadataType] #14544
• Add a way to use another property as a template for facets #31978
• Rerun relationship discovery if target entity type has been readded #19550
• Remove old property overrides when a sproc mapping is removed/renamed #28437
• Use parameterized constructors to generate default mapping of properties #4356
• Add convention types for service properties #31155
• Add sugar to allow opt-in mapping for properties/relationships/etc. #16009
• Separate conventions into groups/tags #28340
• UseLazyLoadingProxies does not work when model is built outside of OnModelCreating #15532
• Allow applications to force nullability of columns #24685
• Model building API: additional configurability of the default conversion for any property of a given type #20418
• HaveDefaultValue configuration #31312
• Model Definition: Bulk configuration using Fluent API #9117
• Support single configuration for all uses of an owned type, shared type, or some arbitrary base class/interface #6787
• Add logging for backing field discovery #12524
• Improve discovery for F# explicit fields #12923
• Log a warning with using a non-nullable property by convention for an explicitly optional FK #19958
• Log a warning when explicit configuration indirectly overrides data annotations #12693
• Don't use reflection at runtime #24903
• Compiled model: Generate code that builds the model lazily #24899
• Add feature switches to reduce app size #24901
• Add IConventionEntityTypeBuilder extension methods with StoreObjectIdentifier #28206
• Add IConventionPropertyBuilder extension methods with StoreObjectIdentifier #28207
• Create model building convention interfaces for all changes in Core metadata #28883