Using IDataAdapter to fill a strongly-typed dataset

[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

 

[Guest]

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

 

[Robert Bouillon]

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

 

[Guest]

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