DbParameter para = _fac.CreateParameter();
para.ParameterName = parameterName;
para.Value = value == null ? DBNull.Value : value;
para.DbType = dbType;
if (dbType != DbType.Binary && size > -1)//mysql不能设定长度,否则会报索引超出了数组界限错误。
{
switch (dbType)
{
case DbType.AnsiString:
case DbType.AnsiStringFixedLength:
case DbType.StringFixedLength:
para.Size = size;
break;
default:
para.Size = size / 2;//
break;
}
}
para.Direction = direction;