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!
severman 0 Junior Poster in Training
kvprajapati 1,826 Posting Genius Team Colleague
>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 0 Junior Poster in Training
>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 0 Junior Poster in Training
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 1,826 Posting Genius Team Colleague
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
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.