How to connect to Oracle in C#?

P

Paul2014-09-23 21:47:37

Oracle

Paul, 2014-09-23 21:47:37

Guys, tell me how best to connect to the database on oracle. I myself generally met with the oracle for the first time, so I don’t know how it is. Information on the Internet is different. I use Visual Studio 2010 and Oracle 10R2 It's
not difficult for anyone to skinte an example of queries like select where data is unloaded and all sorts of insert / update or kick on the _Russian-language_ manual. In English, oraklovsky man somehow did not master, sorry.

Reply

Answer the question

In order to leave comments, you need to log in

2 answer(s)

S

Sumor, 2014-09-23
@paul35

The first option is via ODBC. ODBC driver .
The second option is through the Oracle .net provider. Link to MSDN
Example from MSDN

I

imisan, 2014-11-27
@imisan

Yes, just be aware that
The types in System.Data.OracleClient are deprecated. The types remain supported in the current version of .NET Framework but will be removed in a future release. Microsoft recommends that you use a third-party Oracle provider.
exile