XML data file to SQL Server

Question

I am writing a web application in C#.NET MVC 4. I have a web form which inserts data to an XML file within the APP_Data folder. I am wondering next if i can load this data into a sql server database and how i would go about doing this!

SQLServer has built-in functions to output any result out to XML format but I am not sure about how easy it is to do it the other way around and insert-from a XML file. — djangofan
– djangofan, Commented Jan 10, 2014 at 1:07
possible duplicate : Importing data from XML file to SQL database — har07
– har07, Commented Jan 10, 2014 at 1:19

Daniel Gimenez · Accepted Answer · 2014-01-10 01:27:55Z

0

Super easy. I do something similar where I have a table with an Identity primary key column, a Created Date DateTime column, and a Data column that's type XML. You can insert the XML from .Net as a string. Instead of going through the labor of creating an XmlDocument, I just have strongly typed Model and serialize it to a string.

string xmlData;
var xmlSerializer = new XmlSerializer(model.GetType());

using (var sw = new StringWriter()) {
    xmlSerializer.Serialize(sw, model);
    xmlData = sw.ToString();
}

using (var efContext = new MyDbEntities()) {
    evContext.Documents.Add(new Document() {
        CreatedDate = DateTime.Now,
        Data = xmlData
    });
    efContext.SaveChanges();
}

answered Jan 10, 2014 at 1:27

Daniel Gimenez

21.1k4 gold badges60 silver badges78 bronze badges

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

Collectives™ on Stack Overflow

XML data file to SQL Server

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related