c#将文件转成流存入SqlServer数据库

数据表内存放流的字段数据类型为：image

//存 
private void Button_Click(object sender, RoutedEventArgs e)
{
     var time = DateTime.Now;
     string filePath = @"C:\Users\Hoteam\Downloads\测试.txt";
     FileStream fs = new FileStream(filePath, FileMode.Open);
     BinaryReader br = new BinaryReader(fs);
     Byte[] byData = br.ReadBytes((int)fs.Length);
     fs.Close();
     string conn = @"server=HOTEAM-PC\MSSQLSERVER2012;database=Text;Uid=sa;Pwd=123 ";
     SqlConnection myconn = new SqlConnection(conn);
     myconn.Open();
     string str = "insert into fileInfo (fileName,fileStream) values('测试文件',@file)";
     SqlCommand mycomm = new SqlCommand(str, myconn);
     mycomm.Parameters.Add("@file", SqlDbType.Image, byData.Length);
     mycomm.Parameters["@file"].Value = byData;
     mycomm.ExecuteNonQuery();
     myconn.Close();
     var time2 = DateTime.Now;
     MessageBox.Show(time+"-"+time2);
 }

//取
 private void Button_Click_1(object sender, RoutedEventArgs e)
 {
     var time = DateTime.Now;
     string conn = @"server=HOTEAM-PC\MSSQLSERVER2012;database=Text;Uid=sa;Pwd=123 ";
     string str = "select fileStream from fileInfo where fileName='测试文件' ";
     SqlConnection myconn = new SqlConnection(conn);
     SqlDataAdapter sda = new SqlDataAdapter(str, conn);
     DataSet myds = new DataSet();
     myconn.Open();
     sda.Fill(myds);
     myconn.Close();
     Byte[] Files = (Byte[])myds.Tables[0].Rows[0]["fileStream"];
     BinaryWriter bw = new BinaryWriter(File.Open(@"D:\测试文件.txt", 
     FileMode.OpenOrCreate));
     bw.Write(Files);
     bw.Close();
     var time2 = DateTime.Now;
     MessageBox.Show(time + "-" + time2);
}