Class <-> table relationships

[SkiNLaB]

I almost ALWAYS have a corresponding class for each table in my database, no matter which way i do it, it always comes down to a class per table.

there should be some kind of difference in the strucutre between my classes and my database shouldnt there?

Is this what everyone else ends up with aswell when they are designing their programs?

[frigginjerk]

I do the same thing.

I've been thinking about making a a vb addin that will scan an mdb file and create corresponding classes. But I'm lazy....

[SkiNLaB]

There are two similar tools, we just need someone to combine them, i found them on PSC.

one creates a class with all ur field names, and properties etc,

the other makes nice subs building ur sql strings for inserts, updates, deletes etc.

If i combine them it will be a super DB table class maker.

[frigginjerk]

sweet!

Can you post the links to these projects?

[SkiNLaB]

im not entirely sure which one i used but im sure its in this list

http://www.planetsourcecode.com/vb/s...t=Alphabetical

and other one i used that builds sql queries..

http://www.planetsourcecode.com/vb/s...23742&lngWId=1

but there are alot more entries in this area that i havent as yet seen on PSC.

this one looks good http://www.planetsourcecode.com/vb/s...41365&lngWId=1