Hassan Vaezzadeh on LinkedIn: 5 Techniques to Optimized EF Query in .NET Core. (2024)

Understanding the 𝐝𝐢𝐟𝐟𝐞𝐫𝐞𝐧𝐜𝐞 𝐛𝐞𝐭𝐰𝐞𝐞𝐧 𝐞𝐚𝐠𝐞𝐫 𝐥𝐨𝐚𝐝𝐢𝐧𝐠 𝐚𝐧𝐝 𝐥𝐚𝐳𝐲 𝐥𝐨𝐚𝐝𝐢𝐧𝐠 𝐢𝐧 𝐄𝐧𝐭𝐢𝐭𝐲 𝐅𝐫𝐚𝐦𝐞𝐰𝐨𝐫𝐤 can significantly impact your application's performance and resource usage.With 𝐞𝐚𝐠𝐞𝐫 𝐥𝐨𝐚𝐝𝐢𝐧𝐠, all related entities, such as products and their associated categories, are fetched upfront in a single database query. This reduces the need for additional queries when accessing related data.In contrast, 𝐥𝐚𝐳𝐲 𝐥𝐨𝐚𝐝𝐢𝐧𝐠 delays the loading of related entities until they're explicitly accessed. While convenient, this approach can result in additional queries being executed on-demand, potentially impacting performance.Understanding when to use each loading strategy is crucial for optimizing data retrieval in Entity Framework applications.#entityframework #performanceoptimization #dataretrieval #csharp #dotnet #orm

32

Implementing Global Query Filter in EntityFramework is a good practice, especially for soft delete.But if you are using Database First Approach, every time you do a reverse engineering , this query filter will reset.How can it be done using Database First Appraoch? Click the link below ⬇ https://lnkd.in/gnPxdHk3⏩ Reshare with your network if this is helpful#003 #dotnet #softwareengineering #softwaredevelopment

9

Let's review Predicate and Expression in C#!Predicate<T> and Expression<Func<T, bool>> in C# are two powerful tools for data filtering.Predicate<T>:+ Is a delegate to define criteria that return a boolean to indicate whether an object meets these conditions.+ It's ideal for in-memory filtering of collections, providing a straightforward way to filter data without complex setups.Expression<Func<T, bool>>:+ Shines when working with Entity Framework Core.+ This tool allows you to build expression trees that are translated into SQL queries.+ Helps to dynamically construct complex queries that EF Core can efficiently translate into database queriesWhy Use Expressions?1. Expressions let you construct queries on-the-fly based on runtime conditions.2. By translating expression trees into SQL, you leverage the database's processing power for filtering, making it more efficient than loading all data into memory.3. Expressions enable you to write modular and reusable query logic. 4. With Expressions, you seamlessly integrate with LINQ and EF Core, making it easier to write clean and maintainable code.5. Building intricate queries with ease.Predicate<T> and Expression<Func<T, bool>> together offer a robust approach to data filtering, whether you're working with in-memory collections or querying a database.✅ They help build more powerful, dynamic, modular, and scalable queries.✍ Share your experiences using Expressions in the comments!-- Follow Elliot One for more software engineer posts.#dotnet #efcore #softwareengineering

329

35 Comments

Are you curious about the differences between Database-First and Code-First approaches in Entity Framework? Let's understand it!𝐃𝐚𝐭𝐚𝐛𝐚𝐬𝐞-𝐅𝐢𝐫𝐬𝐭:Start with an existing database and generate models from it. Perfect for when your database is already set up.𝐂𝐨𝐝𝐞-𝐅𝐢𝐫𝐬𝐭:Start with the code, then create the database. Ideal for when you want full control over your models and database design.𝐖𝐡𝐢𝐜𝐡 𝐭𝐨 𝐂𝐡𝐨𝐨𝐬𝐞?➺ Database-First: Use this if your database is already built.➺ Code-First: Choose this if you want to design your database through code.Understanding these approaches helps you pick the right one for your project. Happy coding!Stay tuned for more easy tech tips! Like, Repost, and Comment below!#dotnet #entityframework #databasefirst #codefirst #csharp

130

1 Comment

Code First vs Database First

1

LINQ (Language Integrated Query) in C# is a feature that lets you query and manipulate data directly within your codeusing a SQL-like syntax or method calls. It supportsquerying various data sources such as collections, databases,XML, etc., with powerful operators like Where, Select, OrderBy, and more.LINQ provides efficient querying through deferred execution and integrates seamlessly withC# for improved code readability and maintenance.Example:// Sample dataList<int> numbers = new List<int> { 1, 2, 3, 4, 5, 6, 7, 8, 9, 10 };// Query Syntaxvar evenNumbersQuery = from num in numberswhere num % 2 == 0select num;// Method Syntaxvar evenNumbersMethod = numbers.Where(num => num % 2 == 0);// Iterating through resultsforeach (var num in evenNumbersQuery){Console.WriteLine(num); // Output: 2, 4, 6, 8, 10}foreach (var num in evenNumbersMethod){Console.WriteLine(num); // Output: 2, 4, 6, 8, 10}

2

𝙐𝙣𝙙𝙚𝙧𝙨𝙩𝙖𝙣𝙙𝙞𝙣𝙜 𝙬𝙝𝙖𝙩 𝙎𝙌𝙇 𝙦𝙪𝙚𝙧𝙞𝙚𝙨 𝙮𝙤𝙪𝙧 𝙇𝙄𝙉𝙌 𝙘𝙤𝙙𝙚 𝙜𝙚𝙣𝙚𝙧𝙖𝙩𝙚𝙨 𝙘𝙖𝙣 𝙗𝙚 𝙩𝙧𝙞𝙘𝙠𝙮Normally, the SQL commands executed by Entity Framework (EF) can appear 𝐪𝐮𝐢𝐭𝐞 𝐝𝐢𝐟𝐟𝐞𝐫𝐞𝐧𝐭 𝐟𝐫𝐨𝐦 𝐭𝐡𝐞 𝐋𝐈𝐍𝐐 queries that created them. This mismatch can make it difficult to analyze and debug your code.⭐ EF's query tags feature comes to the rescue!This feature lets you add a short, descriptive comment directly into the generated SQL query.This comment acts as a bridge, making it easier to 𝗺𝗮𝘁𝗰𝗵 𝘁𝗵𝗲 𝗦𝗤𝗟 𝗯𝗮𝗰𝗸 𝘁𝗼 𝘁𝗵𝗲 𝗼𝗿𝗶𝗴𝗶𝗻𝗮𝗹 𝗟𝗜𝗡𝗤 𝗰𝗼𝗱𝗲p.s: check out the post about TagWithCallSite's twin:https://lnkd.in/dfXP869W#dotnet #efcore #csharp

40

2 Comments

#DbContext in Entity Framework Core🏷️ DbContext is a component for managing entities, relationships and configuring #EFCore 's behavior.🏷️ DbContext is a #DotNet class, that acts intermediate between the .NET application and the database🏷️DbContext plays a crucial role in managing entities, tracking changes, and coordinating database operations.🏷️Key Responsibilities of DbContext:🗝️ Tracks the state of entities (Added, Deleted, Modified, UnChanged),to generate appropriate SQL statements when saving changes to the database.🗝️ Database Interaction: DbContext provides methods to interact with the database including:➕ Querying entities.➕ Saving changes.➕ Executing raw SQL commands.➕ Managing transactions.🗝️ DbContext translates #LINQ queries written in your application into SQL queries that can be executed against the database. This translation is handled by EF Core's query pipeline.🗝️ Configuration and Relationships:DbContext allows you to configure various aspects of EF Core, including :➕ Connection settings➕ Entity mappings➕Establish relationships (e.g., one-to-many, many-to-many) between entities.➕ Database initialization strategies.#EntityFrameworkCore #DbContext #ORM #DotNetDevelopment #SoftwareEngineering #backend

16

𝙐𝙣𝙙𝙚𝙧𝙨𝙩𝙖𝙣𝙙𝙞𝙣𝙜 𝙬𝙝𝙖𝙩 𝙎𝙌𝙇 𝙦𝙪𝙚𝙧𝙞𝙚𝙨 𝙮𝙤𝙪𝙧 𝙇𝙄𝙉𝙌 𝙘𝙤𝙙𝙚 𝙜𝙚𝙣𝙚𝙧𝙖𝙩𝙚𝙨 𝙘𝙖𝙣 𝙗𝙚 𝙩𝙧𝙞𝙘𝙠𝙮Normally, the SQL commands executed by Entity Framework (EF) can appear 𝐪𝐮𝐢𝐭𝐞 𝐝𝐢𝐟𝐟𝐞𝐫𝐞𝐧𝐭 𝐟𝐫𝐨𝐦 𝐭𝐡𝐞 𝐋𝐈𝐍𝐐 queries that created them. This mismatch can make it difficult to analyze and debug your code.⭐ EF's query tags feature comes to the rescue!This feature lets you add a short, descriptive comment directly into the generated SQL query.This comment acts as a bridge, making it easier to 𝗺𝗮𝘁𝗰𝗵 𝘁𝗵𝗲 𝗦𝗤𝗟 𝗯𝗮𝗰𝗸 𝘁𝗼 𝘁𝗵𝗲 𝗼𝗿𝗶𝗴𝗶𝗻𝗮𝗹 𝗟𝗜𝗡𝗤 𝗰𝗼𝗱𝗲#dotnet #efcore #csharp

78

8 Comments