Pomelo.EntityFrameworkCore.MySql

Pomelo.EntityFrameworkCore.MySql copied to clipboard

Calling Convert.ToInt64() gives `signed` instead of `bigint`

1

### Steps to reproduce Given the following DTO: ``` csharp public class WpPostmeta : IMetaKeyValuePair { public long MetaId { get; set; } public long PostId { get; set; }...

sommmen

How to get relevance score on full text search with EF Core

2

Hi, with stored procedure we can get score like this ```SQL SELECT id, MATCH (title,content,author) AGAINST ('traveling to parks') as score FROM news; ``` ```Shell +----+----------------------+ | id | score...

benny-adiwijaya

Using modelBuilder.UseCollation("utf8mb4_0900_ai_ci", DelegationModes.ApplyToDatabases) can generate unexpected migration operations

2

### Steps to reproduce The reproducing steps are similar to #1508 , and using `UseCollation("utf8mb4_0900_ai_ci", DelegationModes.ApplyToDatabases)` instead of using `HasCharSet(null, DelegationModes.ApplyToDatabases)`. ### The issue When using `builder.UseCollation("utf8mb4_0900_ai_ci", DelegationModes.ApplyToDatabases)` in DB...

FosterLin

GroupBy inside Select produces wrong SQL

5

### Steps to reproduce Create a query with a `GroupBy` on a navigational property inside a select statement. ```C# await db.sessions .Include(s => s.answers) .Select(s => s.answers.GroupBy(a => a.identifier).Count()) .ToListAsync();...

orjandh

EF Core generates non-optimized SQL for .Include().First() queries

9

Pomelo is not correctly generating SQL code. The following code produces the following SQL: ```SQL SELECT 't'.'UserId', 't'.'Username', 'o'.'OrderId', 'o'.'Total', 'o'.'UserId' FROM ( SELECT 'u'.'UserId', 'u'.'Username' FROM 'Users' AS 'u'...

uehlbran

Generate SQL scripts that do no contain DELIMITER

1

### Steps to reproduce `dotnet ef migrations script --idempotent` ### The issue The generated SQL contains `DELIMITER`, making it invalid for use with `MySqlConnector`. Is there a way to to...

jerrysdev

wait_timeout and interactive_timeout issues after upgrading to MySQL 8.0.24

12

I am using Pomelo version 3.2.4 in some projects (.net core 3.1) but since updating to MySQL 8.0.24 i get issues in our services related to `wait_timeout` and `interactive_timeout`. More...

e-simo

RenameColumnOperation adds unwanted default value on the column

2

### Steps to reproduce Have a model that looks like this: ```c# class SomeTable { public string SomeColumn { get; set; } } b.Property("SomeColumn") .IsRequired() .HasMaxLength(255) .HasColumnType("varchar(64)"); ``` Then change...

foriequal0

See https://github.com/dotnet/efcore/issues/28104.

lauxjpn

Mapping data type of byte[]

1

Why is data type `byte[]` automatically mapped to SQL type `char()`? Shouldn't be the BINARY or VARBINARY? Is is possible to change it somehow by model annotation?

jendo42