메소드 | 설명 | |
---|---|---|
AddParameter ( |
Adds a new instance of a DbParameter object to the command.
|
|
CheckIfOracleCommand ( |
Checks if oracle command.
|
|
ExecuteDataSet ( |
Executes a command and returns the results in a new DataSet.
|
|
ExecuteDataSet ( |
Executes a command and returns the result in a new DataSet.
|
|
ExecuteReader ( |
Creates an OracleDataReader based on the command.
|
|
ExecuteReader ( |
Creates an OracleDataReader based on the command.
|
|
ExecuteXmlReader ( |
Executes the OracleCommand and returns a new XmlReader. Unlike other Execute... methods that take a DbCommand instance, this method does not set the command behavior to close the connection when you close the reader. That means you'll need to close the connection yourself, by calling the command.Connection.Close() method. There is one exception to the rule above. If you're using TransactionScope to provide implicit transactions, you should NOT close the connection on this reader when you're done. Only close the connection if Transaction.Current is null. |
|
ExecuteXmlReader ( |
Executes the OracleCommand in a transaction and returns a new XmlReader. Unlike other Execute... methods that take a DbCommand instance, this method does not set the command behavior to close the connection when you close the reader. That means you'll need to close the connection yourself, by calling the command.Connection.Close() method. |
|
GetParameterValue ( |
Gets a parameter value.
|
|
GetStoredProcCommand ( string storedProcedureName ) : |
Creates a DbCommand for a stored procedure. The parameters for the stored procedure will be discovered and the values are assigned in positional order. |
|
LoadDataSet ( |
Loads a DataSet from a DbCommand.
|
|
LoadDataSet ( |
Loads a DataSet from a DbCommand in a transaction.
|
|
OdpNetDatabase ( string connectionString ) : System | ||
OdpNetDatabase ( string connectionString, IOraclePackage packages ) : System | ||
SetParameterValue ( |
Sets a parameter value.
|
메소드 | 설명 | |
---|---|---|
DeriveParameters ( |
Retrieves parameter information from the stored procedure specified in the DbCommand and populates the Parameters collection of the specified DbCommand object. The DbCommand must be an instance of a OracleCommand object. |
|
SameNumberOfParametersAndValues ( |
Determines if the number of parameters in the command matches the array of parameter values.
|
|
SetUpRowUpdatedEvent ( |
Sets the RowUpdated event for the data adapter. The DbDataAdapter must be an OracleDataAdapter. |
메소드 | 설명 | |
---|---|---|
AddInParameter ( |
||
AddInParameter ( |
||
AddInParameter ( |
||
AddOutParameter ( |
||
AddParameter ( |
||
AddParameter ( |
||
ConfigureParameter ( OracleParameter parameter, string name, OracleDbType dbType, int size, ParameterDirection direction, bool nullable, byte precision, byte scale, string sourceColumn, DataRowVersion sourceVersion, object value ) : void | ||
ConvertBoolToShort ( object value ) : object |
Converts a Boolean object to a short or DBNull if null. This is specifically used in the conversion of a Boolean to OracleDbType.Int16. Contrary to most interpretations of a boolean value a value of 0 (zero) stored in a Database is generally regarded as representing false. |
|
ConvertByteArrayToGuid ( object value ) : object |
Converts a byte array object to GUID. This is specifically used in the conversion of OracleDbType.Raw back to Guid |
|
ConvertGuidToByteArray ( object value ) : object |
Converts a GUID object to a byte array or DBNull if null. This is specifically used in the conversion of a Guid to OracleDbType.Raw |
|
ConvertShortToBool ( object value ) : object |
Converts a short object to Boolean. This is specifically used in the conversion of OracleDbType.Int16 back to Boolean |
|
CreateParameter ( string name, OracleDbType dbType, int size, ParameterDirection direction, bool nullable, byte precision, byte scale, string sourceColumn, DataRowVersion sourceVersion, object value ) : |
||
DoExecuteXmlReader ( OracleCommand oracleCommand ) : |
Does the execute XML reader. Execute the actual XML Reader call. |
|
GetParameterTypeRegistry ( string commandText ) : |
Gets the parameter type registry for the specified command.
|
|
OnOracleRowUpdated ( object sender, OracleRowUpdatedEventArgs args ) : void |
Called when a dataset row is updated. Listens for the RowUpdate event on a data adapter to support UpdateBehavior.Continue |
|
PrepareCWRefCursor ( |
Prepares the CW ref cursor. This is a private method that will build the Oracle package name if your stored procedure has proper prefix and postfix. This functionality is include for the portability of the architecture between SQL and Oracle datbase. This method also adds the reference cursor to the command writer if not already added. This is required for Oracle .NET managed data provider. |
|
QueryProcedureNeedsCursorParameter ( |
Queries the procedure to see if it needs a cursor parameter.
|
|
RegisterParameterType ( |
Registers the type of the parameter in a parameter registry.
|
|
TranslatePackageSchema ( string storedProcedureName ) : string |
Translates the package schema. Looks into configuration and gets the information on how the command wrapper should be updated if calling a package on this connection. |
public AddParameter ( |
||
command | The command to add the parameter. | |
name | string | The name of the parameter. |
dbType | DbType | One of the |
size | int | The maximum size of the data within the column. |
direction | ParameterDirection | One of the |
nullable | bool | A value indicating whether the parameter accepts |
precision | byte | The maximum number of digits used to represent the |
scale | byte | The number of decimal places to which |
sourceColumn | string | The name of the source column mapped to the DataSet and used for loading or returning the |
sourceVersion | DataRowVersion | One of the |
value | object | The value of the parameter. |
리턴 | void |
public static CheckIfOracleCommand ( |
||
command | The command. | |
리턴 | OracleCommand |
protected DeriveParameters ( |
||
discoveryCommand | The |
|
리턴 | void |
public ExecuteDataSet ( |
||
command | The command to execute to fill the |
|
리턴 |
public ExecuteDataSet ( |
||
command | The command to execute to fill the |
|
transaction | The transaction to participate in when executing this reader. | |
리턴 |
public ExecuteReader ( |
||
command | The command wrapper to execute. | |
리턴 | IDataReader |
public ExecuteReader ( |
||
command | The command wrapper to execute. | |
transaction | The transaction to participate in when executing this reader. | |
리턴 | IDataReader |
public ExecuteXmlReader ( |
||
command | The |
|
리턴 |
public ExecuteXmlReader ( |
||
command | The |
|
transaction | The |
|
리턴 |
public GetParameterValue ( |
||
command | The command that contains the parameter. | |
name | string | The name of the parameter. |
리턴 | object |
public GetStoredProcCommand ( string storedProcedureName ) : |
||
storedProcedureName | string | The name of the stored procedure. |
리턴 |
public LoadDataSet ( |
||
command | The command to execute to fill the |
|
dataSet | The |
|
tableNames | string | An array of table name mappings for the |
리턴 | void |
public LoadDataSet ( |
||
command | The command to execute to fill the |
|
dataSet | The |
|
tableNames | string | An array of table name mappings for the |
transaction | The |
|
리턴 | void |
public OdpNetDatabase ( string connectionString ) : System | ||
connectionString | string | |
리턴 | System |
public OdpNetDatabase ( string connectionString, IOraclePackage packages ) : System | ||
connectionString | string | |
packages | IOraclePackage | |
리턴 | System |
protected SameNumberOfParametersAndValues ( |
||
command | The |
|
values | object | The array of parameter values. |
리턴 | bool |
public SetParameterValue ( |
||
command | The command with the parameter. | |
parameterName | string | The parameter name. |
value | object | The parameter value. |
리턴 | void |
protected SetUpRowUpdatedEvent ( |
||
adapter | The |
|
리턴 | void |