Click here to Skip to main content
15,895,011 members
Articles / Database Development / SQL Server

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

Rate me:
Please Sign up or sign in to vote.
4.84/5 (19 votes)
23 Dec 2009CPOL10 min read 52.7K   1.5K   48  
This article makes an experimental comparison on the performance of the different methods to pass structured data to SQL Server Stored Procedure parameters from ADO.NET.

Microsoft Visual Studio Solution File, Format Version 10.00
# Visual Studio 2008
Project("{FAE04EC0-301F-11D3-BF4B-00C04F79EFBC}") = "SQLSPPerformanceComparison", "SQLSPPerformanceComparison\SQLSPPerformanceComparison.csproj", "{C2BB48EA-6244-420D-AB91-170017F48F22}"
EndProject
Global
	GlobalSection(SolutionConfigurationPlatforms) = preSolution
		Debug|Any CPU = Debug|Any CPU
		Release|Any CPU = Release|Any CPU
	EndGlobalSection
	GlobalSection(ProjectConfigurationPlatforms) = postSolution
		{C2BB48EA-6244-420D-AB91-170017F48F22}.Debug|Any CPU.ActiveCfg = Debug|Any CPU
		{C2BB48EA-6244-420D-AB91-170017F48F22}.Debug|Any CPU.Build.0 = Debug|Any CPU
		{C2BB48EA-6244-420D-AB91-170017F48F22}.Release|Any CPU.ActiveCfg = Release|Any CPU
		{C2BB48EA-6244-420D-AB91-170017F48F22}.Release|Any CPU.Build.0 = Release|Any CPU
	EndGlobalSection
	GlobalSection(SolutionProperties) = preSolution
		HideSolutionNode = FALSE
	EndGlobalSection
EndGlobal

By viewing downloads associated with this article you agree to the Terms of Service and the article's licence.

If a file you wish to view isn't highlighted, and is a text file (not binary), please let us know and we'll add colourisation support for it.

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)


Written By
United States United States
I have been working in the IT industry for some time. It is still exciting and I am still learning. I am a happy and honest person, and I want to be your friend.

Comments and Discussions