private async Task <IEnumerable <CompareHelper.Differ> > GetDiff(IEnumerable <string> exists)
{
var list = new List <CompareHelper.Differ>();
foreach (var objectName in exists)
{
var leftSqlTextOriginal = await SqlHelper.GetObjectDefinition(_leftConnectionString, objectName).ConfigureAwait(false);
var rightSqlTextOriginal = await SqlHelper.GetObjectDefinition(_rightConnectionString, objectName).ConfigureAwait(false);
var leftSqlText = CompareHelper.AdjustForCompare(leftSqlTextOriginal);
var rightSqlText = CompareHelper.AdjustForCompare(rightSqlTextOriginal);
if (leftSqlText == rightSqlText)
{
continue;
}
list.Add(new CompareHelper.Differ(objectName, leftSqlTextOriginal, rightSqlTextOriginal));
}
return(list);
}
private async Task <IEnumerable <CompareHelper.Differ> > GetDiff(IEnumerable <string> exists)
{
var list = new List <CompareHelper.Differ>();
foreach (var file in exists)
{
var objectName = Path.GetFileNameWithoutExtension(file);
var fileTextOriginal = await FileHelper.ReadText(file).ConfigureAwait(false);
var fileText = CompareHelper.AdjustForCompare(fileTextOriginal);
var sqlTextOriginal = await SqlHelper.GetObjectDefinition(_connectionstring, objectName).ConfigureAwait(false);
var sqlText = CompareHelper.AdjustForCompare(sqlTextOriginal);
if (sqlText != fileText)
{
list.Add(new CompareHelper.Differ(objectName, sqlTextOriginal, fileTextOriginal));
}
}
return(list);
}
