关于 数据库中 读写 Blob 字段的正确做法。

被一个小问题给恶心了一回。

留影，备查。

class BolbHelper
    {
        /// <summary>
        /// 将图像转为二进制字节数组
        /// </summary>
        /// <param name="image"></param>
        /// <returns></returns>
        public static byte[] ImageToBinaryBytes(Image image)
        {
            byte[] result;
            using (var ms = new MemoryStream())
            {
                image.Save(ms, ImageFormat.Bmp);
                using(var br = new BinaryReader(ms))
                {
                    ms.Seek(0, SeekOrigin.Begin);
                    result = br.ReadBytes((int)ms.Length);
                    br.Close();
                }
                ms.Close();
            }
            return result;
        }

        /// <summary>
        /// 从二进制字节数组读取图像
        /// </summary>
        /// <param name="data"></param>
        /// <returns></returns>
        public static Image ImageFromBinaryBytes(byte[] data)
        {
            Image result;
            using (var ms = new MemoryStream())
            {
                using(var bw = new BinaryWriter(ms))
                {
                    bw.Write(data);
                    result = Image.FromStream(ms);
                    bw.Close();
                }
                ms.Close();
            }
            return result;
        }
    }