SQLHelper and Binary Large Objects

Aug 10, 2012 at 9:27 AM

Hi,

first I want to thank you for this great libary! Its helping me all day ;-)

May ask if the GetParameter Function From helper.ExecuteReader supports binary large objects?

 

Michael

Aug 10, 2012 at 2:38 PM

To be honest, I haven't used Blobs in a while so I had to double check, but yes it does. All you would do is:

byte[] Data = helper.GetParameter<byte[]>("BlobDataColumn", null);

If it's an Image, varbinary, or binary data. And it converts byte arrays appropriately when adding them as a parameter also.

Aug 10, 2012 at 5:54 PM

Thanks for your quick response.Tried it and it's running - great!

Michael