Oracle.dataaccess

public void GetData(string connString)

cmd.Connection = conn; cmd.CommandText = "SELECT EMPLOYEE_ID, FIRST_NAME FROM EMPLOYEES WHERE DEPARTMENT_ID = :deptId"; cmd.CommandType = CommandType.Text; oracle.dataaccess

while (reader.Read())

Unlike database drivers written purely in managed code, Oracle.DataAccess.dll acts as an interop layer. It relies on a multi-tiered architecture to process database commands: public void GetData(string connString) cmd

The is an unmanaged driver (prior to 12c) but can also refer to managed libraries in later versions. It relies on the Oracle Client software installed on the machine where the .NET application runs. cmd.CommandText = "SELECT EMPLOYEE_ID

DataTable dt = new DataTable(); // ... fill DataTable