How can I get an XSD or programmatically interrogate a Visio model from C# (for code generation)?

Hi folks. I'm trying to do code-generation based on a Visio model. Up till
now I've been basing my generated code on the structure of the database
generated by Visio.

That's got me most of the way, but I now need information that never gets
into the database structure (e.g. the verbs on joins).

Ideally I'd like to get an XSD representation of the ORM model, that'd make
my job a lot easier. However I'd settle for just being able to gain access
to the information by hooking into Visio from C#.

Can anyone offer any suggestions or pointers?

Thanks

Sean

Hi Sean,

Check out the toolbox on my website (free, URL below). It will export the
ORM and ER metadata as XML. Along with that is some sample XSLT that will
render XSD from the ER model.

Hope that helps,
Scot.
...........................
Scot Becker

Orthogonal Software
www.orthogonalsoftware.com

ORM Protal/Blog: www.objectrolemodeling.com

"news.microsoft.com" wrote in message
...
Hi folks. I'm trying to do code-generation based on a Visio model. Up till
now I've been basing my generated code on the structure of the database
generated by Visio.

That's got me most of the way, but I now need information that never gets
into the database structure (e.g. the verbs on joins).

Ideally I'd like to get an XSD representation of the ORM model, that'd
make my job a lot easier. However I'd settle for just being able to gain
access to the information by hooking into Visio from C#.

Can anyone offer any suggestions or pointers?

Thanks

Sean

Excellent, thanks Scot. We've gone a different way for now, to avoid a
dependence on using Visio for every project we want to generate code for.
However there's a very good chance that the toolkit could prove very useful
later on.

Thanks,

Sean


"Scot Becker" wrote in message
...
Hi Sean,

Check out the toolbox on my website (free, URL below). It will export the
ORM and ER metadata as XML. Along with that is some sample XSLT that will
render XSD from the ER model.

Hope that helps,
Scot.
..........................
Scot Becker

Orthogonal Software
www.orthogonalsoftware.com

ORM Protal/Blog: www.objectrolemodeling.com

"news.microsoft.com" wrote in message
...
Hi folks. I'm trying to do code-generation based on a Visio model. Up
till now I've been basing my generated code on the structure of the
database generated by Visio.

That's got me most of the way, but I now need information that never gets
into the database structure (e.g. the verbs on joins).

Ideally I'd like to get an XSD representation of the ORM model, that'd
make my job a lot easier. However I'd settle for just being able to gain
access to the information by hooking into Visio from C#.

Can anyone offer any suggestions or pointers?

Thanks

Sean