Deliver highly-requested user features for EF Core

[roji]

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.

---

Done in 6.0

• SQL Server temporal tables #4693
• Allow defining column order via [ColumnAttribute.Order] when creating tables #10059
• Migrations Bundles #19693
• Split query for non-navigation collections #21234
• Detect simple join tables in reverse engineering and create many-to-many relationships #22475
• Mechanism/API to specify a default conversion for any property of a given type in the model #10784

Done in 7.0

• ExecuteUpdate/Delete (AKA bulk update, without loading data into memory) #795
• Relational: TPC inheritance mapping pattern #3170
• Map inserts, updates, and deletes (CUD operations) to stored procedures #245
• Map JSON values stored in database to EF properties #4021

Done in 8.0

• Support raw SQL queries without defining an entity type for the result #10753
• Implement complex types (value objects) #13947
• Use C# structs or classes as value objects #9906

Future release

• Merge/Upsert/AddOrUpdate support #4526
• Allow FKs to exist in the model but avoid creating them in the database #15854
• Allow mapping a key or index over more than one column across owned entity types. #11336
• Add relational JSON mapping support for complex types #31252
• Squash migrations #2174
• Update model from database #831

[codingyourlife]

+1 for those two

• Map JSON values stored in database to EF properties
• Allow defining column order via [ColumnAttribute.Order] when creating tables

Keep up the good work! :)