EntityFramework.Docs icon indicating copy to clipboard operation
EntityFramework.Docs copied to clipboard

Update/revise/move/remove "How queries work" section

Open AskYous opened this issue 6 years ago • 3 comments

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.

AskYous avatar Sep 11 '19 03:09 AskYous

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.

divega avatar Sep 11 '19 18:09 divega

See also comment in #1783

ajcvickers avatar Jan 15 '20 22:01 ajcvickers

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

ajcvickers avatar Feb 10 '20 19:02 ajcvickers