Home / ASP.NET Wiki / Data Access / Serialization

Serialization

 Rate It (1)

The process of serialization converts an object into a form so that it can be transported across the network or can be placed in a storage location. The storage location could be a physical file, database or ASP.NET Cache. The state of the Object is preserved in form so that it could be constructed again at some later stage, which is know as Deserialization.

There are three formats of serialization

  1. Binary Serialization - Light and compact used in Remoting
  2. SOAP Serialization - interoperable use SOAP and used in web Services
  3. XML Serialization - Custom Serialization

In this article I will put forward an example of XML Serialization.

XML Serialization

For XML serialization, For every public member you need an attribute and that is necessary. it can serialize only public members.

It is also known as Shallow Serialization.

Following Is the code for serializing while accessing the data from Database.

 Dim cnnConnection As New SqlConnection()
            Try
                'Declare local variables
                Dim drdDetails As SqlClient.SqlDataReader = Nothing
                Dim objSer As New BLL.SerCollection
                Dim cmdDetails As SqlCommand = Nothing

                cnnConnection.ConnectionString = System.Configuration.ConfigurationManager.ConnectionString["ConnectionString"].DBConnectionString

                cmdDetails = New SqlCommand(PROC_SELECT_FOR_SEARCH, cnnConnection)

                'Set the timeout and add parameters to the Stored Procedure
                cmdDetails.CommandTimeout = 30
                cmdDetails.CommandType = CommandType.StoredProcedure
                cmdDetails.Parameters.Add("@Search", SqlDbType.VarChar).Value = strSearch
             
                'Open the connection and get the query results
                cnnConnection.Open()

                Dim XMLR As System.Xml.XmlReader = cmdDetails.ExecuteXmlReader

                Dim serializer As XmlSerializer = New XmlSerializer(GetType(BLL.SerCollection))
                objSer  = CType(serializer.Deserialize(XMLR), BLL.SerCollection)

                Return objSer
            Catch ex As Exception
                'Exception Block
                Throw New DBException(ex, "Get Method Faild")

                Return Nothing
            Finally
                cnnConnection.Close()
            End Try 
 

Revision number 2, Sunday, December 21, 2008 3:18:19 PM by mbanavige

Comments

good job

good example

i need c# example to serialize and deserialize a image from DB.

Shortcuts

Table of Contents

Top Wiki Contributors

(last 30 days)

  1. francissvk (1)
  2. deepeshsp (1)