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