Mega Code Archive

 

Categories / C# Tutorial / ADO Net

 

Output the XSD schema for the DataSet

using System;       using System.Data;       using System.Data.SqlClient;           class Program           {               static void Main(string[] args)               {                   string xsdFileName = "AdventureWorks.xsd";                   string sqlConnectString = "Data Source=(local);Integrated security=SSPI;Initial Catalog=AdventureWorks;";                   string sqlText = "SELECT * FROM Sales.SalesOrderHeader;SELECT * FROM Sales.SalesOrderDetail;";                   SqlDataAdapter da = new SqlDataAdapter(sqlText, sqlConnectString);                   da.TableMappings.Add("Table", "SalesOrderHeader");                   da.TableMappings.Add("Table1", "SalesOrderDetail");                   DataSet ds = new DataSet("AdventureWorks");                   da.FillSchema(ds, SchemaType.Mapped);                   ds.Relations.Add("SalesOrderHeader_SalesOrderDetail",                       ds.Tables["SalesOrderHeader"].Columns["SalesOrderID"],                       ds.Tables["SalesOrderDetail"].Columns["SalesOrderID"]);                   ds.WriteXmlSchema(xsdFileName);               }           }