By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
432,526 Members | 1,895 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 432,526 IT Pros & Developers. It's quick & easy.

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

P: n/a
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
Nov 20 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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

Nov 20 '05 #2

P: n/a
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

Nov 20 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.