|
dev
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Overlapping typed datasets in .NET2: best practices?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 I use a dataset per process. Thus your option 1.
-- Show quoteMiha Markic [MVP C#] RightHand .NET consulting & development www.rthand.com Blog: http://cs.rthand.com/blogs/blog_with_righthand/ "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 > btw, I use template based code generator (CodeSmith) to automatically
produce all required datasets... -- Show quoteMiha Markic [MVP C#] RightHand .NET consulting & development www.rthand.com Blog: http://cs.rthand.com/blogs/blog_with_righthand/ "henk gijsbert" <h**@paralax.nl> wrote in message news:1147934180.478030.186850@g10g2000cwb.googlegroups.com... > Thanks Miha. Is there anyone with an opposing opinion? > |
|||||||||||||||||||||||