generate xsd file form stored procedure

[Vicky]

How can we genrate a xsd from a stored procedure in VS.net.
Is any way by which dataset code is autogenerated for a specific stored
procedure.

 

[Cowboy]

There is no autogen tool, if that is what you are asking. There may be a
third party tool, or you could create your own.

You can query the parameters and send in bogus information to create a
DataSet and create the XSD file using WriteXmlSchema(). This would work for
code gen.

You can also create the routine that gets the DataSet and simply write out
the XSD using WriteXmlSchema().

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

************************************************
Think Outside the Box!
************************************************