#include "stdafx.h"
using namespace System;
using namespace System::Data;
void main()
{
DataSet^ myDataSet = gcnew DataSet("Game Data");
DataTable^ playerTable = myDataSet->Tables->Add("Player");
DataTable^ scoreTable = myDataSet->Tables->Add("Score");
DataColumn^ firstNameColumn1 = playerTable->Columns->Add("First Name",String::typeid);
DataColumn^ lastNameColumn1 = playerTable->Columns->Add("Last Name",String::typeid);
playerTable->Columns->Add("Email", String::typeid);
array^ primaryKey = {firstNameColumn1, lastNameColumn1};
playerTable->PrimaryKey = primaryKey;
DataColumn^ firstNameColumn2 = scoreTable->Columns->Add("First Name",String::typeid);
DataColumn^ lastNameColumn2 = scoreTable->Columns->Add("Last Name",String::typeid);
scoreTable->Columns->Add("Points", int::typeid);
array^ foreignKey = {firstNameColumn2, lastNameColumn2};
myDataSet->Relations->Add("Player-Score", primaryKey, foreignKey);
myDataSet->Tables["Score"]->Constraints->Add("Unique",foreignKey, true);
}