在oracle数据库中插入blob,使用C#在oracle数据库中插入blob

这是一个使用c#和过程在oracle中插入blob数据的示例(你说更喜欢这意味着你可能).

using System;

using System.Data;

using Oracle.DataAccess.Client;

using Oracle.DataAccess.Types;

using System.IO;

using System.Text;

//Step 1

// Connect to database

// Note: Modify User Id, Password, Data Source as per your database setup

string constr = "User Id=Scott;Password=tiger;Data Source=orcl9i";

OracleConnection con = new OracleConnection(constr);

con.Open();

Console.WriteLine("Connected to database!");

// Step 2

// Note: Modify the Source and Destination location

// of the image as per your machine settings

String SourceLoc = "D:/Images/photo.jpg";

String DestinationLoc = "D:/Images/TestImage.jpg";

// provide read access to the file

FileStream fs = new FileStream(SourceLoc, FileMode.Open,FileAccess.Read);

// Create a byte array of fi