Table name in Dataset

[Guest]

Hi,

When I create a typed dataset containing multiple relational tables using
Generate dataset, it creates a single set of records based on what was chosen
when setting up the data adapter. If I have an orders table, an orderItems
table, a customer table etc. set up in the DataAdapter, the dataset chooses
one of these tables names as the name that intellisense exposes as the set of
records. This can be changed manually when viewing the schema.

My question is, how does it choose which table name to use for this combined
set of columns?

Thanks for your thoughts on this

Ant

 

[Cor Ligthert [MVP]]

For the version 2005 users this is version 2003.

Ant,

Sorry I am always fighting with those names myself in 2003, however to
prevent confusing.
The generic strongly typed dataset is very much changed in the version 2005
from that in 2003.

By the way the version in 2003 is for me almost unchangable (I see this
because you write "generate dataset" what is not in 2005), that goes much
better in the version 2005 just by using the designer.

To give you a change on a less confusing answer.

Cor

 

[Guest]

Thanks Cor,
it doesn't really answer my question but at least I don't need to worry
about it in V2005 & it's also reassuring that others find this a bit querky.

Thanks
Ant

 

[W.G. Ryan - MVP]

Ant:

It chooses the names based on the schema information of the queries. However
you can change this and very well may want to. In addition, check out the
TableMappings and ColumnMappings collections. This lets you work with your
tables and columns abstracted from their 'real' db names which may make
manipulating them a little easier/clearer.

HTH,

Bill