public ParamObj(string name, object value, SysDbType type, int size)
{
this.name = name;
this.value = value;
this.type = type;
this.size = size;
}
public ParamObj(string name, object value, SysDbType type, int size)
{
this.name = name;
this.value = value;
this.type = type;
this.size = size;
}
public ParamObj(string name, object value, SysDbType type, int size, ParamDirection direction)
{
this.name = name;
this.value = value;
this.type = type;
this.size = size;
this.direction = direction;
}
public ParamObj(string name, object value, SysDbType type, int size, ParamDirection direction)
{
this.name = name;
this.value = value;
this.type = type;
this.size = size;
this.direction = direction;
}
public static SqlDbType ConvertDbType(SysDbType typeStr)
{
switch (typeStr)
{
case SysDbType.BigInt:
return SqlDbType.BigInt;
case SysDbType.Image:
return SqlDbType.Image;
case SysDbType.Bool:
return SqlDbType.Bit;
case SysDbType.Char:
return SqlDbType.Char;
case SysDbType.DateTime:
return SqlDbType.DateTime;
case SysDbType.Date:
return SqlDbType.Date;
case SysDbType.Decimal:
return SqlDbType.Decimal;
case SysDbType.Float:
return SqlDbType.Float;
case SysDbType.Int:
return SqlDbType.Int;
case SysDbType.NChar:
return SqlDbType.NChar;
case SysDbType.NVarChar:
return SqlDbType.NVarChar;
case SysDbType.NVarCharMax:
return SqlDbType.NText;
case SysDbType.VarChar:
return SqlDbType.VarChar;
case SysDbType.VarCharMax:
return SqlDbType.Text;
case SysDbType.SmallInt:
return SqlDbType.SmallInt;
case SysDbType.TinyInt:
return SqlDbType.TinyInt;
case SysDbType.Binary:
return SqlDbType.Binary;
default:
return SqlDbType.VarChar;
}
}
