saving xml output to database

Question

In my project I need to read a csv file and convert it into xml and save the xml to database table. I want to save the xml Output directly to database without saving to a file. I was able to convert csv to xml, but I am not sure how to save it(without saving to a file) database directly. Any help is appreciated.

Here is my code

   var lines = System.IO.File.ReadAllLines(@"C:\test.csv");

            var xml = new XElement("TopElement",
               lines.Select(line => new XElement("Item",
                line.Split(';')
                .Select((column, index) => new XElement("Column" + index, column)))));

           // XmlTextReader reader = new XmlTextReader(xml.ToString());


            //xml.Save(@"C:\xmloutput.xml);  // dont want to save to file.

What kind of database are you using? You may want to do some research on ADO.NET — DJ Quimby
– DJ Quimby, Commented Sep 13, 2012 at 14:36
use a memorystream? and a binary field in your database. example — Jordy van Eijk
– Jordy van Eijk, Commented Sep 13, 2012 at 14:36
Why not save the file as binary to databse why do you think it better the other way it a lot faster to save the file directly unless, you need to extract the data from, it — COLD TOLD
– COLD TOLD, Commented Sep 13, 2012 at 14:37
Why from excel file to xml and then to database? Why not directly to database? — Mitja Bonca
– Mitja Bonca, Commented Sep 13, 2012 at 14:38
You have the XML you want in the xml variable. Can't you just insert that into the database directly? — Andrew Walters
– Andrew Walters, Commented Sep 13, 2012 at 14:39

Community · Accepted Answer · 2017-05-23 12:27:15Z

2

Do you have column of type "XMl" in database in case you are using SQL Server?

You can check Save XML directly to Database with C#

edited May 23, 2017 at 12:27

CommunityBot

11 silver badge

answered Sep 13, 2012 at 14:54

Ravi Vanapalli

9,9703 gold badges36 silver badges43 bronze badges

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

3 Comments

Henry Over a year ago

I want to insert the entire data into one single row , In for later use, In such case above solutions doesn't work

Henry Over a year ago

Your solution is right. I was able to insert xml into table like any other data. Thanks for help

Ravi Vanapalli Over a year ago

@Henry if the solution is correct then please UP vote as well.

Jai Mallesh Babu · Accepted Answer · 2012-09-13 15:03:51Z

0

Maintaining XML in SQL Server:

http://msdn.microsoft.com/en-us/library/bb510480(SQL.105).aspx

C# sample (converting XML to string): http://social.msdn.microsoft.com/Forums/en-US/vstsdb/thread/d1666d13-dea3-4ce8-a818-6b852a63de4f/

answered Sep 13, 2012 at 15:03

Jai Mallesh Babu

3351 gold badge3 silver badges11 bronze badges

Comments

Jai Mallesh Babu · Accepted Answer · 2012-09-13 15:08:58Z

0

Implementing XML in SQL Server:

http://msdn.microsoft.com/en-us/library/ms189887(SQL.105).aspx

2 Comments

Henry Over a year ago

I want to insert the entire data into one single row , In for later use, In such case above solutions doesn't work

Jai Mallesh Babu Over a year ago

You can make the whole xml as string or serialize and save it in single row. That is one of resolutions provided above.

Collectives™ on Stack Overflow

saving xml output to database

3 Answers 3

3 Comments

Comments

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

3 Comments

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related