Pomelo.EntityFrameworkCore.MySql

Pomelo.EntityFrameworkCore.MySql copied to clipboard

Many users are currently simply calling `ServerVersion.AutoDetect()` every time when setting up their `DbContext`. This will lead to an additional roundtrip every time the `DbContext` is setup. We should add...

lauxjpn

Check our System.Text.Json support against .NET 6 Preview 4 enhancements

4

.NET 6 Preview 4 adds a [writable JSON DOM](https://github.com/dotnet/core/issues/6098#issuecomment-840857013) and other JSON related stuff. We need to coordinate with the EF Core team in regards to the planned general JSON...

lauxjpn

Invalid SQL generated when changing the primary key in migration with .AddPrimaryKey(...)

8

### Steps to reproduce See code in https://github.com/Mertsch/PomeloPrimaryKeyBug 1. Have a primary key 2. Add migration 3. Change primary key 4. Add migration 5. Execute migrations (get exception on the...

Mertsch

Feature request: provide a way to set JsonSerializer options

6

Currently when using `UseMicrosoftJson` there does not appear to be a way to specify the serialization options (`JsonSerializerOptions`) for JsonSerializer to use (eg the second parameter passed to `JsonSerializer.Serialize`) You...

jonnermut

Once [dotnet/efcore#26471](https://github.com/dotnet/efcore/issues/26471) identifies WITH expressions as composable, we can remove the `MySqlQuerySqlGenerator.CheckComposableSql()` override again, that we recently introduced.

lauxjpn

FK properties with default values aren't always marked as store-generated

3

### Steps to reproduce Only needs to see for IdUserState **SQL table** ```sql CREATE TABLE `user` ( `idUser` int NOT NULL, `name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,...

ruirodrigues1971

For idempotent migration generation, we need to conditionally check for the existence of a given migration ID in the history table. Because MySQL limits the execution of conditional statements to...

lauxjpn

Migration After scaffold

3

### Steps to reproduce This problem happened last week, but now I making some documentation the error happened again. using normal scaffold, for example `dotnet ef dbcontext scaffold "SERVER=localhost; DATABASE=zaccsemel;...

ruirodrigues1971

Could not scaffold the foreign key 'articleContent(articleId)'. A key for 'id' was not found in the principal entity type 'Articles'.

3

## Steps to reproduce ### Create Tables ```sql DROP TABLE IF EXISTS `articles`; CREATE TABLE `articles` ( `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, `keyId` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci...

SpiritLing

When connect to Mycat, MySqlException: Unknown command

13

### Steps to reproduce Sorry, I haven't move deep into the framework. :-) ### The issue when connect to Mycat, I got below info: `MySqlException: Unknown command MySqlConnector.Core.ServerSession.TryResetConnectionAsync(ConnectionSettings cs, IOBehavior...

JackRipVim