using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Data.OracleClient;
namespace DBFactory
{
    public class OracleDBFactory:DBFactory
    {
        Oracle.ManagedDataAccess.Client.OracleConnection conn = new Oracle.ManagedDataAccess.Client.OracleConnection();
        public override IDbConnection GetDBConnection()
        {
            return conn;
        }
        public override IDbTransaction GetDBTransaction(IsolationLevel LockAction)
        {
             
            return conn.BeginTransaction( LockAction);
        {

        };
        }
        public override IDbCommand GetDBCommand()
        {
            return new Oracle.ManagedDataAccess.Client.OracleCommand();
        }
        public override IDbCommand GetDBCommand(string cmdText, IDbConnection conn1)
        {
            return new Oracle.ManagedDataAccess.Client.OracleCommand(cmdText,(Oracle.ManagedDataAccess.Client.OracleConnection) conn1);
        }
        public override IDbDataAdapter GetDataAdapter(IDbCommand dbc)
        {
            return new Oracle.ManagedDataAccess.Client.OracleDataAdapter((Oracle.ManagedDataAccess.Client.OracleCommand)dbc);
        }
        public override IDbDataAdapter GetDataAdapter( )
        {
            return new Oracle.ManagedDataAccess.Client.OracleDataAdapter( );
        }
        public override IDbDataParameter GetParameter()
        {
            return new Oracle.ManagedDataAccess.Client.OracleParameter();
        }
        public override IDbDataParameter GetParameter(string ParameterName, DbType dbtype)
        {
            
            return new Oracle.ManagedDataAccess.Client.OracleParameter(ParameterName, (Oracle.ManagedDataAccess.Client.OracleDbType)dbtype);
        }
        public override IDataReader GetDataReader(IDbCommand dbc)
        {
            return ((Oracle.ManagedDataAccess.Client.OracleCommand)dbc).ExecuteReader() ;
        }
    }
}