An Experimental Performance Comparison on the Methods to Pass Structured Data to SQL Server Stored Procedures from ADO.NET

IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[UploadByXMLType]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[UploadByXMLType];
GO


CREATE PROCEDURE [dbo].[UploadByXMLType]
	@DataInXMLType AS TEXT
AS
BEGIN
	DECLARE @I int
	DECLARE @XML AS XML
	
	SET @XML = CAST(@DataInXMLType AS XML)
	EXEC sp_xml_preparedocument @I OUTPUT, @XML
	
	SELECT *
	FROM OPENXML (@I, '/DATAS/DATA', 1) WITH
	([ID] INT 'ID', [Name] VARCHAR(250) 'Name', [Score] INT 'Score') 
	
	EXEC sp_xml_removedocument @I
END;
GO