Releases · npgsql/efcore.pg

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