Milan Jovanovićmilanjovanovic.hashnode.dev·Apr 13, 2024A Clever Way To Implement Pessimistic Locking in EF CoreSometimes, especially in high-traffic scenarios, you absolutely need to ensure that only one process can modify a piece of data at a time. Imagine you're building the ticket sales system for a wildly popular concert. Customers are eagerly grabbing ti...Discuss·116 readsPostgreSQL
Nabidul Islamnabidul.hashnode.dev·Apr 9, 2024Modelling using EF Core in ASP.NETWhat is EF Core? EF core, commonly known as Entity Framework core, is an open-source tool developed by Microsoft to allow developers to interact with data in the database using .NET objects instead of writing SQL queries. What is ASP.NET? ASP.NET is ...Discuss·1 like·70 readsASP.NET
Hirusha Fernandohirushafernando.hashnode.dev·Mar 27, 2024Entity Framework Core Audit Trial With Audit.NetWhat is Audit Trail? Audit trail is a record of all user activities within an application. It captures details like who accessed the application, what changes were made, and when they occurred. By maintaining an audit trail, developers can track data...Discussaudit-trial
Pablo Rivas Sánchezpablorivas.eu·Mar 24, 2024Enhancing Database Operations with EF Core 7 InterceptorsEntity Framework Core 7 (EF7) introduces a range of enhancements, including advanced support for interceptors. Interceptors empower developers to intercept, modify, and suppress EF Core operations, offering granular control over database interactions...Discussefcore
Milan Jovanovićmilanjovanovic.hashnode.dev·Mar 23, 2024Fast SQL Bulk Inserts With C# and EF CoreWhether you're building a data analytics platform, migrating a legacy system, or onboarding a surge of new users, there will likely come a time when you'll need to insert a massive amount of data into your database. Inserting the records one by one f...Discuss·118 readsSQL
Milan Jovanovićmilanjovanovic.hashnode.dev·Feb 3, 2024How I Made My EF Core Query 3.42x Faster With BatchingEF Core is a fantastic ORM if you're building .NET applications. But it's a tool like any other. And you can end up using it in a suboptimal way. Today, I'll show you a simple idea I used to get an almost 4x performance improvement. I'm not saying yo...Discussdotnet
shineydocs-eddy-studios.hashnode.dev·Jan 19, 2024EntityFramework Core -Tracking and No-Tracking Queriesintro 默认情况下,查询是可跟踪的,这意味着如果查询更改了某些实体的某些属性并保存它们,则这些修改将在数据库上重新执行。 您查询产品,更改其名称并保存更改。下次您查询此产品时,他的名字将是更新的。Great. 什么是 AsNoTracking? AsNoTracking 方法允许查询不可跟踪,因此即使调用 SaveChanges 方法,数据库中也不会发生任何更改。 在我们前面的示例中绝对没有意义,但是如果您已经知道您的查询不会修改数据库怎么办? 原理 下面这段查询: return ...DiscussEntityFramework CoreEntityFrameworkCor
Alexandru Prodancodecraftsymphony.com·Dec 1, 2023Introduction to EF Core Relationships ModelingIntroduction This article explains the necessary terms used while designing a data model and introduces you to different ways to configure relationships in EF Core. Furthermore, the article distinguishes the three methods for configuring EF Core rela...Discuss·42 readsEF Coreefcore
Milan Jovanovićmilanjovanovic.hashnode.dev·Nov 18, 2023How To Use EF Core InterceptorsEF Core is my favorite ORM for .NET applications. Yet, its many fantastic features sometimes go unnoticed. For example, query splitting, query filters, and interceptors. EF interceptors are interesting because you can do powerful things with them. Fo...Discuss·103 reads.NET
Sudi Davidsudi.dev·Nov 14, 2023Adding Entity Framework Core and SQLiteBuilding upon our introduction to Minimal APIs, let's proceed to the next level by incorporating a data source to store and retrieve recipe information. We'll be using SQLite as our database and Entity Framework Core to interact with it. To get start...Discuss·1 like·56 readsefcore