Explains the new named global query filters feature in Entity Framework Core 10, enabling multiple, selectively disableable filters.
Explores new features in EF Core 10.0 for managing multiple named global query filters and selectively ignoring them.
Explains the three table inheritance patterns (TPH, TPT, TPC) now available in EF Core 7 for mapping object-oriented class hierarchies to relational databases.
A guide on integrating Asyncpg with FastAPI and Air for direct PostgreSQL database access, bypassing heavier ORMs like SQLAlchemy.
Announcing Data API Client v2, a TypeScript rewrite for AWS Aurora Serverless Data API with ORM support and pg/mysql2 compatibility.
EF Core 10.0 adds support for the new JSON data type in Microsoft SQL Server 2025, enabling querying and storage of JSON documents.
EF Core 10.0 introduces a new ComplexProperty() method for mapping complex types, providing an alternative to the older Owned Entities approach.
A guide to setting up asynchronous PostgreSQL operations with SQLModel and FastAPI, including code examples for async engines and sessions.
Explains how to bypass Entity Framework's SqlRaw requirement to return all entity properties by explicitly selecting NULL for missing columns.
Introduces fastmigrate, a simple Python tool for managing SQLite database migrations without requiring a specific ORM.
Explores the concept of 'Design Pressure' in software architecture, examining invisible forces that shape code and discussing coupling, types, and ORMs.
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.
Explains a performance issue with ToListAsync/ToArrayAsync in EF Core when querying large data columns and recommends using synchronous versions.
A guide on managing Entity Framework Core migrations during development within .NET Aspire distributed applications.
Discusses the pros and cons of soft deleting database records, including implementation, performance, and alternatives.
A developer shares the design process and challenges of implementing improved lazy loading in their custom ORM, focusing on static analysis and reducing configuration.
The article argues that most programming tasks, from ORMs to routing, fundamentally involve text processing and data mapping.
Introduction to Jakarta Data specification and its stateless repositories for Java developers, using Hibernate as an implementation.
Explains how Entity Framework protects against SQL injection in LINQ queries but warns of risks when using raw SQL, highlighting safer alternatives.
