Sql generator

  • Thread starter Thread starter Kris Desmadryl
  • Start date Start date
K

Kris Desmadryl

If you drag a db table to a component in vs.net the DataAdapter is
automatically configured (select, delete, tablemappings, ...). Is it
possible to do this in code. I don't want to use the CommandBuilder because
the statements generated by this are not so nice. For instance the parameter
name is @P1 and not @Person_ID or @Original_Person_ID.

I would like to generate the source code for my accessors.

Kris.
 
thx for the information
Is it possible to approach this DACW in coding ?
It would be nice if I could generate all parameters for all tables in my
database by writing a small program I tried this by using the
commandbuilder, but I have some problems with it. For instance the type is
Int32 but the size is 0 and so on.

Kris
 
Use the DACW to generate your parameters, then go in and tweak them. I can't
think of an easier way. Forget about the commandbuilder and life will
improve :=)
 
Back
Top