class Program {

 static void Main(string[] args) {

  var result = new CWSearch().FetchFiles(DatabaseConnection.GetConnection("Server=loptst.wisegrid.net;database=OdysseyLOPTST;user=EnterpriseDBUser_OdysseyLOPTST_Database.Reader;password=rr123"));

​

  foreach(var file in result) {

   var bytes = Enumerable.Range(0, file.Data.Length)

    .Where(x => x % 2 == 0)

    .Select(x => Convert.ToByte(file.Data.Substring(x, 2), 16))

    .ToArray();

​

   try {

    byte[] dst = new byte[bytes.Length - 2];

​

    Array.Copy(bytes, 2, dst, 0, dst.Length);

    File.WriteAllBytes($ "{file.FileName}.pdf", Decompress(dst));

   } catch (Exception ex) {

    ;

   }

  }

 }

​

 public static byte[] Decompress(byte[] data) {

  MemoryStream input = new MemoryStream(data);

  MemoryStream output = new MemoryStream();

  using(DeflateStream dstream = new DeflateStream(input, CompressionMode.Decompress)) {

   dstream.CopyTo(output);

  }

  return output.ToArray();

 }

}