C# Class NSoft.NFramework.Data.OdpNet.OdpNetTool

Public Methods

Method	Description
AssertIsOracleCommand ( this cmd ) : void	cmd의 수형이 OracleCommand수형인지 확인합니다.
ClearAllPools ( ) : void	모든 Oracle Connection Pool을 제거합니다.
CreateOracleConnection ( this db, bool &newConnectionCreated ) : Oracle.DataAccess.Client.OracleConnection	Oracle Connection을 비동기 방식으로 엽니다.
OpenConnection ( this db, int tryCount ) : Oracle.DataAccess.Client.OracleConnection	Oracle 연결이 성공하지 못하는 경우가 많아, 재시도 횟수 만큼 간격을 두고 연결을 시도합니다. Oracle DB의 Process 수를 기본(40)에서 100 이상으로 늘려주면 연결이 성공할 확률이 높습니다.
PrepareCWRefCursor ( this db, OracleCommand command ) : void	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.

Private Methods

Method	Description
HandleConnectionError ( OdpNetDatabase db, Exception ex, int tryCount ) : void
QueryProcedureNeedsCursorParameter ( OracleCommand command ) : bool	Queries the procedure to see if it needs a cursor parameter.

Method Details

AssertIsOracleCommand() public static method

cmd의 수형이 OracleCommand수형인지 확인합니다.

의 수형이 가 아닐 때

public static AssertIsOracleCommand ( this cmd ) : void
cmd	this	수형 확인할 DbCommand 인스턴스
return	void

ClearAllPools() public static method

모든 Oracle Connection Pool을 제거합니다.

public static ClearAllPools ( ) : void
return	void

CreateOracleConnection() public static method

Oracle Connection을 비동기 방식으로 엽니다.

public static CreateOracleConnection ( this db, bool &newConnectionCreated ) : Oracle.DataAccess.Client.OracleConnection
db	this	DAAB OdpNetDatabase 인스턴스
newConnectionCreated	bool	새로운 Connenction이 생성되었는지 여부
return	Oracle.DataAccess.Client.OracleConnection

OpenConnection() public static method

Oracle 연결이 성공하지 못하는 경우가 많아, 재시도 횟수 만큼 간격을 두고 연결을 시도합니다. Oracle DB의 Process 수를 기본(40)에서 100 이상으로 늘려주면 연결이 성공할 확률이 높습니다.

public static OpenConnection ( this db, int tryCount ) : Oracle.DataAccess.Client.OracleConnection
db	this	DAAB OdpNetDatabase 인스턴스
tryCount	int	연결 실패 시, 재 시도 횟수
return	Oracle.DataAccess.Client.OracleConnection

PrepareCWRefCursor() public static method

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.

public static PrepareCWRefCursor ( this db, OracleCommand command ) : void
db	this
command	OracleCommand	The command.
return	void