Featured
Explore the differences between AI Agents and Traditional Software, their use cases, key benefits, and why they are shaping the future of intelligent applications.
Artificial Intelligence is no longer a technology reserved for data scientists.
Implement the Repository Pattern with ASP.NET Core Web API on .NET 10 — EF Core 10, DTO mapping with extension methods, async CRUD operations, and the built-in OpenAPI support with Scalar.
AutoMapper usage in ASP.NET Core Web API, its 2025 commercial licensing change, and the modern alternatives — hand-written mapping extension methods and the Mapperly source generator.
Build your first ASP.NET Core Web API on .NET 10 with Entity Framework Core — scaffold models from SQL Server, add an async controller, and test with the built-in OpenAPI document and Scalar.
Provision a complete Azure Linux VM from C# with the modern Azure.ResourceManager SDK — DefaultAzureCredential auth, VNet, public IP, NIC, SSH-key login, and a migration map from the deprecated Fluent
How Azure Resource Manager works and why templates beat scripts — with Bicep as the modern authoring language: parameters, resources, outputs, what-if previews, and deployment commands.
Create an SSH key pair with ssh-keygen, provision an Azure Ubuntu VM that accepts only that key using the Azure CLI, connect, and harden access — with cleanup commands.
Export SQL Server query results to Excel with ClosedXML — no Office installation, no COM Interop, safe on servers and containers, with styling and a Web API download endpoint.
Find your Azure subscription ID and Microsoft Entra tenant ID, register an app for a client ID and secret, assign RBAC roles, and wire all four into DefaultAzureCredential.
Rotate rows into columns with PIVOT, the CASE alternative for multiple aggregates, dynamic pivots with STRING_AGG and sp_executesql, and UNPIVOT (plus CROSS APPLY VALUES) for the reverse.
Configure CORS in ASP.NET Core Web API — default and named policies, origin/method/header restrictions, preflight requests, per-endpoint policies with RequireCors, and EnableCors/DisableCors attribute
EF Core Fluent API configuration in OnModelCreating — tables, columns, keys, indexes, relationships, query filters, value conversions, and when to prefer it over DataAnnotations.
Configure one-to-one, one-to-many, and many-to-many relationships with the EF Core Fluent API — HasOne/WithOne, HasForeignKey, OnDelete behaviors, and EF Core 5+ skip navigations without a join entity
Per-row table expressions: top-N-per-group queries, passing row values into table-valued functions, APPLY (VALUES) for named expressions, and when plain JOIN is all you need.
Shape your SQL Server schema with DataAnnotations — Table, Column, Key, Required, MaxLength, Index, Timestamp, ConcurrencyCheck — and apply it with EF Core migrations, verified against a real database
Scaffold a DbContext and entities from an existing SQL Server database with dotnet ef dbcontext scaffold — what gets generated, re-scaffolding on schema changes, and extending via partial classes.
CTEs from basics to recursion — readable query pipelines, the top-N-per-group idiom with window functions, chained CTEs, writable CTEs for dedup, and walking hierarchies of any depth.
Test ASP.NET Core Web API endpoints with Postman — GET, POST, PUT, and DELETE requests, JSON bodies, the status codes to expect, and practical tips like collections and environment variables.
Functions compute inside queries; procedures do work. The full capability matrix, parameter sniffing notes, and a mechanical decision guide with working examples of each.
