Use AsNoTracking() for better performance in Entity Core
Entity Core maintains the snapshot of the table while reading the data from the database to track the changes. If you don’t want to track the changes and you just want to read the data from the database, use AsNoTracking() for better performance. By using AsNoTracking(), we are telling Entity Core that doesn’t maintain any snapshot for the specific table.
var categories = _dbContext.Categories.AsNoTracking();
As shown above, we are reading the data from the Categories table without maintaining any snapshot which increases the performance. With AsNoTracking(), we can’t track any changes to the database object and it works for read-only data.
Latest TechTips
Latest Posts
Categories
- AngularJS (7)
- Asp.Net (231)
- Asp.Net Core (4)
- Asp.Net MVC (55)
- Asp.Net Web API (32)
- Blazor (6)
- C#.Net (432)
- Cryptography (9)
- Entity Framework Core (2)
- General (12)
- Git (5)
- IIS (5)
- JavaScript (6)
- jQuery (28)
- LINQ (10)
- Microsoft Azure (32)
- Microsoft Excel (2)
- Microsoft Office (42)
- Microsoft Promo Code (16)
- Oracle (2)
- Sharepoint (21)
- Silverlight (3)
- SQL Server (12)
- Terraform (3)
- Vb.Net (8)
- WCF (19)
- WPF (18)
- Xamarin (10)
- XML (4)