Pomelo.EntityFrameworkCore.MySql

Pomelo.EntityFrameworkCore.MySql copied to clipboard

See https://github.com/dotnet/efcore/issues/27503 upstream.

lauxjpn

How can set AUTO_INCREMENT initial value for primary key?

12

How can set AUTO_INCREMENT initial value for primary key using [Pomelo.EntityFrameworkCore.MySql](https://github.com/PomeloFoundation/Pomelo.EntityFrameworkCore.MySql)?. like this [https://stackoverflow.com/questions/1485668/how-to-set-initial-value-and-auto-increment-in-mysql](https://stackoverflow.com/questions/1485668/how-to-set-initial-value-and-auto-increment-in-mysql) ```SQL CREATE TABLE my_table ( id INT UNSIGNED NOT NULL AUTO_INCREMENT, name VARCHAR(100) NOT NULL, PRIMARY...

Satancito

allow autoincrement column other than primary key

13

### Steps to reproduce Model: ``` public class Area { [Key] public Guid AreaId { get; set; } [Column("auto_id")] [DatabaseGenerated(DatabaseGeneratedOption.Identity)] public long AutoId { get; set; } } ``` Builder:...

kvanska

Duplicating record in Insert (Add or AddAsync)

16

The System runs in Private Cloud and in the test environment I have no problem, but in the production environment at times the Insert duplicates the information generating the same...

fulviocanducci

InvalidOperationException: The property 'Test.Coord' is of type 'Point' which is not supported by the current database provider.

8

### Steps to reproduce Entity : ```C# public Point Coord { get; set; } ``` OnModelCreating : ```C# builder.Entity(b => { ... b.Property(x => x.Coord).ValueGeneratedNever().IsRequired().HasColumnType("point").HasSpatialReferenceSystem(4326).HasColumnName("Coord"); ... } ``` Create DbContext...

GillesFr06

> Design decisions: > > * We will stop wrapping single-updates SaveChanges with transactions. > * For SQL Server, we will prepend `SET IMPLICIT_TRANSACTIONS OFF` for SQL Server to ensure...

lauxjpn

Practical Way to use MySql Enums

17

### Steps to reproduce Almost everything works with MySql enums when you change the column type with the following method that you call for every property in your context: ```...

greghroberts

Support for Index Hints (Draft/For Consideration)

1

### Preface Occasionally the MySQL/MariaDB query planner will make a very sub-optimal (aka downright silly) decision when deciding which index to use for a query. This can have enormous performance...

crozone

Support setting scaffold to use DateTimeOffset for all date types.

7

Requesting a feature request to have `dotnet ef dbcontext scaffold` have a option to use DateTimeOffset for all date types instead of DateTime.

johnwc

Support for CONVERT_TZ() function with appropriate translation.

5

### Preface MySQL supports a function called [`CONVERT_TZ(dt,from_tz,to_tz)`](https://mariadb.com/kb/en/convert_tz/), which allows datetime values to be converted from a given source timezone into a given target timezone. The timezone values can either...

crozone