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 18.104.22.168 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.