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].[UploadByTableType]') 
		AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[UploadByTableType];
GO

IF  EXISTS (SELECT * FROM sys.types st JOIN sys.schemas ss 
		ON st.schema_id = ss.schema_id 
	WHERE st.name = N'TStudentScore' AND ss.name = N'dbo')
DROP TYPE [dbo].[TStudentScore];
GO

CREATE TYPE [dbo].[TStudentScore] AS TABLE(
	[ID] [int] NULL,
	[Name] [varchar](250) NULL,
	[Score] [int] NULL
);
GO

CREATE PROCEDURE dbo.UploadByTableType
	@DataInTableType AS TStudentScore READONLY
AS
BEGIN
	SELECT * FROM @DataInTableType
END;