Well, I didn't find a specific forum where to post this, so I'm doing it here, at Installing and Registering. Maybe someone can lend me a hand.
Here I go: I'm covering the role of IT Manager in an enterprise that expect to make a big jump in the forecoming months. We worked with Oracle technology for a very long time and I think it's time to make a twist in our old Developer Suite-made applications.
We have just two options to go: .NET or Java. I know that Oracle, historicaly, supports Java and bla bla bla, but I find Java and all its world a little... sluggish about medium and big applications construction and deployment. Construction and deployment times are crucial in our business, so now I'm trying Visual Studio Express in order to compare this times with Java's times. Oracle just begun to support .NET developments with its brand new .Net Developer Center, so it's time to give Visual Studio a big chance.
But (there's always a BUT) I've found that I can only access SQL Server and Access databases from Visual Studio Express 2005. So I want to know before throwing myself into investigation, insomnia nights and big headaches: does Visual Studio Express support the instalation and use of the following Oracle Tools designed for Visual Studio .NET Take a look at them:
Oracle Developer Tools for Visual Studio .NET: http://www.oracle.com/technology/tech/dotnet/tools/index.html
Oracle Data Provider for .NET: http://www.oracle.com/technology/tech/windows/odpnet/index.html
Oracle Database Extensions for .NET: http://www.oracle.com/technology/tech/dotnet/ode/index.html
Well, if someone here is able to give me a hand, I'll be very thankfull. I'm already working on that and if I found something interesting, I will post it here.
Best regards,
Fafa
.NET and Oracle
Mani Krish
You can use the express products with Oracle.... You just have to manually create the connections and the data layer. You will not be able to use the wizards to connect to the databases.
One that you can use the wizards is to create a data layer and expose the data objects, this way you can use the normal binding and just bind to the data objects.
http://www.oracle.com/technology/pub/articles/cook_dotnet.html
jgroleau
Forget it, pals... It seems there are two major issues with that:
- Oracle Developer Tools for Visual Studio .NET and the other two Oracle Tools are certified only against Visual Studio 2003. It's expected the VS2005 release of these tools by the end of May, 2006
- Visual Studio Express does not support add-ins, so...
So, considering that we are not moving from Oracle Database, I must ask now:
Can I access Oracle Databases with Visual Studio Express using ADO.NET (from VB or C#)
And, if I wait 'till the end of May, 2006 for the Oracle release, Visual Studio 2005 Express will not be supporting add-ins at all, so... Hope to solve this without Microsoft bothersome trials expiring 90-days after the installation. I don't want to pick Java without giving .NET a chance.
Best regards,
Fafa
Itsme18
Hi!
I know it's been a while since you posted your last message, but I guess it won't hurt to answer your questions anyway.
I don't have much experience with Visual Studio Express, however I do develop applications using Oracle database and Visual Studio 2005 (Professional). That said, you should probably consider what VS Express offers (and what it doesn't offer) very carefully before starting a mid-sized project (it seems to be more suitable for small projects).
However, you shouldn't have any problems accessing Oracle either thorugh ODBC provider (not recommended) or through System.Data.OracleClient namespace.
Good luck with your projects.
Andreja