Pomelo.EntityFrameworkCore.MySql

Pomelo.EntityFrameworkCore.MySql copied to clipboard

Can't add empty or new migration with Add-Migration

6

### Steps to reproduce - Have already a migration - Try to add another one by just using Package Manager Console command => **Add-Migration Test** - Or try to add...

Monsieur-Ours

The LINQ expression could not be translated.

4

### Steps to reproduce The LINQ expression 'DbSet() .Where(o => o.ScoringDate.Date > DateTime.Now.AddDays(-61).Date) .GroupBy(o => o.ServiceId)' could not be translated. ### The issue I recently upgraded my project from .NET...

buddyackerman

Rename `master` branch to `main`

1

To stay aligned with common practices, we should name the default branch `main`.

lauxjpn

Migration bundles does not work in the context of MySQL database and CICD pipeline in Github Action

9

## File a bug I was following this [document](https://learn.microsoft.com/en-us/azure/app-service/tutorial-dotnetcore-sqldb-app?bc=%2Fazure%2Fservice-connector%2Fbreadcrumb%2Ftoc.json&toc=%2Fazure%2Fservice-connector%2FTOC.json) to deploy an app service with MySQL DB, the sample it uses is SQL Server code first and run the below...

xboxeer

The `ServerVersionSupport` derived classes of `MySqlServerVersionSupport` and `MariaDbServerVersionSupport` are heavily used internally to determine which features are available and what syntax to use for them. We current do not check...

lauxjpn

Does ToJson not supported? Getting exception

7

### Steps to reproduce ``` public class OrderContext : DbContext { public DbSet Orders { get; set; } protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder) { var connectionString = ""; optionsBuilder.UseMySql(ServerVersion.AutoDetect(connectionString), options...

pantonis

Publishing ASP.NET Core MySQL Entity Framework Migrations to a remote machine fails

3

Good afternoon! MySQL version: MariaDB 11.2.1 Operating system: Windows Server 2019 Datacenter Pomelo.EntityFrameworkCore.MySql version: 7.0.0 (01/17/2023) Microsoft.EntityFrameworkCore.Tools version: 7.0.11 (12.09.2023) I am using MariaDB 11.2.1 (MySQL) database server and Pomelo.EntityFrameworkCore.MySql...

fox-15

Unable to translate set operation when matching columns on both sides have different store types

1

I'm trying to write the UNION query with IEnumerable.Concat() and use SQLite provider to test it. Consider the following entity: ``` public class Blog { public int Id { get;...

universorum

[Question] When requesting the database, a statement that I have not operated will always be executed.

1

### Steps to reproduce ``` services.AddPooledDbContextFactory(opt => { opt.UseMySql(AppSettings.Sql.ConnectionString, new MySqlServerVersion(ServerVersion.Parse(AppSettings.Sql.Version)), builder => { builder.MinBatchSize(4); builder.CommandTimeout(60); builder.UseQuerySplittingBehavior(QuerySplittingBehavior.SplitQuery); builder.UseNewtonsoftJson(MySqlCommonJsonChangeTrackingOptions.FullHierarchyOptimizedSemantically); }); opt.UseQueryTrackingBehavior(QueryTrackingBehavior.NoTracking); if (AppSettings.IsDebugger) { opt.LogTo(x => { Console.ForegroundColor = ConsoleColor.DarkYellow; Console.WriteLine(x);...

lycoris-xmin

Failed to execute all integration tests

4

I executed the integration test according to the document, but all failed and the error table did not exist. Why is this? Where can I get the initial table。 

deskau