SQL Data Type for System.Drawing.Color

Question

I want to save a setting in MS SQL for .net Color. What data type in MS SQL should I use?

Answer 1

Use Int32, then use Color.FromArgb(Int32) and Color.ToArgb() to read and write, respectively. See: http://msdn.microsoft.com/en-us/library/ed705s37.aspx

Answer 2

The easy way would be to use color.ToArgb() to convert it to a 32-bit integer and store it as that. You can convert it back to a color using the static method Color.FromArgb(int).