EDN Admin
Well-known member
Hi,
I have to create a large XML file to pass into a stored proc as a parameter. This XML will have hundreds of rows to be inserted into about 15 tables of which one the tables has 350+ columns. In the stored proc, I plan reading this XML and insert data into
the corresponding tables.
I am unable to figure out what the best appraoch would be to create this XML in VB.NET code. Im confused with all the options in the XML namespace, not sure of what the best approach would be in terms performance.
Any input would be greatly appreciated!
Thanks you!!
View the full article
I have to create a large XML file to pass into a stored proc as a parameter. This XML will have hundreds of rows to be inserted into about 15 tables of which one the tables has 350+ columns. In the stored proc, I plan reading this XML and insert data into
the corresponding tables.
I am unable to figure out what the best appraoch would be to create this XML in VB.NET code. Im confused with all the options in the XML namespace, not sure of what the best approach would be in terms performance.
Any input would be greatly appreciated!
Thanks you!!
View the full article