SqlConnection con = new SqlConnection(TConst.ConnectionString);
      SqlCommand qUpdate = new SqlCommand(
              "update Ref_PersonPhoto " +
              "set RPF_Preview=@Preview " +
              "where RPF_ID=@ID"
      , con);
      qUpdate.CommandType = CommandType.Text;
      //qUpdate.CommandTimeout = 900;
      SqlCommand query = new SqlCommand(
        "select top 3 RPF_Photo,RPF_ID from Ref_PersonPhoto " +
        "where RPF_Photo is not null and RPF_Preview is null and len(RPF_Photo)>0" +
        TTools.IIF(PersonID=="","", " and RPF_PersonID="+ PersonID)
      , con);
      query.CommandType = CommandType.Text;
      query.CommandTimeout = 9000;
      SqlDataReader dr = null;
      int pSize = 100;
      bool rep = false;
      try {
        con.Open();
        dr = query.ExecuteReader();
        rep = dr.HasRows;
        while (dr.Read()) {
          byte[] b = null;
          b = (byte[])dr["RPF_Photo"];
          //b.Length
          Image<Rgba32> image = Image.Load(b, out IImageFormat mimeType);
          decimal coef = TTools.IIF(
              image.Width > image.Height,
              pSize/ Convert.ToDecimal(image.Width),
              pSize / Convert.ToDecimal(image.Height)
          );
          image.Mutate(ctx => ctx.Resize(Convert.ToInt32(image.Width* coef), Convert.ToInt32(image.Height* coef)));
          var memoryStream = new MemoryStream();
          image.Save(memoryStream, mimeType);
          memoryStream.Flush();
          qUpdate.Parameters.Clear();
          //qUpdate.Parameters["ID"].Value       = dr["RPF_ID"].ToString();
          //qUpdate.Parameters["Preview"].Value  = memoryStream.ToArray();

          qUpdate.Parameters.AddWithValue("@ID", dr["RPF_ID"].ToString());
          qUpdate.Parameters.AddWithValue("@Preview", memoryStream.ToArray());
          qUpdate.ExecuteNonQuery();
          //qUpdate.Dispose();

          memoryStream.Close();
          memoryStream.Dispose();
          image.Dispose();
        }
      } catch (Exception e) {
        TTools.Trace(e.Message);

      }
      dr.Close();
      query.Dispose();
      qUpdate.Dispose();
      con.Close();
      con.Dispose();