Using IDataAdapter to fill a strongly-typed dataset

  • Thread starter Thread starter Robert Bouillon
  • Start date Start date
R

Robert Bouillon

We're using abstract interfaces for the data access in our classes. We're
using strongly-typed datasets when using data adapters.

We can use a SqlDataAdapter to fill a strongly-typed dataset using the Fill
method, but we can't get the same result if we've cast the object to an
IDataAdapter's fill method.

Is it possible to fill a stronly-typed dataset using the interface?

Thanks.
--ROBERT
 
Robert - have you found an answer to this yet? We're trying to do the same
thing, but we haven't been able to figure out a way to use strongly typed
datasets with our Data Access Layer.

Thanks,
Josh Lindenmuth
 
Josh,

I was surprised to actually see a reply :) Unfortunately I was unable to
find anything and I concluded that it's just not supported in this version
of .NET. Perhaps it was overlooked (quite dissapointing).

I ended up having to do a strong cast to a SqlClient Type. I wrapped the
InvalidCastException with a more descriptive exception.

--ROBERT
 
We weren't able to setup our DAL using typed datasets either ... so we ended
up using a third party DAL (LLBLGen ... very nice product). Thanks for the
reply.

Good luck,
josh
 
Back
Top