When working with the SqlCommand you will no doubt have to supply parameters to your command whether it be a Stored Procedure or Text command. Although not as efficient as an actual Stored Procedure there are some powerful things you can achieve using the System.Data.ParameterDirection, or rather other than just Input.