generate entity classes

[butch77]

Hi

For every project I need entity classes for each table.
I'm using an XSD DataSet to retrieve the data from the DB.

Since these classes are always very similar, I was wondering, whether
I could just develop a little generator program, that uses a template
to generate my class.

I've been searching the web for any good software for entity-class
generators but I couldn't find any. Any suggestions?

So my main question now is: what is the best way (very practically
explained) how to read the DBs table structure with all primary and
foreign keys?

And is there any way to maybe develop a plugin for VS that reads a XSD
file and generates the entities.

Thanks!!!

 

[Guest]

Take a look at the Repository Factory which you can find at codeplex.com

-- Peter
Recursion: see Recursion
site: http://www.eggheadcafe.com
unBlog: http://petesbloggerama.blogspot.com
BlogMetaFinder: http://www.blogmetafinder.com

 

[James Crosswell]

Hi

For every project I need entity classes for each table.
I'm using an XSD DataSet to retrieve the data from the DB.

Since these classes are always very similar, I was wondering, whether
I could just develop a little generator program, that uses a template
to generate my class.

I've been searching the web for any good software for entity-class
generators but I couldn't find any. Any suggestions?

So my main question now is: what is the best way (very practically
explained) how to read the DBs table structure with all primary and
foreign keys?

And is there any way to maybe develop a plugin for VS that reads a XSD
file and generates the entities.

Maybe look at netTiers. It sounds like it does what you want.

Best Regards,

James Crosswell
Microforge.net LLC
http://www.microforge.net

 

[sloan]

I believe there are templates for CodeSmith available for this type of
stuff.
However, CodeSmith costs a few bucks. But could be worth it.
(They have a 7 or 30 day evaluation period as well).



Though not related, here is a interesting blog entry as well.
http://stimpy77.spaces.live.com/blog/cns!FE05918FD4D775C5!375.entry