Home All Groups Group Topic Archive Search About

Overlapping typed datasets in .NET2: best practices?

Author
17 May 2006 6:14 PM
henk gijsbert
Assume  I have one adressTable that is used for as well companies as
persons and I have need to retrieve companies with adresses as well as
persons with adresses. I could generate typed datasets, one with
companytable+addresstable and one with personTable+addresstable,
resulting in as well identical addresstables generated in both datasets
as identical AddressTableAdapters.

This doesn't feel right. What is a good practice in such a case:
-Do it anyway as described
-Generate 3 typed datasets with 1 table each and use untyped datasets
to combine the typed tables (this is what I am thinking of)
-Use one typed dataset and one untyped
-something else?

Regards,
Henk

Author
17 May 2006 6:28 PM
Miha Markic [MVP C#]
I use a dataset per process. Thus your option 1.

--
Miha Markic [MVP C#]
RightHand .NET consulting & development www.rthand.com
Blog: http://cs.rthand.com/blogs/blog_with_righthand/

Show quote
"henk gijsbert" <h**@paralax.nl> wrote in message
news:1147889679.677050.205000@38g2000cwa.googlegroups.com...
> Assume  I have one adressTable that is used for as well companies as
> persons and I have need to retrieve companies with adresses as well as
> persons with adresses. I could generate typed datasets, one with
> companytable+addresstable and one with personTable+addresstable,
> resulting in as well identical addresstables generated in both datasets
> as identical AddressTableAdapters.
>
> This doesn't feel right. What is a good practice in such a case:
> -Do it anyway as described
> -Generate 3 typed datasets with 1 table each and use untyped datasets
> to combine the typed tables (this is what I am thinking of)
> -Use one typed dataset and one untyped
> -something else?
>
> Regards,
> Henk
>
Author
18 May 2006 6:36 AM
henk gijsbert
Thanks Miha. Is there anyone with an opposing opinion?
Author
18 May 2006 7:58 AM
Miha Markic [MVP C#]
btw, I use template based code generator (CodeSmith) to automatically
produce all required datasets...

--
Miha Markic [MVP C#]
RightHand .NET consulting & development www.rthand.com
Blog: http://cs.rthand.com/blogs/blog_with_righthand/

Show quote
"henk gijsbert" <h**@paralax.nl> wrote in message
news:1147934180.478030.186850@g10g2000cwb.googlegroups.com...
> Thanks Miha. Is there anyone with an opposing opinion?
>

AddThis Social Bookmark Button