Use Linq to Save CLR objects as Binary

Question

Is it possible to define a custom type converter so that I can save CLR objects into a sql field using Linq?

It looks like this capability should be available. The Visual Studio 2010 Linq-to-Sql designer exposes the Type property for each auto-generated CLR property.

However, when I set the type property to system.drawing.color, I get the error:

Error   1   DBML1005: Mapping between DbType 'Binary(4)'
and Type 'System.Drawing.Color' in Column 'PixelColor' of Type 'Character' 
is not supported.       0   0

It seems like I should be able to implement this type converter somehow.

create a new datatype for color in your SQL Server database and map System.Drawing.Color to this new type. — kelloti
– kelloti, Commented Feb 26, 2011 at 23:01

Hans Passant · Accepted Answer · 2011-02-26 23:09:38Z

1

Use Color.ToArgb() and FromArgb() to convert back and forth to an int value that you can store in a dbase column. If you really want to then you can use the ColorConverter class to convert back and forth to a string, something you can stuff into your PixelColor column. Using an integer column type is a heckofalot more efficient though.

answered Feb 26, 2011 at 23:09

Hans Passant

946k151 gold badges1.8k silver badges2.6k bronze badges

Sign up to request clarification or add additional context in comments.

Comments

PeterM · Accepted Answer · 2011-02-27 22:47:09Z

1

Thanks Hans.

The complete solution for me was to have 2 properties in my Linq-to-Sql class. One is ColorDb which has a type system.Int32 and directly maps to a database field. It is auto-Created by the designer. This property is set to private. A second public property ColorClr which has a type System.Drawing.Color performs the conversion and exposes the data properly typed.

Partial Public Class MyObject

    Public Property ColorClr As System.Drawing.Color
        Set(ByVal value As Color)
            Me.ColorDb = value.ToArgb
        End Set
        Get
            Return Color.FromArgb(Me.ColorDb)
        End Get
    End Property
End Class

answered Feb 27, 2011 at 22:47

PeterM

2,7121 gold badge31 silver badges36 bronze badges

Collectives™ on Stack Overflow

Use Linq to Save CLR objects as Binary

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related