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")); }