Connecting Oracle Database to Visual Studio with ODP.NET is easy.
Please refer Using Oracle Developer Tools for Visual Studio
And if you are only about to develop a locally hosted application with Microsoft Visual Studio...
There is one step that must keep in mind. Enter the value for Database Source Name in the format shown below.
Database Source Name : localhost:1521/<yourDatabase_SID>
eg. localhost:1521/XE
otherwise, you'll be alerted with error message: ora-12560: TNS: protocol adapter error
You can use Visual Studio in window 7 with oracle 10g through the latest ODP.NET.
