Example contradicts the Warning #3997
Description
The Warning box explains that it is necessary to specify proper sort order on queries that call AsSplitQuery(). Specifically it says "Note that relational databases do not apply any ordering by default, even on the primary key."
The example code immediately preceding the warning apparently contradicts this advise. It shows SQL generated from a query that took no care to specify a sort order, yet the generated SQL includes "ORDER BY [b].[BlogId]" in both SELECT statements.
So which is it? Does EF Core do some magic to pick a default sort order or not? Does the SQL in the box really come from the given C# query or not? Something needs to be updated in the document to remove the contradiction.
Document Details
⚠ Do not edit this section. It is required for docs.microsoft.com ➟ GitHub issue linking.
- ID: 43baa9f3-c415-c328-6c10-53aabaaec652
- Version Independent ID: 4e789a1b-aa88-d194-dc2e-0a23251250d7
- Content: Single vs. Split Queries - EF Core
- Content Source: entity-framework/core/querying/single-split-queries.md
- Product: entity-framework
- Technology: entity-framework-core
- GitHub Login: @smitpatel
- Microsoft Alias: avickers