/// <summary> /// /// </summary> /// <param name="dt"></param> private static void GenerateFkConstraints(DataTable dt) { var path = Path.Combine( _params[Parameters.OtherWorkPath].ToString(), Constants.CreateForeignKeys); using (var sw = new StreamWriter(path, false, Encoding.Default)) { var saveFkName = ""; var cnt = 0; sw.WriteBeginTrans(); foreach (DataRow row in dt.Rows) { if (saveFkName != row["fk_name"].ToString()) { saveFkName = row["fk_name"].ToString(); cnt = 0; } else cnt++; sw.WriteFkStatement(row, cnt); } sw.WriteCommitTrans(); } }