HELP - How can I view the SQL underlying an XSD (dataset)

  • Thread starter Thread starter Edward
  • Start date Start date
E

Edward

Visual Studio 2005

I have a number of XSD objects in my project and it would be really
helpful to see the SQL that they're based on. However, despite right-
clicking on practically everything, the ability to see this eludes
me. Can someone please point the way for me?

Thanks

Edward
 
Hello Edward,

I am not sure anymore if this was in Visual Studio 2005 so ignoring but you
can try

In Visual Studio 2008 and later (and 2002/2003 you can click on that little
icon in Solution Explorer show all files.

Then there shows up a designer.vb file

Success

Cor
 
Hello Edward,

I am not sure anymore if this was in Visual Studio 2005 so ignoring but you
can try

In Visual Studio 2008 and later (and 2002/2003 you can click on that little
icon in Solution Explorer show all files.

Then there shows up a designer.vb file

Success
Click to expand...

Thanks, Cor, but unfortunately this doesn't work. The designer.vb
file is a strongly typed in-memory cache of data. What it doesn't
show is the underlying SQL on which the various tables represented are
based. I'm sure that I've previously been able to load the XSD file
into something like a query designer which shows a graphical
representation of the JOINs etc. Only now I can't find out how....

Edward
 
Back
Top