前几天,需要弄个工具把数据库中的IMAGE字段读出生成实体文件。居然弄了10+分钟,郁闷。特此留下标记,对自己以示警告:
using System;
using System.Collections.Generic;
using System.Text;
using System.IO;
using System.Data.SqlClient;
namespace ConsoleApp
{
class Program
{
static void Main(string[] args)
{
SqlConnection conn = new SqlConnection("myConnectionString");
conn.Open();
SqlCommand command = new SqlCommand("myCommandText", conn);
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
byte[] writer = (byte[])reader["imageColumn"];
string fileDir = @"myImageDir";
if (!Directory.Exists(fileDir))
Directory.CreateDirectory(fileDir);
using (FileStream fos = new FileStream(
string.Format(@"{0}\{1}.jpg", fileDir, reader["imageName"].ToString()),
FileMode.OpenOrCreate, FileAccess.ReadWrite))
{
fos.Write(writer, 0, writer.Length);
fos.Close();
}
}
reader.Dispose();
command.Dispose();
conn.Close();
}
}
}