ZZZ Projects

🎬 New video is live! LINQ Dynamic vs C# Eval Expression: Which One Should You Use? Anton Martyniuk walks through key concepts and practical examples to help you get up and running. 👉 Watch here: youtube.com/watch?v=twipi1…

New article on YogiHosting! Learn how to boost your EF Core performance using Entity Framework Extensions for fast bulk operations (insert, update, delete, merge). 👉 yogihosting.com/entity-framewo… #DotNet #EFCore #EntityFramework #Performance #ZZZProjects

March Monthly Contest Winner “Definitely the library is amazing, and is ideal for high-performance scenarios where efficiency and clear data access logic matter most.” — Nelson Solorzano, Freelancer Thanks for sharing your experience 👏 👉 entityframework-extensions.net/contest #DotNet #EF

New video in Arabic! If you're working with Entity Framework, this video is worth checking out. You’ll learn how to: ✔️ Boost performance ✔️ Reduce execution time ✔️ Handle large datasets more efficiently Video here: youtube.com/watch?v=7q2lfU… #dotnet #EntityFramework

📝 New article by Anton Martyniuk Learn how to get the most out of Entity Framework Extensions by understanding its key options — from column control to performance tuning. 👉 antondevtips.com/blog/entity-fr…

𝗬𝗼𝘂 𝘀𝘁𝗶𝗹𝗹 𝘄𝗿𝗶𝘁𝗲 𝗮 𝗪𝗵𝗲𝗿𝗲 + 𝗖𝗼𝗻𝘁𝗮𝗶𝗻𝘀 𝗶𝗻 𝗘𝗙 𝗖𝗼𝗿𝗲? Please stop! 👇 As you are ruining the performance of your application. When working with Entity Framework Core, developers often need to retrieve multiple entities from the database based on a collection of IDs or values. The typical approach is to use the Contains method: 𝚟𝚊𝚛 𝚙𝚛𝚘𝚍𝚞𝚌𝚝𝚜 = 𝚊𝚠𝚊𝚒𝚝 𝚍𝚋𝙲𝚘𝚗𝚝𝚎𝚡𝚝.𝙿𝚛𝚘𝚍𝚞𝚌𝚝𝚜 .𝚆𝚑𝚎𝚛𝚎(𝚙 => 𝚙𝚛𝚘𝚍𝚞𝚌𝚝𝙸𝚍𝚜.𝙲𝚘𝚗𝚝𝚊𝚒𝚗𝚜(𝚙.𝙸𝚍)) .𝚃𝚘𝙻𝚒𝚜𝚝𝙰𝚜𝚢𝚗𝚌(); This approach works fine for small collections, but it creates significant problems when dealing with large datasets: → Performance degradation - Even with proper indexes, the SQL WHERE IN clause becomes slower as the number of parameters increases. → Parameter limit exceeded - SQL Server has a hard limit of 2,100 parameters per query. While you can work around this by splitting queries into batches in SQL, this is not always practical when using EF Core, especially in complex scenarios with additional filters and joins. → Memory and connection issues - Multiple round-trips to the database consume more memory and keep database connections open longer, potentially causing connection pool exhaustion. This becomes a real problem in scenarios like synchronizing product catalogs, processing bulk orders, or updating inventory across thousands of items. There is a better solution: 𝗘𝗻𝘁𝗶𝘁𝘆 𝗙𝗿𝗮𝗺𝗲𝘄𝗼𝗿𝗸 𝗘𝘅𝘁𝗲𝗻𝘀𝗶𝗼𝗻𝘀 library provides specialized methods for bulk data retrieval that solve all these problems. The library provides specialized methods that use temporary tables internally to bypass the parameter limit and improve performance. In the video, I show a detailed guide to 5 bulk-read methods using the 𝗘𝗻𝘁𝗶𝘁𝘆 𝗙𝗿𝗮𝗺𝗲𝘄𝗼𝗿𝗸 𝗘𝘅𝘁𝗲𝗻𝘀𝗶𝗼𝗻𝘀 library. I explain in depth these methods: → WhereBulkContains → WhereBulkNotContains → BulkRead → WhereBulkContainsFilterList → WhereBulkNotContainsFilterList 👉 Get the source code of this video: ↳ github.com/anton-martyniu… 👉 Get started with EF Core Extensions: ↳ entityframework-extensions.net/?utm_source=an… —— ♻️ Repost to help others learn how to perform bulk read operations in EF Core ➕ Follow me ( @AntonMartyniuk ) to improve your .NET and Architecture Skills Many thanks to @zzzprojects for sponsoring this post.

In this article, you’ll learn how to get started with Entity Framework Extensions and use bulk operations like BulkInsert, BulkUpdate, and BulkMerge to handle large datasets efficiently. devskillsunlock.com/blog/entity-fr…

📷 ZZZ Projects — February Newsletter Stay up to date with the latest updates, releases, and community highlights from the ZZZ Projects team! mailchi.mp/zzzprojects/wh…

Want to build a fast and clean CRUD API in ASP.NET Core? In this new article from Coding Sonata, you’ll learn how to combine Dapper for lightweight data access with Dapper Plus for high-performance inserts, updates, and bulk operations. codingsonata.com/building-crud-…

🎥 Sarrawy Dev explains Entity Framework Extensions and how it helps boost performance. Whether you’re optimizing bulk operations or improving overall efficiency, this video breaks the concepts down in a clear and practical way. 👉 Watch here: youtube.com/watch?v=_yyru5…

These options in Entity Framework Extensions library (PART 2) Will save you hours, days or even weeks of development 👇 Entity Framework Extensions library is not only useful when you need to insert thousands of records. It also comes with hundreds of useful options that can save a lot of time in your daily routine with EF Core. In the video, I show a detailed guide on various options with 𝗘𝗻𝘁𝗶𝘁𝘆 𝗙𝗿𝗮𝗺𝗲𝘄𝗼𝗿𝗸 𝗘𝘅𝘁𝗲𝗻𝘀𝗶𝗼𝗻𝘀 library. This video is PART 2 in the series. You can try EF Core Extensions for free with the monthly trial. 👉 Get started with EF Core Extensions: ↳ lnkd.in/djZVdbPY 👉 See real-world benchmarks: ↳ lnkd.in/eMD9dAvt 👉 Get the source code of this video: ↳ lnkd.in/dkp4XaXG —— ♻️ Repost to help others save time with EF Core Extensions ➕ Follow me ( @AntonMartyniuk ) to improve your .NET and Architecture Skills Many thanks to @zzzprojects for sponsoring this post.

⚡ Working with large data sets in EF Core? This article explains why many developers use Entity Framework Extensions! antondevtips.com/blog/why-every… #dotnet #efcore #entityframework #developers #performance #backend #softwaredevelopment

Filtering large lists in EF Core? This article explains the real difference between Where and WhereBulkContains and when performance really matters. 👉 pavle.codes/where-vs-where…

Monthly Contest Winner Congrats! 🥳 “I tried this library and it is amazing. Powerful, easy to use and really efficient. It also helped me reduce code complexity. Great work!” — Giacomo Petrussa Thanks for sharing your experience entityframework-extensions.net/contest #DotNet #EntityFramework

🎥 New video – Part 1/2 @AntonMartyniuk explains key options in Entity Framework Extensions, with practical EF / EF Core examples and real-world scenarios. ▶️ Watch Part 1: youtu.be/YwODaOlgWRQ?si… Part 2 coming soon 👀

These options in Entity Framework Extensions library Will save you hours, days or even weeks of development 👇 Entity Framework Extensions library is not only useful when you need to insert thousands of records. It also comes with hundreds of useful options that can save a lot of time in your daily routine with EF Core. In the video, I show a detailed guide on various options with 𝗘𝗻𝘁𝗶𝘁𝘆 𝗙𝗿𝗮𝗺𝗲𝘄𝗼𝗿𝗸 𝗘𝘅𝘁𝗲𝗻𝘀𝗶𝗼𝗻𝘀 library. This is the first part of the video, stay tuned for more PART 2 in 2 weeks. You can try EF Core Extensions for free with the monthly trial. 👉 Get started with EF Core Extensions: ↳ entityframework-extensions.net/?utm_source=an… 👉 See real-world benchmarks: ↳ github.com/zzzprojects/En… 👉 Get the source code of this video: ↳ github.com/anton-martyniu… —— ♻️ Repost to help others save time with EF Core Extensions ➕ Follow me ( @AntonMartyniuk ) to improve your .NET and Architecture Skills Many thanks to @zzzprojects for sponsoring this post.

Dapper Plus Options Explained: Everything You Can Customize poornasoysa.tech/dapper-plus-op…

🎉 Monthly Contest Winner: “This extension made it extremely easy to make EF the pinacle of our backend… helped us improve speed and make bulk insert reliable. That I didnt find this earlier I dont know” - Aleksander Lyse 👉 Join next month’s contest: entityframework-extensions.net/contest

📬 December Newsletter is out Our latest ZZZ Projects newsletter is live, with recent updates across our performance libraries and a look at what we’ve been working on as the year wraps up. 👉 Read it here: mailchi.mp/zzzprojects/wh…

🎥 New sponsored video! Dive into EF Core inheritance with a clear breakdown of TPH vs TPT vs TPC — with real, practical examples. Perfect for sharpening your EF Core skills 👉 youtube.com/watch?v=dtqvdl… #dotnet #efcore #csharp #entityframework