Creating classes from sql server

[venerable bede]

I have been asked to look at the possibility of creating base classes in code from a sql server database (crazy considering I'm still learning oop).

To do this I need to be able to extract all :

table names
fields and data types
relationships
e.t.c

I know this is possible but have no idea where to start.

Can anyone give me a kick start or a kick if you want ?

How can I extract this info ?
What classes/methods will allow me do do the above ?

Not an easy one I know.

[hellswraith]

Shoot me a email, and I will send you a Aleta (that is a cross between Alpha and Beta) version of my code generator.

And if that doesn't do it for you, there are others...

http://dotnetjunkies.com/WebLog/seic...2/20/4771.aspx

http://www.ericjsmith.net/codesmith/

[hellswraith]

I never got an email from you, so I assume you don't need it anymore...correct?

[venerable bede]

I sent you an email on Friday.

I'll try again today.

Cheers