public static Address GetAddressByType(int companyID, AddressType addressType)
        {
            using (ErapGsobContext cx = new ErapGsobContext())
            {
                string type = addressType.ToString();

                Address address = (from a in cx.AddressSet.Include("Type").Include("City").Include("City.Country")
                                   from c in a.Company
                                   where string.Compare(a.Type.Name, type, true) == 0 &&
                                   c.ID == companyID
                                   select a).FirstOrDefault();

                return address;
            }
        }

using (ErapGsobContext cx = new ErapGsobContext())
            {
                string type = addressType.ToString();

                Address address = cx.AddressSet.
Include("Company").
Include("Type").
Include("City").
Include("City.Country").
FirstOrDefault(r=> r.Company.ID == companyID && string.Compare(r.Type.Name, type, true) == 0);

                return address;
            }