Tables to Classes

[Shardool Karnik]

Is it possible to have Visio create C# classes based on the database model ?
We are creating a layer where every table has its own class.

Can I create a software model from it ?

All help is appreciated...

- Nik

 

[Al Edlund]

If you have the Visio Enterprise Architect version which comes with VS.NET
EA.
al

 

[Anthony Bloesch]

While it is true that you can model C# classes in VEA you cannot
automatically generate a class model from a database model.

In .Net, it is easy to generate the wrapper classes (i.e. typed data sets)
automatically so you may not need a model at all.

Anthony

--
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm

Note: For the benefit of the community-at-large, all responses to this
message are best directed to the newsgroup/thread from which they
originated.

 

[--CELKO--]

Many years ago, the INCITS H2 Database Standards Committee(nee ANSI
X3H2 Database Standards Committee) had a meeting in Rapid City, South
Dakota. We had Mount Rushmore and Bjarne Stroustrup as special
attractions. Mr. Stroustrup did his slide show about Bell Labs
inventing C++ and OO programming for us and we got to ask questions.

One of the questions was how we should put OO stuff into SQL. His
answer was that Bells Labs, with all their talent, had tried four
different approaches to this problem and come the conclusion that you
should not do it. OO was great for programming but deadly for data.

I have watched people try to force OO models into SQL and it falls
apart in about a year. Every typo becomes a new attribute or class,
queries that would have been so easy in a relational model are now
multi-table monster outer joins, redundancy grows at an exponential
rates, constraints are virtually impossible to write so you can kiss
data integrity goodbye, etc.