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

c# entity-framework-core exception mysql

Question

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 snippet into OnModelCreating function:

            foreach (var entityType in modelBuilder.Model.GetEntityTypes())
                foreach (var property in entityType.GetProperties())
                    if (property.ClrType == typeof(bool) || property.ClrType == typeof(Boolean))
                        property.SetValueConverter(new BoolToZeroOneConverter<Int16>());

What do I miss?

1
0
6/3/2019 10:30:28 AM

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Accepted Answer

This was due to database schema and model mismatch and I added the following to fix the issue:

                    else if (property.ClrType == typeof(Nullable<bool>) || property.ClrType == typeof(Nullable<Boolean>))
                        property.SetValueConverter(new BoolToZeroOneConverter<Nullable<Int16>>());
1
6/5/2019 4:06:33 AM

Popular Answer

try belove code:

[Required]
[Column(TypeName = "BIT")]
public bool IsDelete { get; set; }
bdangvnt

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

The type initializer for 'System.Data.Entity.Internal.AppConfig' threw an exception on a Sub Website

In EF6 you can use Code Base configuration - take a look at ...this... article for more details....EDIT...I checked in a ...change... to EF6 code where exact duplicates are ignored. This should solve your problem. Note that this did not fit in the 6.0.2 release and should be included in the next release after 6.0.2.
c# entity-framework entity-framework-6 nuget
asked by Pawel

Unable to determine the provider name for provider factory of type "System.Data.Sqlite.SqliteFactory"

I got the answer by myself, but I still don't know the root cause, now it works. I changed webconfig, here is the webconfig that make my project to work....I added a provider that is "System.Data.Sqlite", Please note its type that is same with System.Data.Sqlite.EF6... <provider invariantName="System.Data.SQLite" type="System.Data.SQLite.EF6.SQLit...
c# entity-framework entity-framework-6 sqlite visual-studio-2013
asked by zhnglicho

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'

Is there a reason behind this line...csProduct.ProductNo = 0; ...the framework will assign the key after save. ...Just remove that line, If you want the ID then after .SaveChanges(); then check the ID value of the Entity. ...csRepository.CSContext.SaveChanges(); var NewID = csProduct.ProductNo;
c# entity-framework-core sql-server
asked by Joe Ricklefs

EF AsNoTracking Causes error. Expression of type 'System.DateTime' cannot be used for assignment to type 'System.Nullable`1[System.DateTime]'

It's caused by EF Core bug introduced in v2.1....Reported and tracked by ...#12215: Exception when loading entity containing a primitive property with matching System.Nullable backing field.......No workaround provided, fix scheduled for v2.2....What I can suggest is to force EF using the property rather than the backing field:...protected override...
c# ef-core-2.1 entity-framework entity-framework-core
asked by Ivan Stoev

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

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

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). Otherw...
.net-core c# entity-framework-core mysql
asked by Bradley Grainger

Unable to create a constant value of type 'System.Tuple

EF6 does not support (cannot translate to SQL) ...Tuple.Create... (and ...Tuple<>... constructors), in-memory collection joins, ...Contains... of in-memory collection on non primitive types and many others....The solution in your case is to replace (int year, int month) pair with primitive type expression like this:...int period = 12 * year + (mont...
c# entity-framework entity-framework-6 linq
asked by Ivan Stoev

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