Is there a better tool for automated creation of database objects?

[Rob Richardson]

Greetings!

It seems to me that there is room for a lot of improvement in automatic
generation of database objects. If I create a data adapter from a table
shown in the Server Explorer, I get Select, Insert, Update, and Delete
commands, not all of which may be necessary. I don't have any control over
command names or parameter names. If all I am going to be doing is
inserting data into a table, I don't even need a data adapter. All I need
as a command with appropriate parameters, since I can call ExecuteNonQuery()
on it.

Also, all of the automatically generated objects are generated as members of
a form. They can't be generated as members of a class.

So, I would like a more intelligent, flexible solution for automatic
creation of database objects. It should be fairly easy to create an add-in
that would provide the features I want, and that it is likely that other
people feel the same way. Did anybody ever build such a beast? If so,
where can I find it?

Thanks very much!

Rob

[CJ Taylor]

You may want to see Deklarit or C1 Data Objects

Deklarit is basically a nice OR mapper, that will generate SQL scripts for
you etc based on business ideas (pretty decent actually) and 3.0 was just
released last week too..

C1, be prepared for bugs, powerful framework nonetheless, I use it now, but
it has its quirks.. you get used to them.

HTH,
CJ
"Rob Richardson" <no*******@n2net.net> wrote in message
news:Ol**************@tk2msftngp13.phx.gbl...

Greetings!

It seems to me that there is room for a lot of improvement in automatic
generation of database objects. If I create a data adapter from a table
shown in the Server Explorer, I get Select, Insert, Update, and Delete
commands, not all of which may be necessary. I don't have any control over command names or parameter names. If all I am going to be doing is
inserting data into a table, I don't even need a data adapter. All I need
as a command with appropriate parameters, since I can call ExecuteNonQuery() on it.

Also, all of the automatically generated objects are generated as members of a form. They can't be generated as members of a class.

So, I would like a more intelligent, flexible solution for automatic
creation of database objects. It should be fairly easy to create an add-in that would provide the features I want, and that it is likely that other
people feel the same way. Did anybody ever build such a beast? If so,
where can I find it?

Thanks very much!

Rob

[CJ Taylor]

You may want to see Deklarit or C1 Data Objects

Deklarit is basically a nice OR mapper, that will generate SQL scripts for
you etc based on business ideas (pretty decent actually) and 3.0 was just
released last week too..

C1, be prepared for bugs, powerful framework nonetheless, I use it now, but
it has its quirks.. you get used to them.

HTH,
CJ
"Rob Richardson" <no*******@n2net.net> wrote in message
news:Ol**************@tk2msftngp13.phx.gbl...

Greetings!

It seems to me that there is room for a lot of improvement in automatic
generation of database objects. If I create a data adapter from a table
shown in the Server Explorer, I get Select, Insert, Update, and Delete
commands, not all of which may be necessary. I don't have any control over command names or parameter names. If all I am going to be doing is
inserting data into a table, I don't even need a data adapter. All I need
as a command with appropriate parameters, since I can call ExecuteNonQuery() on it.

Also, all of the automatically generated objects are generated as members of a form. They can't be generated as members of a class.

So, I would like a more intelligent, flexible solution for automatic
creation of database objects. It should be fairly easy to create an add-in that would provide the features I want, and that it is likely that other
people feel the same way. Did anybody ever build such a beast? If so,
where can I find it?

Thanks very much!

Rob