100% Free Forever
AI-Powered Learning
Industry Expert Content
Certificates & Badges
Learn At Your Own Pace
C#

Tracking vs No-Tracking Queries

When to let EF Core track query results for later updates versus opting out with AsNoTracking for faster, read-only workloads.

Performance & TransactionsIntermediate8 min readJul 10, 2026
Analogies

Tracking Queries Are the Default

When you write context.Blogs.Where(b => b.Rating > 3).ToList(), EF Core runs the query, materializes each row into an entity, and registers every one of those entities with the ChangeTracker as Unchanged. This is what makes it possible to mutate a property afterward and have SaveChanges pick it up automatically. The convenience comes at a cost: EF has to keep an identity map (so the same primary key always resolves to the same in-memory instance) and an original-value snapshot for every row, which consumes memory and adds bookkeeping overhead proportional to the number of rows returned.

🏏

Cricket analogy: It's like a scorer logging every ball bowled in a Test match into the official book by default — useful if you need to review the innings later, but overkill if you only wanted today's final score.

AsNoTracking: Opting Out for Read-Only Scenarios

Calling .AsNoTracking() on a query tells EF Core to skip both the identity map and the original-value snapshot for the returned entities — it just materializes objects and hands them back untracked. This is the right default for read-only workloads: API GET endpoints, report generation, or any query whose results you're never going to pass back into SaveChanges. Because there's no snapshot bookkeeping, no-tracking queries are measurably faster and use less memory, especially when materializing large result sets or deeply nested Include graphs.

🏏

Cricket analogy: It's like a fan watching the match purely for entertainment rather than as an official scorer — you absorb the action without maintaining a ball-by-ball ledger you'll never need to reference again.

AsNoTrackingWithIdentityResolution

Plain AsNoTracking() has one gotcha: if the same row appears multiple times across a query result (common with Include on a one-to-many relationship), EF Core materializes a separate object instance for each occurrence instead of resolving them to one shared instance, since there's no identity map to deduplicate against. AsNoTrackingWithIdentityResolution() fixes this by keeping a temporary, weak-referenced identity map scoped only to that single query, so duplicate rows resolve to the same in-memory instance without the overhead of full change tracking or long-lived snapshots.

🏏

Cricket analogy: It's like a stadium selling separate tickets for the same seat number across different gate entrances unless someone cross-checks a master seating chart to make sure Seat 14B always refers to the same physical seat.

Choosing the Right Query Mode

The decision is straightforward once you frame it correctly: use a tracking query (the default) whenever you intend to modify the results and call SaveChanges — for example, loading an order to update its status. Use AsNoTracking() for anything read-only, which in most web applications is the majority of queries, especially GET endpoints and DTO projections. Reach for AsNoTrackingWithIdentityResolution() specifically when you need duplicate-free object graphs from a no-tracking Include query, such as returning a Category with its Products where each Product also references back to the same Category instance.

🏏

Cricket analogy: It's like a captain deciding whether to review a decision with DRS — you only spend the review (tracking overhead) when the outcome actually needs to change, not on every single delivery.

csharp
// Read-only endpoint: skip change tracking entirely
public async Task<List<BlogDto>> GetBlogsAsync()
{
    return await _context.Blogs
        .AsNoTracking()
        .Select(b => new BlogDto { Id = b.BlogId, Url = b.Url })
        .ToListAsync();
}

// Duplicate-free graph from a no-tracking Include query
var categories = await _context.Categories
    .Include(c => c.Products)
    .AsNoTrackingWithIdentityResolution()
    .ToListAsync();

// Update scenario: keep the default tracking behavior
var order = await _context.Orders.FirstAsync(o => o.OrderId == id);
order.Status = OrderStatus.Shipped;
await _context.SaveChangesAsync();

Calling SaveChanges after mutating an entity returned from an AsNoTracking() query will silently do nothing — the entity was never registered with the ChangeTracker, so EF has no snapshot to diff against and generates no SQL.

  • Tracking is EF Core's default: every materialized entity is registered with the ChangeTracker and identity map.
  • AsNoTracking() skips the identity map and snapshot, giving faster, lower-memory results for read-only queries.
  • Mutating an AsNoTracking() entity and calling SaveChanges has no effect — EF isn't watching that instance.
  • AsNoTrackingWithIdentityResolution() adds a query-scoped identity map to deduplicate repeated rows in Include graphs without full tracking overhead.
  • Use tracking queries for anything you plan to modify and persist via SaveChanges.
  • Use AsNoTracking() for GET endpoints, reports, and DTO projections that never round-trip back to SaveChanges.
  • Choose AsNoTrackingWithIdentityResolution() when a no-tracking Include query would otherwise produce duplicate object instances for the same row.

Practice what you learned

Was this page helpful?

Topics covered

#EntityFrameworkCoreStudyNotes#MicrosoftTechnologies#TrackingVsNoTrackingQueries#Tracking#Queries#Default#AsNoTracking#SQL#StudyNotes#SkillVeris

Frequently Asked Questions

21 categories · pick one to explore

Where can I get free study notes for programming and tech subjects?
SkillVeris offers completely free study notes covering programming and tech subjects, with no signup fees or paywalls. The notes are structured by course and topic, written for quick understanding, and enriched with the Learn Through Hobbies analogy method, so you can revise concepts through cricket, music, gaming, cooking and more.
Are SkillVeris study notes good for exam revision?
Yes, the study notes are designed for efficient revision: each topic answers its heading immediately, keeps explanations concise, and links to related glossary terms and cheat sheets. Students preparing for university exams or certification tests use them as quick revision notes because they distil concepts without the padding of full textbooks.
What subjects do the free study notes cover?
The study notes span the platform's main domains, including AI and machine learning, Python and programming, web development, DevOps, cloud, security and databases. Coverage mirrors the 37 live courses, so notes exist for the topics you are actually studying, and new note sets are added as courses launch.
How are SkillVeris study notes different from regular textbooks?
The notes are answer-first, concise and free, whereas textbooks are long and often expensive. Each section explains one concept directly, then reinforces it through selectable hobby analogies like cricket or cooking. Notes also cross-link to the glossary, blog and cheat sheets, letting you jump to related material instantly instead of flipping pages.
Can I use the developer study material without creating an account?
The study notes are free to access, and SkillVeris does not charge anything for its developer study material at any point. Browsing notes is straightforward from the Study Notes section, and if you want progress tracking, certificates and AI Mentor conversations tied to your learning, a free account unlocks those extras.
Do the study notes explain concepts with analogies?
Yes, this is a signature SkillVeris feature. Study notes use the Learn Through Hobbies method, explaining technical concepts through analogies from twelve domains including cricket, music, gaming, photography, travel, movies, fitness, chess, cooking, finance, business and sports. You can switch the analogy domain instantly to whichever hobby makes the concept click.
Are the revision notes suitable for last-minute exam preparation?
Yes, revision notes on SkillVeris work well for last-minute preparation because every section states the answer in its first sentences, so skimming is genuinely effective. Pair them with the relevant cheat sheet for formulas and syntax, and use the glossary for any unfamiliar term you meet while cramming.
Is there free study material for AI and machine learning?
Yes, SkillVeris provides free study notes across its AI and ML catalogue, covering Python for AI, deep learning frameworks like PyTorch and TensorFlow, Hugging Face Transformers, Large Language Models, RAG, AI agents and MLOps. All of it is free, making it a strong resource for Indian students and global learners alike.
Can beginners understand the study notes, or are they for experts?
Beginners can absolutely use them. The notes are written in plain language, define terms as they appear, and lean on hobby analogies to make abstract ideas concrete. Difficulty scales with the underlying course level, so beginner-course notes stay gentle while advanced-course notes go deeper, and the glossary supports you throughout.
How do study notes connect with SkillVeris courses?
Study notes are organised by course and topic, so they map directly to the structured courses and their 24–40-lesson curriculum. Many learners study a lesson first, then use the matching notes for revision before module assessments and the final exam, where 80 percent is required to pass and earn the certificate.
Are there study notes for Python specifically?
Yes, Python is well covered through notes tied to the Python-focused courses, including Python for AI and ML. Topics span fundamentals through applied machine learning usage. You can reinforce the notes with Python practice in Code Lab, which runs code in your browser with no installation required.
Do the study notes include code examples?
Yes, study notes include code examples wherever a concept is best shown in code, alongside explanations, key points and analogies. Reading a snippet in the notes and then reproducing it yourself in Code Lab is an effective loop, since Code Lab lets you run code in the browser across six languages.
How often is new study material added to SkillVeris?
Study material grows alongside the course catalogue. Whenever new courses join the platform's 37 live courses, matching study notes, glossary entries and cheat sheets are added so the resources stay in sync. Existing notes are also refined over time, so it is worth revisiting topics you studied earlier.
Can I use SkillVeris notes to prepare for technical interviews?
Yes, the notes make excellent interview revision because they compress each concept into direct, answer-first explanations, which mirrors how you should answer interview questions. Combine them with the SkillVeris interview questions feature, which includes readiness scoring, to test whether your revision has actually made you interview-ready.
Are the study notes mobile-friendly for studying on the go?
Yes, the study notes are built to load fast and read comfortably on mobile devices, so you can revise during a commute or between classes. Sections are short and answer-first, which suits small screens, and analogy switching works on mobile too, letting you study anywhere without carrying books.
What is the difference between study notes and cheat sheets?
Study notes explain concepts in depth with context, examples and analogies, making them ideal for learning and revision. Cheat sheets are compact quick-reference summaries of syntax, commands and key facts, ideal once you already understand a topic. Most learners study the notes first, then keep the cheat sheet handy while coding.
Do study notes help if I am stuck on a course lesson?
Yes, reading the matching study notes often clarifies a lesson because the same concept is explained from a different angle, frequently with a different analogy. If you are still stuck, ask the AI Mentor, which answers 24/7 at Quick, Detailed or Deep-dive depth until the idea genuinely makes sense.
Is there free study material for DevOps and cloud topics?
Yes, SkillVeris carries free study notes for DevOps and cloud topics as part of its coverage across 37 live courses. The material suits learners following the DevOps Engineer or Cloud Engineer paths, and it links to related glossary terms and cheat sheets so you can revise the whole toolchain in one place.
Can school or college students in India use these notes for projects?
Yes, students across India and worldwide use SkillVeris notes for coursework, projects and exam preparation, and everything is free, which matters for student budgets. The notes explain concepts clearly enough to cite in project reports, and Code Lab lets you prototype the project code directly in your browser.
How should I combine study notes with other SkillVeris resources?
A proven loop: learn from a course lesson, revise with the matching study notes, look up unfamiliar terms in the glossary, keep the cheat sheet open while practising in Code Lab, and quiz yourself with interview questions. The AI Mentor fills any remaining gaps 24/7, at whatever depth you need.

What Learners Say

Real journeys from the SkillVeris community — swipe for more.

SkillVeris taught me Python through Cricket. Now I’m building real projects and feeling confident!
Arjun S. · B.Tech Student
The best platform for hobby-based learning. Concepts finally stick.
Priya R. · Data Analyst
I went from zero coding to a portfolio of projects — all by learning through my love for gaming. Landed my first internship!
Kabir M. · CS Undergraduate
Trending Topics50 popular tags — tap to explore
Trending CoursesAll 37 free courses — tap to browse