Using IDataAdapter to fill a strongly-typed dataset

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

Josh
Wed May 25 15:41:02 CDT 2005

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" wrote:

> 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
Fri Jun 03 12:53:36 CDT 2005

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

"Josh Lindenmuth" <Josh Lindenmuth@discussions.microsoft.com> wrote in
message news:7C07F063-23D7-4693-81EF-F695767B4ECD@microsoft.com...
> 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" wrote:
>
> > 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
> >
> >
> >

Josh
Fri Jun 03 13:02:01 CDT 2005

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

"Robert Bouillon" wrote:

> 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
>
> "Josh Lindenmuth" <Josh Lindenmuth@discussions.microsoft.com> wrote in
> message news:7C07F063-23D7-4693-81EF-F695767B4ECD@microsoft.com...
> > 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" wrote:
> >
> > > 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
> > >
> > >
> > >
>
>
>