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.
3 articles · ← All articles
- 10 min
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.
- 8 min
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.
- 7 min
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.