Very Computer

1. Abstract Data Parameter Type?

Greetings,
I have created abstract data provider class (DataAccessor) which get
implemented by .net data provider-specific concrete classes (a SQL provider
class, a OLE DB class, etc).  This helps keep the user ignorant from how db
access gets implemented.  The user has access to these static concrete
classes through a class factory component called Data Manager. So for
example the user would call:

'This returns a reference to concrete class which factory resolves from the
connectionString
 Dim objDBAccess As DataAccessor =
DataManager.GetDBAccessor(connectionString)

My questions is how to best handle parameter manipulation.  I want to enable
the sending of parameters and parameter arrays through Execute methods, but
how to do that if they don't know what provider they are using (don't want
them to send SQLParameter or OLEDBParameter).  Currently the only
implementation I could think of was to added static Set and Gets.  This is
not very robust, however, and does not enable the passing of parameters in
Execute calls.

For example, I want them to be able to:

'where arrSomeArrayofParams is an array of IDataParam-compliant types
objDBAccess.ExecuteNonQuery(CommandType.StoredProcedure,
"getProductDetails", arrSomeArrayofParams)

They currently can only set param one at time, then execute:

ParameterType.dmPtInt, 1)
objDBAccess.ExecuteNonQuery(Nothing, CommandType.StoredProcedure,
"getProductDetails", Nothing)

Any help appreciated!
Thanks in advance
Dave

2. More: Joint SQL7.0 and SQL2000 installations - Hype or?

3. How to retrive abstract data type using jdbc with oracle8.04

4. Access 7.0 VB Controls

5. User Customisable Schema and Oracle Abstract Data Types

6. $$NEED CASH?$$

7. How to retrive abstract data type via jdbc?

8. Question about DB/log backup.

9. SQL Loader and Abstract Data Types and Nested Tables

10. abstract data types

11. Abstract Data Types

12. Problem with Abstract Data Type

13. Data Types using the Data Object