I have an XML file 'D:/Message.XML' with contents as follows
<Description>Test for Message</Description>
I have a SQL table 'tblMessages' with
- Id (Identity column)
- Description nvarchar(max)
- User nchar(10)
I have a c# class file which has a function (InsertXMLContent()). I would like to read the XML file and write the content into the SQL table.
Thanks in advance.