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