SUBSTRING () LEFTJOIN() INNERJOIN()

Some LINQ queries are much harder to read than the SQL they create. Left joins are a great example. You want a simple result: → Show all products → Include reviews when they exist → Keep products with no reviews But in EF Core, writing that query used to take several steps. It worked. It was also easy to get wrong, hard to scan, and not fun to explain to the next person reading your code. EF Core 10 fixes this with new LeftJoin and RightJoin operators. Now your query can say what it is actually doing. Why this matters: → Less noise in common queries → Clearer intent for your team → Fewer workarounds → The same SQL result underneath This is useful for more than products and reviews. Think: → Users with optional settings → Orders with optional shipping data → Customers with optional invoices Anywhere related data may be missing, a clean join makes the code easier to trust. I wrote a practical guide to the new join operators in EF Core 10, including how they compare to the old approach and when to use each one. Read it here: milanjovanovic.tech/blog/wha…

New LINQ Methods in .NET 6-10: Chunk, MinBy, CountBy, Index, LeftJoin, and More New LINQ methods in .NET 6-10: Chunk, DistinctBy, MinBy, CountBy, Index, LeftJoin and more -- every addition with before/after C# code examples. Read the article here: bgh.st/pp8jaf

.𝗡𝗘𝗧 𝟭𝟬 𝗶𝘀 𝗼𝘂𝘁! Here are the top updates 👇 𝗖# 𝟭𝟰 • Extension Members • Null-Conditional Assignment • The Field Keyword • Lambda Parameters with Modifiers • Partial Constructors and Events 𝗙𝗶𝗹𝗲-𝗕𝗮𝘀𝗲𝗱 𝗔𝗽𝗽𝘀: • Starting with .NET 10, you can create a single *.cs file and run it directly, without solution file (sln) and project file (csproj). 𝗔𝗦𝗣.𝗡𝗘𝗧 𝗖𝗼𝗿𝗲 • Validation Support in Minimal APIs • JSON Patch Support in Minimal APIs • Server-Sent Events (SSE) • OpenAPI 3.1 Support 𝗘𝗙 𝗖𝗼𝗿𝗲 • Optional Complex Types • JSON and struct Support for Complex Types • LeftJoin and RightJoin Operators • Named Query Filters • ExecuteUpdate for JSON Columns • Regular Lambdas in ExecuteUpdate .𝗡𝗘𝗧 𝗔𝘀𝗽𝗶𝗿𝗲 • Aspire 9.5 adds targeted CLI • File-based AppHost support • Generative AI visualizer • Trace detail improvements • OpenAI hosting integration • Azure Emulators support 𝗕𝗹𝗮𝘇𝗼𝗿 • Hot Reload for Blazor WebAssembly and .NET on WebAssembly • Environment configuration in standalone Blazor WebAssembly apps • Performance profiling and diagnostic counters for Blazor WebAssembly • NotFoundPage parameter for the Blazor router • Static asset preloading in Blazor Web Apps • Improved form validation 𝗟𝗶𝗯𝗿𝗮𝗿𝗶𝗲𝘀 • New APIs in cryptography, globalization, numerics, serialization, collections, and diagnostics, and when working with ZIP files • New JSON serialization options 𝗥𝘂𝗻𝘁𝗶𝗺𝗲 • Improvements in JIT inlining, method devirtualization, and stack allocations. • AVX10.2 support • NativeAOT enhancements • Improved code generation for struct arguments, and enhanced loop inversion for better optimization. 👉 25,000 engineers are up to date with the latest .NET features by reading my free newsletter. If you want to reach the top 1% of .NET developers, join here: antondevtips.com/?utm_source… —— ♻️ Repost to help others learn about .NET 10 ➕ Follow me ( @AntonMartyniuk ) to improve your .NET Skills

Relatable experience: When I thought I was alloromantic, I picked a crush to blend in with (((them))) and I picked Gurobi Optimizer. #relatable #relatabular #leftjoin #rightjoin #structuredquerylanguage #2NF #3NF #Gay #ComingOut #RsquaredequalsOne #gayhomosexual

Her yerden karşılıklı takipten çıkılmış eski arkadaşı LinkedIn’den çıkartmadığını fark etmek komik. Ne yaptığı hakkında hiçbir bilgin yok ama ücretsiz sql eğitimi gönderisi beğenmiş. Gel sana anlatayım amk leftjoin, trigger, partition by

LeftJoin support in Entity Framework 10 🥳 It was great to finally get this added in 10. #dotnet

📝 Your daily dose of .NET is here! Issue #377 features the end of "GroupJoin gymnastics" with native LeftJoin and RightJoin in EF Core 10 🚀, the arrival of Post-Quantum Cryptography in .NET 10 🔐, building zero-allocation parsers using ref struct 🏎️, and how to automate DI using Scrutor. The ecosystem is evolving fast—stay informed! 👇 dotnetnews.co/archive/the-ne… #dotnet #csharp #efcore #cybersecurity #performance #dotnet10

10 Reasons to Upgrade to .NET 10 That will get approved by your boss 👇 .NET 10 and C# 14 were released on November 11, 2025. Today, I want to show 10 reasons why you should consider upgrading your projects to .NET 10. 1. Long-Term Support (LTS) Release • As a Long-Term Support (LTS) release, .NET 10 will receive three years of support until November 14, 2028. • Support for .NET 8 ends on November 10, 2026, so you should consider upgrading to .NET 10 as soon as possible. 2. Performance improvements in ASP .NET Core • ASP .NET Core in .NET 10 received a major performance boost and can process 15% more requests per second compared to .NET 8. • In addition, ASP .NET Core now consumes 93% less memory than previous versions, significantly reducing the overall working set. 3. Performance improvements in .NET • All the hundreds of performance improvements are available by just upgrading your project to .NET 10. 4. File-Based Apps • Starting with .NET 10, you can create a single *.cs file and run it directly. • This makes C# a good option for CLI utilities, automation scripts, and tooling, without a project setup. 5. Server-Sent Events (SSE) • Server-Sent Events (SSE) provide a lightweight, reliable way for ASP .NET Core apps to push continuous streams of data without the complexity of bidirectional protocols. • Server-Sent Events (SSE) is a web standard that enables a server to push real-time data to web clients over a single HTTP connection. 6. Extension Members in C# 14 • The new syntax separates the receiver (the type you're extending) from the members you're adding. • You can now extend properties and static members. 7. Validation and JSON Patch Support in Minimal APIs • You can use JSON Patch in your Minimal APIs starting from .NET 10. • ASP. NET Core 10 adds built-in validation support for Minimal APIs. 8. LeftJoin and RightJoin Operators in EF 10 • .NET 10 adds first-class LINQ support for LeftJoin, making these queries much simpler. • EF 10 also supports RightJoin, which keeps all data from the second collection and only matching data from the first. 9. Named Query Filters in EF 10 • Global query filters let you define conditions that apply to all queries for an entity type. • EF 10 introduces named query filters, letting you define multiple filters and control them independently. 10. Blazor Improvements • Hot Reload for Blazor WebAssembly and .NET on WebAssembly. • Performance profiling and diagnostic counters for Blazor WebAssembly. 👉 Here is the detailed guide on these reasons: antondevtips.com/draft/10-re… Send this to your boss to approve your project migration. 👉 Join 20,000 software engineers who stay ahead with the latest .NET features by reading my Newsletter: ↳ antondevtips.com/?utm_source… —— ♻️ Repost to help others migrate their projects to .NET 10 ➕ Follow me ( @AntonMartyniuk ) to improve your .NET and Architecture Skills

📝 Your daily dose of .NET is here! Issue #361 focuses on Production Refinements in .NET 10 & ASP. NET Core 🚀. Dive into native EF Core 10 LeftJoin & RightJoin 🔗, the power of Hybrid & Output Caching ⚡, and mastering Time Zones for global apps 🌍. Plus, 5 modern C# features to slash your boilerplate! 👇 dotnetnews.co/archive/the-ne… #dotnet #csharp #efcore #net10 #aspnetcore #performance #architecture

من اهم 3 features نزلوا مع تحديث .NET 10 الي هما LeftJoin and RightJoin support File-based apps Extension members

It took EF Core 10 to make LeftJoin readable in LINQ. After years of: GroupJoin DefaultIfEmpty We finally get: LeftJoin() / RightJoin() Is this a win… or too little, too late? My thoughts: youtu.be/vhshkKRHE9o

EF CoreのLEFT JOIN、 GroupJoin SelectMany DefaultIfEmptyの 組み合わせが毎回面倒だった。 .NET 10でLeftJoin()が追加されて解決✨ 生成SQLは同じで可読性だけ向上。 qiita.com/haruyaNekoder/item… #CSharp #EFCore #EntityFramework

.NET 10 is one of the best releases ever. Here are the top updates 👇 .NET 10 and C# 14 were released on November 11, 2025. As a Long-Term Support (LTS) release, .NET 10 will receive three years of support until November 14, 2028. This makes it a solid choice for production applications that need long-term stability. Here are the most amazing new features in this release: 𝗖# 𝟭𝟰 • Extension Members • Null-Conditional Assignment • The Field Keyword • Lambda Parameters with Modifiers • Partial Constructors and Events 𝗙𝗶𝗹𝗲-𝗕𝗮𝘀𝗲𝗱 𝗔𝗽𝗽𝘀: • Starting with .NET 10, you can create a single *.cs file and run it directly, without solution file (sln) and project file (csproj). 𝗔𝗦𝗣.𝗡𝗘𝗧 𝗖𝗼𝗿𝗲 • Validation Support in Minimal APIs • JSON Patch Support in Minimal APIs • Server-Sent Events (SSE) • OpenAPI 3.1 Support 𝗘𝗙 𝗖𝗼𝗿𝗲 • Optional Complex Types • JSON and struct Support for Complex Types • LeftJoin and RightJoin Operators • Named Query Filters • ExecuteUpdate for JSON Columns • Regular Lambdas in ExecuteUpdate 📌 In November, more than 𝟭𝟳,𝟬𝟬𝟬 developers explored these new features in my detailed newsletter. If you missed it, you can read the full guide here: ↳ antondevtips.com/blog/new-fe… 👉 Join 𝟭𝟴,𝟬𝟬𝟬 developers and improve your .NET and Software Architecture skills. Every subscriber also receives a PDF with 650 exclusive .NET learning resources. —— I have already migrated most of my commercial projects to .NET 10. Have you already migrated to .NET 10, or do you have any plans for a migration? —— ♻️ Repost to help others learn about .NET 10 ➕ Follow me ( @AntonMartyniuk ) to improve your .NET and Architecture Skills.

.NET 10 is officially released! 🎉 Here are the top updates 👇 First, .NET 10 is an LTS (long-term support) release. So we get support for the next 3 years. 🔥 Performance improvements Under the hood, .NET 10 delivers major performance boosts. The JIT compiler has been tuned with new optimizations such as de‑abstraction, smarter inlining heuristics and constant‑folding, allowing the runtime to do more work at compile‑time rather than at run‑time. There are many other optimizations across collections and LINQ, which translate to tangible speedups across everyday workloads. 🚀 Aspire goes polyglot Formerly .NET Aspire, Aspire is now a polyglot, developer‑first platform for orchestrating front ends, APIs, containers and databases. Version 9.5 introduces a preview of a single‑file AppHost, letting you define and run your entire distributed application in a single file. The release also debuts a Generative AI visualizer to inspect and debug prompts and responses, plus expanded AI support with typed clients for GitHub Models and Azure AI Foundry and first‑class OpenAI integration. 🔗 EF Core’s new LeftJoin/RightJoin operators LINQ’s lack of a built‑in outer join has long been a pain point. EF Core 10 fixes this by adding LeftJoin and RightJoin operators, so the code now reads exactly like the SQL you intend. For example, you can join products to reviews using LeftJoin() and EF will generate the correct LEFT JOIN statement under the hood. A corresponding RightJoin() keeps all rows from the right side while bringing in matches from the left. These new operators eliminate the verbose GroupJoin DefaultIfEmpty pattern and make LINQ queries easier to read and maintain. What's your favorite feature coming in .NET 10? --- Sign up for the .NET Weekly with 74K other engineers, and get a free Clean Architecture template: milanjovanovic.tech/template…

.NET 10 is out today. Here are the top updates 👇 𝗖# 𝟭𝟰 • Extension Members • Null-Conditional Assignment • The Field Keyword • Lambda Parameters with Modifiers • Partial Constructors and Events 𝗙𝗶𝗹𝗲-𝗕𝗮𝘀𝗲𝗱 𝗔𝗽𝗽𝘀: • Starting with .NET 10, you can create a single *.cs file and run it directly, without solution file (sln) and project file (csproj). 𝗔𝗦𝗣.𝗡𝗘𝗧 𝗖𝗼𝗿𝗲 • Validation Support in Minimal APIs • JSON Patch Support in Minimal APIs • Server-Sent Events (SSE) • OpenAPI 3.1 Support 𝗘𝗙 𝗖𝗼𝗿𝗲 • Optional Complex Types • JSON and struct Support for Complex Types • LeftJoin and RightJoin Operators • Named Query Filters • ExecuteUpdate for JSON Columns • Regular Lambdas in ExecuteUpdate .𝗡𝗘𝗧 𝗔𝘀𝗽𝗶𝗿𝗲 • Aspire 9.5 adds targeted CLI • File-based AppHost support • Generative AI visualizer • Trace detail improvements • OpenAI hosting integration • Azure Emulators support 𝗕𝗹𝗮𝘇𝗼𝗿 • Hot Reload for Blazor WebAssembly and .NET on WebAssembly • Environment configuration in standalone Blazor WebAssembly apps • Performance profiling and diagnostic counters for Blazor WebAssembly • NotFoundPage parameter for the Blazor router • Static asset preloading in Blazor Web Apps • Improved form validation 𝗟𝗶𝗯𝗿𝗮𝗿𝗶𝗲𝘀 • New APIs in cryptography, globalization, numerics, serialization, collections, and diagnostics, and when working with ZIP files • New JSON serialization options 𝗥𝘂𝗻𝘁𝗶𝗺𝗲 • Improvements in JIT inlining, method devirtualization, and stack allocations. • AVX10.2 support • NativeAOT enhancements • Improved code generation for struct arguments, and enhanced loop inversion for better optimization. Get my free .NET Backend Developer roadmap 👇 antondevtips.com/roadmap/dot… —— ♻️ Repost to help others learn about .NET 10 ➕ Follow me ( @AntonMartyniuk ) to improve your .NET Skills

昨日の夜からずっと出てたエラー解決できた… Leftjoinの結合エラーだった😭😭😭 バカタレ、呼んでないテーブルのID持ってくるな！ 11日までは確実に自宅で持ち帰り残業ですー… 自分のスキル不足が本当にしんどい

EF Core 10 finally gets LeftJoin and RightJoin. I always had to google how to do a left join in LINQ. Not anymore! Now with the new operators in Entity Framework Core 10 you finally get clear, simple joins that match what you mean. Before: GroupJoin DefaultIfEmpty Now: LeftJoin With the new LeftJoin method you write exactly that: “keep all from left, match right when available.” The intent is obvious, the code is shorter, and the translation to SQL is the same. I wrote about all the details of the new LeftJoin and RightJoin methods in this article: milanjovanovic.tech/blog/wha… In short: the new LeftJoin and RightJoin operators in EF Core 10 clean up the mess, make your intent crystal clear, reduce boilerplate, and give you better readable code. Better late than never, I guess... --- Sign up for the .NET Weekly with 74K other engineers, and get a free Clean Architecture template: milanjovanovic.tech/template…

𝐍𝐚𝐭𝐢𝐯𝐞 𝐋𝐞𝐟𝐭𝐉𝐨𝐢𝐧 𝐬𝐮𝐩𝐩𝐨𝐫𝐭—𝐧𝐨 𝐦𝐨𝐫𝐞 𝐜𝐨𝐦𝐩𝐥𝐞𝐱 𝐰𝐨𝐫𝐤𝐚𝐫𝐨𝐮𝐧𝐝𝐬 📊 Write cleaner, SQL-like queries directly in LINQ ⚡ Faster, more readable and maintainable code 🛠 Boosts developer productivity & reduces query confusion 👉 𝐑𝐞𝐚𝐝 𝐭𝐡𝐞 𝐟𝐮𝐥𝐥 𝐚𝐫𝐭𝐢𝐜𝐥𝐞: c-sharpcorner.com/article/le… #DotNet #EntityFramework #EFCore #LINQ #DotNet10 #CSharp #Developers #Coding #Programming #TechNews #CSharpCorner

𝐍𝐚𝐭𝐢𝐯𝐞 𝐋𝐞𝐟𝐭𝐉𝐨𝐢𝐧 𝐬𝐮𝐩𝐩𝐨𝐫𝐭—𝐧𝐨 𝐦𝐨𝐫𝐞 𝐜𝐨𝐦𝐩𝐥𝐞𝐱 𝐰𝐨𝐫𝐤𝐚𝐫𝐨𝐮𝐧𝐝𝐬 📊 Write cleaner, SQL-like queries directly in LINQ ⚡ Faster, more readable and maintainable code 🛠 Boosts developer productivity & reduces query confusion 👉 𝐑𝐞𝐚𝐝 𝐭𝐡𝐞 𝐟𝐮𝐥𝐥 𝐚𝐫𝐭𝐢𝐜𝐥𝐞: c-sharpcorner.com/article/le… #DotNet #EntityFramework #EFCore #LINQ #DotNet10 #CSharp #Developers #Coding #Programming #TechNews #CSharpCorner