Npgsql Files

See the release notes.

The full list of changes is available here.

What's Changed

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

New Contributors

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

Full Changelog: https://github.com/npgsql/npgsql/compare/v9.0.0...v10.0.0