
Code Whisper
@codewhisperdev
👾 Anonymous engineer, sharing thoughts on code, tech & systems. 🚫 No face, just logic.
.NET 9 introduces the new LINQ method CountBy. It allows for calculating the frequency of a key. This improvement looks nice. What do you think?

LINQ Tip: Use ToList() after filtering, not before. Why? 🔹 First version loads everything into memory before filtering 🔹 Second version filters at source, better for DB or large collections 🔹 Especially important when using EF Core or APIs with IQueryable #charp #dotnet

🔹 What is Queue<T>? Queue<T> is a First-In-First-Out (FIFO) collection in C#. It means the first item you add is the first one to be removed. When to use? - Task scheduling - Print jobs - Message handling - Breadth-first search (BFS) in graphs Example:

SQL Tip: Always monitor and maintain your indexes. Unused or duplicate indexes = slower writes and wasted space. Why? - Clean indexes = faster inserts/updates - Less I/O, better performance 🔍 Use this to find unused indexes in SQL Server

United States Trends
- 1. No Kings 425K posts
- 2. Good Saturday 27.4K posts
- 3. Garnacho 15.1K posts
- 4. Neto 24.3K posts
- 5. #Caturday 3,068 posts
- 6. #SaturdayVibes 3,800 posts
- 7. Chalobah 4,635 posts
- 8. Acheampong 8,022 posts
- 9. #NFOCHE 19.8K posts
- 10. Forest 84.6K posts
- 11. Ange 19.4K posts
- 12. Dork Cult Protest Day 1,398 posts
- 13. Guiu 5,878 posts
- 14. Joao Pedro 8,628 posts
- 15. Lavia 7,039 posts
- 16. Estevao 10.8K posts
- 17. Massie 39.4K posts
- 18. Emiru 12.5K posts
- 19. Ohtani 244K posts
- 20. Maresca 16.7K posts
Something went wrong.
Something went wrong.