Pomelo.EntityFrameworkCore.MySql
Pomelo.EntityFrameworkCore.MySql copied to clipboard
Entity Framework Core provider for MySQL and MariaDB built on top of MySqlConnector
We will use this issue to track the progress on supporting EF Core 9, including its previews.
### Code ``` using Microsoft.EntityFrameworkCore; public enum OrderStatus { Pending, Shipped } public class StreetAddress { public string Street { get; set; } public string City { get; set; }...
From https://github.com/dotnet/aspire/issues/2033 When running against EF 9 assemblies, Pomelo throws `System.MissingMethodException : Method not found: 'Void Microsoft.EntityFrameworkCore.Migrations.Internal.MigrationsModelDiffer..ctor(Microsoft.EntityFrameworkCore.Storage.IRelationalTypeMappingSource, Microsoft.EntityFrameworkCore.Migrations.IMigrationsAnnotationProvider, Microsoft.EntityFrameworkCore.Update.Internal.IRowIdentityMapFactory, Microsoft.EntityFrameworkCore.Update.Internal.CommandBatchPreparerDependencies)'.` from this code: https://github.com/PomeloFoundation/Pomelo.EntityFrameworkCore.MySql/blob/5fa77d7f68cc51ea6e5d1206fd2cbf58d20f3182/src/EFCore.MySql/Migrations/Internal/MySqlMigrationsModelDiffer.cs#L32-L41 This happens because this "Internal" type...
Hello, The MySQLDbFunctionsExtensions class has support for many of the specific date difference operations that MySql supports through its function TIMESTAMPDIFF(TIME_UNIT, startDate,endDate), but it doesn't support all of them. For...
As of version 8.0.31, MySql supports INTERSECT and EXCEPT. See https://dev.mysql.com/doc/relnotes/mysql/8.0/en/news-8-0-31.html This change enables ExceptIntercept and ExceptInterceptPrecedence for versions >= 8.0.31. The now-enabled tests pass, and it also works properly...
### Steps to reproduce This one will work: ```csharp var query = transactionStorage .Where(w => w.DateCreated >= startTime && w.DateCreated new { Current = s, Previous = transactionStorage.Where(w => w.LogId...
### Description I would like to propose adding a partitioning feature to MySQL. Partitioning allows for better organization and management of large tables by dividing them into smaller, more manageable...
``` dbug: 28/12/2023 00:09:14.545 RelationalEventId.CommandExecuting[20100] (Microsoft.EntityFrameworkCore.Database.Command) Executing DbCommand [Parameters=[@p0='?' (DbType = Guid), @p1='?' (DbType = DateTime), @p2='?' (DbType = Int64), @p3='?' (DbType = Guid), @p4='?' (DbType = Guid), @p5='?' (Size...
### Steps to reproduce I had some existing EF migrations (code first) generated using .NET 6 (and Pomelo 6.0.2). These migrations had some Guid properties that were mapped with the...
### Steps to reproduce Using the RDS Proxy endpoint instead of normal endpoint of Aurora Mysql in the connection string; Here is my connection string format: Server=RDS Proxy endpoint;port=3306;user=XXX;password=YYY;database=zzz;AllowLoadLocalInfile=True;IgnoreCommandTransaction=true ###...