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()