I'm creating an array of SqlParameters to send to SqlCommand.
Every parameter has to have a size, or I get an error.
Would it be efficient to get the bytes of every Object (parameter value) and pass it to the array?
What about truncation?
Does someone know a better method of doing this?
You can get length of all parameters using SqlCommandBuilder.DeriveParameters function. For more information you see http://www.davidhayden.com/blog/dave/archive/2006/11/01/SqlCommandBuilderDeriveParameters.aspx