serialize object and store in a database

[Tony Johansson]

Hi!

Is it common to serialized object and then store it in a database ?

//Tony

 

[Patrice]

Hi,

At least not directly because once the serialized object is stored in the db
it would be difficult to query.

Usually object properties are mapped to database columns using
http://en.wikipedia.org/wiki/Object-relational_mapping technics, see in
particular http://msdn.microsoft.com/en-us/library/bb386992.aspx for what
..NET provides out of the box.

 

[Mr. Arnold]

Hi!

Is it common to serialized object and then store it in a database ?

//Tony

Yeah, I do it with keeping Web session variable of object or object
graphic and serialize it to save to a Varchar(max), using
XMLseralization on the object to serialize and deserialize the object.

It's done for session timeout to to keep object state and restore object
back to its state at time of timeout.

Of course, the SQL server record is using an Identity key, sessionid or
user-id and or some other type of information to make it unique with
date and timestamp so I and query the database to get the object back to
deserialize it back to the object or object graph and but it back into
session.

 

[Arne Vajhøj]

Is it common to serialized object and then store it in a database ?

In all C# code: no - it happens occasionally

In C# code that serializes to memory stream: yes - it is one of the
common reasons

Arne