XML Serialization of Linq-to-Sql objects?

Question

I am working on an Audit Log for an application that uses Linq-To-Sql. I want to serialise an object to stores its values in a XML column in a SQL Server databse.

My problem is that when I try to serialize a Linq-To-Sql obejct that it attempts to serialize all associated entities and entity sets.

My first attempt at a solution was to create seperate class tos tore what I need to serialize and then pass this to an XmlSerializer.

I suppose what I really want to know is how to get the XmlSerializer to ignore certain types of properties - E.g entities and entity sets.

Would I have to write my own XmlSerializer?

All and any advice would be aprreciated.

leppie · Accepted Answer · 2009-10-27 11:26:12Z

1

You need to use the DataContractSerializer, but this will still serialize a partial object graph.

The better solution is to generate your own Linq2SQL classes and apply the XmlIgnore/DataMember attributes (depending on whether you use XmlSerializer or DataContractSerializer).

answered Oct 27, 2009 at 11:26

leppie

118k18 gold badges201 silver badges300 bronze badges

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

2 Comments

KristoferA Over a year ago

+1 Yes, use the DataContractSerializer... sample: social.msdn.microsoft.com/Forums/en-US/linqtosql/thread/…

John Saunders Over a year ago

Be careful that DataContractSerializer doesn't serialize fields that are part of the implementation of the objects. It does so for Entity Framework types in .NET 3.5, and I think I saw it do the same for L2S.

Collectives™ on Stack Overflow

XML Serialization of Linq-to-Sql objects?

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related