I'm resigned to storing some objects directly into an image field in SQL Server. I figured that would mean serializing to a data stream and then store the byte array into field in my LLBLGenPro entity. I went a'googling like I always do just to see what other folks are doing and found this:

Diego F. wrote:

[Original message clipped]

Use binary formatter to serialize the object to a memory stream. Then store

the byte array in teh memory stream in an Image field in sqlserver. To read an object back, first create a memory stream from the Image field's data, then deserialize the data using the binary formatter.

    Frans.

-- Get LLBLGen Pro, productive O/R mapping for .NET: http://www.llblgen.com My .NET Blog: http://weblogs.asp.net/fbouma Microsoft C# MVP

[Edit - I meant to type "memory stream" not "data stream" ]

Jim, are you suprised? All road lead back to Frans and LLBLGen!

and I was thinking I was just stating the obvious