How to serialize and save an object to database as Xml using Linq to SQL

Question

I were using FileStream to Serialize an Object to Xml and Save to the disk

Stream str = new FileStream(@"serializedstate.xml", FileMode.OpenOrCreate)
XmlSerializer x = new XmlSerializer(typeof(GridState));
x.Serialize(str, new GridState
        {
            GridName= txtGridName.Text,
            GridColumns = GetGridColumnStates()
        });

This works fine and Xml file is generated on disk. How do I save serialized Object as Xml into a Sql Server 2008 database's XML column using Linq to SQL? And how to deserialize the same from database?

Vedran · Accepted Answer · 2009-12-01 10:18:14Z

7

To serialize into an XElement

        XmlSerializer x = new XmlSerializer(typeof(GridState));
        XDocument doc = new XDocument();

        using (XmlWriter xw = doc.CreateWriter())
        {
            x.Serialize(xw, new GridState
                {
                    GridName= txtGridName.Text,
                    GridColumns = GetGridColumnStates()
                });
            xw.Close();
        }

        XElement el = doc.Root;

To deserialize

        using (XmlReader xr = el.CreateReader())
        {
            GridState myDeserializedObject = x.Deserialize(xr) as GridState;
            xr.Close();
        }

answered Dec 1, 2009 at 10:18

Vedran

7576 silver badges21 bronze badges

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

Comments

Florim Maxhuni · Accepted Answer · 2009-12-01 09:58:43Z

0

In sql you must have colum type XML and in linq the type of Colum must be XElement than you can manipulate throw Linq.

answered Dec 1, 2009 at 9:58

Florim Maxhuni

1,4211 gold badge17 silver badges35 bronze badges

Collectives™ on Stack Overflow

How to serialize and save an object to database as Xml using Linq to SQL

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related