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); }