Formless Data Wizard?

[Rob Richardson]

Greetings!

I want to automatically generate a typed dataset and its associated command
objects from an Access Database. I can use the Server Explorer and drag the
tables onto a form and use the Data Wizard from there.

My problem is that there is no reason for the form to know about the
database or the objects that will represent my data. The class that
represents the object the database is storing information for is the logical
place for the objects that will represent the data. Therefore, I would like
to automatically generate the dataset and everything else as members of my
class, not as members of my form. Of course, I can cut the automatically
generated code from the form file and paste it inot my class file, but that
is overly cumbersome and it violates the spirit of object-oriented
development.

Is there an add-in or some similar tool that can build a dataset and related
objects anywhere in code, not just inside a form? If not, I think I have a
goal for my first .Net add-in.

By the way, a possibly related question: Is there anyplace better than the
..Net help files where I can find documentation for the CodeDOM namespace? I
looked at the ListGenerator sample. I don't understand what the CodeDOM
constructs give me that I wouldn't get just be directly writing the code.

Thank you very much!

Rob

[Cor]

Hi Rob,

Try to open a new XSD file (dataset) from the items in your solution
explorer and look what that can do for you.

To generate a dataset class you just have to click the right button and
choose for that to do.

You can do it also in code of course, it is not that difficult.

I hope this helps.

Cor