SQL

Relational database fundamentals, SQL Server patterns, schema management, and platform-specific guides.

Pages

  • ACID — ACID properties: Atomicity, Consistency, Isolation, and Durability
  • Indexes — index types, unique constraints, and GetIndices.sql reference
  • Connection Pool — connection pooling: pool management, reuse, and lifetime
  • DAO vs Repository — DAO (Data Access Object) vs Repository pattern comparison
  • DbCommand — IDbCommand hierarchy and command execution patterns
  • Foreign Key Mapping — SQL Server foreign key queries and multi-column relationship patterns
  • Primary Keys — primary key queries via INFORMATION_SCHEMA
  • Referential Integrity — referential integrity enforcement with indices and primary keys
  • Service Broker — SQL Server Service Broker for asynchronous messaging within the database
  • String Search Stored Proc — stored procedure for searching text across database objects
  • Table Schema — sysobjects vs sys.objects and schema introspection queries
  • Temporary Tables — temporary table types, scope, and performance advantages
  • Views — SQL views: parameterized defaults and view-based query patterns
  • Samples — Microsoft sample databases: Northwind and pubs for SQL Server 2000
  • MySQL — MySQL setup, configuration, and .NET integration
  • PostgreSQL — PostgreSQL with Npgsql and Npgsql.EntityFrameworkCore.PostgreSQL
  • SQL LocalDB — SQL Server Express LocalDB instances, firewall configuration, and Azure Storage Emulator

Scripts

The scripts/ folder contains sample SQL installation scripts:

  • instnwnd.sql — Northwind sample database installation script
  • instpubs.sql — pubs sample database installation script

Distributed Transactions

Port Windows/MSDTC distributed transactions support 1
TransactionScope distributed transactions exception 2
Implement distributed/promoted transactions in System.Transactions 3
Distributed Transactions: .NET Framework vs .NET Core 4

< «

Table of contents