>>What exactly do you need to adjust and why?
>
>The focus is to know what is the best approach from the SQLClient data provider in .NET to access SQL Server. For now, I have always used the SQLParameter object approach. But, I have been wondering if sp_executesql was better.
I've always used SQLParameter as well and it executed sp_executesql behind the scenes anyway.
So, what exactly you would try to send to SQL Server?
If it's not broken, fix it until it is.
My Blog