Creating a Strongly Typed DataSet : DataSet « ADO.Net « C# / CSharp Tutorial

1. C# / CSharp Tutorial
2. ADO.Net
3. 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);
              }
          }