/// <summary>
///
/// </summary>
/// <param name="table"></param>
/// <param name="sqlUniqueKey"></param>
/// <returns></returns>
private UniqueKeyInfo GetUnique(TableInfo table, SqlUniqueKeyInfo sqlUniqueKey)
{
var unique = new UniqueKeyInfo();
unique.Table = table;
unique.Name = sqlUniqueKey.UniqueName;
unique.UniqueColumns = sqlUniqueKey.SqlUniqueKeys.Select(s => table.GetColumn(s.ColumnName)).ToList();
return(unique);
}
/// <summary>
///
/// </summary>
/// <param name="table"></param>
/// <param name="sqlUniqueKey"></param>
/// <returns></returns>
private UniqueKeyInfo ConvertToUniqueInfo(TableInfo table, SqlUniqueKeyInfo sqlUniqueKey)
{
var uniqueKey = new UniqueKeyInfo();
uniqueKey.Table = table;
uniqueKey.Name = sqlUniqueKey.UniqueName;
uniqueKey.UniqueColumns = ConvertToUniqueColumnInfo(table, sqlUniqueKey).ToList();
return(uniqueKey);
}
/// <summary>
///
/// </summary>
/// <param name="table"></param>
/// <param name="sqlUniqueKey"></param>
/// <returns></returns>
private IEnumerable <ColumnInfo> ConvertToUniqueColumnInfo(TableInfo table, SqlUniqueKeyInfo sqlUniqueKey)
{
foreach (var uniqueKey in sqlUniqueKey.SqlUniqueKeys)
{
var column = table.GetColumn(uniqueKey.ColumnName);
if (column != null)
{
yield return(column);
}
}
}
