I have the xml files in a folder , I need a code snippet to load the xml file to sql database ,in destination the column type is text.

c/documents/afile.xml

c/documents/bfile.xml

sql server table

id:1

name:afile

xml : content of afile.xml

id:2

name:bfile

xml:content of bfile.xml