SqlDataAdapter can it be used to access oracle db?

SqlDataAdapter can it be used to access oracle db?

开发者_JAVA百科

Yes it says sql, but can it be used for oracle?

---

Microsoft has deprecated its own Oracle drivers. Use Oracle's drivers instead. They will perform better than OleDB or ODBC drivers.

---

No - at least, not directly, you can of course execute SQL Server queries (SqlDataAdapter is SQL Server specific) that access data from Oracle, but you'll need a SQL Server involved. Check out Oracle and ADO.Net on MSDN instead.

---

OleDbDataAdapter or OdbcDataAdapter classes?