C#如何使用两个表之间的关系创建Dataset实例

using System;
using System.Data;

class Program
{
    static void Main()
    {
        // 创建两个DataTable实例
        DataTable customersTable = new DataTable("Customers");
        DataTable ordersTable = new DataTable("Orders");

        // 在Customers表中定义主键列
        customersTable.Columns.Add("CustomerID", typeof(int)).AutoIncrement = true;
        customersTable.Columns["CustomerID"].AutoIncrementSeed = 1;
        customersTable.Columns["CustomerID"].AutoIncrementStep = 1;
        customersTable.PrimaryKey = new DataColumn[] { customersTable.Columns["CustomerID"] };

        // 在Orders表中定义外键列
        ordersTable.Columns.Add("OrderID", typeof(int)).AutoIncrement = true;
        ordersTable.Columns["OrderID"].AutoIncrementSeed = 1;
        ordersTable.Columns["OrderID"].AutoIncrementStep = 1;
        ordersTable.Columns.Add("CustomerID", typeof(int));
        ordersTable.Columns["CustomerID"].AllowDBNull = false;
        ordersTable.Columns["CustomerID"].DefaultValue = 0;

        // 创建DataSet实例，并将两个表添加到DataSet中
        DataSet dataSet = new DataSet();
        dataSet.Tables.Add(customersTable);
        dataSet.Tables.Add(ordersTable);

        // 创建两个表之间的关系
        dataSet.Relations.Add("CustomerOrderRelation", customersTable.Columns["CustomerID"], ordersTable.Columns["CustomerID"]);

        // 输出DataSet中的数据
        Console.WriteLine(dataSet.GetXml());
    }
}