TableAdapters and stored procedures
482211Jan 11 2006 — edited Feb 14 2008Anyone know if there is any support for Oracle using stored procedures with a TableAdapter?
For those unfamiliar with this feature in VS 2005, we create a strongly typed DataSet, put a table on it using the designer, add/configure a TableAdapter and enter the TableAdapter Configuration Wizard. From here, we choose a connection string, then the next wizard step asks "How should the TableAdapter access the database?" Using an Oracle connection string, the only option that is not disabled is "Use SQL statements".
At this step, for an SQL Server connection string, we can select "Use existing stored procedures", which is what we want to use now with Oracle 9i R2. We've been using SQL DML statements quite happily with TableAdapters so far, and had not really noticed that this feature would not be available for Oracle. Unfortunately, we now need to use stored procedures, and we quite like the TableAdapters --- once you get over the rather obvious coupling of data access to the DataSet, not having to write so much code to use DataAdapters is quite nice.
I've read a little about the ODT, and the Oracle Explorer stuff looks pretty cool, but if I go to the trouble of installing the ODT, will it fix my TableAdapter stored procedures problem? Are there any other tools or workarounds?