SQL MCP Server: Microsoft's Answer to the NL2SQL Problem
Microsoft's SQL MCP Server gives AI agents deterministic, RBAC-secured access to SQL Server, PostgreSQL, Cosmos DB, and MySQL without generating a single line of raw SQL. Here is how it works and why it deliberately avoids NL2SQL.
Webhook Patterns in .NET: Sending and Receiving
How to implement webhook sending and receiving in ASP.NET Core, covering signature verification, retry logic, and reliability patterns.
API Rate Limiting in ASP.NET Core
How to implement rate limiting in ASP.NET Core using the built-in rate limiting middleware with fixed window, sliding window, and token bucket algorithms.
ETags and Conditional Requests in .NET APIs
How to implement ETags and conditional requests in ASP.NET Core for efficient caching and safe concurrent updates.
Idempotency in APIs: Making Retries Safe
How to implement idempotent API endpoints in .NET using idempotency keys, preventing duplicate operations from network retries.
HATEOAS in Practice: Hypermedia Links in .NET APIs
A pragmatic approach to implementing HATEOAS in ASP.NET Core APIs, adding discoverable links without over-engineering.
Pagination Patterns: Cursor vs Offset in .NET APIs
A comparison of cursor-based and offset-based pagination in .NET APIs, with implementation examples and guidance on when to use each.
Refit: Typed HTTP Clients for .NET
How to use Refit to generate strongly typed HTTP clients from interface definitions, eliminating boilerplate HttpClient code.
API Documentation with Scalar and OpenAPI in .NET
How to generate interactive API documentation in ASP.NET Core using OpenAPI and Scalar as a modern alternative to Swagger UI.
REST API Design Conventions That Actually Matter
Practical REST API design conventions for .NET APIs covering resource naming, HTTP methods, status codes, and common pitfalls.
Building GraphQL APIs with Hot Chocolate in .NET
A hands-on guide to building a GraphQL API in ASP.NET Core using Hot Chocolate's annotation-based and code-first approaches.
gRPC-Web: Bringing gRPC to the Browser
How to expose gRPC services to browser clients using gRPC-Web middleware in ASP.NET Core.
Getting Started with gRPC in .NET
A practical introduction to building high-performance gRPC services in .NET using Protocol Buffers and the Grpc.AspNetCore package.