I am trying to figure out what is the best way to connect an (existing) ASP.Net application to an Oracle database to read its dictionary information.
There are simply too many possibilities:
- MS Data Provider for Oracle (requires 8.1.7, namespace System.Data.OracleClient)
- Oracle Data Provider for .NET (requires 9.2, namespace Oracle.DataAccess)
- Oracle Provider for OLE DB
- MSDASQL and ODBC
As my current app uses MSSQL server, further options would be:
- Linked Server, access via server..user.object
- Linked Server via OPENROWSET
There are a couple of questions on similar topics on SO, but only some have accepted answers.
What's your experience with each of the drivers? What are their pros and cons?
Of course Oracle is recommending ODP.Net. Is the requirement of version 9.2 (or higher) a problem today?
See Question&Answers more detail:
os 与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…