cannot convert from 'System.Data.Linq.Binary' to 'System.IO.BinaryReader'

Question

my table column is:

AttachContent   varbinary   (max)

when i try to retrieve the data and i get this below error, i am using linq

cannot convert from 'System.Data.Linq.Binary' to 'System.IO.BinaryReader'

Answer 1

System.Data.Linq.Binary contains a byte array. You can use it directly like this:

Binary binary = //your linq object
byte[] array = binary.ToArray();

If you must have a BinaryReader on the byte array you can wrap it up like this:

BinaryReader reader = new BinaryReader(new MemoryStream(binary.ToArray()));