Reverse engineer SQL 8 and generate C# classes

[Elvin Ng]

Hi all,
Background:
Visual Studio .Net with Visio SDK
Visio 2003 EA
SQL 8

Hope I am not the only one who encounters this problem.

I want to reverse engineer a SQL database (about 100 of tables) in Visio and
from the Visio Database Model Diagram, read the Table names and Column names
using the SDK, so that I can generate C# class templates to access the
database.

I have managed to reverse engineered, used the SDK API (tried both COM and
managed code) to access the shapes and cells, but I was not able to find the
table names and columns of that table in the Visio vsd/vdx file. Are the
tables and columns not exposed (to code) at all?

Alternatively I guess I could scan the DDL or the vdx but I hope I don't
have to go to that route.

Thanks,
Elvin

 

[Elvin Ng]

Hi all,
Background:
Visual Studio .Net with Visio SDK
Visio 2003 EA
SQL 8

Hope I am not the only one who encounters this problem.

I want to reverse engineer a SQL database (about 100 of tables) in Visio and
from the Visio Database Model Diagram, read the Table names and Column names
using the SDK, so that I can generate C# class templates to access the
database.

I have managed to reverse engineered, used the SDK API (tried both COM and
managed code) to access the shapes and cells, but I was not able to find the
table names and columns of that table in the Visio vsd/vdx file. Are the
tables and columns not exposed (to code) at all?

Alternatively I guess I could scan the DDL or the vdx but I hope I don't
have to go to that route.

Thanks,
Elvin