DataAdapter fill schema efficiency?

  • Thread starter Thread starter AP
  • Start date Start date
A

AP

Hi,

What has the better performance when trying to create an empty data table
from a stored procedure, using the data adapter fill schema method with a
stored procedure that would select all the records, or using the data
adapter fill method passing an identity parameter that is known not to exist
in the table. Put another way, does the fillschema command execute the
entire stored procedure, or does it do some trickery to get the column info
out? Are there any other ways to do this effeciently?

Thanks,

Adam
 
Hi,

AP said:
Hi,

What has the better performance when trying to create an empty data table
from a stored procedure, using the data adapter fill schema method with a
stored procedure that would select all the records, or using the data
adapter fill method passing an identity parameter that is known not to exist
in the table. Put another way, does the fillschema command execute the
entire stored procedure, or does it do some trickery to get the column info
out? Are there any other ways to do this effeciently?
Click to expand...

I think it executes the sp and examines the columns returned.
Design time, strong typed datasets perhaps?
 
Back
Top