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