Milestone issue

What's Changed

• Translate bytea.Any() as length > 0 by @georg-jung in #3817

Full Changelog: v10.0.1...v10.0.2

See the release notes.

The full list of changes is available here.

What's Changed

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

New Contributors

• @virzak made their first contribution in #3382
• @marcusber made their first contribution in #3465
• @erichiller made their first contribution in #3605
• @kirkbrauer made their first contribution in #3651

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

Milestone issues

Full Changelog: v9.0.3...v9.0.4

Milestone issues

Full Changelog: v9.0.2...v9.0.3

EFCore.PG depends on Npgsql 9.0.2, which contains an important fix around SSL validation (npgsql/npgsql#5942).

Milestone issues

Full Changelog: v9.0.1...v9.0.2

See the release notes.

The full list of changes is available here.

What's Changed

• Fix operator precedence of AT TIME ZONE by @roji in #2987
• Add method postfix when rewriting parameters for StartsWith/EndsWith/Contains by @roji in #2995
• Bring back enumerable Concat/Append translations for ExecuteUpdate by @roji in #3005
• Bump actions/setup-dotnet from 3 to 4 by @dependabot in #3006
• Fix containment inference of multirange mapping from non-range item by @roji in #3013
• Bump actions/upload-artifact from 3 to 4 by @dependabot in #3022
• Bump github/codeql-action from 2 to 3 by @dependabot in #3019
• Cast NodaTime DateInterval.End to date. by @roji in #3024
• Fix index creation when both collation and operators are specified by @roji in #3028
• Fix PgTableValuedFunctionExpression cloning by @roji in #3026
• Make Npgsql-specific JsonValueReaderWriters public for compiled model by @roji in #3029
• Support NpgsqlUIntTypeMapping for the compiled model by @roji in #3030
• Translate DateTime.Date without type mapping in legacy mode by @roji in #3032
• Fix null semantics for ILikeExpression by @roji in #3039
• Remove incorrect variable declaration in NpgsqlArrayConverter by @roji in #3047
• Fix bad array access when an AFTER trigger raises an exception in SaveChanges by @roji in #3049
• Automatic conversion to primary constructors by @roji in #3048
• Automatic usage of collection initializers by @roji in #3051
• Always add parentheses around PgUnknownBinaryExpression by @roji in #3073
• Sync to EF 9.0.0-preview.1.24081.2 by @roji in #3089
• Prune PgTableValuedFunctionExpression's projection by @roji in #3090
• Downgrade xunit back to 2.6.1 by @roji in #3094
• Don't use NpgsqlDataSource from DI if connection string/connection is specified by @roji in #3102
• Remove unneeded backslash ESCAPE from LIKE translations by @roji in #3103
• Add translation of string.Join overload used with List parameter, fix #3105 by @georg-jung in #3106
• Sync to EF 9.0.0-preview.2.24128.4 by @roji in #3125
• Add Translation for to_date and to_timestamp as DBFunctions extensions by @WhatzGames in #2936
• Make INpgsqlRelationalConnection.CloneWith return INpgsqlRelationalConnection by @roji in #3144
• ToDate/ToTimestamp non-nullable by @WhatzGames in #3146
• Stop eagerly throwing when setting value generation strategy by @roji in #3147
• Small primitive collection cleanup by @roji in #3149
• Sync to 9.0.0-preview.3.24172.4 by @roji in #3153
• Use Npgsql 8.0.3 by @roji in #3166
• Remove direct dependency on EFCore.Abstractions by @roji in #3171
• Major work around DbDataSource management, enum handling and plugins by @roji in #3167
• Add missing check for predicate in primitive collection simplifications by @roji in #3196
• Add ordering by ordinality column for primitive collections by @roji in #3209
• Correct non-NodaTime date/time type mappings when NodaTime is configured by @roji in #3214
• Add UUID version 7 as the default guid generator by @ChrisJollyAU in #3249
• Rename NpgsqlUuid7ValueGenerator to NpgsqlSequentialGuidValueGenerator and make it public by @roji in #3255
• Sync to EF Core 9.0.0-preview.7.24405.3 by @roji in #3258
• Sync to EF Core 9.0.0-rc.1.24451.1 by @roji in #3260
• Run CI tests on PG17 (beta) by @roji in #3256
• Various code style/cleanup by @roji in #3261
• Don't use same table in join when it is also primary target table by @ChrisJollyAU in #3263
• Sync to EF Core 9.0.0-rc.2.24460.3 by @roji in #3275
• Negated syntax for regex and ILIKE by @roji in #3276
• Add ConfigureDataSource() to NpgsqlDbContextOptionsBuilder by @roji in #3277
• Support arbitrary enumerables in NpgsqlArrayConverter by @roji in #3290
• Redo NpgsqlSetOperationTypingInjector by @roji in #3291
• Implement Precompiled Query Tests by @ChrisJollyAU in #3289
• Catch exception instead of trying to check if the history repository exists by @roji in #3294
• Properly escape constant regex patterns by @roji in #3299
• Handle another error code when concurrently creating the migrations history table by @roji in #3301
• Prefix JSON geometry representation with SRID by @roji in #3307
• Bump dependencies by @roji in #3316
• Configure CI for released PG17 by @roji in #3300
• Translate array.Where(i => i != x) to array_remove by @roji in #3328
• Remove enum/extension conventions when creating migrations history table by @roji in #3329
• Use Npgsql 9.0.0-preview.1-ci.20241025T100626 by @roji in #3330
• Use Npgsql's new CloneWithAsync by @roji in #3332
• Translations around DateOnly.DayNumber by @roji in #3333
• Support mapping jsonpath by @roji in #3334
• Call NpgsqlDataSource.Clear when doing EnsureDeleted by @roji in #3337
• Fix JsonValueReaderWriter check to support polymorphism by @roji in #3339
• Fix scalar casting from string for POCO/DOM JSON mode by @roji in #3340
• Fix arrays over user-defined ranges by @roji in #3342
• Don't open connection if already open when reloading types by @roji in #3343
• Invoke connection interceptor before tweaking connection string in Exists() by @roji in #3349
• Remove old obsoleted APIs by @roji in #3350
• Add tstzrange to NpgsqlRange by @roji in #3351
• Fix error around mapping Nullable by @roji in #3353
• Use .NET/EF 9.0 GA by @roji in #3361
• Detect and throw for NpgsqlTypeMappings as element type mappings by @roji in #3367
• Allow MapEnum() without an enum name by @roji in #3368

New Contributors

• @georg-jung made their first contribution in #3106
• @WhatzGames made their first contribution in #2936
• @ChrisJollyAU made their first contribution in #3249

Full Changelog: v8.0.0...v9.0.0

The full list of changes is available here.

Full Changelog: v8.0.10...v8.0.11