How to store XML files in SQL database using C#?

Question

I have an XML file which should be a part of a table in my SQL database (say, name, data and XML).
I prefer not to make a string of it if possible. What column type should I use for it? I chose XML but I'm not sure how to work with it.

A small code example would be very appreciated.

Thanks.

NRaf · Accepted Answer · 2010-10-13 11:52:06Z

1

SQL Server (if you're using it) has an XML datatype which you can use. I've never used the datatype but we covered it during an SQL Server/.NET course at university.

http://msdn.microsoft.com/en-us/library/ms189887.aspx

answered Oct 13, 2010 at 11:52

NRaf

7,57914 gold badges57 silver badges92 bronze badges

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

1 Comment

user1228 Over a year ago

That's what I use. 2005+ required.

Collectives™ on Stack Overflow

How to store XML files in SQL database using C#?

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related