C#中通过OleDb操作Oracle Blob数据类型

使用数据源为System.Data.Oledb,Provider为Oracle Provider For .Net
没用OracleClient，因为这个只能用在Oracle
Provider要改为Oracle Proider form Net,默认的MS Oledb For Oracle不支持高版本Oracle（8.0以上）
ConnectionString如下：
Provider=OraOLEDB.Oracle.1;Password=“”;Persist Security Info=True;User ID=“”;Data Source=“”

获取Lob数据
DataAdpter.Fill(DataSet);
通过DataType判断为Lob后
强制转化该列为byte[]

if  ( ds.Tables[ " tAttrFile " ].Columns[sFieldName].DataType  ==   typeof (System.Byte[]))
                         {
                            byte[] MyData= (byte[]) ds.Tables["tAttrFile"].Rows[j][sFieldName];
                            int ArraySize = new int();
                            ArraySize = MyData.GetUpperBound(0);

                            FileStream fs = new FileStream(sTempFileName,FileMode.OpenOrCreate, FileAccess.Write);
                            fs.Write(MyData, 0,ArraySize + 1);
                            fs.Close();
                        }                                                 

插入、修改Lob数据
使用Command的Parameters，类型为Binary

byte [] data  =  cs.Base64DecodeEx(sData);

                cmd[ 0 ]  =   new  System.Data.OleDb.OleDbCommand();
                cmd[ 0 ].CommandText  =   " delete from  "   +  sTableName  +   "  where sProjID=' "   +  sProjID  +
                     " ' and iDegree= "   +  iDegree.ToString();
            
                cmd[ 1 ]  =   new  System.Data.OleDb.OleDbCommand();
                cmd[ 1 ].CommandText  =   " insert into  "   +  sTableName + "  (sProjID,iDegree, "    +  sFieldName  +   " ) values (' "   +  
                    sProjID  +   " ', " +  iDegree.ToString()  +   " ,:bData) " ;
                cmd[ 1 ].Parameters.Add( " bData " ,System.Data.OleDb.OleDbType.Binary,data.Length);
                cmd[ 1 ].Parameters[ " bData " ].Value  =  data;
                iResult  =  db.ExecuteSqls(cmd, 2 );    

 

转载于:https://www.cnblogs.com/calmzeal/archive/2006/04/19/379109.html