Skip to content

v11.0.0

Latest

Choose a tag to compare

@roji roji released this 20 Nov 15:43
· 1 commit to main since this release
fd3674f

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
  • Change migration SQL to include CASCADE for CREATE EXTENSION by @mguinness in #3684
  • Bump actions/upload-artifact from 5 to 6 by @dependabot[bot] in #3688
  • Allow null connection string with ConfigureDataSource by @roji in #3693
  • Add empty permissions block in Github Actions configs by @roji in #3694
  • Implement support for PG18 WITHOUT OVERLAPS by @roji in #3709
  • Implement support for PG18 PERIOD by @roji in #3711
  • Implement IntersectsBbox to translate PostGIS && operator by @bjornharrtell in #3484
  • Fix bug where annotations added by initial migration are not removed when migration is reverted. by @brianpursley in #3714
  • Fix a bug where the result of a function that returns an array is not able to be accessed by array index. by @brianpursley in #3720
  • Refactor method/member translators to stop using reflection lookup by @roji in #3721
  • Sync to EF 11.0.0-preview.1 by @roji in #3722
  • [EF Sync] Sync to EF 11.0.0-preview.2.26116.101 by @github-actions[bot] in #3732
  • Bump github/gh-aw from 0.44.0 to 0.45.4 by @dependabot[bot] in #3734
  • Bump github/gh-aw from 0.45.4 to 0.46.0 by @dependabot[bot] in #3737
  • [EF Sync] Sync to EF 11.0.0-preview.2.26117.101 by @github-actions[bot] in #3736
  • Fix mapping of enums with duplicate labels by @roji in #3743
  • Bump github/gh-aw from 0.46.0 to 0.47.2 by @dependabot[bot] in #3744
  • Additional work on temporal constraints by @roji in #3746
  • Fix arrays over JsonDocument/JsonElement by @roji in #3747
  • [EF Sync] Sync to EF 11.0.0-preview.2.26122.107 by @github-actions[bot] in #3750
  • Add default testcontainer support in the tests by @roji in #3753
  • Bump github/gh-aw from 0.47.2 to 0.50.6 by @dependabot[bot] in #3756
  • Add copilot instructions by @roji in #3761
  • Bump github/gh-aw from 0.50.6 to 0.53.0 by @dependabot[bot] in #3763
  • Switch to nuget OIDC publishing by @roji in #3764
  • Bump actions/upload-artifact from 6.0.0 to 7.0.0 by @dependabot[bot] in #3757
  • [EF Sync] Sync to EF 11.0.0-preview.2.26154.117 by @github-actions[bot] in #3765
  • Sync to EF 11.0.0-preview.3.26155.101 by @roji in #3769
  • Implement EF.Function.JsonPathExists by @roji in #3770
  • Bump github/gh-aw from 0.53.3 to 0.56.2 by @dependabot[bot] in #3772
  • Bump github/gh-aw from 0.56.2 to 0.57.0 by @dependabot[bot] in #3774
  • [EF Sync] Sync to EF 11.0.0-preview.3.26160.112 by @github-actions[bot] in #3776
  • Bump actions/download-artifact from 8.0.0 to 8.0.1 by @dependabot[bot] in #3779
  • Tweak dependabot config by @roji in #3781
  • Bump github/gh-aw from 0.57.0 to 0.58.0 by @dependabot[bot] in #3782
  • Bump github/gh-aw from 0.58.0 to 0.59.0 by @dependabot[bot] in #3786
  • Sync to EF 11.0.0-preview.3.26167.112 by @roji in #3789
  • Fix alias cloning for json recordset table-valued functions by @7645re in #3773
  • Bump github/gh-aw from 0.59.0 to 0.63.0 by @dependabot[bot] in #3792
  • Sync to EF 11.0.0-preview.3.26174.112 by @roji in #3793
  • Bump default PostgreSQL version to 16 by @roji in #3797
  • Add retrying execution strategy in tests by @roji in #3799
  • Fix NpgsqlOptionsExtension losing ParameterizedCollectionMode between clones by @roji with @Copilot in #3796
  • Filter out extension-related operations in creation scripts of history table by @dkottis in #3713
  • Sync to EF 11.0.0-preview.3.26203.107 by @roji in #3802
  • Sync to EF 11.0.0-preview.4.26203.108 by @roji in #3803
  • Sync to EF 11.0.0-preview.4.26210.110 by @roji in #3809
  • Bump actions/upload-artifact from 7.0.0 to 7.0.1 by @dependabot[bot] in #3811
  • Sync to EF 11.0.0-preview.4.26215.121 by @roji in #3814
  • Sync to EF 11.0.0-preview.4.26224.122 by @roji in #3822
  • Sync to EF 11.0.0-preview.5.26227.124 by @roji in #3823
  • Fix nullability of IncludeProperties includeExpression parameter by @roji in #3826
  • Sync to EF 11.0.0-preview.5.26251.112 by @roji in #3827
  • Fix ST_Extent box2d cast being removed by EF simplifier by @roji in #3828
  • Sync to EF 11.0.0-preview.5.26261.101 by @roji in #3833
  • Fix Windows test connection cleanup flakiness by @roji in #3837
  • Sync to EF 11.0.0-preview.5.26267.102 by @roji in #3838
  • Sync to EF 11.0.0-preview.5.26275.101 by @roji in #3844
  • Bump GitHubActionsTestLogger from 2.4.1 to 3.0.4 by @dependabot[bot] in #3847
  • Bump Microsoft.SourceLink.GitHub from 8.0.0 to 10.0.300 by @dependabot[bot] in #3848
  • Use Npgsql 10.0.3 by @roji in #3849
  • Sync to EF 11.0.0-preview.5.26279.113 by @roji in #3853
  • Fix JSON null partial updates by @roji in #3855
  • Fix TargetInvocationException with nullable value types with HasConversion by @henriquewr in #3843
  • Sync to EF 11.0.0-preview.5.26311.105 by @roji in #3859
  • Add generic date_trunc translation by @roji in #3858
  • Sync to EF Core preview.6 by @roji in #3860
  • Bump the minor-and-patch group with 4 updates by @dependabot[bot] in #3863
  • Sync to EF 11.0.0-preview.6.26319.105 by @roji in #3866
  • Run CI setup steps in parallel by @roji in #3869
  • Sync to EF 11.0.0-preview.6.26327.103 by @roji in #3870
  • Bump actions/checkout from 6 to 7 by @dependabot[bot] in #3867
  • Disable Agent Workflow for syncing by @roji in #3874
  • Fix GIN index detection for views by @roji in #3879
  • Fix deprecated GitHub Actions outputs by @roji in #3881
  • Bump the minor-and-patch group with 3 updates by @dependabot[bot] in #3882
  • Sync to EF 11.0.0-preview.7.26324.112 by @roji in #3884
  • Bump actions/setup-dotnet from 5 to 6 by @dependabot[bot] in #3885
  • Bump the minor-and-patch group with 4 updates by @dependabot[bot] in #3886
  • Fix LIKE escape mapping with value converters by @roji in #3889
  • Handle absent LIKE escape expressions explicitly by @roji in #3890
  • Fix: spelling of occurred in sync-to-latest-ef skill by @mcbbugu in #3900
  • Bump Testcontains.PostgreSql to 4.14.0 by @roji in #3904
  • Bump the minor-and-patch group with 5 updates by @dependabot[bot] in #3907
  • Sync to EF 11.0.0-rc.1.26431.118 by @roji in #3910
  • Remove unused SSL setup from Windows CI by @roji in #3911
  • Bump the minor-and-patch group with 3 updates by @dependabot[bot] in #3917
  • Use precedence-aware parentheses for regex operands by @roji in #3927
  • Translate three-argument ConvertTimeBySystemTimeZoneId by @roji in #3939
  • Sync to EF 11.0.0-rc.2.26504.105 by @roji in #3942
  • Skip type mapping inference for already-mapped unnest inputs by @roji in #3943
  • Truncate sub-microsecond ticks when formatting TimeSpan as interval by @AtakanUk in #3932
  • Bump actions/upload-artifact from 7.0.1 to 7.0.2 by @dependabot[bot] in #3950
  • Preserve row value type mappings when rewriting expressions by @roji in #3953
  • Fix Last() on primitive collections returning the first array element by @sanjaysingh in #3925
  • Remove row value regression test's global mapper dependency by @roji in #3959
  • Reject concurrent indexes in idempotent migration scripts by @roji in #3966
  • Fix collection conversion with nullable element converters by @roji in #3965
  • Add Daitch-Mokotoff fuzzy string matching support by @adomorn in #3922
  • Fix Contains on an object collection over a value-converted column by @sanjaysingh in #3961
  • Fix time zone conversion after DateTimeOffset.UtcDateTime by @roji in #3973
  • Support indexes on JSON members by @roji in #3974
  • Support DROP INDEX CONCURRENTLY by @eypcnckr in #3902
  • Enable structural JSON reader buffer reuse by @roji in #3976
  • Add modelBuilder.UseNoIdentityGeneration() by @roji in #3978
  • Support complex-property paths in index includes by @roji in #3977
  • Support NodaTime ranges in temporal constraints by @roji in #3975
  • Optimize Intersect().Any() over static readonly collections by @roji in #3980
  • Fix transient and concurrency exception handling by @roji in #3981
  • Support modeled JSON in PostgreSQL JSON functions by @roji in #3979
  • Normalize concurrency failures during automatic transaction commit by @roji in #3983
  • Translate SequenceEqual over array slices by @roji in #3982
  • Fix tsvector metadata cast for IReadOnlyList by @DaniilSaushkin in #3984
  • Make sure that when using PadLeft/PadRight we don't truncate if given length is less than the string length by @ChrisJollyAU in #3288
  • Fix array type inference for mixed collection types by @roji in #3991
  • Fix migration history initialization in caller transactions by @roji in #3992
  • Scope key name uniqueness to schemas by @roji in #4000
  • Translate string methods with char arguments by @roji in #4001
  • Fix null checks on unbounded NodaTime Interval bounds by @roji in #3999
  • Support configuring database creation encoding by @roji in #4005
  • Preserve array element converters with explicit column types by @roji in #4007
  • Support System.Text.Json serialization of LTree by @roji in #4006
  • Fix null propagation in date/time interval construction by @roji in #4008
  • Fix BCE NodaTime SQL literal formatting by @roji in #4023
  • Fix repeated seed-data updates for list properties by @roji in #4024
  • Preserve inherited HiLo sequences in model snapshots by @roji in #4031
  • Fix date/time mapping round-tripping and cloning by @roji in #4022
  • Fix Regex.Replace to replace all matches by @roji in #4040
  • Map byte[] to json/jsonb as a raw JSON document again by @Aykuttonpc in #3935
  • Improve test guidance and use PostGIS containers by @roji in #4045
  • Translate ToString() on string expressions by @roji in #4047
  • Add translation support for LocalDateTime.ToDateTimeUnspecified by @Brads3290 in #2833
  • Translate Millisecond and Microsecond members by @roji in #4049
  • Translate AddMilliseconds and AddMicroseconds by @roji in #4053
  • Translate Enumerable.Concat over bytea to || by @virzak in #2200
  • Improve error message when duplicate enum definitions are registered. by @rubenscordeirobr in #3493
  • NpgsqlRelationalConnection owns newly created connection. by @marcusber in #3565
  • Fix type mapping for derived tsquery parameters by @roji in #4058
  • Translate BitArray.Get and indexer access by @roji in #4063
  • Respect PgNameAttribute on enum types in MapEnum by @roji in #4064
  • Fix precision-only numeric migration snapshot churn by @roji in #4065
  • Fix schema cache race during migration history creation by @roji in #4071
  • Fix schema-qualified collations and names containing dots by @roji in #4072
  • Fix byte-array projections from JSON collections by @roji in #4067
  • Fix tsvector columns over JSON-mapped navigations/complex properties by @hostage2222 in #3893
  • Translate PostGIS line interpolation and merging by @roji in #4080
  • Add ST_SetSRID translation by @roji in #4079
  • Add PostGIS ST_Scale translations by @roji in #4081
  • Support integer and exact-numeric tsvector inputs by @roji in #4104
  • Fix hstore SQL literal generation for null and escaped values by @brianpursley in #3780
  • Add hstore query translations by @roji in #4082
  • Fix NodaTime LocalDate subtraction and BCE year extraction by @roji in #4109
  • Sync to EF 11.0.0-rc.3.26522.148 by @roji in #4112
  • Sync to EF 11.0.0 by @roji in #4125
  • Fix TimeOnly.IsBetween for midnight-spanning ranges by @emremenekse in #4127
  • Parenthesize the item of ANY/ALL when its precedence requires it by @efeesrefinal in #4130
  • Format storage parameter values with the invariant culture by @Sorbitol in #4115
  • Fix nullability metadata for PostgreSQL translations by @roji in #4134
  • Fix chained array subscripts and nullable intersections by @roji in #4135
  • Test PostgreSQL 19 in CI by @roji in #4138
  • Update to Npgsql 11.0.0 and refresh dependencies by @roji in #4139

New Contributors

Full Changelog: v9.0.0...v11.0.0