public void ToCustomObject(OracleConnection con, IntPtr pUdt)
{
if (!OracleUdt.IsDBNull(con, pUdt, 0))
{
Value = (int?[])OracleUdt.GetValue(con, pUdt, 0);
}
}
public void ToCustomObject(global::Oracle.DataAccess.Client.OracleConnection con, IntPtr pUdt)
{
this.SdoGType = OracleUdt.IsDBNull(con, pUdt, "SDO_GTYPE") ? null : (int?)OracleUdt.GetValue(con, pUdt, "SDO_GTYPE");
this.SdoSRID = OracleUdt.IsDBNull(con, pUdt, "SDO_SRID") ? null : (int?)OracleUdt.GetValue(con, pUdt, "SDO_SRID");
this.SdoPoint = OracleUdt.IsDBNull(con, pUdt, "SDO_POINT") ? null : (SdoPointType)OracleUdt.GetValue(con, pUdt, "SDO_POINT");
this.SdoElemInfoArray = OracleUdt.IsDBNull(con, pUdt, "SDO_POINT") ? null : (int[])(OracleUdt.GetValue(con, pUdt, "SDO_ELEM_INFO"));
this.SdoOrdinateArray = OracleUdt.IsDBNull(con, pUdt, "SDO_ORDINATES") ? null : (double[])(OracleUdt.GetValue(con, pUdt, "SDO_ORDINATES"));
}
protected U GetValue <U>(int oracleColumnId)
{
if (OracleUdt.IsDBNull(_connection, _pUdt, oracleColumnId))
{
if (default(U) is ValueType)
{
throw new Exception(errorMessageHead + oracleColumnId + " of value type " + typeof(U));
}
return(default(U));
}
return((U)OracleUdt.GetValue(_connection, _pUdt, oracleColumnId));
}
protected TUser GetValue <TUser>(int oracleColumnId)
{
if (OracleUdt.IsDBNull(_connection, _pUdt, oracleColumnId))
{
if (default(TUser) is ValueType)
{
throw new Exception(ErrorMessageHead + oracleColumnId.ToString() + " of value type " +
typeof(TUser));
}
return(default(TUser));
}
return((TUser)OracleUdt.GetValue(_connection, _pUdt, oracleColumnId));
}
public TU GetValue <TU>(int oracleColumnId)
{
if (OracleUdt.IsDBNull(_connection, _pUdt, oracleColumnId))
{
if (default(TU) is ValueType)
{
throw new Exception("Error converting Oracle User Defined Type to .Net Type");
}
return(default(TU));
}
return((TU)OracleUdt.GetValue(_connection, _pUdt, oracleColumnId));
}
protected TUser GetValue <TUser>(string oracleColumnName)
{
if (OracleUdt.IsDBNull(_connection, _pUdt, oracleColumnName))
{
if (default(TUser) != null)
{
throw new Exception(ErrorMessageHead + oracleColumnName + " of value type " +
typeof(TUser));
}
return(default(TUser));
}
return((TUser)OracleUdt.GetValue(_connection, _pUdt, oracleColumnName));
}
public void MapTo(T instance, OracleConnection conn, IntPtr pUdt)
{
if (_attribute != null)
{
string attributeName = _attribute.AttributeName;
if (!OracleUdt.IsDBNull(conn, pUdt, attributeName))
{
object value = OracleUdt.GetValue(conn, pUdt, attributeName);
if (!(value == null || value is DBNull))
{
_property.SetValue(instance, value, null);
}
}
}
}
protected U GetValue <U>(int oracleColumn_Id)
{
if (OracleUdt.IsDBNull(connection, pUdt, oracleColumn_Id))
{
if (default(U) is ValueType)
{
throw new Exception(errorMessageHead + oracleColumn_Id.ToString() + " of value type " + typeof(U).ToString());
}
else
{
return(default(U));
}
}
else
{
return((U)OracleUdt.GetValue(connection, pUdt, oracleColumn_Id));
}
}
protected U GetValue <U>(string oracleColumnName)
{
if (OracleUdt.IsDBNull(this.connection, this.udtHandle, oracleColumnName))
{
if (default(U) is ValueType)
{
throw new Exception(errorMessageHead + oracleColumnName.ToString() + " of value type " + typeof(U).ToString());
}
else
{
return(default(U));
}
}
else
{
return((U)OracleUdt.GetValue(this.connection, this.udtHandle, oracleColumnName));
}
}
public void ToCustomObject(OracleConnection con, IntPtr pUdt)
{
Name = (string)OracleUdt.GetValue(con, pUdt, "NAME");
ValueTypeNo = (long)OracleUdt.GetValue(con, pUdt, "VALUE_TYPE_NO");
switch ((EValueType)ValueTypeNo)
{
case EValueType.DATE:
if (!OracleUdt.IsDBNull(con, pUdt, "VALUE_DATE"))
{
ValueDate = (DateTime)OracleUdt.GetValue(con, pUdt, "VALUE_DATE");
}
break;
case EValueType.NUMBER:
if (!OracleUdt.IsDBNull(con, pUdt, "VALUE_NUMBER"))
{
ValueNumber = (decimal)OracleUdt.GetValue(con, pUdt, "VALUE_NUMBER");
}
break;
case EValueType.OBJECT:
if (!OracleUdt.IsDBNull(con, pUdt, "VALUE_OBJECT_NO"))
{
ValueObject = (long)OracleUdt.GetValue(con, pUdt, "VALUE_OBJECT_NO");
}
break;
case EValueType.VARCHAR:
if (!OracleUdt.IsDBNull(con, pUdt, "VALUE_VARCHAR2"))
{
ValueVarchar2 = (string)OracleUdt.GetValue(con, pUdt, "VALUE_VARCHAR2");
}
break;
}
}
public void ToCustomObject(global::Oracle.DataAccess.Client.OracleConnection con, IntPtr pUdt)
{
this.X = OracleUdt.IsDBNull(con, pUdt, "X") ? null : (double?)(OracleUdt.GetValue(con, pUdt, "X"));
this.Y = OracleUdt.IsDBNull(con, pUdt, "Y") ? null : (double?)(OracleUdt.GetValue(con, pUdt, "Y"));
this.Z = OracleUdt.IsDBNull(con, pUdt, "Z") ? null : (double?)(OracleUdt.GetValue(con, pUdt, "Z"));
}
