See the release notes.

The full list of changes is available here.

What's Changed

• STJ 9.0 alternative approach by @NinoFloris in #5941
• Remove support for net6.0 by @roji in #5947
• Some leftover cleanup for removing net6.0 by @roji in #5949
• Map date/time to DateOnly/TimeOnly by default by @roji in #5948
• Make the cidr<->IPNetwork mapping the default by @roji in #5950
• Fix connecting with VerifyCA and VerifyFull by @vonzshik in #5944
• Remove stopwatch allocations by @vonzshik in #5977
• Bump actions/setup-dotnet from 4.1.0 to 4.2.0 by @dependabot[bot] in #5983
• Use exception convenience methods by @bbowyersmyth in #5982
• Bump actions/setup-dotnet from 4.2.0 to 4.3.0 by @dependabot[bot] in #6007
• Add support for postgresql type names with dots by @dvas-hash in #5971
• Send close_notify TLS alert on connection shutdown by @vonzshik in #5995
• Remove DisplayClass struct creation in PgReader by @bbowyersmyth in #6014
• Always dispose RemoteCertificate on SslStream by @vonzshik in #6022
• Remove LongRunningConnection field from NpgsqlConnector by @vonzshik in #6024
• Tighten SCRAM-SHA-256 SASL check by @vonzshik in #6023
• Add SHA3 hash algorithms for SASL authentication by @vonzshik in #6028
• Remove dotnet SDK version from CI (use global.json) by @roji in #6037
• Add support for specifying allowed auth methods by @vonzshik in #6036
• Migrate to SLNX by @roji in #6053
• Switch to Ubuntu 24.04 in CI by @roji in #6054
• Bump actions/setup-dotnet from 4.3.0 to 4.3.1 by @dependabot[bot] in #6059
• Add basic testing for tracing by @vonzshik in #6051
• parameter-collection Clone() should set correct collection instance by @mgravell in #6066
• Fix brew on mac CI by @NinoFloris in #6071
• Fix adding to hash lookup while renaming an unnamed parameter by @vonzshik in #6073
• Update LICENSE date (2024 -> 2025) by @kurnakovv in #6082
• Add tracing for physical connection open by @vonzshik in #6091
• Start testing on .NET 9 by @vonzshik in #5945
• Turn on by @roji in #6097
• Reenable public API analyzer by @roji in #6101
• Update Npgsql to .NET 9 by @vonzshik in #6099
• Ignore system CA store if root certificate is provided by @vonzshik in #6102
• Fix reading columns asynchronously via JsonNet plugin by @vonzshik in #6109
• Fixes #6107 missed should buffer in biginteger numeric converter by @NinoFloris in #6117
• Fix logging parameters with batches by @vonzshik in #6079
• Implement GSSAPI session encryption by @vonzshik in #6131
• feat: add support for PGAPPNAME to set application name by @michael-todorovic in #6139
• Fix returning null from KerberosUsernameProvider.GetUsername with concurrent calls by @vonzshik in #6137
• Add NpgsqlTsVector.Empty by @roji in #6145
• Add assert to NpgsqlCommand.Transaction if it's completed by @vonzshik in #6151
• Compare normalized type names by @0MG-DEN in #6011
• Do CI testing for PG18 (beta) by @roji in #6155
• Fix infinite consume on error with connection break by @vonzshik in #6161
• Bump actions/checkout from 4 to 5 by @dependabot[bot] in #6174
• Fix concurrent NpgsqlDataSource.Dispose and Bootstrap by @vonzshik in #6116
• Set socket options before connecting to postgres by @vonzshik in #6090
• Bump actions/setup-dotnet from 4.3.1 to 5.0.0 by @dependabot[bot] in #6182
• Bump BenchmarkDotNet from 0.13.12 to 0.15.2 by @dependabot[bot] in #6191
• Bump GitHubActionsTestLogger from 2.3.3 to 2.4.1 by @dependabot[bot] in #6192
• Bump Microsoft.Data.SqlClient from 5.2.2 to 6.1.1 by @dependabot[bot] in #6196
• Move to PublicApiAnalyzers v4 by @manandre in #6185
• Move to NUnit v4 by @manandre in #6183
• Bump extension versions to 10.0.0-rc.1 by @roji in #6209
• Fix logical replication tests with PostgreSQL 18 by @vonzshik in #6171
• Update NuGet dependencies by @manandre in #6188
• Fix possible deadlock while asynchronously reading values from reader by @vonzshik in #6202
• Bump BenchmarkDotNet from 0.15.2 to 0.15.3 by @dependabot[bot] in #6215
• Bump BenchmarkDotNet from 0.15.3 to 0.15.4 by @dependabot[bot] in #6221
• Suppress ExecutionContext while creating timers by @vonzshik in #6106
• Rewrite NpgsqlConnectionStringBuilderSourceGenerator as incremental by @manandre in #6186
• Add COPY operations dispose on initialization failure by @vonzshik in #6220
• Bump OpenTelemetry.Api from 1.12.0 to 1.13.0 by @dependabot[bot] in #6229
• Bump Newtonsoft.Json from 13.0.3 to 13.0.4 by @dependabot[bot] in #6228
• Bump Microsoft.NET.Test.Sdk from 17.14.1 to 18.0.0 by @dependabot[bot] in #6227
• Bump Microsoft.CodeAnalysis.CSharp from 4.13.0 to 4.14.0 by @dependabot[bot] in #6226
• Bump Scriban.Signed from 6.2.1 to 6.4.0 by @dependabot[bot] in #6230
• Bump xunit.runner.visualstudio from 3.1.4 to 3.1.5 by @dependabot[bot] in #6231
• Allow specifying TargetSessionAttributes in connection string with NpgsqlDataSourceBuilder by @vonzshik in #6046
• Add support for multiple client certificates by @vonzshik in #6162
• Fix getting wrong schema with CommandBehavior.SchemaOnly and autoprepare by @vonzshik in #6040
• Remove timeout translation from NpgsqlReadBuffer by @vonzshik in #6126
• Add a connection string parameter to control NpgsqlException.BatchCommand by @vonzshik in #6098
• Add implicit cast from .NET IPNetwork to NpgsqlInet by @roji in #6232
• Bump NUnit3TestAdapter from 5.1.0 to 5.2.0 by @dependabot[bot] in #6236
• Bump Microsoft.Data.SqlClient from 6.1.1 to 6.1.2 by @dependabot[bot] in #6242
• Bump github/codeql-action from 3 to 4 by @dependabot[bot] in #6239
• Bump OpenTelemetry.Api from 1.13.0 to 1.13.1 by @dependabot[bot] in #6245
• Fix a few issues with type mappings for schema generator by @vonzshik in #6241
• Bump dependencies to 10.0.0-rc.2 by @roji in #6260
• Fix infinite loop when a connector is closed while concurrently consuming result set by @vonzshik in #6265
• Bump actions/upload-artifact from 4 to 5 by @dependabot[bot] in #6266
• Fix streaming threshold value by @NinoFloris in #6269
• Respect configured schemas in enum field loading by @NinoFloris in #6268
• Bump Scriban.Signed from 6.4.0 to 6.5.0 by @dependabot[bot] in #6273
• Incorrect multi-threading synchronization in UpdateDatabaseState by @ArtemSerostanov in #6114
• Additional GetBytes/GetStream tests by @bbowyersmyth in #5934
• Fix inclusive infinity upper bound interval conversion by @NinoFloris in #6270
• Wrap GetHostAddresses/Async calls to catch SocketException by @pedrowindisch in #5664
• Add Deconstruct() for Npgsql types by @ddas09 in #5695
• Explicitly set histogram bucket bounds (#6167) by @KeterSCP in #6168
• Reduce temporary string creation during types load by @bbowyersmyth in #5986
• Use actual version of the Npgsql for ActivitySource by @KeterSCP in #6277
• Stop testing PostGIS on Windows by @roji in #6275
• Upgrade to postgres 18 for CI by @vonzshik in #6223
• Bump BenchmarkDotNet from 0.15.4 to 0.15.5 by @dependabot[bot] in #6279
• Bump NUnit.Analyzers from 4.10.0 to 4.11.0 by @dependabot[bot] in #6280
• Bump NUnit.Analyzers from 4.11.0 to 4.11.1 by @dependabot[bot] in #6281
• Move json dom mappings to the NativeAOT compatible resolver by @NinoFloris in #6271
• Add SupportsReading plumbing by @NinoFloris in #5472
• Populate CommandText when NpgsqlBatchCommand is created by @brunohoff in #6234
• Remove unsafe from WriteStringChunked by @bbowyersmyth in #5988
• Cube support by @kirkbrauer in #3867
• Bump NUnit.Analyzers from 4.11.1 to 4.11.2 by @dependabot[bot] in #6288
• fixes ConnectionReset on secured connection on Windows by @trivalik in #6287
• Remove task cancellation helpers by @NinoFloris in #6291
• NpgsqlMultiHostDataSource: rethrow OperationCanceledException on canc… by @rus-art in #6283
• Bump BenchmarkDotNet from 0.15.5 to 0.15.6 by @dependabot[bot] in #6293
• Allow specifying multiple root certificates in NpgsqlDataSourceBuilder by @vonzshik in #6057
• Fix returning properties from NpgsqlConnectionStringBuilder.GetProperties by @vonzshik in #6290
• Fix the NpgsqlCube to use the full G17 floating-point format by @kirkbrauer in #6295
• Include .NET 10.0 for the main project and all tests by @NinoFloris in #6300
• Prioritize _dataTypeName over _npgsqlDbType by @NinoFloris in #6299
• Do not parse batch commands with no parameters by @lfpraca in #6298
• Improve output parameter handling by @NinoFloris in #5645
• Check pgTypeId for default resolution call in ObjectConverter by @NinoFloris in #6304
• Move all reloadable state into one reference by @NinoFloris in #6303
• Upgrade from .NET10-RC2 to .NET10-RTM. by @josteink in #6311
• Bump Microsoft.Data.SqlClient from 6.1.2 to 6.1.3 by @dependabot[bot] in #6319
• Bump Microsoft.NET.Test.Sdk from 18.0.0 to 18.0.1 by @dependabot[bot] in #6320
• Bump OpenTelemetry.Api from 1.13.1 to 1.14.0 by @dependabot[bot] in #6321
• Bump Scriban.Signed from 6.5.0 to 6.5.1 by @dependabot[bot] in #6322
• Add experimental to AddTypeInfoResolverFactory by @NinoFloris in #6325
• Add IDbTypeResolver to allow plugins to control how DbTypes are mapped by @PauloHMattos in #6267
• Fix idle/busy conn. pool metrics when using NpgsqlDataSource by @elafarge in #5497
• Add Timeout property to text COPY operations by @vonzshik in #6294
• Fix synchronous GSS session encryption and enable it by default by @vonzshik in #6324
• Move TryTrackDataSource to constructor and enable metrics more accurately by @NinoFloris in #6329
• Define TFM-specific dependencies by @sebastienros in #6326
• Align OTel metrics to latest spec by @roji in #6328
• Bump Microsoft.CodeAnalysis.CSharp from 4.14.0 to 5.0.0 by @dependabot[bot] in #6330
• Fix failing Timeout_during_authentication test by @vonzshik in #6332
• Complete fix for failing Timeout_during_authentication test by @vonzshik in #6334
• Throw ObjectDisposedException on assignment to Disposed NpgsqlCommand by @kevbot18 in #6048
• Override GetColumnSchemaAsync by @NinoFloris in #6337
• Align with the stable OTel tracing specs by @roji in #6338
• Bump actions/checkout from 5 to 6 by @dependabot[bot] in #6344
• Make Include Realm the default by @NinoFloris in #6341
• Revisit macOS ignored tests by @NinoFloris in #6340
• Revisit remaining NonParallelizable and Ignore by @NinoFloris in #6339
• Instrument NpgsqlBinaryImporter with OpenTelemetry by @manandre in #5921
• Add db.npgsql.prepared to tracing by @roji in #6346
• Update devcontainer for .NET 10 by @manandre in #6347

New Contributors

• @dvas-hash made their first contribution in #5971
• @mgravell made their first contribution in #6066
• @kurnakovv made their first contribution in #6082
• @michael-todorovic made their first contribution in #6139
• @0MG-DEN made their first contribution in #6011
• @ArtemSerostanov made their first contribution in #6114
• @pedrowindisch made their first contribution in #5664
• @ddas09 made their first contribution in #5695
• @KeterSCP made their first contribution in #6168
• @brunohoff made their first contribution in #6234
• @kirkbrauer made their first contribution in #3867
• @trivalik made their first contribution in #6287
• @rus-art made their first contribution in #6283
• @lfpraca made their first contribution in #6298
• @josteink made their first contribution in #6311
• @PauloHMattos made their first contribution in #6267
• @elafarge made their first contribution in #5497
• @sebastienros made their first contribution in #6326
• @kevbot18 made their first contribution in #6048

Full Changelog: v9.0.0...v10.0.0