Example.AdventureWorks2008ObjectContext_Dal.DbCtx.AdventureWorksLT2008R2Entities.DenormAddresses C# (CSharp) Method

        public IQueryable<CAddress> DenormAddresses()
        {
            return this.Customers.FullOuterJoin(this.CustomerAddresses,
                c => c.CustomerID, ca => ca.CustomerID,
                (c, ca) =>
                    new CAddress
                    {
                        AddressID = ca.AddressID,
                        CustomerID = c.CustomerID,
                        FirstName = c.FirstName,
                        LastName = c.LastName,
                    }
                );
        }