In this video, I’ll show you how to implement CQRS-style queries using Entity Framework Core to reduce database load and boost performance. Learn how to leverage projections, AsNoTracking, and strongly-typed results to write minimal, efficient queries. Whether you're building APIs or optimizing existing ones, these techniques will level up your skills!

Become a sponsor to access source code ► https://www.patreon.com/zoranhorvat
Join Discord server with topics on C# ► https://codinghelmet.com/go/discord
Enroll course *Beginning Object-Oriented Programming with C#* ► https://codinghelmet.com/go/beginning-oop-with-csharp
Subscribe ► https://www.youtube.com/channel/UCxsWfh8LCcn55mFB6zGBT1g?sub_confirmation=1
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
👨 About Me 👨
Hi, I’m Zoran, I have more than 20 years of experience as a software developer, architect, team lead, and more. I have been programming in C# since its inception in the early 2000s. Since 2017 I have started publishing professional video courses at Pluralsight and Udemy and by this point, there are over 100 hours of the highest-quality videos you can watch on those platforms. On my YouTube channel, you can find shorter video forms focused on clarifying practical issues in coding, design, and architecture of .NET applications.❤️
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
⚡️COPYRIGHT NOTICE:
The Copyright Laws of the United States recognize a “fair use” of copyrighted content.  Section 107 of the U.S. Copyright Act states: “Notwithstanding the provisions of sections 106 and 106A, the fair use of a copyrighted work, including such use by reproduction in copies or phono records or by any other means specified by that section, for purposes such as criticism, comment, news reporting, teaching (including multiple copies for classroom use), scholarship, or research, is not an infringement of copyright." This video and our youtube channel, in general, may contain certain copyrighted works that were not specifically authorized to be used by the copyright holder(s), but which we believe in good faith are protected by federal law and the Fair use doctrine for one or more of the reasons noted above.

Zoran Horvat

Learn how to optimize database queries using the CQRS principle in Entity Framework Core. This involves separating queries from commands, projecting queries to collect only necessary data, and efficiently using resources by minimizing database calls. The post provides a practical guide, including code examples, to illustrate how to implement CQRS in a Minimal API application.

Master CQRS Queries in EF Core: Optimize for Speed and Efficiency