BlogDatabases

Databases articles

How .NET applications talk to SQL Server and PostgreSQL, measured rather than assumed. These posts compare bulk insert strategies, look at how EF Core translates queries, and benchmark PostgreSQL jsonb indexes.

  1. JSONB in PostgreSQL: querying, indexing, and EF Core mapping

    Use jsonb, not json, for flexible PostgreSQL columns. EF Core 10 maps it with ToJson(); GIN indexes serve containment, expression indexes serve one key.

    10 min
  2. Dapper Plus or SqlBulkCopy? Pros, cons, and hidden limitations for high-performance .NET data ingestion

    SqlBulkCopy is the fastest free bulk insert for SQL Server. Dapper Plus costs a license but adds upserts, identity mapping, and cross-database support.

    8 min
  3. Where vs. WhereBulkContains: What's the real difference in EF Core?

    Since EF Core 8, Contains on SQL Server usually sends the list as one JSON parameter. WhereBulkContains joins a temp table instead, for large or composite keys.

    7 min