Breaking Change in 8.0.4: System.InvalidOperationException: The data is NULL at ordinal 0. This method can't be called on NULL values. Check using IsDBNull before calling. #33547
Description
File a bug
I have run into this problem when upgrading from 8.0.3 to 8.0.4.
I have a Parent type that contains an optional Child.
public class Parent { public int Id { get; set; } public Child? Child { get; set; } } The Child contains a simple type, that is saved as a ComplexProperty.
public class Child { public int Id { get; set; } public required Complex Complex { get; set; } public bool Deleted { get; set; } } There is a QueryFilter defined for the Child (simple bool property "Deleted").
public class ApplicationDbContext : DbContext { public DbSet<Parent> Parents { get; set; } public ApplicationDbContext(DbContextOptions<ApplicationDbContext> options) : base (options) { } protected override void OnModelCreating(ModelBuilder modelBuilder) { base.OnModelCreating (modelBuilder); modelBuilder.Entity<Child> () .ComplexProperty (x => x.Complex); modelBuilder.Entity<Child> ().HasQueryFilter (x => !x.Deleted); } } The Complex type contains a enum.
public class Complex { public MyEnum Enum { get; set; } } public enum MyEnum { None = 0, Enabled = 1, } When I now try to query the enum coming from the Parent type though the Child and Complex types, I want the result to be null, if the (optional) Child is not set (is null).
var my_enum = db_context.Parents .Select (p => p.Child != null ? (MyEnum?)p.Child.Complex.Enum : null) .FirstOrDefault (); But i get a InvalidOperationException instead.
Downgrading back to 8.0.3 restores the expected behavior again.
Include your code
I have created a small solution with one console project to reproduce the problem:
efcore-enum-in-optional-complex-property-with-queryfilter-repro.zip
It creates a sqlite database (deleting any existing "test.db" file beforehand) so you should be able to just run it (again and again) to reproduce the exception.
Stack traces
Unhandled exception. System.InvalidOperationException: An error occurred while reading a database value. The expected type was 'efcore_enum_in_optional_complex_property_repro.Entites.MyEnum' but the actual value was null. ---> System.InvalidOperationException: The data is NULL at ordinal 0. This method can't be called on NULL values. Check using IsDBNull before calling. at Microsoft.Data.Sqlite.SqliteValueReader.GetInt64(Int32 ordinal) at Microsoft.Data.Sqlite.SqliteValueReader.GetInt32(Int32 ordinal) at Microsoft.Data.Sqlite.SqliteDataReader.GetInt32(Int32 ordinal) at lambda_method31(Closure, QueryContext, DbDataReader, ResultContext, SingleQueryResultCoordinator) --- End of inner exception stack trace --- at lambda_method31(Closure, QueryContext, DbDataReader, ResultContext, SingleQueryResultCoordinator) at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.Enumerator.MoveNext() at System.Linq.Enumerable.TryGetSingle[TSource](IEnumerable`1 source, Boolean& found) at lambda_method32(Closure, QueryContext) at Microsoft.EntityFrameworkCore.Query.Internal.QueryCompiler.Execute[TResult](Expression query) at Microsoft.EntityFrameworkCore.Query.Internal.EntityQueryProvider.Execute[TResult](Expression expression) at System.Linq.Queryable.FirstOrDefault[TSource](IQueryable`1 source) at Program.<<Main>$>g__Act|0_2(<>c__DisplayClass0_0&) in %path-to-repos%\efcore-enum-in-optional-complex-property-with-queryfilter-repro\efcore-enum-in-optional-complex-property-repro\Program.cs:line 49 at Program.<Main>$(String[] args) in %path-to-repos%\efcore-enum-in-optional-complex-property-with-queryfilter-repro\efcore-enum-in-optional-complex-property-repro\Program.cs:line 12 Include provider and version information
EF Core version: 8.0.4 (still works in 8.0.3)
Database provider: Microsoft.EntityFrameworkCore.Sqlite 8.0.4 (same error happens with Microsoft.EntityFrameworkCore.SqlServer 8.0.4)
Target framework: .NET 8.0
Operating system: Windows 11
IDE: Visual Studio 2022 17.9.5