Pomelo.EntityFrameworkCore.MySql

Pomelo.EntityFrameworkCore.MySql copied to clipboard

Update wiki with converter information regarding DateTimeOffset

2

There are multiple options available to handle `DateTimeOffset`s. One is the default implementation to normalize every `DateTimeOffset` to UTC without offset before saving. Others can be chosen in form of...

lauxjpn

We should give a quick overview about new features and breaking changes and might also want to mention the top 5 issues that are being reported here, but that are...

lauxjpn

Implementing better System.TimeSpan support so member translations make sense

2

> Nope ;-) https://docs.microsoft.com/en-us/dotnet/api/system.timespan.divide?view=netcore-3.1 Ah, makes sense that it returns a `TimeSpan` and not a `DateTime`. We currently don't translate any `TimeSpan` methods in Pomelo (I think that is the...

lauxjpn

Usage of window functions in MariaDB with SQL_MODE set to `ONLY_FULL_GROUP_BY`, in a `SELECT` statement without a `GROUP BY` clause, will result in an error: ```sql SELECT `o`.`OrderID`, `o`.`CustomerID`, `o`.`EmployeeID`,...

lauxjpn

Add common samples

3

This will make it easier for the community to figure out Pomelo specific stuff and how to use Pomelo with common packages (like IdentityServer) without the need to look through...

lauxjpn

We should do some performance tests with the current distance calculation implementations in regards to index usage. We should also decide, whether the current implementation strategy is the way to...

lauxjpn

It would make sense to add the Guid mapping settings that can be specified in the connection string to `DefaultDataTypeMappings` as well, as we have already done with mappings for...

lauxjpn

We should consider removing `MySqlSchemaBehavior` in favor of a warning that throws by default if a schema is being used, but can be ignored if explicitly configured so. Instead of...

lauxjpn

To input a sytem type to Annotation() function instead of MySqlValueGenerationStrategy type

23

### Steps to reproduce The code grenerated by Add-Migration in console: ``` C# public partial class AddConfig : Migration { protected override void Up(MigrationBuilder migrationBuilder) { migrationBuilder.CreateTable( name: "MuTable", columns:...

JeffreySu

Missing retry policy for ServerVersion.AutoDetect()

3

There is currently no way to make use of the `MySqlRetryingExecutionStrategy` when it comes to `ServerVersion.AutoDetect()` calls, because `ServerVersion.AutoDetect()` is usually called before a `DbContext` has been created. For example,...

lauxjpn