Visual Studio 2008 and Oracle 10g

At work we have just started developing in C#.NET using VS2008 and we need to connect to Oracle databases.开发者_JS百科

The problem is that we are still using Oracle 10g servers and Oracle provide four install options:

• Install the Oracle 10g DAC with tools for VS2005 / VS2003
• Install the Oracle 11g DAC with tools for VS2008
• Install Oracle 10g DAC
• Install Oracle 11g DAC

http://www.oracle.com/technology/software/tech/windows/odpnet/index.html

We would prefer to use the 10g DAC but with VS2008 tools...

I'm wondering if anyone knows of any issues we might face using the 11g DAC on a 10g database - are the DACs backwards compatible?

So far it seems ok and we can connect and make queries with it but I have little experience working with Oracle databases, thanks for any pointers!

---

I've been using Visual Studio 2008 with Oracle 11g DAC (with tools) running against Oracle 10gR2 for many months now without any real issues.

---

In my case Oracle 10.g is working with Visual Studio 2008 (3.5 framework) Application, But when i added unit testing it gets failed I tried ORA connection string method also but the error exist