>>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?