Improvements to relational database mappings

[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 improvements to relational mapping constructs. Specific pieces of work will be tracked by linked issues.

Done in 6.0

• Support for SQL Server sparse columns #8023

Done in 7.0

• Relational: TPC inheritance mapping pattern #3170
• Allow specifying different column names per table in TPT, TPC or entity splitting #19811
• Relational: Entity splitting support #620
• Map inserts, updates, and deletes (CUD operations) to stored procedures #245
• Map JSON values stored in database to EF properties #4021
• Perf: improve batching for TPH #3954
• Use partial updates for JSON #28595

Done in 8.0

• SQL Server: Support hierarchyid #365

Done in 9.0

• Json: add ability to specify type of the json column #28452

Backlog

• Support PostgreSQL native inheritance #10739
• Map concurrency tokens to derived tables in TPT #22060
• Allow specifying different column facets per table in TPT, TPC or entity splitting #27970
• Allow specifying different foreign key facets per table in TPT, TPC or entity splitting #27971
• Allow specifying different key facets per table in TPT, TPC or entity splitting #27972
• Allow specifying different index facets per table in TPT, TPC or entity splitting #27973
• Entity Splitting: allow optional split table #27974
• Allow additional configuration on split tables #28204
• Migrations: CHECK Required Columns on TPH Derived Types #2595
• Improved view support #827
• TVF cannot return Shared Type Clr Type #21569
• Support flexible entity type to function mapping #19970
• Flexible navigation mapping #20339
• Query: Relational: Use SequentialAccess when reading data? #885
• Add discriminator filter for unique index on derived type #10665
• Allow more flexible conditional mapping for TPH and similar #10140
• Query: Investigate the perf of different shape of TPT queries #21509
• Create check constraints for columns that are only conditionally nullable #20931
• Names and default names for keys, constraints and indices #12837
• Keep ColumnType up-to-date while model is being built #8624
• Allow to specify constraint name for default values #11502
• Enable configuring default/computed property values with a lambda expression #11001
• Optional alternate key properties #4415
• Alternate Keys on Derived Types (TPT/TPH) #2611
• Query hints (raw SQL, such as OPTIONs) #6717
• Allow mapping a key or index over more than one column across owned entity types. #11336
• Property defining expressions for query: mapping model properties to non-column expressions #10768
• Property defining expressions for update #10862
• Allow mapping different entity types in a hierarchy to different store constructs (table/view/procedure/etc.) #27192
• Allow mapping inserts and deletes to stored procedures with TVPs #27975
• Add entity splitting support to CUD sproc mapping #28433
• Add "table" splitting and complex type support to CUD sproc mapping #28434
• Ability to specify more facets for sproc parameters and result columns #28436
• Support configuring parameters with constant values for sproc mapping #28438
• Allow configuring sproc mapping to use parameter names for invocation  #28439
• Allow to disable auto-transactions for stored procedures mapped to CUD operations #28511
• Allow to configure any property as the return in CUD sproc mapping #28571
• Allow to configure a property as non-persisted only for a specific mapping #33676
• Add support for managing Triggers with EF migration #10770
• Allow table-sharing for base types in TPC and unmapped base types in TPT #32028
• Relational: Allow a custom serializer for JSON columns #28043
• JSON: Support [JsonStringEnumConverter] #27828
• Support inheritence with JSON POCO mapping #27779
• Support cache when creating a sequence #11261
• Json : add support for json mapped entities owned by a regular owned entity #28441
• Json: add support for table splitting on the entities that own json entities #28442
• Json splitting mapping? #28574
• Support mapping multiple owned types to the same JSON column (sharing) #28592
• Support JSON properties with TPT/TPC inheritance mapping #28443
• Json: allow mapping json structure to a different column on view and on table #28584
• Allow specifying more facets on JSON column #28591
• Add support for JSON columns in stored procedure mapping #28593
• Add support for persisting key properties on JSON-mapped entity types #28594