3 replies to this topic

[bodiroga]

Hey people, i am new in C# and have a few questions.How can i make connection in Visual studio 2008 to Oracle. What command can i use to execute some sql commands. For, example i whant to get some queru from table, with command --select * from .. ---- if you have any example preasle post and i with get throw it and learn it.....thanks :::)))

[gregwarner]

You'll need to download and install the Oracle Data Access Components (ODAC) for Visual Studio in order to connect to the Oracle database and perform SQL queries from your C# code. Here's the link to ODAC:
Oracle Data Access Components (ODAC) for Windows

Oracle has lots of good documentation on their site on how to use their components. The link I gave you should be a good starting place. You can also try Googling the term, "ODAC C# tutorial".

[bodiroga]

thanks man :)

[sam_coder]

Microsoft also provides a built in Oracle Connector. (add a reference to System.Data.OracleClient from your GAC)

I also personally recommend downloading the above mentioned. Just remember that this will become a dependency for any deployment out of your development environment.