Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Article about tracking presents only small information about the topic. #2767

Open
shoter opened this issue Oct 14, 2020 · 2 comments
Open

Comments

@shoter
Copy link

shoter commented Oct 14, 2020

This article present very little info about tracking. It does answer following questions:

  1. How does tracking affect future queries that query the same entity?
  2. What will happen if I execute for example context.Entities.Where(e => e.Name.StartsWith("zix") twice in the row
  3. How tracking works with TransactionScope and overall with transactions.
  4. Does IsolationLevel of transaction impacts tracking?
  5. What are criteria for LINQ query to return tracking entity and skip SQL query?
  6. Why my query inside RepeatableRead transaction returns cached data from queries outside transaction when I just changed data manually from db side? Why afterwards I have read lock when I am using old tracked entity? It does not make sense - did I make some kind of SQL Query then but it is not updating my entity?
  7. What is lifespan of tracked entities? Do they even have lifespan?
  8. Is there a limit of how many tracked entities EF can have?
  9. Are there any performance considerations we should think about when using tracking?
  10. How can I disable tracking for whole DbContext? Is it possible?

Therefore this article is a stub and it explains nothing of importance.


Document Details

Do not edit this section. It is required for docs.microsoft.com ➟ GitHub issue linking.

@smitpatel
Copy link
Member

Questions for @dotnet/efteam
#2803 clarifies 1,2,5

9,10 is already answered by existing article.

I am not sure how/where/what we should document for rest.

@smitpatel smitpatel removed their assignment Oct 22, 2020
@smitpatel smitpatel removed this from the 5.0.0 milestone Oct 22, 2020
@ajcvickers
Copy link
Member

ajcvickers commented Oct 23, 2020

  • 1. How does tracking affect future queries that query the same entity?
  • 2. What will happen if I execute for example context.Entities.Where(e => e.Name.StartsWith("zix") twice in the row
  • 3. How tracking works with TransactionScope and overall with transactions.
  • 4. Does IsolationLevel of transaction impacts tracking?
  • 5. What are criteria for LINQ query to return tracking entity and skip SQL query?
  • 6. Why my query inside RepeatableRead transaction returns cached data from queries outside transaction when I just changed data manually from db side? Why afterwards I have read lock when I am using old tracked entity? It does not make sense - did I make some kind of SQL Query then but it is not updating my entity?
  • 7. What is lifespan of tracked entities? Do they even have lifespan?
  • 8. Is there a limit of how many tracked entities EF can have?
  • 9. Are there any performance considerations we should think about when using tracking?
  • 10. How can I disable tracking for whole DbContext? Is it possible?

@ajcvickers ajcvickers self-assigned this Oct 23, 2020
@ajcvickers ajcvickers added this to the Backlog milestone Oct 23, 2020
@ajcvickers ajcvickers removed their assignment Aug 31, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

4 participants