associative array type for blob column in the table

 // (1) read in the file to be saved as a blob in the database
  FileStream input = new FileStream(filename, FileMode.Open, 
                                         FileAccess.Read);
  byte[] buffer = new byte[(int)input.Length];
  input.Read(buffer, 0, buffer.Length);
  // (2) insert empty blob in the database
  cn = GetConnection();
  tx = cn.BeginTransaction();
  cmd = new SqlCommand("dbo.stp_AddBLOB", cn, tx);
  cmd.CommandType = System.Data.CommandType.StoredProcedure;
  SqlDataReader r = cmd.ExecuteReader(
      System.Data.CommandBehavior.SingleRow);
  r.Read();
  string id = r[0].ToString();
  string path = r[1].ToString();
  r.Close();
  // (3) get the transaction context
  cmd2 = new SqlCommand("SELECT GET_FILESTREAM_TRANSACTION_CONTEXT()", 
                cn, tx);
  Object obj = cmd2.ExecuteScalar();
  byte[] txCtx = (byte[])obj;
  // (4) open the filestream to the blob
  SafeFileHandle handle = OpenSqlFilestream(
      path,
      DESIRED_ACCESS_WRITE,
      SQL_FILESTREAM_OPEN_NO_FLAGS,
      txCtx,
      (UInt32)txCtx.Length,
      0);
  // (5) open a Filestream to write the blob
  FileStream output = new FileStream(
      handle,
      FileAccess.Write,
      buffer.Length,
      false);
  output.Write(
      buffer,
      0,
      buffer.Length);
      output.Close();

// Construct INSERT Command
SqlCommand StoredProcedureCommand = new SqlCommand("array_insert", conn);

addEmp.Parameters.Add("@p_job_id",  SqlDbType.VarChar, 2).Value = pjobid;
addEmp.Parameters.Add("@p_job_title", SqlDbType.NVarChar, 35).Value = ptitle;
addEmp.Parameters.Add("@p_min_salary",     SqlDbType.Number).Value = pminSalery;
addEmp.Parameters.Add("@p_max_salary",  SqlDbType.Number).Value = pmaxSalery;
addEmp.Parameters.Add("@ReportsTo", SqlDbType.Int).Value          = preportsTo;
addEmp.Parameters.Add("@P_JOBPIC",     SqlDbType.Image, photo.Length).Value = photo;
 _conn.Open();
addEmp.ExecuteNonQuery();
_conn.Close();