I've just been investigating the Oracle ADO.NET drivers for Visual Studio 2005. The download is 213Mb and contains an add-in for VS2005.
You get an 'Oracle Explorer' which allows you to see all the tables, views, procedures, functions, packages etc. within a database. It's pretty slick with a query analyser and wizards to create new procedures and tables etc.

Found a really good tutorial on the Oracle site after searching through Google and their Support forums for some answers on returning result sets etc.

I've not quite found the answer for a similar task I'd do with DataSets with calling a StoredProcedure with input/output parameters. So far I've found that I can put result sets into OracleRefCursor's but this requires using an OracleDataReader which I don't believe is as efficient as just grabbing the data and closing the connection with a DataAdapter Fill method.

There were samples with the ODP.NET installation which use DataAdapters aswell, but they do not show how to call a StoredProcedure with it instead of Text.