Skip to content

Upgrading Npgsql 8 to 9

Breaking8.0.9 → 9.0.5Breaking4Security2Deprecated3New21Changed34Fixed59Other44

BreakingUpgrade verdict

4 breaking changes and 2 security fixes.

  • Removes the isFirstAttempt argument from NpgsqlConnector.Open.
  • Improves AsObject/T implementation symmetry and removes the downcast method.
  • Removes some deprecated or unused auth methods and renames enum values.
  • Removes multipass resolution.
Top 5 of 9 that need code or config changes

Target frameworks requirement changed in 9.0.0: .NETStandard2.0, .NETStandard2.1, net6.0, net7.0, net8.0 → net6.0, net8.0.

Drops microsoft.bcl.hashcode, system.collections.immutable, system.threading.channels.

Moves microsoft.extensions.logging.abstractions 8.0.0 → 8.0.2, system.diagnostics.diagnosticsource 8.0.0 → 8.0.1. Your build may pick other versions.

Breaking4
Removes the isFirstAttempt argument from NpgsqlConnector.Open.
NpgsqlConnector.Open
Improves AsObject/T implementation symmetry and removes the downcast method.
AsObjectAsT
Removes some deprecated or unused auth methods and renames enum values.
Removes multipass resolution.
Security2
Fixes SSL certificate validation.
Bumps System.Text.Json to 8.0.5 to address a CVE.
System.Text.Json
Deprecated3
Adds [Experimental] to converter-related APIs.
Obsoletes PgOutputReplicationOptions constructors in a non-breaking way.
PgOutputReplicationOptions
Obsoletes ServerCompatibilityLevel.Redshift.
ServerCompatibilityLevel.Redshift