public static void RowShowDifferences() { IEnumerable <Row> rows1 = new List <Row>(); IEnumerable <Row> rows2 = new List <Row>(); Parallel.Invoke(() => { try { Connect.Open(); rows1 = Connect.Query <Row>("SELECT * FROM web_transactionDays1"); Connect.Close(); } catch (Exception exc) { Connect.Close(); Console.WriteLine(exc); } }, () => { try { Connect2.Open(); rows2 = Connect2.Query <Row>("SELECT * FROM web_transactionDays2"); Connect2.Close(); } catch (Exception exc) { Connect.Close(); Console.WriteLine(exc); } }); List <string> diff1 = rows1.Except(rows2).Select(a => a.ToString()).ToList(); List <string> diff2 = rows2.Except(rows1).Select(a => a.ToString()).ToList(); DiffPrint.Coloring(diff1, diff2); }
public static void Substring(string query1, string query2) { List <string> tableStrings1 = new List <string>(); List <string> tableStrings2 = new List <string>(); Parallel.Invoke(() => { try { Connect.Open(); tableStrings1 = GetStringList(query1, Connect); Connect.Close(); } catch (Exception exc) { Connect.Close(); Console.WriteLine(exc); } }, () => { try { Connect2.Open(); tableStrings2 = GetStringList(query2, Connect2); Connect2.Close(); } catch (Exception exc) { Connect2.Close(); Console.WriteLine(exc); } }); IEnumerable <string> aOnlyTable1 = tableStrings1.Except(tableStrings2); IEnumerable <string> aOnlyTable2 = tableStrings2.Except(tableStrings1); DiffPrint.Coloring(aOnlyTable1.ToList(), aOnlyTable2.ToList()); }