Sources

DV DEV Community: #dotnet
RSS

20stories
1 d agolatest
FusionCache 2.9
Two-layer product cache
DVDEV Community: #dotnet nikosst Oct 25

Two-level caching in .NET with FusionCache and Redis

This guide shows how to combine FusionCache's in-process L1 memory with a shared Redis L2 layer in a product catalog API. The author keeps Clean Architecture boundaries intact and focuses on correct cache behavior rather than raw speed numbers. It is a practical starting point for developers who run several instances and need to plan freshness and invalidation.

Agent Framework
Stop when guards fail
DVDEV Community: #dotnet MICHAEL-MAURICE Oct 25

Making .NET AI Agent Guardrails Fail Closed When They Break

The article examines what a .NET AI agent does when its own guardrails fail, such as a throwing guard, a down classifier, a missing caller or miswired middleware. The author deliberately breaks each guard layer and shows how to make the request blocked instead of silently allowed. It ends with a practical checklist for developers building guarded agents.

EF Core 10
Store documents in jsonb
DVDEV Community: #dotnet Mehdi Mohseni Oct 24

PostgreSQL jsonb with EF Core 10: Mapping, Indexing and Querying Document Columns

EF Core 10 with Npgsql 10 maps a .NET complex type to a PostgreSQL jsonb column using ToJson(). The article shows how LINQ property access becomes ->> SQL, which index types serve which queries, and when a jsonb column beats a separate EAV table. It is a practical guide for models with many sparse optional fields.

MySQL vs Nebula
Why graph queries stalled
DVDEV Community: #dotnet Mehdi Mohseni Oct 24

MySQL Recursive CTE vs C# BFS vs NebulaGraph at 500 Million Rows

A team moving a relationship-heavy system from MySQL to graph databases reports that a recursive CTE collapsed at around 500 million rows. The author built a reproducible benchmark comparing the CTE, a C# breadth-first search on the same MySQL tables, and NebulaGraph. The results suggest the CTE's design, not the relational engine, caused most of the delay.

SQL Server
Wrong session setting
DVDEV Community: #dotnet Kausar Raza Oct 23

SQL Server Msg 1934: why QUOTED_IDENTIFIER errors happen and how to fix them

SQL Server error 1934 appears when a statement uses a feature such as a filtered index while the session has QUOTED_IDENTIFIER off. The author explains why the ASP.NET Core application never sees it while the classic sqlcmd does, and how the setting interacts with stored procedures. Useful for anyone who updates ASP.NET Core Identity tables by hand.

SQLite, EF Core 10
Same file back out
DVDEV Community: #dotnet Son Tran Oct 20

Round-tripping SQLite schemas: what a diagram lost and what was fixed

Schemity, a desktop ERD tool, read two real SQLite schemas, Campfire on Rails 8 and Jellyfin on EF Core 10, and rebuilt database files from the SQL it wrote. Before the fixes, declared column types, partial and expression indexes and AUTOINCREMENT settings were lost. The post is a useful case study for anyone who edits or migrates SQLite schemas with a tool.

Feedback

Found a bug or have an idea? Your message lands straight in my inbox.

Type of message