Pomelo.EntityFrameworkCore.MySql

Pomelo.EntityFrameworkCore.MySql copied to clipboard

### Simple AddDays example ```csharp using (var context = serviceProvider.GetService()) { double daysDiff = 5; var posts = await context.BlogPosts .Where(p => p.PublicationDate.AddDays(daysDiff) < DateTimeOffset.Now) .ToListAsync(); } ``` Generated SQL:...

AlphaGit

SQL Syntax Error

19

# Environment: MySQL version: 5.7.18 Operating system: Win7x64;Win10x64;debian8x64 Pomelo.EntityFrameworkCore.MySql version: 1.1.2 NetStandard 1.4 # DbContext::OnModelCreating: ```csharp modelBuilder.Entity(buildAction => { buildAction.HasKey(dataValueEntity => dataValueEntity.Id); buildAction.HasOne(dataValueEntity => dataValueEntity.SensorEntity) .WithMany(sensor => sensor.DataValues) .HasForeignKey(dataValueEntity =>...

deinok

The `AUTO_INCREMENT` option for the primary key is currently hardcoded in the SQL generated by the migration. Would like to be able to provide a configurable way, e.g. via the...

buzzers

Since it is not standard SQL syntax to include an index in a `CREATE TABLE` statement, efcore generates separate migration statements for tables and indexes. But MySQL supports this syntax,...

buzzers

Primary key drop when data present

6

### Steps to reproduce Our Bitwarden product has a beta offering where self-hosters can utilize Entity Framework Core and bring their own database. MySQL is one such offering. We build...

withinfocus

For a detailed explanation of this fix, see https://github.com/PomeloFoundation/Pomelo.EntityFrameworkCore.MySql/issues/1828#issuecomment-1947454764. Should be backported to `8.0.0`. Fixes #1828

lauxjpn

AWS Lambda using NET8 image hangs on database access

7

### Steps to reproduce None. ### The issue We moved to NET8, so therefor we started using a NET8 image for a AWS Lambda. The Lambda accesses two MySql databases...

geedsen

Pomelo for Newtonsoft.Json is not using serialization settings when generating property paths in MySQL Functions that search JSON values

4

### Steps to reproduce using `Pomelo` and `Newtonsoft.Json` if you have an entity with a column marked as `json` when querying for a field in this column, Pomelo generates a...

jjavierdguezas

You can use source-generated JsonSerializerOptions or provide additional converters when using JSON columns. This PR makes it possible

trejjam

[NotMapped] property in entity will cuased query all field in query, even not used

1

### Steps to reproduce ``` public class AnyClassContainsNotMapped { public int Key { get; set; } public string Name { get; set; } public byte[] NeedNotQuery { get; set; }...

Flithor