The OracleDataReader.GetDateTime(int i) method throws an InvalidCastException :Column contains NULL data  whenever the column in any row contains null data.

How to solve this problem？

Thanks,

Error Message:

An unhandled exception occurred while processing the request.

InvalidCastException: Column contains NULL data

Oracle.ManagedDataAccess.Client.OracleDataReader.GetDateTime(int i)

• Stack
• Query
• Cookies
• Headers

• InvalidCastException: Column contains NULL data

  • Oracle.ManagedDataAccess.Client.OracleDataReader.GetDateTime(int i)

  • lambda_method(Closure , DbDataReader )

  • Microsoft.EntityFrameworkCore.Storage.Internal.TypedRelationalValueBufferFactory.Create(DbDataReader dataReader)

  • Microsoft.EntityFrameworkCore.Query.Internal.AsyncQueryingEnumerable<T>+AsyncEnumerator.BufferlessMoveNext(DbContext _, bool buffer, CancellationToken cancellationToken)

  • Oracle.EntityFrameworkCore.Storage.Internal.OracleExecutionStrategy.ExecuteAsync<TState, TResult>(TState state, Func<DbContext, TState, CancellationToken, Task<TResult>> operation, Func<DbContext, TState, CancellationToken, Task<ExecutionResult<TResult>>> verifySucceeded, CancellationToken cancellationToken)

  • Microsoft.EntityFrameworkCore.Query.Internal.AsyncQueryingEnumerable<T>+AsyncEnumerator.MoveNext(CancellationToken cancellationToken)

  • System.Linq.AsyncEnumerable+SelectEnumerableAsyncIterator<TSource, TResult>.MoveNextCore(CancellationToken cancellationToken) in Select.cs

  • System.Linq.AsyncEnumerable+AsyncIterator<TSource>.MoveNext(CancellationToken cancellationToken) in AsyncIterator.cs

  • Microsoft.EntityFrameworkCore.Query.Internal.AsyncLinqOperatorProvider+ExceptionInterceptor<T>+EnumeratorExceptionInterceptor.MoveNext(CancellationToken cancellationToken)

  • System.Linq.AsyncEnumerable.Aggregate_<TSource, TAccumulate, TResult>(IAsyncEnumerable<TSource> source, TAccumulate seed, Func<TAccumulate, TSource, TAccumulate> accumulator, Func<TAccumulate, TResult> resultSelector, CancellationToken cancellationToken) in Aggregate.cs

  • i9kun.Business.Controllers.Customs.CtmiehdrController.Index() in CtmiehdrController.cs

    +
    27.   return View(await _context.Ctm_ie_hdrs.ToListAsync());