Saturday, August 18, 2012 7:19 AM
I need to connect with Oracal database ..what are the states for that ?
I don't have ODP.Net...where can i download it ?
Saturday, August 18, 2012 5:42 PM
Easiest way to connect to Oracle database is use ADO.NET provider from Oracle, download developer tools to Visual Studio. If for some reason you don't want to use that, you can use OleDbCommand class included in System.Data.OleDb namespace in .NET Framework.
Connecting is easy as using any other ADO.NET provider.
Tuesday, August 21, 2012 6:30 AMModerator
If you just haven't used ODP.Net before, I suggest you to read the oracle document:
Best Regards,This response contains a reference to a third party World Wide Web site. Microsoft is providing this information as a convenience to you. Microsoft does not control these sites and has not tested any software or information found on these sites; therefore, Microsoft cannot make any representations regarding the quality, safety, or suitability of any software or information found there. There are inherent dangers in the use of any software found on the Internet, and Microsoft cautions you to make sure that you completely understand the risk before retrieving any software from the Internet.
Bob Wu [MSFT]
MSDN Community Support | Feedback to us
Tuesday, August 21, 2012 6:55 AMJust to add that Oracle's provider requires a matching Oracle client installed (a ton of megabytes). There is a commercial option from DevArt that is a standalone lightweight product - copy & paste deployment, no version problems, etc.
Miha Markic [MVP C#] http://blog.rthand.com