Oracle.dataaccess

.NET App → Oracle.DataAccess.dll → Oracle Client → SQL*Net → Oracle Database

using (OracleConnection conn = new OracleConnection(connStr)) oracle.dataaccess

DataTable dt = new DataTable(); // ... fill DataTable using (OracleConnection conn = new OracleConnection(connStr)) bulkCopy.BatchSize = 500

bulkCopy.DestinationTableName = "TEMP_EMPLOYEES"; bulkCopy.BatchSize = 500; bulkCopy.WriteToServer(dt); cmd.CommandType = CommandType.StoredProcedure

conn.Open(); OracleCommand cmd = new OracleCommand("GET_EMPLOYEES_BY_DEPT", conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("p_dept_id", OracleDbType.Int32).Value = 30; cmd.Parameters.Add("p_cursor", OracleDbType.RefCursor).Direction = ParameterDirection.Output; using (OracleDataReader reader = cmd.ExecuteReader())

using (OracleConnection conn = new OracleConnection(connStr))

conn.Open(); OracleCommand cmd = new OracleCommand("SELECT first_name, last_name FROM employees WHERE department_id = :deptId", conn); cmd.Parameters.Add("deptId", OracleDbType.Int32).Value = 10;