private string ProcessRelationShipName(CSharpConfig config, ItemRelationship relationShip, string defaultName)
{
if (config.DataBase.Rewrite == null)
return defaultName;
var rewrite = config.DataBase.Rewrite.FirstOrDefault(c =>
c.SchemaPK == relationShip.ItemGroupPK
&& c.TablePK == relationShip.ItemPK
&& c.ColumnPK == relationShip.PropertyPK
&& c.SchemaFK == relationShip.ItemGroupFK
&& c.TableFK == relationShip.ItemFK
&& c.ColumnFK == relationShip.PropertyFK);
if (rewrite != null)
return rewrite.CustonName;
return defaultName;
}
private List<ItemRelationship> GetRelationships(SqlConnection cnx, string tabela, string schema)
{
List<ItemRelationship> result = new List<ItemRelationship>();
SqlCommand cmd = new SqlCommand(SqlRelationship(tabela, schema), cnx);
var reader = cmd.ExecuteReader();
while (reader.Read())
{
var relationShip = new ItemRelationship
{
ItemGroupPK = reader["SchemaPK"].ToString(),
ItemPK = reader["TablePK"].ToString(),
PropertyPK = reader["ColumnPK"].ToString(),
ItemGroupFK = reader["SchemaFK"].ToString(),
ItemFK = reader["TableFK"].ToString(),
PropertyFK = reader["ColumnFK"].ToString(),
RelationshipType = reader["Type"].ToString() == "M" ? ItemRelationshipType.Many : ItemRelationshipType.Single,
Nullable = reader["Nullable"].ToString() == "1"
};
result.Add(relationShip);
}
return result;
}
