In .Net Framework 2.0 (VS2005) I'm having problems deserializing binary data
that was serialized and stored in a mysql 5.0 longblob field (stored via the
mysql data connector datareader object). I have modified the code to try
various suggestions I've seen in the forums, but no luck so far. Thanks in
advance for any light you can shed on this....

The error is "End of Stream encountered before parsing was completed."

The code used to serialize is:

               Stream stream = new System.IO.FileStream("BinFile.bin",
                               FileMode.Create,
                               FileAccess.Write,
                               FileShare.None);
               formatter.Serialize(stream,_DataValue.BinDataArray);
               stream.Close();

               //store binary data in approp db field.
               this._ParentObject.CurrentData.Value_Binary =
GetBinaryData("BinFile.bin");

//the GetBinaryData function is:
private static byte[] GetBinaryData(string filePath)
           {

               System.IO.FileStream bstream = new FileStream(
                   filePath,FileMode.Open, FileAccess.Read);
               BinaryReader reader = new BinaryReader(bstream);

               byte[] BinaryOut = reader.ReadBytes((int)bstream.Length);
             
               reader.Close();
               bstream.Close();
               return BinaryOut;
           }

The code used to deserialize is:

              FileStream stream;
               BinaryWriter writer;

             .
             .
             .

               
               
               int bufSize = 100000;  //originally 100, I made it 100000
trying to see
                                                //if that would help this
problem
               byte[] buff = new byte[bufSize];
               long retval = 0;
               long startIndex = 0;
               .
               .
               .

                   stream = new FileStream("DataBinFile.bin",
FileMode.OpenOrCreate, FileAccess.Write);
                   writer = new BinaryWriter(stream);

                   startIndex = 0;

                   //dr is an already open mysqlconnector datareader - like
any ado.net
                   //datareader
                   retval = dr.GetBytes(dr.GetOrdinal("Value_Binary"),
startIndex, buff, 0, bufSize);

                   while (retval == bufSize)
                       {
                       writer.Write(buff);
                       writer.Flush();

                       startIndex += bufSize;
                       retval = dr.GetBytes(dr.GetOrdinal("Value_Binary"),
startIndex, buff, 0, bufSize);
                       }
                   
                   
                   //let's try putting the stream back to the beginning of
the file
                   stream.Seek(0, SeekOrigin.Begin);
                   writer.Close();
                   stream.Close();
                   }
               dr.Close();
               
                       
               IFormatter formatter = new BinaryFormatter();

               Stream dstream = new System.IO.FileStream("DataBinFile.bin",
                               FileMode.Open,
                               FileAccess.Read,
                               FileShare.Read);
               dstream.Seek(0, SeekOrigin.Begin);
               //the error occurs when I go to execute the next line of code
               //to deserialize
               _MyValueArray =
(DataCollBinValue)formatter.Deserialize(dstream);
               
               dstream.Close();