| Justin Naidl 2005-09-15, 6:59 pm |
| I have a few questions concerning the functionality of ADO.net. First
off all the reason I am asking, and if anybody knows of a tool like this
available or a better way of doing this please inform me. :) What I would
like to do is write an xml parser where you basically give it an xml
document that holds the specifications for a table in a database. I haven't
written the DTD for it yet but have a vague idea of what kind of information
I would like it to hold. The parser will then output 2 files. The first is
a .mdb MS Access file. If a file is specified by the user, the table will
be added to the file or if no file is specified by the user a new file would
be created. The second file that would be output is a C# (or maybe VB) file
that will contain the code for doing some of the basic needs of a database
such as inserts deletes and some queries. The end goal is that a programmer
will only have to add smaller pieces of functionality to this file in stead
of having to do the whole design part by him/herself. It would allow a
generic package that would be able to design the boring general parts of a
database and GUI without any major effort giving the programmer more time to
deal with the need-specific details. I haven't found a lot of really good
information on the full functionality of the ADO .net package. It seems
like it is very powerful and I look forward to playing with it but it also
seems so detailed that it is tough to get a really good concept of all of
it.
So, on to the questions.
1. Are there any sql commands that you cannot pass to an Access database
via OleDbCommand objects? Is it legal to send CREATE, ALTER commands? I
have no reason to believe that it isn't legal.
2. Is there any better way to alter the characteristics of a table from .net
other than using the SQL commands that are associated with the tasks?
3. Is it possible to create the file from .net without having to start with
a blank one?
4. Are there any  add-in's, packages, or resources on the net which may
make this task a little easier.
|