Pomelo.EntityFrameworkCore.MySql

Pomelo.EntityFrameworkCore.MySql copied to clipboard

EF Core 6, [Required] DataAnnotation is not created by the database scaffold

1

### Steps to reproduce Create the table: ```sql CREATE TABLE application_user( id bigint NOT NULL AUTO_INCREMENT COMMENT 'Primary key', username varchar(50) NOT NULL COMMENT 'username', ... PRIMARY KEY (id), UNIQUE...

florentmsl

Add support for MariaDB's "system-versioned tables" (temporal tables)

20

The SQL Server provider recently added support for [temporal tables](https://docs.microsoft.com/en-us/ef/core/what-is-new/ef-core-6.0/whatsnew#sql-server-temporal-tables). While MySQL has not yet added support for temporal tables, MariaDB has in form of their [system-versioned tables](https://mariadb.com/kb/en/system-versioned-tables/). We should...

lauxjpn

See https://github.com/dotnet/efcore/pull/28056 and https://github.com/dotnet/efcore/issues/21202 upstream.

lauxjpn

See https://github.com/dotnet/efcore/pull/28048 upstream.

lauxjpn

EndsWith translation

3

### Steps to reproduce ```cs // This works db.Set.Where(x => x.String.EndsWith("*")) // This does not work db.Set.Where(x => x.String.EndsWith('*')) ``` ### The issue EndsWith can be translated if a string...

IvMisticos

Impossible to scaffold MySQL 5.0.95 database

1

When scaffolding a MySQL 5.0.95 database i get the following error: Unknown table 'REFERENTIAL_CONSTRAINTS' in information_schema Seems legit to me, as 'REFERENTIAL_CONSTRAINTS' table is only available in MySQL 5.1.* and...

sneps85

how to make a contains query of composite key

4

### The issue In mysql,I can make a query like: ``` select * from `Table` where (Id,Name) in ((1,"test"),...); ``` How can I make a query like above in ef...

hoxcape

Table constraints get dropped on migration fail

1

### Steps to reproduce The following classes. ```c# public class EntityContext : DbContext { public DbSet Orders { get; set; } public DbSet DetailedOrders { get; set; } protected override...

Phomor

Paging generate SQL

1

`var list = _adminContext.GiveMoneyLog.Include(s => s.UserClerk).Include(s => s.UserSimple).Where(exp).OrderByDescending(m => m.CreateTime).Skip((page - 1) * limit).Take(limit).ToList();` The generated SQL is as follows： ```SQL SELECT * FROM ( SELECT * FROM `GiveMoneyLog` AS...

HaoQianCheng

Implementation should be possible for MariaDB but currently not for MySQL, that will need a workaround. See https://github.com/dotnet/efcore/issues/27372#issuecomment-1059767176.

lauxjpn