/// <summary>
///
/// </summary>
/// <param name="table"></param>
/// <returns></returns>
public SqlPrimaryKey GetPrimaryKey(SqlTable table)
{
return(SqlPrimaryKeys?.FirstOrDefault(f =>
f.TableSchema == table.Schema &&
f.TableName == table.Name));
}
/// <summary>
///
/// </summary>
/// <param name="table"></param>
/// <param name="sqlTable"></param>
/// <returns></returns>
private List <ColumnInfo> GetColumns(TableInfo table, SqlTable sqlTable)
{
var columns = SqlColumnManager.GetSqlColumns(sqlTable);
return(columns.Select(s => ConvertToColumnInfo(table, s)).ToList());
}
/// <summary>
///
/// </summary>
/// <param name="table"></param>
/// <param name="sqlTable"></param>
/// <returns></returns>
private List <UniqueKeyInfo> GetUniqueKeys(TableInfo table, SqlTable sqlTable)
{
var uniqueKeys = SqlUniqueKeyManager.GetUniqueKeys(sqlTable);
return(uniqueKeys.Select(s => ConvertToUniqueInfo(table, s)).ToList());
}
/// <summary>
///
/// </summary>
/// <param name="table"></param>
/// <returns></returns>
public List <SqlUniqueKeyInfo> GetUniqueKeys(SqlTable table)
{
var keys = SqlUniqueKeys.ToList(w => w.TableName == table.Name && w.TableSchema == table.Schema);
return(keys.GroupBy(g => g.ConstraintName).Select(s => new SqlUniqueKeyInfo(s)).ToList());
}