public virtual DataBase AddPK() { dt = conn.getPK(); string tempTable = null; PrimaryKey pk = null; if (dt.Rows.Count != 0) { foreach (DataRow item in dt.Rows) { if (tempTable != item["TableName"].ToString()) { if (tempTable != null) { db.ListPK.Add(pk); } tempTable = item["TableName"].ToString(); pk = new PrimaryKey(); pk.PKName1 = item["IndexName"].ToString(); pk.PkOfTable1 = standardizing(tempTable); } pk.ListColumnsPK.Add(standardizing(item["ColumnName"].ToString())); } db.ListPK.Add(pk); } return(db); }