C# Class Azavea.Open.DAO.OleDb.OleDbOracleDaLayer

Implements a FastDao layer customized for PostGreSQL (optionally with PostGIS installed).
Inheritance: Azavea.Open.DAO.SQL.SqlDaDdlLayer
Mostra file Open project: azavea/net-dao-oledb

Public Methods

Method Description
OleDbOracleDaLayer ( OleDbDescriptor connDesc ) : System

Construct the layer. Should typically be called only by the appropriate ConnectionDescriptor.

SequenceExists ( string name ) : bool

Returns whether a sequence with this name exists or not. Firebird doesn't appear to support the SQL standard information_schema.

StoreRoomMissing ( ClassMapping mapping ) : bool

Returns true if you need to call "CreateStoreRoom" before storing any data. This method is "Missing" not "Exists" because implementations that do not use a store room can return "false" from this method without breaking either a user's app or the spirit of the method. Store room typically corresponds to "table".

Protected Methods

Method Description
GetAsciiStringType ( ) : string

Oracle doesn't seem to have a varchar type that is limited to ASCII characters.

GetAutoType ( Type baseType ) : string

Returns the DDL for the type of an automatically incrementing column. Some databases only store autonums in one col type so baseType may be ignored.

GetByteArrayType ( ) : string

Returns the SQL type used to store a byte array in the DB.

GetLongType ( ) : string

Returns the SQL type used to store a long in the DB.

GetStringType ( ) : string

Returns the SQL type used to store a "normal" (unicode) string in the DB.

Method Details

GetAsciiStringType() protected method

Oracle doesn't seem to have a varchar type that is limited to ASCII characters.
protected GetAsciiStringType ( ) : string
return string

GetAutoType() protected method

Returns the DDL for the type of an automatically incrementing column. Some databases only store autonums in one col type so baseType may be ignored.
protected GetAutoType ( Type baseType ) : string
baseType System.Type The data type of the column (nominally).
return string

GetByteArrayType() protected method

Returns the SQL type used to store a byte array in the DB.
protected GetByteArrayType ( ) : string
return string

GetLongType() protected method

Returns the SQL type used to store a long in the DB.
protected GetLongType ( ) : string
return string

GetStringType() protected method

Returns the SQL type used to store a "normal" (unicode) string in the DB.
protected GetStringType ( ) : string
return string

OleDbOracleDaLayer() public method

Construct the layer. Should typically be called only by the appropriate ConnectionDescriptor.
public OleDbOracleDaLayer ( OleDbDescriptor connDesc ) : System
connDesc OleDbDescriptor Connection to the Firebird DB we'll be using.
return System

SequenceExists() public method

Returns whether a sequence with this name exists or not. Firebird doesn't appear to support the SQL standard information_schema.
public SequenceExists ( string name ) : bool
name string Name of the sequence to check for.
return bool

StoreRoomMissing() public method

Returns true if you need to call "CreateStoreRoom" before storing any data. This method is "Missing" not "Exists" because implementations that do not use a store room can return "false" from this method without breaking either a user's app or the spirit of the method. Store room typically corresponds to "table".
public StoreRoomMissing ( ClassMapping mapping ) : bool
mapping ClassMapping
return bool