IdentityServer4 with MySql and Dot Net Core - No coercion operator is defined between types 'System.Int16' and 'System.Boolean'

.net-core c# entity-framework-core mysql

Question

I am working on the IdentityServer4 with MySQL and .NET Core.

When I generate the token using the link, I get the below attached error.

I converted all the Boolean fields to short. 

modelBuilder.Entity<Patient>()
    .Property(r => r.IsDeleted)
    .HasConversion(new BoolToZeroOneConverter<short>());

enter image description here

1
1
2/26/2019 10:04:27 AM

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Popular Answer

It appears that you're encountering a known bug: https://bugs.mysql.com/bug.php?id=92987

On the similar issue https://bugs.mysql.com/bug.php?id=93028, people have reported success by switching away from MySql.Data.EntityFramework to Pomelo.EntityFrameworkCore.MySql (an alternative OSS EF.Core implementation for MySQL). Otherwise, you may just have to wait for Oracle to fix the issue.

0
2/26/2019 6:09:45 PM

Related Questions

Unable to cast Anonymous Type from 'System.Linq.IQueryable' to 'System.Data.Entity.Core.Objects.ObjectQuery'

As noted by dna2 at the end of his question, this issue was fixed in ...EF 6.0.2.... To upgrade your version of EF, do the following in the Package Manager Console (VS2013 ...VIEW -> Other Windows -> Package Manager Console...)....Update-Package EntityFramework -Version 6.0.2
c# entity-framework entity-framework-6 linq linq-to-entities
asked by Brant Olsen

Method not found: 'Void System.Data.Entity.DbModelBuilder.RegisterEntityType(System.Type)'

This exception probably is happening because of the different versions of loaded assemblies. If XAF referencies the 6.0.0 version in it's metadata, and your project doesn't, the compiler will load the 6.0.0 version to bin folder....You can try overload the assembly version in you application configuration file (app.config), using something like thi...
c# entity-framework entity-framework-6
asked by Fabio Lima

Unable to cast object of type 'System.Linq.Expressions.FieldExpression' to type 'System.Linq.Expressions.ParameterExpression

You should try calling ...Include... method in the ...DbSet... that you want to load the related entity:... var table = (from pc in _db.PlayerComments.Include(p => p.Period) //... ...And I think your query would be simpler if you use navigation properties instead explicit joins:...var table =await _db.PlayerComments.Include(p => p.Per...
entity-framework entity-framework-core linq
asked by octavioccl

Entityframework Core Unable to cast object of type 'System.Int32' to type 'System.Int64'

DB first entity framework core throws this exception when SaveChanges(); This code works just fine with Entity Framework but not with Entity Framework Core....Exception message: Unable to cast object of type 'System.Int32' to type 'System.Int64'....CsProduct csProduct = new CsProduct() { CheapestPrice = 1, LastPrice = 1, LastUpdateDate ...
c# entity-framework-core sql-server
asked by jong shin

'System.MissingMethodException' occurred in System.Private.CoreLib.ni

OK it seems to be a bug in ...MySQL -> entity framework adapter ...MySql.Data.EntityFrameworkCore.... I downgraded from ...7.0.6-IR31... to ...6.10.1-beta... and everything works fine now!
.net .net-core c# entity-framework entity-framework-core
asked by Mohammed Noureldin

Eager Loading "No coercion operator is defined between types" after .NET Core/EF Core 2.0 Upgrade

Include... isn't useful in this situation as you are returning a projection and the ...Include...s are ignored (read about ignored includes ...here...)....If by "intended results" you mean you want ...record.PaperRecord.Paper... to have a value, simply include it in your projection; EF will wire up the relationship....new { PaperRecord = _.Pape...
.net-core c# eager-loading entity-framework-core linq
asked by Moho

Unable to cast object of type 'System.Linq.Expressions.MethodCallExpression' to type 'System.Linq.Expressions.LambdaExpression'

You can assign a variable for ..._ratingsProvider.GetRating... first, to avoid the error in the title....After that you will have another error saying entity framework does not support your query. You need something like LINQKit ...https://github.com/scottksmith95/LINQKit.... ...AsExpandable()... and ...Invoke(x, id)... are from LINQKit....using Li...
c# entity-framework entity-framework-6 linq sql
asked by michael yin

System.Private.CoreLib: Exception while executing function: System.Data.SqlClient: Keyword not supported: 'authentication'

The exception is expected for now, check the ...thread.......SqlClient for .NET Core still does not support using the 'authentication' keyword in the connection string. That will happen when ...this issue... is actually fixed....In order to use AAD in the new version of SqlClient in .NET Core 2.2, customers need to obtain the access token themselve...
.net-core azure azure-functions azure-sql-database entity-framework-core
asked by Jerry Liu

Entity Framework Core DbContext.SaveChanges throws System.InvalidCastException: Unable to cast object of type System.Boolean to type System.Int16

I am using .net core 2.2 with entity framework using MySql.Data.EntityFramework.Core. Bump into this exception when I do the following:...DbContext.MyDbSet.Add(new MyClass()); DbContext.SaveChanges(); ...Exception:...System.InvalidCastException: Unable to cast object of type System.Boolean to type System.Int16...I have added the following code sn...
c# entity-framework-core exception mysql
asked by Kok How Teh

System.PlatformNotSupportedException: System.Data.SqlClient is not supported on this platform

I got it working in the test project by adding a reference to System.Data.SqlClient 4.5.0.1
.net-core .net-standard entity-framework-core
asked by Kirsten Greed

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge
View more on Stack Overflow

Prime Library

Performance

Expression Evaluator

More Projects...

Related

Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow