Reducing roundtrips by uisng arrays of parameters/rows

  • Thread starter Thread starter Aleksey Dmitriyev
  • Start date Start date
A

Aleksey Dmitriyev

Does ADO.NET provide a way to operate by arrays of rows and parameters
similar to ODBC multi-row fetch or multi-parameter binding? The Dataset is
not the same because it has a considerable overhead and probably does NOT
save roundtrips. I know Oracle Data Provider (ODP.NET) has a mechanism that
I need. What about OracleClient or SqlClient?

Thanks,
A.D.
 
Define why you think DataSet has considerable overhead? At it's lowest
level. a DataSet is nothing more than arrays.
 
DataSet does not help. It sits in memory and accesses database via the same
IDbCommand. Oracle Data Provider has a extended property BindArrayCount and
overloaded members of OracleParameter that allow working with sets of
Parameters in a single Execute. I was looking for something like that in
..Net interfaces and other provider implementations.

--A.D.
 
Back
Top