Creates a list of the navigation and the belonging scalar properties.

edmx_navigation_and_scalar_properties

private class Key
{
    public string TypeName { get; set; }
    public string NavPropertyName { get; set; }
    public override string ToString()
    {
        return string.Format("{0}.{1}", TypeName, NavPropertyName);
    }
}

private class Value
{
    public string ScalarPropertyName { get; set; }
    public string EndMemberType { get; set; }
    public override string ToString()
    {
        return string.Format("{0} ({1})", ScalarPropertyName, EndMemberType);
    }
}
private Dictionary<Key, Value> GetDependentProperties()
{
    var result = new Dictionary<Key, Value>();
    using (var ctx = new PoMS.DAL.OracleRepository.OracleEntities())
    {
        var container = ctx.MetadataWorkspace.GetEntityContainer(ctx.DefaultContainerName, DataSpace.CSpace);
        foreach (var set in container.BaseEntitySets)
        {
            var metadataProperties = set.ElementType.Members.Where(x => x is NavigationProperty).Cast<NavigationProperty>();
            foreach (var p in metadataProperties)
            {
                if (p.ToEndMember.RelationshipMultiplicity == RelationshipMultiplicity.Many)
                    continue;

                var k = new Key();
                k.TypeName = set.ElementType.Name;
                k.NavPropertyName = p.Name;
                        
                var assoc = (p.ToEndMember.DeclaringType as AssociationType);
                if (assoc.ReferentialConstraints.Count == 1)
                {
                    var dependentProp = assoc.ReferentialConstraints.First().ToProperties.First();

                    var v = new Value();
                    v.ScalarPropertyName = dependentProp.Name;
                    v.EndMemberType = p.ToEndMember.Name;
                    result.Add(k, v);
                }
            }
        }
    }
    return result;
}