We have implemented static, auto-generated C# DB Layer, that deals with all parameters in such way:

for SP: exec mysp @par1 = @par1, @par2 = @par@

we just call (generated) C#...