Entity Framework Core throws SqlNullValueException when loading entities from DbContext

Question

I have this MyEntity table in the database:

The data inside MyEntity is the following:

The EF Core entity is the following:

public class MyEntity
{
    public int Id { get; set; }
    public int MyInt { get; set; }
}

I am getting an exception:

System.Data.SqlTypes.SqlNullValueException: 'Data is Null. This method or property cannot be called on Null values.'

when trying to load the MyEntity from the DbContext:

var myEntities = dbContext.Set<MyEntity>.ToList();

What am I doing wrong?

Jogge · Accepted Answer · 2020-05-26 05:59:02Z

2

You are getting this error because the MyInt in your MyEntity database table is nullable, and one of the rows you are trying to load has a MyInt set to null.

To fix this, just change the type of your MyInt property in your entity to Nullable<int> or int?:

public class MyEntity
{
    public int Id { get; set; }
    public int? MyInt { get; set; }
}

answered May 26, 2020 at 5:59

Jogge

1,88218 silver badges40 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Entity Framework Core throws SqlNullValueException when loading entities from DbContext

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related