quick db definition question

[marvinklein]

i created a new database by defining it as an ado catalog....
then i can add adox tables...

but, i would rather use the normal table class rather than the ado table class. how can i add a normal table to an ado catalog, or how can i define my database differently?

can you define a new database directly from a dataset for example?

[Pirate]

As far as I know (since I'd worked on this issue) , you can't create mdb database with pure ADO.NET . You can only do this if you want to create SQL Database File .

[marvinklein]

right. i d'ont like ado much either.
so is there a way to define a database given some tables using an object other than the adox catalog?

[Pirate]

You can build your own database Scheme(whether empty or structured with tables and columns objs) and store it in XML file but not in mdb file . Again SQL can be built by ADO.NET using the SQL String 'Create' .

Simply , you just creates your objs (DataTable or DataColumn and add every obj to the corresponding collection ) .