Show / Hide Table of Contents

Class Oracle12

The Oracle12-class contains the functions necessary to run NetServer on Oracle 12 using the Oracle provider loaded dynamically. The Microsoft Oracle driver is deprecated and no longer supported.

Inheritance
object
Dialect
OracleCommon
Oracle12
Inherited Members
OracleCommon.CheckForDuplicateRow(IDataReader)
OracleCommon.CheckForDistinct(PrivateSelect)
OracleCommon.ToSql(JsonValue)
OracleCommon.ToSql(Parameter)
OracleCommon.ToSql(Add)
OracleCommon.ToSql(In)
OracleCommon.ToSql(NotIn)
OracleCommon.ToSql(FieldTypeConvert)
OracleCommon.ToSql(NotLike)
OracleCommon.ToSql(Like)
OracleCommon.ToSql(Equal)
OracleCommon.ToSql(UnEqual)
OracleCommon.ToSql(OrderBy)
OracleCommon.ToSql(WaitFor)
OracleCommon.DateToVarchar(string)
OracleCommon.TimeToVarchar(string)
OracleCommon.ConvertToDbParameterType(object, FieldDataType)
OracleCommon.ConvertToDbType(object, FieldDataType)
OracleCommon.ConvertFromDbType(object, FieldDataType)
OracleCommon.DataReaderGetString(SoDataReader, IDataReader, int)
OracleCommon.CaseSensitiveDatabase
OracleCommon.DefaultConnectionString
Dialect._tables
Dialect._tablesInJoin
Dialect._returnDBFields
Dialect._dbSchemaTable
Dialect._soSchemaTable
Dialect._returnArguments
Dialect._usedAliases
Dialect._filterCallbacks
Dialect._cmd
Dialect._stringFieldsInOrderByWithDistinct
Dialect.ShouldRowBeSkipped(IDataReader)
Dialect.IsTableReferencedInSelect(SoTable)
Dialect.GetUpdatedSchemaTable(DataTable)
Dialect.GenerateCaseInsensitivity(FieldInfo, Parameter, string)
Dialect.GetOriginAsComment(SqlCommand)
Dialect.HandleDateAndTimeWrapping(string, FieldDataType)
Dialect.GetFieldDbDataType(int)
Dialect.GetIndexOfField(Argument)
Dialect.GetFieldInfoFromIndex(int)
Dialect.CheckForAlias()
Dialect.InvokeToSql(params object[])
Dialect.IsAnyArgumentString(params Argument[])
Dialect.ToSqlUpperIfNeeded(Argument)
Dialect.ToSqlFrom()
Dialect.ToSqlField(FieldInfoCollection)
Dialect.ToSqlField(ArgumentCollection)
Dialect.ToSqlField(ReturnFieldsCollection)
Dialect.ToSql(Argument)
Dialect.GetOrderbyCollationHint()
Dialect.ToSql(GroupBy)
Dialect.ToSql(Count)
Dialect.ToSql(CountAll)
Dialect.ToSql(IsNull)
Dialect.ToSql(IsNotNull)
Dialect.EncodedArraySearch(Argument, Argument[], Dialect.EncodedArraySearchType, Dialect.FulltextEncodedSearch)
Dialect.ToSql(HasAny)
Dialect.ToSql(HasAll)
Dialect.ToSql(MissingAny)
Dialect.ToSql(MissingAll)
Dialect.ToSql(Between)
Dialect.ToSql(NotBetween)
Dialect.ToSql(TableInfo)
Dialect.ToSql(FieldInfo)
Dialect.ToSql(LessThan)
Dialect.ToSql(GreaterThan)
Dialect.ToSql(LessThanOrEqual)
Dialect.ToSql(GreaterThanOrEqual)
Dialect.ToSql(HasFlag)
Dialect.ToSql(HasNoFlag)
Dialect.ToSql(And)
Dialect.ToSql(Or)
Dialect.ParseMathematicalArguments(MathematicalExpression, string)
Dialect.ToSql(Greatest)
Dialect.ToSql(Subtract)
Dialect.ToSql(Multiply)
Dialect.ToSql(Divide)
Dialect.ToSql(LeftOuterJoin)
Dialect.ToSql(RightOuterJoin)
Dialect.ToSql(InnerJoin)
Dialect.ParseJoinClause(JoinRestriction)
Dialect.ToSql(Distinct)
Dialect.ToSql(Alias)
Dialect.ToSql(FieldDataType)
Dialect.ToSql(Upper)
Dialect.ToSql(Lower)
Dialect.ToSql(Trim)
Dialect.ToSql(Soundex)
Dialect.ToSql(Year)
Dialect.ToSql(Month)
Dialect.ToSql(Day)
Dialect.ToSql(Hour)
Dialect.ToSql(Minute)
Dialect.ToSql(Second)
Dialect.ToSql(Sum)
Dialect.ToSql(Max)
Dialect.ToSql(Min)
Dialect.ConvertToDbString(string)
Dialect.TimeTUtc2DateTime(int)
Dialect.TimeTLocal2DateTime(int)
Dialect.DateTime2TimeTUtc(DateTime)
Dialect.DateTime2TimeTLocal(DateTime)
Dialect.SelectSql(PrivateSelect)
Dialect.ComposeSelect(string, string, string, string, StringBuilder, PrivateSelect)
Dialect.InsertSql(PrivateSave)
Dialect.UpdateSql(PrivateSave)
Dialect.DeleteSql(PrivateSave)
Dialect.UnionSql(TableExpression)
Dialect.PreParseUnion(TableExpression)
Dialect.DifferenceSql(TableExpression)
Dialect.GenerateSql(SqlCommand)
Dialect.FieldIsClob(Argument)
Dialect.FieldIsString(Argument)
Dialect.DataReaderGetName(SoDataReader, IDataReader, int)
Dialect.DataReaderGetDataTypeName(SoDataReader, IDataReader, int)
Dialect.DataReaderGetFieldType(SoDataReader, IDataReader, int)
Dialect.DataReaderGetValue(SoDataReader, IDataReader, int)
Dialect.DataReaderGetOrdinal(SoDataReader, IDataReader, string)
Dialect.DataReaderGetNullValue(SoDataReader, int)
Dialect.DataReaderGetBoolean(SoDataReader, IDataReader, int)
Dialect.DataReaderGetByte(SoDataReader, IDataReader, int)
Dialect.DataReaderGetBytes(SoDataReader, IDataReader, int, long, byte[], int, int)
Dialect.DataReaderGetChar(SoDataReader, IDataReader, int)
Dialect.DataReaderGetChars(SoDataReader, IDataReader, int, long, char[], int, int)
Dialect.DataReaderGetGuid(SoDataReader, IDataReader, int)
Dialect.DataReaderGetInt32(SoDataReader, IDataReader, int)
Dialect.DataReaderGetInt32Array(SoDataReader, IDataReader, int)
Dialect.DataReaderGetInt64(SoDataReader, IDataReader, int)
Dialect.DataReaderGetDateTime(SoDataReader, IDataReader, int)
Dialect.DataReaderGetData(SoDataReader, IDataReader, int)
Dialect.DataReaderIsDBNullAsync(SoDataReader, DbDataReader, int, CancellationToken)
Dialect.IntToSingleWord(int)
Dialect.IntArrayToWordString(params int[])
Dialect.IntFromSingleWord(string)
Dialect.IntArrayFromWordString(string)
Dialect.GetDefaultTransaction(SoConnection, SqlCommand)
Dialect.DataReaderIsDBNull(SoDataReader, DbDataReader, int)
Dialect.BlockUpperInOrderBy
Dialect.MaxInSize
Dialect.Tables
Dialect.ReturnDBFields
Dialect.HasAliasOnDelete
Dialect.HasAliasOnInsert
Dialect.HasAliasOnUpdate
Dialect.HasAliasOnSelect
Dialect.CurrentSqlType
Dialect.CurrentOuterSqlType
Dialect.ReturnFieldsIndexer
Dialect.VarcharType
object.ToString()
object.Equals(object)
object.Equals(object, object)
object.ReferenceEquals(object, object)
object.GetHashCode()
object.GetType()
object.MemberwiseClone()
Namespace: SuperOffice.Data.Dialect
Assembly: SoDataBase.BusinessLogic.dll
Syntax
public class Oracle12 : OracleCommon

Methods

DataReaderGetDecimal(SoDataReader, IDataReader, int)

Gets the value of the specified column as a decimal.

Declaration
public override decimal DataReaderGetDecimal(SoDataReader soReader, IDataReader innerReader, int i)
Parameters
Type Name Description
SoDataReader soReader

DataReader to read from.

IDataReader innerReader
int i
Returns
Type Description
decimal
Overrides
Dialect.DataReaderGetDecimal(SoDataReader, IDataReader, int)

DataReaderGetDouble(SoDataReader, IDataReader, int)

Gets the value of the specified column as a double-precision floating point number.

Declaration
public override double DataReaderGetDouble(SoDataReader soReader, IDataReader innerReader, int i)
Parameters
Type Name Description
SoDataReader soReader

DataReader to read from.

IDataReader innerReader
int i
Returns
Type Description
double
Overrides
Dialect.DataReaderGetDouble(SoDataReader, IDataReader, int)

DataReaderGetFloat(SoDataReader, IDataReader, int)

Gets the value of the specified column as a single-precision floating point number.

Declaration
public override float DataReaderGetFloat(SoDataReader soReader, IDataReader innerReader, int i)
Parameters
Type Name Description
SoDataReader soReader

DataReader to read from.

IDataReader innerReader
int i
Returns
Type Description
float
Overrides
Dialect.DataReaderGetFloat(SoDataReader, IDataReader, int)

DataReaderGetInt16(SoDataReader, IDataReader, int)

Gets the value of the specified column as a 16-bit signed integer.

Declaration
public override short DataReaderGetInt16(SoDataReader soReader, IDataReader innerReader, int i)
Parameters
Type Name Description
SoDataReader soReader

DataReader to read from.

IDataReader innerReader

inner data reader

int i

column index

Returns
Type Description
short

the integer or 0 if null

Overrides
OracleCommon.DataReaderGetInt16(SoDataReader, IDataReader, int)

DataReaderGetItem(SoDataReader, IDataReader, int)

Oracle 12 specific data read - uses Oracle driver, so don't need special case

Declaration
protected override object DataReaderGetItem(SoDataReader soReader, IDataReader innerReader, int i)
Parameters
Type Name Description
SoDataReader soReader

outer reader

IDataReader innerReader

inner reader

int i

column index

Returns
Type Description
object

number, string or whatever

Overrides
OracleCommon.DataReaderGetItem(SoDataReader, IDataReader, int)

GetIsolationLevel(IsolationLevel)

The oracle databases only support ReadCommitted or Serializable through the Microsoft Oracle data provider.

Declaration
public override IsolationLevel GetIsolationLevel(IsolationLevel requestedLevel)
Parameters
Type Name Description
IsolationLevel requestedLevel

Requested isolation level

Returns
Type Description
IsolationLevel

Chaos, ReadUncommitted and ReadCommitted result in ReadCommitted. All other result in Serializable.

Overrides
OracleCommon.GetIsolationLevel(IsolationLevel)

Extension Methods

EnumUtil.MapEnums<From, To>(From)
Converters.MapEnums<From, To>(From)
© SuperOffice. All rights reserved.
SuperOffice |  Community |  Release Notes |  Privacy |  Site feedback |  Search Docs |  About Docs |  Contribute |  Back to top