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