Update/revise/move/remove "How queries work" section
If you can given an example execution happening from C# to the database back to C#, that would be nice. Because even though I read this, I don't know what it means to cache as mentioned in 1a. If I ran Author.Books.ToList() twice, do two executions run or not? An example may have answered this for me.
Document Details
⚠ Do not edit this section. It is required for docs.microsoft.com ➟ GitHub issue linking.
- ID: 3208b215-1bac-c110-12f4-e1a6b448fdaf
- Version Independent ID: 3f6fb56f-0a79-8861-f8c4-ea5969a9aff5
- Content: How Queries Work - EF Core
- Content Source: entity-framework/core/querying/overview.md
- Product: entity-framework
- Technology: entity-framework-core
- GitHub Login: @rowanmiller
- Microsoft Alias: divega
Triage: Clarify that what we mean here is that the result of query compilation is cached. The results are also added to the DbContext (if the query is tracked) but the second query will execute against the database.
Also mention compiled query and relational SQL command caching.
See also comment in #1783
Note from team meeting:
- Move internal specifics of query to the internals/architecture docs (#1920)
- User-perspectives should be covered where appropriate in other docs
- May need a simple, high-level introduction to LINQ