T
Tony Johansson
Hi!
Is it common to serialized object and then store it in a database ?
//Tony
Is it common to serialized object and then store it in a database ?
//Tony
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
P
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.
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.
M
Mr. Arnold
Tony said: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.
A
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