Npgsql Entity Framework Core PostgreSQL Files

See the release notes.

The full list of changes is available here.

What's Changed

• Depend on Npgsql 9.0.1 by @roji in https://github.com/npgsql/efcore.pg/pull/3376
• Restore virtual modifier by @virzak in https://github.com/npgsql/efcore.pg/pull/3382
• Add NullIf Translation for Ternary expressions by @WhatzGames in https://github.com/npgsql/efcore.pg/pull/3403
• Regex replace and count by @WhatzGames in https://github.com/npgsql/efcore.pg/pull/3062
• Depend on EF 10.0.0-alpha.1.24610.3 by @roji in https://github.com/npgsql/efcore.pg/pull/3409
• Sync to EF 10.0.0-alpha.1.24620.1 by @roji in https://github.com/npgsql/efcore.pg/pull/3416
• Reorganize translation tests by @roji in https://github.com/npgsql/efcore.pg/pull/3417
• Annotate functional tests for nullability by @roji in https://github.com/npgsql/efcore.pg/pull/3418
• Align test namespaces with the EF standard by @roji in https://github.com/npgsql/efcore.pg/pull/3419
• Redo enum label addition by @roji in https://github.com/npgsql/efcore.pg/pull/3425
• Add some tests around date/time mappings by @roji in https://github.com/npgsql/efcore.pg/pull/3432
• Fix quoted enum handling by @roji in https://github.com/npgsql/efcore.pg/pull/3434
• Sync to EF 10.0.0-alpha.1.24620.1 by @roji in https://github.com/npgsql/efcore.pg/pull/3435
• Sync to 10.0.0-alpha.1.25074.3 by @roji in https://github.com/npgsql/efcore.pg/pull/3442
• Fix calling base method in NpgsqlMigrationsSqlGenerator by @roji in https://github.com/npgsql/efcore.pg/pull/3443
• Depend on EF 10.0.0-alpha.1.25068.1 by @roji in https://github.com/npgsql/efcore.pg/pull/3453
• Sync to EF 10.0.0-preview.2.25103.6 by @roji in https://github.com/npgsql/efcore.pg/pull/3454
• Generate UUIDv7 values for value-generated strings by @roji in https://github.com/npgsql/efcore.pg/pull/3462
• Always close connection after reloading types in migration. by @marcusber in https://github.com/npgsql/efcore.pg/pull/3465
• Sync to EF 10.0.0-preview.2.25103.6 by @roji in https://github.com/npgsql/efcore.pg/pull/3471
• Fix nullability for IndexOf (array_position) by @roji in https://github.com/npgsql/efcore.pg/pull/3477
• Preserve ConfigureDataSource() callback when applying other context options by @roji in https://github.com/npgsql/efcore.pg/pull/3482
• Remove dotnet SDK version from CI (use global.json) by @roji in https://github.com/npgsql/efcore.pg/pull/3486
• Stop include data source connection string in service provider hashcode by @roji in https://github.com/npgsql/efcore.pg/pull/3501
• Migrate to SLNX by @roji in https://github.com/npgsql/efcore.pg/pull/3502
• Switch to Ubuntu 24.04 in CI by @roji in https://github.com/npgsql/efcore.pg/pull/3503
• Sync to EF 10.0.0-preview.3 by @roji in https://github.com/npgsql/efcore.pg/pull/3520
• Parse float/double/decimal in scaffolding by @roji in https://github.com/npgsql/efcore.pg/pull/3541
• Additional fixes to scaffolding by @roji in https://github.com/npgsql/efcore.pg/pull/3543
• Sync to EF preview.4 by @roji in https://github.com/npgsql/efcore.pg/pull/3548
• Sync to EF preview.5 by @roji in https://github.com/npgsql/efcore.pg/pull/3549
• Make NpgsqlArrayConverter not throw for struct arrays by @roji in https://github.com/npgsql/efcore.pg/pull/3552
• Sync to EF 10.0.0-preview.6.25314.101 by @roji in https://github.com/npgsql/efcore.pg/pull/3553
• Sync to EF 10.0.0-preview.6.25321.102 by @roji in https://github.com/npgsql/efcore.pg/pull/3556
• Reload types should close the newly opened connection. by @marcusber in https://github.com/npgsql/efcore.pg/pull/3561
• Sync to EF 10.0.0-preview.7.25352.2 by @roji in https://github.com/npgsql/efcore.pg/pull/3558
• Do CI testing for PG18 (beta) by @roji in https://github.com/npgsql/efcore.pg/pull/3569
• Fix PG18 (beta) CI config by @roji in https://github.com/npgsql/efcore.pg/pull/3570
• Translate Guid.CreateVersion7 by @roji in https://github.com/npgsql/efcore.pg/pull/3571
• Support PG18 virtual generated columns by @roji in https://github.com/npgsql/efcore.pg/pull/3572
• Switch to using Guid.CreateVersion7 in NpgsqlSequentialGuidValueGenerator by @roji in https://github.com/npgsql/efcore.pg/pull/3575
• Add translations for NodaTime LocalDate.{At,AtMidnight} by @roji in https://github.com/npgsql/efcore.pg/pull/3577
• Bump actions/checkout from 4 to 5 by @dependabot[bot] in https://github.com/npgsql/efcore.pg/pull/3594
• Sync to EF 10.0.0-preview.7 by @roji in https://github.com/npgsql/efcore.pg/pull/3597
• Sync to EF 10.0.0-rc.1.25416.111 by @roji in https://github.com/npgsql/efcore.pg/pull/3598
• Update NpgsqlDbContextOptionsBuilder.cs by @erichiller in https://github.com/npgsql/efcore.pg/pull/3605
• Sync to EF 10.0.0-rc.2.25431.101 by @roji in https://github.com/npgsql/efcore.pg/pull/3607
• Vary array containment translation based on indexes by @roji in https://github.com/npgsql/efcore.pg/pull/3611
• Bump actions/setup-dotnet from 4 to 5 by @dependabot[bot] in https://github.com/npgsql/efcore.pg/pull/3612
• Sync to EF 10.0.0-rc.2.25468.104, partial update, JSON primitive collections revamp by @roji in https://github.com/npgsql/efcore.pg/pull/3623
• Simplify SQL when copying JSON scalar properties across documents by @roji in https://github.com/npgsql/efcore.pg/pull/3627
• Fix NpgsqlArrayConverter for one-directional conversions by @roji in https://github.com/npgsql/efcore.pg/pull/3629
• Sync to EF 10.0.0-rc.2.25502.106 by @roji in https://github.com/npgsql/efcore.pg/pull/3630
• Map IPNetwork <-> cidr by @roji in https://github.com/npgsql/efcore.pg/pull/3331
• Bump github/codeql-action from 3 to 4 by @dependabot[bot] in https://github.com/npgsql/efcore.pg/pull/3632
• Bump EF version to 10.0.0-rc.2.25502.107 by @roji in https://github.com/npgsql/efcore.pg/pull/3640
• Ensure key name uniqueness by @roji in https://github.com/npgsql/efcore.pg/pull/3641
• Fix store type name base for JSON-nested scalar collections by @roji in https://github.com/npgsql/efcore.pg/pull/3644
• Bump actions/upload-artifact from 4 to 5 by @dependabot[bot] in https://github.com/npgsql/efcore.pg/pull/3645
• Rewrite NpgsqlDatabaseCreator.Exists() to do SELECT 1 by @roji in https://github.com/npgsql/efcore.pg/pull/3648
• Stop testing PostGIS on Windows in CI (#6275) by @roji in https://github.com/npgsql/efcore.pg/pull/3649
• Stop testing on all Windows versions, simplify CI by @roji in https://github.com/npgsql/efcore.pg/pull/3650
• Cube support (revamped) by @kirkbrauer in https://github.com/npgsql/efcore.pg/pull/3651
• Bump dependencies to EF 10.0.0 by @roji in https://github.com/npgsql/efcore.pg/pull/3659
• Allow mapping multidim arrays to json/jsonb again by @roji in https://github.com/npgsql/efcore.pg/pull/3663
• Automatically install cube extension when the model has a cube property by @roji in https://github.com/npgsql/efcore.pg/pull/3664
• Bump actions/checkout from 5 to 6 by @dependabot[bot] in https://github.com/npgsql/efcore.pg/pull/3669

New Contributors

• @virzak made their first contribution in https://github.com/npgsql/efcore.pg/pull/3382
• @marcusber made their first contribution in https://github.com/npgsql/efcore.pg/pull/3465
• @erichiller made their first contribution in https://github.com/npgsql/efcore.pg/pull/3605
• @kirkbrauer made their first contribution in https://github.com/npgsql/efcore.pg/pull/3651

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