c# system.byte[] sql更新到数据库

将byte[]数据更新存入数据库,开始用了Dapper的Execute方法,不行

然后又用了 Dapper的Update方法,还是不行

纳闷了,看来得自己写SQL了,设置参数类型为SqlDbType.VarBinary,可以了

 String ConnectString = ConfigurationManager.AppSettings["ConnectionStrings"].ToString();

 string sql = "UPDATE ADS_Card SET FingerDataTwo = @FingerDataTwo WHERE UserId = @UserId";
                SqlConnection con = new SqlConnection(ConnectString);
                SqlCommand cmd = new SqlCommand(sql, con);               
                cmd.Parameters.Add("@FingerDataTwo", SqlDbType.VarBinary).Value = objectCard.FingerDataTwo;
                cmd.Parameters.Add("@UserId", SqlDbType.Int).Value = objectCard.UserId;
                con.Open();
                cmd.ExecuteNonQuery();
                con.Close();