Unable to cast object of type 'System.Data.Linq.Binary' to type 'System.Byte[]'

Question

Receiving the error 'Unable to cast object of type 'System.Data.Linq.Binary' to type 'System.Byte[]'.' In visual studio. I am have images stored in a sql server db that I am displaying in a treeview format. I can open the dbml designer and change all the System.Data.Linq.Binary to System.Byte but the images come out fuzzy and blurry. Any thoughts?

Here is the code:

public class ImageBytesConverter : IValueConverter
{
    public object Convert(object value, Type targetType, object parameter,
        System.Globalization.CultureInfo culture)
    {
        BitmapImage bitmap = new BitmapImage();

        if (value != null)
        {
            byte[] photo = (byte[])value;
            MemoryStream stream = new MemoryStream();


            int offset = 78;
            stream.Write(photo, offset, photo.Length - offset);

            bitmap.BeginInit();
            bitmap.StreamSource = stream;
            bitmap.EndInit();
        }

        return bitmap;
    }
}

Posting some code may allow us to help.

Richard Schneider
– Richard Schneider

2013-02-24 23:32:33 +00:00
Commented Feb 24, 2013 at 23:32 — Richard Schneider
– Richard Schneider, Commented Feb 24, 2013 at 23:32
Having wrong icon size can cause blurred icons.

Dialecticus
– Dialecticus

2013-02-24 23:42:47 +00:00
Commented Feb 24, 2013 at 23:42 — Dialecticus
– Dialecticus, Commented Feb 24, 2013 at 23:42
dup of stackoverflow.com/questions/14029967/…

Joe
– Joe

2014-10-30 16:39:29 +00:00
Commented Oct 30, 2014 at 16:39 — Joe
– Joe, Commented Oct 30, 2014 at 16:39

sa_ddam213 · Accepted Answer · 2013-02-24 23:46:44Z

You will have to use the ToArray method from Binary to get the byte[] value.

public class BinaryToByteArrayConverter : IValueConverter
{
    public object Convert(object value, Type targetType, object parameter, CultureInfo culture)
    {
        if (value != null && value is System.Data.Linq.Binary)
        {
            byte[] array = (value as System.Data.Linq.Binary).ToArray();
            BitmapImage bitmap = new BitmapImage();

            using (MemoryStream stream = new MemoryStream())
            {
                int offset = 78;
                stream.Write(array, offset, array.Length - offset);
                bitmap.BeginInit();
                bitmap.StreamSource = stream;
                bitmap.EndInit();
            }
            return bitmap;
        }
        return null;
    }

    public object ConvertBack(object value, Type targetType, object parameter, CultureInfo culture)
    {
        return null;
    }
}

codekaizen · Accepted Answer · 2013-02-25 01:42:40Z

1

Use System.Data.Linq.Binary.ToArray()

The fuzziness and blurriness very unlikely due to the conversion of the bytes, but rather to the control you are using to display it not being aligned to the pixel grid, or else being resized slightly, stretching the image and causing it to be upscaled and blurred. Make sure the image is not stretched and the control is aligned to the pixel grid with SnapsToDevicePixels="True"

Also, here is some help for your code:

public class ImageBytesConverter : IValueConverter
{
    public object Convert(object value, Type targetType, object parameter,
        System.Globalization.CultureInfo culture)
    {
        BitmapImage bitmap = new BitmapImage();
        bitmap.CacheOption = BitmapCacheOption.OnLoad;

        if (value != null)
        {
            byte[] photo = ((System.Data.Linq.Binary)value).ToArray();

            using(MemoryStream stream = new MemoryStream())
            {
                int offset = 78;
                stream.Write(photo, offset, photo.Length - offset);

                bitmap.BeginInit();
                bitmap.StreamSource = stream;
                bitmap.EndInit();
            }

            return bitmap;
        }

        return null;
    }
}

edited Feb 25, 2013 at 1:42

answered Feb 24, 2013 at 23:37

codekaizen

27.5k7 gold badges88 silver badges141 bronze badges

1 Comment

codekaizen Over a year ago

That should be an obvious fix, and I added it.

Collectives™ on Stack Overflow

Unable to cast object of type 'System.Data.Linq.Binary' to type 'System.Byte[]'

2 Answers 2

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related