A daily tech link roundup covering VS Code updates, WebAssembly, .NET 10, AI development, Python guides, DevOps tools, and industry news.
Analyzes performance differences between ToListAsync and ToArrayAsync in Entity Framework, concluding ToListAsync is faster.
How to implement sortable UUID v7 GUIDs as primary keys in Entity Framework using a custom value generator.
C# 14 introduces breaking changes to LINQ queries. This article explains the issues with Reverse and Contains and provides workarounds.
Explains how ToDictionaryAsync in Entity Framework Core retrieves entire database objects, impacting performance, and provides a solution using Select.
A developer shares techniques to improve database performance for large BLOB data retrieval in C#/.NET, including compression and chunking requests.
Explains how to bypass Entity Framework's SqlRaw requirement to return all entity properties by explicitly selecting NULL for missing columns.
Explains how to disable thread safety checks in Entity Framework for performance, with warnings about risks and proper usage.
An update on the performance fix for ToListAsync in Entity Framework Core, addressing slow queries and high allocations when fetching large data.
Critiques a misleading LinkedIn performance tip about Entity Framework, explaining why dragging entire databases into memory is inefficient and offering the correct solution.
A guide to implementing lazy loading for navigation properties in EF Core using the Proxies package, with a focus on MongoDB integration.
A developer shares a complex solution for dynamic column selection in Entity Framework using expressions, highlighting a self-admitted overengineered approach.
A proposal to add a dedicated LeftJoin operator to LINQ in .NET 10, simplifying a common database query pattern.
Performance comparison between ToArrayAsync and ToListAsync methods in Entity Framework 8, using benchmarks to analyze memory and speed.
Explains how to create a custom SQL expression in Entity Framework to query data using strongly-typed ID value types, solving translation issues.
A developer explains a compiler error when performing LINQ joins on multiple columns in Entity Framework and provides the solution requiring matching anonymous type property names.
Discusses the pros and cons of soft deleting database records, including implementation, performance, and alternatives.
Explains how Entity Framework protects against SQL injection in LINQ queries but warns of risks when using raw SQL, highlighting safer alternatives.
Explains how to store complex objects and lists as JSON in databases using Entity Framework 8 and 7, including configuration and benefits.
A guide to using the EntityFramework.Exceptions library to handle specific database errors like constraint violations in Entity Framework.
