AI & MLIntermediate
Embeddings and Vector Databases in .NET: A Practical Guide
Learn how embeddings and vector databases work in .NET: similarity metrics, HNSW indexes, Microsoft.Extensions.VectorData and pgvector, SQL Server and Qdrant.
Databases & SQL
20 articles about Databases & SQL: in-depth .NET and AI guides, senior interview questions and AI news on DotNet AI Hub.
Technologies 9
ArchitectureAdvanced
Event Sourcing in .NET: Concepts and Implementation
Event sourcing in .NET explained: event stores, streams, projections, snapshots, upcasting, idempotency, Marten, KurrentDB and GDPR crypto-shredding.
Data & EF CoreIntermediate
Dapper and ADO.NET: High-Performance Data Access in .NET
Learn when to go below EF Core with ADO.NET and Dapper: readers, pooling, multi-mapping, safe parameters, transactions, Dapper.AOT and SqlBulkCopy.
Data & EF CoreAdvanced
Database Migrations and Zero-Downtime Schema Changes in .NET
Ship schema changes safely in .NET: EF Core migrations, bundles, idempotent scripts, CI/CD rollout, expand-contract, backfills, DbUp and FluentMigrator.
Data & EF CoreBeginner
Entity Framework Core: The Complete Guide for .NET Developers
Learn Entity Framework Core end to end: DbContext, modeling, relationships, migrations, querying, change tracking, complex types, JSON columns and EF Core 10.
Data & EF CoreAdvanced
EF Core Performance Tuning: Proven Techniques and Checklist
Speed up EF Core with proven techniques: no-tracking queries, projections, split queries, pooling, compiled queries, bulk updates, indexes and SQL logging.
Data & EF CoreIntermediate
NoSQL in .NET: A Practical Guide to Azure Cosmos DB and MongoDB
NoSQL in .NET with Azure Cosmos DB and MongoDB: document modeling, partition keys, consistency, request units, SDK patterns and EF Core providers.
Data & EF CoreIntermediate
PostgreSQL with .NET: Npgsql, EF Core and pgvector
A practical guide to PostgreSQL in .NET: Npgsql pooling and multiplexing, EF Core JSONB, arrays, full-text search, COPY imports and pgvector search.
Data & EF CoreIntermediate
SQL Server for .NET Developers: Indexes, Query Plans and Transactions
SQL Server for .NET developers: design indexes, read execution plans, fix parameter sniffing, choose isolation levels, handle deadlocks and use SQL Server 2025.
Interview Questions 11
Data & EF CoreSenior
ADO.NET and Dapper Interview Questions
Senior .NET interview questions on ADO.NET and Dapper covering connection pooling, DataReader streaming, SqlBulkCopy, multi-mapping and SQL injection.
Data & EF CoreSenior
EF Core Internals Interview Questions
Senior-level EF Core internals interview questions on change tracking, identity resolution, query translation, compiled models and interceptors.
Data & EF CoreSenior
EF Core Performance Interview Questions
Senior EF Core performance interview questions on N+1 queries, split queries, tracking, bulk updates, compiled queries and DbContext pooling.
Data & EF CoreArchitect
NoSQL and Polyglot Persistence Interview Questions
Architect-level interview questions on choosing data stores, Cosmos DB partition keys, RU costs, consistency levels and polyglot persistence trade-offs.
Data & EF CoreArchitect
SQL Query Optimization Interview Questions for .NET Architects
Architect-level SQL Server interview questions on indexing, execution plans, parameter sniffing, statistics, Query Store, partitioning and sharding.
Data & EF CoreSenior
Transactions, Isolation Levels and Concurrency Control Interview Questions
Senior interview questions on ACID, isolation levels, RCSI and snapshot isolation, optimistic concurrency, distributed transactions and deadlocks.
Data & EF CoreLead
Zero-Downtime Database Migration Interview Questions
Lead-level interview questions on zero-downtime database migrations, expand-contract, online indexes, safe backfills and running EF Core in pipelines.
Distributed SystemsArchitect
CAP, Consistency Models and Idempotency Interview Questions
Architect-level interview questions on CAP, PACELC, eventual consistency, read-your-writes, idempotency keys, clock ordering and conflict resolution in .NET.
System DesignArchitect
System Design Interview: E-Commerce Order Management in .NET
Senior .NET system design interview questions on e-commerce systems covering cart, inventory reservation, order sagas, catalog search and flash sales.
System DesignArchitect
System Design Interview: Payment Processing System in .NET
Senior .NET system design interview questions on payment systems: idempotency, double-entry ledgers, PSP integration, webhooks, sagas and PCI DSS scope.
System DesignArchitect
System Design Interview: URL Shortener in .NET
Senior .NET system design interview questions on building a URL shortener: ID generation, storage, caching, redirects, analytics and abuse controls.