private void CreateSchema()
{
_ds = new DataSet("VehiclesRepairs");
var vehicles = _ds.Tables.Add("Vehicles");
vehicles.Columns.Add("VIN", typeof(string));
vehicles.Columns.Add("Make", typeof(string));
vehicles.Columns.Add("Model", typeof(string));
vehicles.Columns.Add("Year", typeof(int));
vehicles.PrimaryKey = new DataColumn[] { vehicles.Columns["VIN"] };
var repairs = _ds.Tables.Add("Repairs");
var pk = repairs.Columns.Add("ID", typeof(int));
pk.AutoIncrement = true;
pk.AutoIncrementSeed = -1;
pk.AutoIncrementStep = -1;
repairs.Columns.Add("VIN", typeof(string));
repairs.Columns.Add("Description", typeof(string));
repairs.Columns.Add("Cost", typeof(decimal));
repairs.PrimaryKey = new DataColumn[] { repairs.Columns["ID"] };
_ds.Relations.Add(
"vehicles_repairs",
vehicles.Columns["VIN"],
repairs.Columns["VIN"]);
_ds.WriteXmlSchema(_xsdFile);
}