private void button1_Click(object sender, EventArgs e)
{
//call table creatot
//MainProgram.CreatTable (textBox1.Text, richTextBox1);
Employee ds = new Employee();
TableClass tab = new TableClass(typeof(Employee));
richTextBox1.Text = tab.CreateTableScript();
}
public static void CreatTable(string tableName, RichTextBox ta)
{
List <TableClass> tables = new List <TableClass> ();
// Pass assembly name via argument
Assembly a = Assembly.LoadFile(tableName);
Type [] types = a.GetTypes();
// Get Types in the assembly.
foreach (Type t in types)
{
TableClass tc = new TableClass(t);
tables.Add(tc);
}
// Create SQL for each table
foreach (TableClass table in tables)
{
Console.WriteLine((ta.Text = ta.Text + "\n" + table.CreateTableScript()).TrimEnd());
Console.WriteLine();
}
// Total Hacked way to find FK relationships! Too lazy to fix right now
foreach (TableClass table in tables)
{
foreach (KeyValuePair <String, Type> field in table.Fields)
{
foreach (TableClass t2 in tables)
{
if (field.Value.Name == t2.ClassName)
{
// We have a FK Relationship!
Console.WriteLine("GO");
Console.WriteLine("ALTER TABLE " + table.ClassName + " WITH NOCHECK");
Console.WriteLine("ADD CONSTRAINT FK_" + field.Key + " FOREIGN KEY (" + field.Key + ") REFERENCES " + t2.ClassName + "(ID)");
Console.WriteLine("GO");
}
}
}
}
}
