.Net equivalent of Oracle CLOB and BLOB

In my C#.Net application, I am developing a business object based on a table in
an Oracle database.  One of the table fields is defined as CLOB and another as BLOB:

ID                               NUMBER(9)
VALUESNAME          CLOB
VALUESBINARY       BLOB


In my business object class, what .Net datatype should I use when defining those
properties?  What is the .Net equivalent of CLOB and BLOB:

public class TestObject
    {
        private Int32 userid;;
        private ??? valuesstring;
        private ??? valuesbinary;

    }


Thanks!
JeffDrummondAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
WarpsehConnect With a Mentor Commented:
If i'm not mistaken, the type you are looking for is System.Data.OracleClient.OracleLob :)
0
 
WarpsehCommented:
The OracleLob.LobType Will tell you which kind of LOB is (System.Data.OracleClient.OracleType.Clob or System.Data.OracleClient.OracleType.Blob or many others)
0
All Courses

From novice to tech pro — start learning today.