private static IDbDataParameter CreateParameter(IDbCommand dbCommand, string parameterName, DbTypeContainer parameterType, int parameterLength, object parameterValue, ParameterDirection parameterDirection) { IDbDataParameter param; param = dbCommand.CreateParameter(); param.ParameterName = parameterName; if (parameterType.IsDbType == true) { param.DbType = parameterType.DbType.GetValueOrDefault(DbType.Object); } else { ((SqlParameter)param).SqlDbType = parameterType.SqlDbType.GetValueOrDefault(SqlDbType.Variant); } if (parameterLength != Int32.MinValue) { param.Size = parameterLength; } param.Value = parameterValue; param.Direction = parameterDirection; return(param); }
private static void AddParameter(IDbCommand dbCommand, string parameterName, DbTypeContainer parameterType, int parameterLength, object parameterValue, ParameterDirection parameterDirection) { dbCommand.Parameters.Add( CreateParameter(dbCommand, parameterName, parameterType, parameterLength, parameterValue, parameterDirection)); }