public string FKToSqlString(SForeignKey fk)
{
List <string> colcurr = new List <string>();
List <string> colref = new List <string>();
foreach (var a in fk.columns)
{
colcurr.Add(a.Key.name);
colref.Add(a.Value);
}
string template = "alter table {0} add constraint FK_{0}_{1}_{2} foreign key references {1}({3});";
string s = string.Format(template, fk.table.name, fk.tablename, string.Join("_", colcurr), string.Join(",", colref));
return(s);
}
private string FKToSqlStringOutter(SForeignKey fk)
{
List <string> colcurr = new List <string>();
List <string> colref = new List <string>();
foreach (var a in fk.columns)
{
colcurr.Add(a.Key.name);
colref.Add(a.Value);
}
//foreign key({0}) references {1}({2}) on delete cascade on update cascade
string template = "alter table {0} add constraint foreign key({1}) references {2}({3}) on delete cascade on update cascade;";
string s = string.Format(template, fk.table.name, string.Join("_", colcurr), fk.tablename, string.Join(",", colref));
return(s);
}
