1

I am trying to connect to oracle database. I am able to connect to it through a local SQL Developer tool by sticking something in the oranames.tns file.

My question is that i will be deploying this website to a number of places. A few questions:

  1. What is the simplest way i can use to connect to this database and do very basic queries. I see some examples that have me referencing oracleclient dlls. Other methods not? Is there a best practice here?

  2. Am i going to have to update the oranames.tns file on everyone on of the machines that i deploy to ? is there any simpler way

Improve this question

1 Answer 1

Reset to default
3

1. You can use the Oracle data provider that comes with Microsoft, but I recommend using ODP.Net. It's best to use native libraries when possible since they are usually optimized better, at least in my experience.

2. You only need to configure the tnsnames.ora on the server, because the server is what's going to be handling the DB connections, not the client PCs (assuming that this is a MVC website).

Improve this answer
Sign up to request clarification or add additional context in comments.

1 Comment

If they use 10g (and won't allow us to install anything on their server), any ideas on how to get EF or Linq to Objects working with Oracle?

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.