• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 669
  • Last Modified:

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 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.
1 Solution
slightwv (䄆 Netminder) Commented:
Use Oracle's provider: ODP.Net


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


I have been using ODP.Net since .Net 2.x
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.

Join & Write a Comment

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now