.net connectivity with oracle

In h开发者_运维问答ow many ways we can make .net connection with oracle(along with syntax) and which is the best syntax to use and why..

---

Using the System.Data.OracleClient works very effectively for me. You will need to add that reference in your project before you can include the using System.Data.OracleClient;

You can learn more about working with this at MSDN: 1. Oracle Client Namespace & 2. Oracle Connection Class

You will need to connect, just like other dbs, using a connection string. There are options, I use TNS as directed by our database group. It seems to be reliable and efficient but I really can't compare it to other methods. For TNS you need make sure that your TNS file contains pointers to the Oracle server (rather like a "HOST" file) and your connection string will look something like: Data Source=YourOracleServer;User Id=Username;Password=Password; Remember that with Oracle (unlike MS-SQL) you don't need to specify a database name/schema/catalog as your UserID controls what resources you have access to.