Public Overrides Sub Prepare()

public override void Prepare()

If you call one of the ExecuteNonQuery, ExecuteReader, or ExecuteScalar methods after calling Prepare, any parameter value that is larger than the value specified by the Size property is automatically truncated to the original specified size of the parameter, and no truncation errors are returned.

The truncation only happens for the following data types:

If the size property is not specified, and so is using the default value, the data is not truncated.

• ExecuteNonQuery method
• ExecuteReader method
• ExecuteScalar method