.Net 2.0: creating XSD files from SQL Table

19 Jan 2006 10:47 AM

Steve B.

Hello,

With VS 2003, I used to drop tables from a Sql server on a component or a
form in order to create a XSD file that have the same structure than the
table. This schema is used somewhere in the code to create dataset according
the schema (used in CF, so I can't use strongly typed DataSet).

With VS 2005, the dataset XSD file is quite different and I don't want to
rewrite my libraries. Is there any way with VS 2005 to create XSD files like
the source tables ?

Thanks,
Steve

19 Jan 2006 3:12 PM

Cowboy (Gregory A. Beamer) - MVP

The actual description has not change. What has changed (at least with drag
and drop) is the plumbing. If you want to add the plumbing, re-dragging on
your XSD form might be the easiest. If you are simply trying to consume using
the same methodology, it does not matter. The question is whether or not
embedded commands, etc., are worth the time to rebuild your STDs.

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

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

Show quote

"Steve B." wrote:

> Hello,
>
> With VS 2003, I used to drop tables from a Sql server on a component or a
> form in order to create a XSD file that have the same structure than the
> table. This schema is used somewhere in the code to create dataset according
> the schema (used in CF, so I can't use strongly typed DataSet).
>
> With VS 2005, the dataset XSD file is quite different and I don't want to
> rewrite my libraries. Is there any way with VS 2005 to create XSD files like
> the source tables ?
>
> Thanks,
> Steve
>
>
>