Just discovered a super handy way to add more context to your #EFCore query logs using Query Tags. If you’ve ever struggled debugging #LINQ and #SQL queries, this is such a useful technique. It adds comments to the generated SQL, making it WAY easier to track down issues.
I wish I had known this sooner—it’s simple but incredibly effective! If you work with EF Core, definitely check it out
https://qr.pageinit.net/eftags
#dotnet #debugging #softwaredevelopment
I wish I had known this sooner—it’s simple but incredibly effective! If you work with EF Core, definitely check it out
https://qr.pageinit.net/eftags
#dotnet #debugging #softwaredevelopment
Blogspot
Supercharge your EF Core debugging with Query Tags
Debugging database queries in Entity Framework Core can sometimes feel like searching for a needle in a haystack. When your application gene...
Running a DELETE statement in production? I recently tackled some pesky duplicate data and found a safe way to do it with a Common Table Expression, letting you preview what will be removed. Check out my breakdown on fixing it (and preventing it!) here: https://qr.pageinit.net/5 #sql #techtips
SelAromDotNet
Cleaning Up Bad SQL Data: Find and Delete Duplicate Records The Right Way
Find duplicate data in a production SQL table? Follow this pragmatic, real-world guide to safely find and delete those duplicate rows using a Common Table Expression (CTE), and learn how to prevent it from ever happening again with a unique constraint.