DataAdapter fill schema efficiency?

[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

 

[Miha Markic]

Hi,

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?

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