How using HiLo to generate keys with Pomelo.EntityFrameworkCore.MySql?

Using MySQL provider for .net core application generates MissingMethodException

The problem was related to sql provider. It's already fixed in current versions.

missing stored procs when scaffolding mysql using EF Core on .net core and pomelo drivers

There is a Known issue with Pomelo and latest version of Entity Framework....It is working for me with this configuration:...Microsoft.EntityFrameWorkCore 2.0.3 Microsoft.EntityFrameworkCore.Tools 2.0.3 Pomelo.EntityFrameworkCore.MySql 2.0.1 ...To call the stored procedure in MySql you can use something like:...var values = _context.Test.FromSql("c...

Issue while querying MySQL Database with Pomelo Entity Framework Core

I downloaded your project and applied ...Migration... to create database and tables in my MySQL server using these two commands as I dont have your SQL scripts with data:...Add-Migration <NAME>...Update-Database...Then I added sample data to ...employees... table as shown from below ...select... query: ...MariaDB [employees]> select * from employee...

Pomelo.EntityFrameworkCore.Mysql error DBContextOptionsBuilder does not contain a definition for UseMyQL

I changed it to:...// Add framework services. services.AddDbContext<WebAPIDataContext>(options => { options.UseMySql(Configuration.GetConnectionString("MysqlConnection")); });

Errors using Pomelo MySQL EF provider with ASP.NET Core 2.0 Preview

I am using Pomelo 1.1.2 on ASP.NET Core 2.0 Preview, along with EF 2.0 Preview. With their demo code, I get the following exception every time I call "UseMySql":...System.TypeLoadException occurred HResult=0x80131522 Message=Method 'Clone' in type 'Microsoft.EntityFrameworkCore.Internal.MySqlOptionsExtension' from assembly 'Pomelo.EntityFramewo...

Mysql Entity Framework issue - Specified key was too long; max key length is 3072 bytes

I used official MySql provider ...MySql.Data.EntityFrameworkCore... which is in pre-release state and has some troubles with migrations. Then I changed to ...Pomelo.EntityFrameworkCore.MySql... and updated database without any errors.

Unable to find provider assembly with name Pomelo.EntityFrameworkCore.MySql

After upgrading the .net Core version 2.1.1 to 2.2.0 it works properly.

Incorrect SQL generated by Pomelo with MySQL and .NET Core

I was mapping properties in Order to another object's properties, eg...public string PropA => obj.ProbA ...and when I stopped doing that and changed it to long form using getters and setters it started working.

Pomelo.EntityFrameworkCore.MySql error with EF Core 3.0

I found a solution, not sure if it is a workaround or is this the normal way to do it though....Just add the below in your DataContext class:...protected override void OnModelCreating(ModelBuilder builder) { base.OnModelCreating(builder); builder.Entity<AppUser>(entity => entity.Property(m => m.Id).HasMaxLength(255))...

Pomelo.EntityFrameworkCore.MySql MySqlGeometry, EntityframeworkCore Migrations failed

While ...MySqlGeometry... is supported by MySqlConnector (the underlying library used by Pomelo), it is not yet supported by Pomelo itself....We have spatial data type support planned as a feature for the ...3.1.0... release.