value NOTHING can appear in the Object() array filled by the OleDBDataReader ?

  • Thread starter Thread starter pamela fluente
  • Start date Start date
P

pamela fluente

I am using an OledbDataReader to read each record into an array of
objects, as usual.


My question is:

is it ever possible that one of the values contained in the array be
Nothing.

I have never seen it happen and I would believe it is impossible.

Can anyone confirm that ? And in case what is the reason ?


-P
 
pamela said:
I am using an OledbDataReader to read each record into an array of
objects, as usual.


My question is:

is it ever possible that one of the values contained in the array be
Nothing.

I have never seen it happen and I would believe it is impossible.

Can anyone confirm that ? And in case what is the reason ?


-P
Click to expand...

It's my understanding that it can't happen, NULL values are always
specified as DBNull.Value.

In general, use the native ADO.NET providers instead of oledb to be
sure.

FB

--
------------------------------------------------------------------------
Lead developer of LLBLGen Pro, the productive O/R mapper for .NET
LLBLGen Pro website: http://www.llblgen.com
My .NET blog: http://weblogs.asp.net/fbouma
Microsoft MVP (C#)
------------------------------------------------------------------------
 
It's my understanding that it can't happen, NULL values are always
specified as DBNull.Value.

In general, use the native ADO.NET providers instead of oledb to be
sure.

FB

--
------------------------------------------------------------------------
Lead developer of LLBLGen Pro, the productive O/R mapper for .NET
LLBLGen Pro website:http://www.llblgen.com
My .NET blog:http://weblogs.asp.net/fbouma
Microsoft MVP (C#)
------------------------------------------------------------------------- Nascondi testo tra virgolette -

- Mostra testo tra virgolette -
Click to expand...

Thanks Frans,

I wanted to make sure that programmatically I only need to check for
dbNull values.

So far I have never neen a Nothing value. But perhaps did not try
hard enough.

I was wondering if perhaps it is actually impossible for some
technical reason (OleDB implementation).

I do have seen however an "Object" type (which is somehow curious).
So I was wondering whether it could also
spit a Nothing value.

BTW I am considering OleDb (and only that) because I am doing a
cross work among many different platforms.

-P
 
Back
Top