connection from .NET to Oracle RDBMS v11.1

What is connection string for Oracle RDBMS? Should I  continue to use ADO.NET?

Background: My C#.NET application is using ADO.NET (SQLConnection, SqlCommand, SqlDataReader classes) to select data from Microsoft SQL Server database tables. The data tables are moving from Microsoft to an Oracle RDBMS version 11.0.7.0 database.

The following is my connection string to SQL Server.
Data Source=STEP2SQL;Initial Catalog=ProductSafety;Integrated Security=True

Also ... What is the proper .NET class for use with an Oracle database?
System.Data.OracleClient Namespace is deprecated.
tonygallo10Asked:
Who is Participating?
 
slightwv (䄆 Netminder)Connect With a Mentor Commented:
Use Oracle's provider: ODP.Net

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

Everything should be similar to what you are used to.
0
 
HainKurtSr. System AnalystCommented:
check:

http://www.infoq.com/news/2009/06/oracleclient_deprecated

I have been using ODP.Net since .Net 2.x
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.