Read and write .NET Objects in SQL Database without serialization

Question

I have a small query. I need to create a Caching Service of my own that will write and read .NET Objects to and from the Database. Now, I have achieved that with the help of Binary Serialization. But the Problem is I need to deliberately marked my objects as [Serializable], which makes me think that what if someone will try to add an object which is not marked as [Serializable].

Thus, I need to find a way to read and write Objects to Database without Serialization.

I have one thought too.. As we all know Session can store any object in it. Now, we can make sessions to be stored in the DB, outproc. What mechanism it uses to store these objects without serializing or deserializing.

Any help will be highly appreciated.

Thanks. M.B

Objects stored in a session backed by a database must be serializable. It is not just a switch to flip. You must serialize in some way to store the data in a database. — Chris Pitman
– Chris Pitman, Commented Jan 11, 2011 at 2:52
So that simply means that whenever we try to save something in session its is being serialized to stored in DB if the Session State is set to be outproc on a SQl Server.. So how can you serialize objects on the fly when its is not marked as [Serializable]. — Mohit
– Mohit, Commented Jan 11, 2011 at 4:58

Austin Salonen · Accepted Answer · 2011-01-11 02:53:52Z

1

If it's saving to disk in any manner, it is serializing the state in some manner. You can easily serialize with XML to the database on your own.

Check out the System.Xml.Serialization namespace.

answered Jan 11, 2011 at 2:53

Austin Salonen

50.4k16 gold badges112 silver badges140 bronze badges

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

Comments

Keith Irwin · Accepted Answer · 2011-01-11 03:06:59Z

0

To serialize an object means to take the information from that object and store it to some form of permanent store in a standard way so that the object can later be effectively reconstructed via that information. Any object which is going to be written out to a database should be serializable. If it is being stored without some form of serialization process, then when deserialization is attempted the object may possibly be read back in a strange or inconsistent state.

answered Jan 11, 2011 at 3:06

Keith Irwin

5,66824 silver badges31 bronze badges

Collectives™ on Stack Overflow

Read and write .NET Objects in SQL Database without serialization

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