DBNull exception on Nullable foreign key while using AsSplitQuery() latest EF Core

Viewed 9

Here is my Exception. I am doing .Include on a Foreign Key reference and when I run it as a split query I get this exception.

   at Microsoft.Data.SqlClient.SqlDataReader.GetFieldValueFromSqlBufferInternal[T](SqlBuffer data, _SqlMetaData metaData)

at Microsoft.Data.SqlClient.SqlDataReader.GetFieldValue[T](Int32 i) at Microsoft.EntityFrameworkCore.Query.Internal.BufferedDataReader.BufferedDataRecord.ReadObject(DbDataReader reader, Int32 ordinal, ReaderColumn column) at Microsoft.EntityFrameworkCore.Query.Internal.BufferedDataReader.BufferedDataRecord.ReadRow() at Microsoft.EntityFrameworkCore.Query.Internal.BufferedDataReader.BufferedDataRecord.d__90.MoveNext() at Microsoft.EntityFrameworkCore.Query.Internal.BufferedDataReader.d__27.MoveNext() at Microsoft.EntityFrameworkCore.Query.Internal.BufferedDataReader.d__27.MoveNext() at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.d__19.MoveNext() at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.d__19.MoveNext() at Microsoft.EntityFrameworkCore.Query.Internal.SplitQueryingEnumerable1.AsyncEnumerator.<InitializeReaderAsync>d__20.MoveNext() at Microsoft.EntityFrameworkCore.SqlServer.Storage.Internal.SqlServerExecutionStrategy.<ExecuteAsync>d__72.MoveNext() at Microsoft.EntityFrameworkCore.Query.Internal.SplitQueryingEnumerable1.AsyncEnumerator.<MoveNextAsync>d__19.MoveNext() at Microsoft.EntityFrameworkCore.Query.ShapedQueryCompilingExpressionVisitor.<SingleOrDefaultAsync>d__151.MoveNext() at Microsoft.EntityFrameworkCore.Query.ShapedQueryCompilingExpressionVisitor.d__15`1.MoveNext()

0 Answers
Related