internal void UpdateTypes(SQL_TYPE sqlType)
{
SqlType = sqlType;
OdbcTypeMap map = OdbcTypeConverter.GetTypeMap(SqlType);
OdbcType = map.OdbcType;
SqlCType = map.NativeType;
}
public OdbcParameter()
{
_cbLengthInd = new NativeBuffer();
ParameterName = String.Empty;
IsNullable = false;
SourceColumn = String.Empty;
Direction = ParameterDirection.Input;
_typeMap = OdbcTypeConverter.GetTypeMap(OdbcType.NVarChar);
}
public OdbcParameter ()
{
_cbLengthInd = new NativeBuffer ();
ParameterName = String.Empty;
IsNullable = false;
SourceColumn = String.Empty;
Direction = ParameterDirection.Input;
_typeMap = OdbcTypeConverter.GetTypeMap (OdbcType.NVarChar);
}
public OdbcParameter (string name, object value)
: this ()
{
this.ParameterName = name;
Value = value;
//FIXME: MS.net does not infer OdbcType from value unless a type is provided
_typeMap = OdbcTypeConverter.InferFromValue (value);
if (value != null && !value.GetType ().IsValueType) {
Type type = value.GetType ();
if (type.IsArray)
Size = type.GetElementType () == typeof (byte) ?
((Array) value).Length : 0;
else
Size = value.ToString ().Length;
}
}
public OdbcParameter(string name, object value)
: this()
{
this.ParameterName = name;
Value = value;
//FIXME: MS.net does not infer OdbcType from value unless a type is provided
_typeMap = OdbcTypeConverter.InferFromValue(value);
if (value != null && !value.GetType().IsValueType)
{
Type type = value.GetType();
if (type.IsArray)
{
Size = type.GetElementType() == typeof(byte) ?
((Array)value).Length : 0;
}
else
{
Size = value.ToString().Length;
}
}
}
public void ResetOdbcType()
{
_typeMap = OdbcTypeConverter.GetTypeMap(OdbcType.NVarChar);
}
public override void ResetDbType()
{
_typeMap = OdbcTypeConverter.GetTypeMap(OdbcType.NVarChar);
}
public OdbcParameter(string name, OdbcType odbcType)
: this()
{
this.ParameterName = name;
_typeMap = (OdbcTypeMap)OdbcTypeConverter.GetTypeMap(odbcType);
}
public void ResetOdbcType ()
{
_typeMap = OdbcTypeConverter.GetTypeMap (OdbcType.NVarChar);
}
public override void ResetDbType ()
{
_typeMap = OdbcTypeConverter.GetTypeMap (OdbcType.NVarChar);
}
public OdbcParameter (string name, OdbcType type)
: this ()
{
this.ParameterName = name;
_typeMap = (OdbcTypeMap) OdbcTypeConverter.GetTypeMap (type);
}
