I am working on a desktop application in VB.Net (4.0) There will a lot of SQL scripts which contains a lot of insert queries . Currenlty we are running the scripts using SMO (http://msdn.microsoft.com/en-us/library/ms162557.aspx)
One way
For performance, we have planned to change the sql scripts to xml file ( instead of insert queries, it will have xml data with a proper xsd defined ). Loads xml to dataSet and Using SQL Bulk Copy we are trying to insert to SQL Server.
Second way
Loads xml to dataSet Creates user defined table type based on the datatable in dataset (creted from xml file) and create a stored procedure which has parameter as this table type . In that sp, it will contains insert into tablename select * from tablevalueparameter.
So please suggest me to best and suitable way. Thanks in advance.