dumping XML data to SQL Server

I want to achieve it using SqlBulkCopy. And also I need to copy the data in 4 tables. How can I achieve it.


Regards, MZEE

Hi, The below code will read xml and save it in datatable. You can use the same logic to save into database through entity framework or stored proc.

        //the path in which XML file is saved

    string path = "D:\\Santhosh\\XMLFile1.xml";

    DataSet ds=new DataSet();

    //Reading XML file and copying to dataset

    ds.ReadXml(path);

    dataGridView1.DataSource = ds;

    dataGridView1.DataMember = "table1";

you can read more in the below article.
http://www.c-sharpcorner.com/UploadFile/1a81c5/populating-values-from-xml-to-gridview-and-from-gridview-to/