Not sure if this is the right place to ask.
I have a custom object in ASP.NET called TransactionResponseObject.
And I want to save this object AS IS - in one piece in SQL Server 2005 (instead of taking each and every property of it and individually saving it into separate columsn of a table in the database).
Question:
1). What type of SQL Server 2005 datatype will I be using in this case ?
2). Is there a good and easy tutorial on converting a custom object into XML format? and perhaps saving the xml into the database (I feel it's just an extra step - meaning extra processing which i want to avoid).
Thanks
TorontoMale
you can probaly serialize the object and store either in an xml column with or witouth a schema, preferably with, or as a binary, or as a string, then load up that way.
you have many options on storing the serialized object.
No comments:
Post a Comment