Skip to content

Releases: npgsql/efcore.pg

v10.0.0

22 Nov 17:42

Choose a tag to compare

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

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

v10.0.0-preview.7

17 Aug 07:05
0533e60

Choose a tag to compare

v10.0.0-preview.7 Pre-release
Pre-release
Sync to EF 10.0.0-preview.7 (#3597)

v10.0.0-preview.2

24 Mar 11:21

Choose a tag to compare

v10.0.0-preview.2 Pre-release
Pre-release
Remove NuGet.config

v10.0.0-preview.1

01 Mar 18:47

Choose a tag to compare

v10.0.0-preview.1 Pre-release
Pre-release
Bump versions to 10.0.0-preview.1

v9.0.4

01 Mar 08:01

Choose a tag to compare

v9.0.3

17 Jan 18:57

Choose a tag to compare

v9.0.2

07 Dec 18:01

Choose a tag to compare

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

v9.0.0

18 Nov 17:50

Choose a tag to compare

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

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

v8.0.11

18 Nov 17:49

Choose a tag to compare

The full list of changes is available here.

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

v8.0.10

17 Oct 18:27

Choose a tag to compare

The full list of changes is available here.

Full Changelog: v8.0.8...v8.0.10