Entityframework + Oracle Study Notes-Environment combination (1)

The company's new project uses Oracle database and entityframework. There is no suitable information on the Internet, so you cannot learn and practice it.

First, use dbfirst mode.

1. Download the Oracle plug-in odac that supports ado.net.

Odac 11.2 release 3 (11.2.0.2.1) with Oracle Developer Tools for Visual Studio

Address: http://www.oracle.com/technetwork/developer-tools/visual-studio/downloads/index.html

2. Install

After the odac is downloaded, install the client.

Then, in the oracle11g (or another client) installed on the local machine, F: \ app \ Administrator \ product \ 11.2.0 \ dbhome_1 \ Network \ ADMIN copy all files to the odac installation directory F: \ app \ Administrator \ product \ 11.2.0 \ client_1 \ Network \ admin.

(The above is the path of my machine and can be replaced with the corresponding directory in the installation environment)

3. Test

Test after installation

PLSQL:

If PLSQL is set before, clickCancel and enter the PLSQL System

Set the corresponding path here and log on again.

Below is the vs2010 Test

After odac is installed, the ODP. Net driver will be used to establish a data connection. Enter the user name and password, and click test connection. After the connection test is successful, the odac can be used directly after the installation is successful.