Serialization Create an empty instance of your object Dim Obj as New MYOBJECT Dim cn As New SqlConnection(ConnectionString.Text_) Dim cmd As New SqlCommand Dim Trans As SqlTransaction With cmd .Connection = cn .Transaction = Trans .CommandType = CommandType.StoredProcedure .CommandText = "somestoredprocedure" Dim xMLSerialiser_ As New System.Xml.Serialization.XmlSerializer ( Obj.GetType ) Dim sWriter As New System.IO.StringWriter xMLSerialiser_.Serialize(sWriter, Obj ) 'add xml to database .Parameters.AddWithValue("@persistxml", sWriter.ToString) End With cmd.ExecuteNonQuery() Trans.Commit() DeSerialization Dim Obj as New MYOBJECT cn.Open() With cmd .Connection = cn .CommandType = CommandType.Text
My experiences with Object Oriented Programming