Hi,
I want to develop a code generator for our Data-Access Layer and I'd like to
know if there are queries I can make to have the table and column
definitions... something like Select * From Tables and Select * From
Columns Where TableName=@TableName.... something like this... I know there
are views in SqlServer 2005... for the Table Definition, I think it's
INFORMATION_TABLES or something like it... there is a similar table for
columns, but some properties are missing, like if the columns is an
Identity...

I also want to know if there is a way to retrieve the relationships like
Table1.Field1-->Table2.Field2 or something like this...

If you have a link to a web site I can find all those informations, go ahead
and post it... but for those who would be tempted, don't post
www.google.com, I already tried to find something useful without any real
success...

Can someone help me please?

Thanks

ThunderMusic

Now don't go off and 'reinvent the wheel'.

Try these articles:

http://www.theserverside.net/tt/arti...ataSetDesigner
http://www.codegeneration.net/tiki-index.php?page=NET
http://www.codegeneration.net/generators.php

--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc

Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous

You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf


"ThunderMusic" <NoSpAmdanlatathotmaildotcom (AT) NoSpAm (DOT) com> wrote

because I want to add my own things in it... and because we will probably
generate 100's of classes, I don't want to cut and paste my things in all
these classes... with my code generator, I'll be sure the classes reflect
exactly what we really need.

thanks tought, those links may be helpful...

ThunderMusic


"Arnie Rowland" <arnie (AT) 1568 (DOT) com> wrote

I thought the links might give you ideas, if not even code...

--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc

Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous

You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf


"ThunderMusic" <NoSpAmdanlatathotmaildotcom (AT) NoSpAm (DOT) com> wrote