30 result(s) in everything

• Blog Types of SQL Server Joins with Examples

  INNER, LEFT, RIGHT, FULL OUTER, CROSS, and self joins explained on one dataset with real results — including the anti-join pattern and the WHERE-vs-ON trap that breaks LEFT JOINs.

• Blog Python for .NET Developers: A Practical First Project

  Coming from C#? Learn Python by building a small REST API with FastAPI — virtual environments demystified, Pydantic as your model binding, and a side-by-side C# to Python cheat sheet.

• Blog Modern .NET Backend Roadmap — Part 8: CI/CD with GitHub Actions

  Automate build, smoke test, image, and deployment with GitHub Actions: SHA-tagged images, OIDC federation to Azure, environments with approvals, and pipeline hygiene.

• Blog AutoMapper in ASP.NET Core Web API — and the Modern Alternatives

  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.

• Blog How to Pivot Data in SQL Server

  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.

• Blog How to Bind a DropDownList in ASP.NET Core MVC

  Bind selects with the select tag helper: model-bound options, enum dropdowns, required validation, and cascading dropdowns using a JSON action and fetch.

• Blog Compare DataTables with LINQ: Except, Intersect and Union

  Diff two data snapshots with LINQ set operators: what was added, removed, changed, and unchanged — including the modern ExceptBy/IntersectBy/UnionBy variants.

• Blog Convert a DataTable to CSV, List or JSON in .NET

  Three DataTable conversions done right in .NET 10: RFC-4180 CSV with quoting, typed List<T> via DataRow.Field, and JSON through records — edge cases verified.

• Blog Using Fluent API in EF Core Code First

  EF Core Fluent API configuration in OnModelCreating — tables, columns, keys, indexes, relationships, query filters, value conversions, and when to prefer it over DataAnnotations.

• Blog User-Defined Functions in SQL Server

  Scalar, inline table-valued, and multi-statement functions with real outputs — why inline TVFs optimize like views, when scalar UDFs go per-row, and why MSTVFs are a last resort.

• Blog AJAX Calls with JsonResult in ASP.NET Core MVC — fetch and jQuery

  Return JSON from ASP.NET Core MVC actions and call them from the browser — the fetch API for modern pages, jQuery $.ajax for legacy ones, POSTing JSON with FromBody, and common pitfalls.

• Blog OUTER APPLY and CROSS APPLY in SQL Server with Examples

  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.

• Blog Create and Connect an Azure Linux VM with an SSH Key Pair

  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.

• Blog WCF Test Client: How to Test WCF Services with WcfTestClient.exe

  Find, launch, and use WCF Test Client: add a service by WSDL, invoke operations with complex parameters, read the SOAP XML, fix the classic quota errors, and know its limits.

• Blog Modern .NET Backend Roadmap — Part 6: Docker

  Package the API as a container: multi-stage Dockerfile, layer-cache-friendly restore, non-root user, and the two real build failures you will hit — verified with a running container.

• Blog Modern .NET Backend Roadmap — Part 3: Dapper for Fast Reads

  Add a Dapper read path beside EF Core: read models behind a port, parameterized SQL, mapping gotchas we actually hit, and when each tool wins.

• Blog SQL Server Common Table Expressions with Examples

  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.

• Blog How to Export SQL Server Data to Excel in C# (Without Office Interop)

  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.

• Blog Entity Framework Core Database-First Tutorial

  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.

• Blog EF Core Code First Migrations with DataAnnotations Attributes

  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

• Blog Run MongoDB in Docker and Connect from .NET

  MongoDB 7 in a container with one command, then typed documents, filters, atomic updates, LINQ, and indexes from the .NET driver — verified end to end.

• Blog Create an Azure VM using C# and Azure.ResourceManager

  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

• Blog Cascading Dropdowns with JsonResult in ASP.NET Core

  Build cascading dropdowns in ASP.NET Core — a JsonResult action per level, the fetch API on the change event, safe option rendering, and a jQuery version for older projects.

• Blog Bulk Upload into SQL Server using SqlBulkCopy and C#

  Load 100,000 rows in under a second with SqlBulkCopy: column mappings, batch sizes, transactions, staging tables, and the constraint fine print — measured for real.

• Blog Angular Nested Components with input() and output()

  Parent–child contracts in modern Angular: required signal inputs, typed outputs, why they beat the decorators, and when to switch from prop drilling to a signal service.

• Blog Access SQL Server from a .NET Console Application

  Connect to SQL Server from a .NET 10 console app with Microsoft.Data.SqlClient: connections, parameterized commands, data readers, transactions, and where Dapper and EF Core fit.

• Blog Implement Repository Pattern with ASP.NET Core Web API

  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.

• Blog How to Implement Dependency Injection in .NET Core

  Learn dependency injection in .NET with the built-in IoC container — register services in Program.cs, inject them through constructors, choose lifetimes, and swap implementations with one line.

• Blog Host an ASP.NET Core Web API in IIS

  Publish and host ASP.NET Core in IIS: the ASP.NET Core Module, Hosting Bundle, app pool settings that matter, and the 500.19/500.30/502.5 troubleshooting table.

• Blog Getting Started with ASP.NET Core Web API and Entity Framework

  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.