+1  A: 

The object that you need to return is a CustomerWebsitePage and not a WebsitePage. The reason is that whatever object you return must know about the customer since the property will need it to determine which field (CustomerPage or WebsitePage) to use.

Considering that, you can have a function CustomerWebsitePage.GetAllPagesForCustomer(Customer c) that would return an enumeration of pages. However, to achieve the functionality you are looking for, you must implement some read-through properties in the CustomerWebsitePage. Let's take the example of Name. Here would be how to implement it in CustomerWebsitePage:

public string Name
{
    get{ if( String.IsNullOrEmpty(CustomerWebsitePageName) ) 
            return WebsitePage.Name;
         return CustomerWebsitePageName; }
}

For the Children pages, you could have a property:

public IEnumerable<CustomerWebPage> Children
{
   get
   {
      return WebsitePage.Children.Select( it => it.Customer.CustomerID == this.CustomerID );       }
}

Note that with this setup you couldn't run EF Linq queries on these new fields (because they exist only in the objects themselves, not in the database mapping). You can pepper the code with Load() if you want to seamlessly load all the children, but it will cost you in performance. To ensure that all the children are loaded, try the following loading function:

IEnumerable<CusomterWebPage> GetAllPagesForCustomer(Customer c)  
{
    return Context.CustomerWebPageSet.Include("WebsitePage").Where( it => it.Customer.CustomerID == c.CustomerID );
}
ADB
Thanks for the advice. I have decided to go a different route altogether and not use the strongly typed object to do the overriding. Instead, I'm just handling it myself in the looping of this data. I guess I could say that this is a limitation of using the Entity framework when trying to do this sort of inheritance with overriding certain values. Who knows, I may even be able to use the entity framework to create this inheritance. But for now at least, I'm just handling it manually.Thanks.
TehOne