I'm using an oracle database w/ my .net 2 and VS2005 websites/projects.

My question is: what sqldatabase connection type (provider) should I be using to make the most of the VS2005 tools?
- .net framework provider for for OLE DB
- .net framework provider for for ORACLE
- .net framework provider for for ODBC

If I use OLE DB, which provider should I then use: oracle provider for ole db or microsoft for oracle...

Also - anyone know if its possible to use the gui for selecting fields from table(s) (using the checkboxes to view the table schema) rather than the manually entered sql statement?

Thanks.



GREG LANDGRAF
APPLICATION EXPERT
Computerized Facility Integration (CFI)
20 N Wacker Drive, Suite 2600, Chicago, IL 60601
OFFICE:  312.236.2323 x 6854
MOBILE: 847.721.3027
FAX:       &nbs p;312.236.2336
EMAIL:   [email protected]
Facilities Technology - Better, Faster and Cheaper!