<div>
The OracleLob.LobType Will tell you which kind of LOB is (System.Data.OracleClient.<wbr />OracleType<wbr />.Clob or System.Data.OracleClient.O<wbr />racleType.<wbr />Blob or many others)
</div>


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)

<div>
<div class="content wysiwyg-content">
In my C#.Net application, I am developing a business object based on a table in<br />
an Oracle database. &nbsp;One of the table fields is defined as CLOB and another as BLOB:<br />
<br />
ID &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; NUMBER(9)<br />
VALUESNAME &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;CLOB<br />
VALUESBINARY &nbsp; &nbsp; &nbsp; BLOB<br />
<br />
<br />
In my business object class, what .Net datatype should I use when defining those<br />
properties? &nbsp;What is the .Net equivalent of CLOB and BLOB:<br />
<br />
public class TestObject<br />
&nbsp; &nbsp; {<br />
&nbsp; &nbsp; &nbsp; &nbsp; private Int32 userid;;<br />
&nbsp; &nbsp; &nbsp; &nbsp; private ??? valuesstring;<br />
&nbsp; &nbsp; &nbsp; &nbsp; private ??? valuesbinary;<br />
<br />
&nbsp; &nbsp; }<br />
<br />
<br />
Thanks!
</div>
</div>


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!

.Net equivalent of Oracle CLOB and BLOB

The .NET Framework is not specific to any one programming language; rather, it includes a library of functions that allows developers to rapidly build applications. Several supported languages include C#, VB.NET, C++ or ASP.NET.