c#读取oracle blob生成dwg

string connstring2 = “Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=******)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=*)));User Id=;Password=*********”;

private void button3_Click(object sender, EventArgs e)

{

OracleConnection con = new OracleConnection(connstring2);

con.Open();

string sql = “select * from TEMP_001 t”;

OracleCommand com = new OracleCommand(sql, con);

OracleDataReader rs = com.ExecuteReader();

while (rs.Read())

{

byte[] File = (byte[])rs["MAP_FILE"];
string nm = (string)rs["ADDRESS"];
           

FileInfo fi=new FileInfo(“F://”+nm+".dwg");

FileStream fs=fi.OpenWrite();

fs.Write(File,0,File.Length);

fs.Flush();

fs.Close();

}

rs.Close();

com.Dispose();

con.Dispose();

con.Close();

this.label1.Text = “Ok”;

}