working with oracle 10g in VS 2010

[severman]

Hi all.
Does anybody knows how work with oracle DB in Visual Studio 2010
i was able to connect to the DB(meaning i can see the tables in the Server Explorer), but i cannot add the reference to the System.Data.OracleClient like it is able in VS 2008.
Thanks!

[kvprajapati]

>but i cannot add the reference to the System.Data.OracleClient like it is able in VS 2008.

.NET Framework Client Profile - an interesting feature is added with vs2010.

In order to work with Oracle provider you have to set target framework property to ".Net Framework 4" instead of ".Net Framework 4 client profile". (Open Project Properties).

[severman]

>but i cannot add the reference to the System.Data.OracleClient like it is able in VS 2008.

.NET Framework Client Profile - an interesting feature is added with vs2010.

In order to work with Oracle provider you have to set target framework property to ".Net Framework 4" instead of ".Net Framework 4 client profile". (Open Project Properties).

THANKS ALOT!
did the job!

[severman]

hi
although it did the trick
i'm wondering if there a better way to work since now i'm getting like 300 warnings.
do u know a better way? and if so do u have a good tutorial for it?
10x!

[kvprajapati]

In fact, Microsoft's support for Oracle - System.Data.OracleClient is deprecated in .NET 4.0. You can download ODP API from - http://www.oracle.com/technology/tech/dotnet/msoc/index.html

Read these threads :
1. http://stackoverflow.com/questions/1004484/system-data-oracleclient-namespace-discontinued
2. http://stackoverflow.com/questions/1193066/how-to-write-a-net-application-that-works-with-both-sqlserver-and-oracle-now-th