Let's first introduce Oracle Developer Tools for Visual Studio. NET,
To achieve seamless development using Oracle Database J in Visual Studio,
I have learned the convenience of accessing the SQL Server database in Visual Studio,
After you install Oracle Developer Tools for Visual Studio. NET,
You can access the Oracle database in Visual Studio and access SQL server data in the same way,
For example, you can debug Oracle database development in Visual Studio,
You can also directly access the Oracle database, write stored procedures, or trigger these PL/SQL statements,
You can also use database controls such as sqldatasource to access the Oracle database,
Likewise, you can operate data in Oracle databases through datasets,
After installing Oracle Developer Tools for Visual Studio. NET,
You can easily access the Oracle database in Visual Studio,
First, let's look at my matching platform,
Hardware Platform
Previously, we used 10 Gb. When we used Visual Studio and Oracle 10 Gb,
1 GB of memory can barely run, but barely,
If 11 GB memory is used now, at least 2 GB memory. If the memory is 1 GB, we do not recommend 11 GB memory,
Get a 10g or 9i game by yourself,
Software Platform
The Oracle 11gr1 database is used,
Visual Studio 2008,
Then Oracle Developer Tools for Visual Studio. NET,
OS: win7 flagship edition (preferably server or XP)
It is installed with the latest version compatible with Oracle 11g,
Oracle 11gr1 and Oracle Developer Tools for Visual Studio. NET
You can download it from the Oracle official website,
However, when downloading Oracle Developer Tools for Visual Studio. NET,
You must note that you must select the version corresponding to your Oracle database,
Otherwise, you will always be unable to connect to Oracle in,
Then, Oracle Developer Tools for Visual Studio. NET is directly installed,
Note,
Install Oracle Developer Tools for Visual Studio. NET and
Oracle 11g also needs to be modified,
Let's take a look at the location where Oracle 11g needs to be modified.
Find
H: \ Software \ oracle \ oracle11gr1 \ database \ stage \ prereq \ DB
Under
Refhost. xml
Use NotePad to open this file and add the following marked parts
In this way, Oracle 11g can be installed successfully under win7 (otherwise it will not be installed)
Then you need to modify Oracle Developer Tools for Visual Studio. NET,
Find a file in the image file directory first,
H: \ Software \ oracle other \Odtwithodac11g \ stage \ prereq \ odac
File under
Refhost. xml
Then open it in notepad and add the following mark statement.
After completing the steps above, you can successfully install Oracle 11g and ODT. Net in win7.
After Oracle Developer Tools for Visual Studio. NET is installed,
Make another modification,
First find the installation directory of the Oracle database, and then find the following directory
For example, I installed it on drive D.
D: \ app \ Xiaozhen \ product \ 11.1.0 \ db_1 \ Network \ admin
Find the two files marked below
Then copy the two files
The following directory is under the installation directory of Oracle Developer Tools for Visual Studio. NET,
For example
D: \ app \ Xiaozhen \ product \ 11.1.0 \ client_1 \ Network \ admin
Then you can restart the machine.
Open Visual Studio 2008
You can find that there are more things under the "Tools" column of Visual Studio,
Then you can select "connect to Database" under the "tool" column"
The above shows that the connection to the Oracle database using ODT. NET is successful.
Follow "OK" to establish the connection to the Oracle database,
Then you can view it in "server resource manager"