Bump Pomelo.EntityFrameworkCore.MySql and Microsoft.EntityFrameworkCore in /Source

[dependabot[bot]]

Bumps Pomelo.EntityFrameworkCore.MySql and Microsoft.EntityFrameworkCore. These dependencies needed to be updated together. Updates Pomelo.EntityFrameworkCore.MySql from 6.0.3 to 8.0.2

Release notes

Sourced from Pomelo.EntityFrameworkCore.MySql's releases.

8.0.2

This release is compatible with .NET 8.0, EF Core 8.0, MySQL 8.0, MariaDB 11.3/11.2/11.1/11.0/10.11/10.10/10.6/10.5/10.4 and MySqlConnector 2.3.5.

For all new features and bugfixes contained in this release, see related issues and pull requests. The EF Core 8.0 release train is tracked by #1746.

8.0.1

This release is compatible with .NET 8.0, EF Core 8.0, MySQL 8.0, MariaDB 11.2/11.1/11.0/10.11/10.10/10.6/10.5/10.4 and MySqlConnector 2.3.5.

For all new features and bugfixes contained in this release, see related issues and pull requests. The EF Core 8.0 release train is tracked by #1746.

8.0.0

This release is compatible with .NET 8.0, EF Core 8.0, MySQL 8.0, MariaDB 11.2/11.1/11.0/10.11/10.10/10.6/10.5/10.4 and MySqlConnector 2.3.5.

For all new features and bugfixes contained in this release, see the related issues and pull requests of the following milestones:

• 8.0.0
• 8.0.0-beta.2
• 8.0.0-beta.1

8.0.0-beta.2

This prerelease is compatible with .NET 8.0, EF Core 8.0, MySQL 8.0/5.7, MariaDB 11.1/11.0/10.11/10.10/10.6/10.5/10.4 and MySqlConnector 2.3.1.

For all new features and bugfixes contained in this prerelease, see related issues and pull requests. The EF Core 8.0 release train is tracked by #1746.

8.0.0-beta.1

This prerelease is compatible with .NET 8.0, EF Core 8.0 RC 1, MySQL 8.0/5.7, MariaDB 11.1/11.0/10.11/10.10/10.6/10.5/10.4 and MySqlConnector 2.3.0-beta.3.

For all new features and bugfixes contained in this prerelease, see related issues and pull requests. The EF Core 8.0 release train is tracked by #1746.

7.0.0

This release is compatible with .NET 7.0/6.0, EF Core 7.0, MySQL 8.0/5.7, MariaDB 10.9/10.8/10.7/10.6/10.5/10.4/10.3 and MySqlConnector 2.2.5.

For all new features and bugfixes contained in this release, see the related issues and pull requests of the following milestones:

• 7.0.0
• 7.0.0-silver.1
• 7.0.0-alpha.1

7.0.0-silver.1

This prerelease is compatible with .NET 7.0/6.0, EF Core 7.0, MySQL 8.0/5.7, MariaDB 10.9/10.8/10.7/10.6/10.5/10.4/10.3 and MySqlConnector 2.2.2.

For all new features and bugfixes contained in this prerelease, see related issues and pull requests.

7.0.0-alpha.1

This prerelease is compatible with .NET 7.0/6.0, EF Core 7.0, MySQL 8.0/5.7, MariaDB 10.9/10.8/10.7/10.6/10.5/10.4/10.3 and MySqlConnector 2.2.0.

... (truncated)

Commits

• 6b1e9ca [BACKPORT] Add DateTimeOffset member translations for .DateTime, `.UtcDat...
• bcbedf4 [BACKPORT] Allow easier injection of customized MySqlRelationalConnection i...
• 73aab49 Use current DbConnection for updating the sql_mode. (#1862) (#1882)
• 53826cc [BACKPORT] Add support for CONVERT_TZ via EF.Functions.ConvertTimeZone() ...
• 7bf885a Revert "Workaround SELECT ... ORDER BY (SELECT 1) related bug in Oracle's MyS...
• d9afafb Stop using MySqlValueGenerationStrategy.ComputedColumn annotations for `Row...
• 1457e87 Push packages from *-maint branches to nightly feeds as well. (#1867)
• 9a8cdcf Update to EF Core 8.0.2 (#1866)
• 2ba0d90 Update GitHub workflows.
• 928ee13 Update branding to 8.0.2.
• Additional commits viewable in compare view

Updates Microsoft.EntityFrameworkCore from 6.0.29 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

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

• EFC8: Lazy Loading regression on newly created objects
• EfCore 8: Primitive collections in JSON documents error with init
• Buffering error in JSON deserialization with junk data
• Contains fallback translation fails when the array parameter has AsQueryable
• QueryableMethodNormalizingExpressionVisitor does not visit recursively when converting List.Contains to Queryable.Contains
• SqlNullabilityProcessor ignores Contains item visitation
• SensitiveDataLogging with ComplexProperty: Unable to cast RuntimeComplexType to type IEntityType
• JSON materialization code should be resilient to incorrect JSON documents

EF Core 8 (EF8) is available from NuGet

EF8 contains many new features and enhancements, including:

• Allow Multi-region or Application Preferred Regions in EF Core Cosmos
• Use C# structs or classes as value objects
• Support primitive collections in the compiled model
• Migrations and model snapshot for primitive collections
• Query: add support for projecting JSON entities that have been composed on
• SQLite: Add EF.Functions.Unhex
• Add type mapping APIs to customize JSON value serialization/deserialization

... (truncated)

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)
• 7c8f682 Merge in 'release/8.0' changes
• 86dd535 [release/8.0] Don't discover DbFunctions when building ad-hoc model (#32807)
• Additional commits viewable in compare view

Most Recent Ignore Conditions Applied to This Pull Request

| Dependency Name | Ignore Conditions | | --- | --- | | Microsoft.EntityFrameworkCore | [>= 7.a, < 8] | | Pomelo.EntityFrameworkCore.MySql | [>= 7.a, < 8] |

You can trigger a rebase of this PR 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)

Note Automatic rebases have been disabled on this pull request as it has been open for over 30 days.

[LtRipley36706]

@dependabot rebase

[dependabot[bot]]

Looks like these dependencies are up-to-date now, so this is no longer needed.