Package Dependencies: Bump Npgsql.EntityFrameworkCore.PostgreSQL, Microsoft.EntityFrameworkCore and Microsoft.EntityFrameworkCore.Relational

[dependabot[bot]]

Bumps Npgsql.EntityFrameworkCore.PostgreSQL, Microsoft.EntityFrameworkCore and Microsoft.EntityFrameworkCore.Relational. These dependencies needed to be updated together. Updates Npgsql.EntityFrameworkCore.PostgreSQL from 8.0.0 to 8.0.2

Release notes

Sourced from Npgsql.EntityFrameworkCore.PostgreSQL's releases.

v8.0.2

This is the first patch release following 8.0.0, with 15 bug fixes.

The full list of changes is available here.

Commits

• 5a671b9 Bump version to 8.0.2
• a4676b8 Remove unneeded backslash ESCAPE from LIKE translations (#3103)
• b88a521 Don't use NpgsqlDataSource from DI if connection string/connection is specifi...
• f818704 Bump dependency versions
• bab35a7 Always add parentheses around PgUnknownBinaryExpression (#3073)
• bbcdde6 Fix bad array access when an AFTER trigger raises an exception in SaveChanges...
• c698389 Fix null semantics for ILikeExpression (#3039)
• f958e9a Cast NodaTime DateInterval.End to date. (#3024)
• baaf41f Support NpgsqlUIntTypeMapping for the compiled model (#3030)
• 557e166 Make Npgsql-specific JsonValueReaderWriters public for compiled model (#3029)
• Additional commits viewable in compare view

Updates Microsoft.EntityFrameworkCore from 8.0.1 to 8.0.2

Release notes

Sourced from Microsoft.EntityFrameworkCore's releases.

EF Core 8.0.2 is available on NuGet now. This is a patch release of EF Core 8 (EF8) containing only important bug fixes:

• Adding EF.Constant to prevent parameterization in query
• Nav expansion visitor does not visit the Contains item argument
• SqliteException "no such column : rX.value" when ordering on subquery value in combination with a "where contains" when upgrading from 7 to 8.0.0-rc.2.23480.1
• DB Context pooling with proxies resulting in memory issues in 8.0 RC2
• Nav expansion visitor does not visit the non-lambda arguments (Skip, Take, ElementAt)
• LINQ "Contains" generates SQL with wrong char length
• Using new[] in select query gives exception .NET 8
• EF Core Cosmos 7.0.13 => 7.0.14 Value cannot be null. (Parameter 'derivedType')
• New OpenJSON expression to SQL translation breaks aggregates on subquery with 'Cannot perform an aggregate function on an expression containing an aggregate or a subquery' exception
• Did Contains stop working on empty list in EF Core 8?
• LINQ "Contains" fails to generate SQL with custom converter
• error on working with explicit many-to-many relations with OnDelete.Restrict
• Lazy loader throwing invalid operation exceptions
• Cosmos provider v7.0.14 and v8.0.0 breaks previous OwnsMany behaviour
• Constructor not found for type 'Microsoft.EntityFrameworkCore.ChangeTracking.Internal.NullableClassCurrentProviderValueComparer
• Inconsistent behavior related to relationship cycle
• Property conversions are lost on base type is subtype is registered to model afterwards after upgrade to EFCore 8
• Incorrect parameter rewriting for string StartsWith/EndsWith/Contains
• Migrations bug when creating stored procedure with GOTO statement
• Unable to Scaffold DBContext if tables in SQL Server have certain names
• Contains translates to correlated query when the item is nullable
• FluentAPI configuration PrimitiveCollection on OwnedNavigationBuilder returns PropertyBuilder instead of PrimitiveCollectionBuilder
• String comparison fails when using const and compiled Models.
• Exception when writing a JSON column with negative enum value
• Getting errors when mixing DbFunction and SqlQueryRaw

Commits

• a97f6ff [internal/release/8.0] Update dependencies from dnceng/internal/dotnet-runtime
• 4016ea7 [internal/release/8.0] Update dependencies from dnceng/internal/dotnet-runtime
• 813b3f7 Merge in 'release/8.0' changes
• 1b51aa3 Merge branch 'release/7.0' into release/8.0
• 2634ffd Merge in 'release/8.0' changes
• 3bb09fb Merge branch 'release/6.0' into release/7.0
• 8e2972c [release/8.0] Bump SqlClient version (#32838)
• 2136285 [release/7.0] Update SqlClient dependency (#32841)
• 2abafb2 [release/6.0] Update SqlClient dependency (#32840)
• 7c8f682 Merge in 'release/8.0' changes
• Additional commits viewable in compare view

Updates Microsoft.EntityFrameworkCore.Relational from 8.0.1 to 8.0.2

Release notes

Sourced from Microsoft.EntityFrameworkCore.Relational's releases.

EF Core 8.0.2 is available on NuGet now. This is a patch release of EF Core 8 (EF8) containing only important bug fixes:

• Adding EF.Constant to prevent parameterization in query
• Nav expansion visitor does not visit the Contains item argument
• SqliteException "no such column : rX.value" when ordering on subquery value in combination with a "where contains" when upgrading from 7 to 8.0.0-rc.2.23480.1
• DB Context pooling with proxies resulting in memory issues in 8.0 RC2
• Nav expansion visitor does not visit the non-lambda arguments (Skip, Take, ElementAt)
• LINQ "Contains" generates SQL with wrong char length
• Using new[] in select query gives exception .NET 8
• EF Core Cosmos 7.0.13 => 7.0.14 Value cannot be null. (Parameter 'derivedType')
• New OpenJSON expression to SQL translation breaks aggregates on subquery with 'Cannot perform an aggregate function on an expression containing an aggregate or a subquery' exception
• Did Contains stop working on empty list in EF Core 8?
• LINQ "Contains" fails to generate SQL with custom converter
• error on working with explicit many-to-many relations with OnDelete.Restrict
• Lazy loader throwing invalid operation exceptions
• Cosmos provider v7.0.14 and v8.0.0 breaks previous OwnsMany behaviour
• Constructor not found for type 'Microsoft.EntityFrameworkCore.ChangeTracking.Internal.NullableClassCurrentProviderValueComparer
• Inconsistent behavior related to relationship cycle
• Property conversions are lost on base type is subtype is registered to model afterwards after upgrade to EFCore 8
• Incorrect parameter rewriting for string StartsWith/EndsWith/Contains
• Migrations bug when creating stored procedure with GOTO statement
• Unable to Scaffold DBContext if tables in SQL Server have certain names
• Contains translates to correlated query when the item is nullable
• FluentAPI configuration PrimitiveCollection on OwnedNavigationBuilder returns PropertyBuilder instead of PrimitiveCollectionBuilder
• String comparison fails when using const and compiled Models.
• Exception when writing a JSON column with negative enum value
• Getting errors when mixing DbFunction and SqlQueryRaw

Commits

• a97f6ff [internal/release/8.0] Update dependencies from dnceng/internal/dotnet-runtime
• 4016ea7 [internal/release/8.0] Update dependencies from dnceng/internal/dotnet-runtime
• 813b3f7 Merge in 'release/8.0' changes
• 1b51aa3 Merge branch 'release/7.0' into release/8.0
• 2634ffd Merge in 'release/8.0' changes
• 3bb09fb Merge branch 'release/6.0' into release/7.0
• 8e2972c [release/8.0] Bump SqlClient version (#32838)
• 2136285 [release/7.0] Update SqlClient dependency (#32841)
• 2abafb2 [release/6.0] Update SqlClient dependency (#32840)
• 7c8f682 Merge in 'release/8.0' changes
• Additional commits viewable in compare view

Dependabot will resolve any conflicts with this PR as long as you don't alter it yourself. You can also trigger a rebase manually by commenting @dependabot rebase.

---

Dependabot commands and options

You can trigger Dependabot actions by commenting on this PR: - `@dependabot rebase` will rebase this PR - `@dependabot recreate` will recreate this PR, overwriting any edits that have been made to it - `@dependabot merge` will merge this PR after your CI passes on it - `@dependabot squash and merge` will squash and merge this PR after your CI passes on it - `@dependabot cancel merge` will cancel a previously requested merge and block automerging - `@dependabot reopen` will reopen this PR if it is closed - `@dependabot close` will close this PR and stop Dependabot recreating it. You can achieve the same result by closing it manually - `@dependabot show ignore conditions` will show all of the ignore conditions of the specified dependency - `@dependabot ignore this major version` will close this PR and stop Dependabot creating any more for this major version (unless you reopen the PR or upgrade to it yourself) - `@dependabot ignore this minor version` will close this PR and stop Dependabot creating any more for this minor version (unless you reopen the PR or upgrade to it yourself) - `@dependabot ignore this dependency` will close this PR and stop Dependabot creating any more for this dependency (unless you reopen the PR or upgrade to it yourself)

[dependabot[bot]]

OK, I won't notify you again about this release, but will get in touch when a new version is available. You can also ignore all major, minor, or patch releases for a dependency by adding an ignore condition with the desired update_types to your config file.

If you change your mind, just re-open this PR and I'll resolve any conflicts on it.