Matthieu MEZIL

public static class PersonExtension

{

    [EdmFunction("TestLINQFunctionsModel", "GetAge")]

    public static int GetAge(this Person p)

    {

        throw new NotSupportedException();

    }

}

var q = from p in context.Persons

        select new { p.LastName, p.FirstName, Age = p.GetAge() };

public class SubObjectSet<TBase, TInherited> : ObjectQuery<TInherited>, IObjectSet<TInherited>

    where TBase : class

    where TInherited : class, TBase

{

    public ObjectSet<TBase> ObjectSet { get; private set; }

    public SubObjectSet(ObjectSet<TBase> objectSet)

        : base(objectSet.OfType<TInherited>().CommandText, objectSet.Context)

    {

        ObjectSet = objectSet;

    }

    #region IObjectSet<TInherited> Members

    public void AddObject(TInherited entity)

    {

        ObjectSet.AddObject(entity);

    }

    public void Attach(TInherited entity)

    {

        ObjectSet.Attach(entity);

    }

    public void DeleteObject(TInherited entity)

    {

        ObjectSet.DeleteObject(entity);

    }

    #endregion

}

public static class ObjectSetExtension

{

    public static T Get<T>(this ObjectSet<T> objectSet, object key) where T : class

    {

        object value;

        objectSet.Context.TryGetObjectByKey(new EntityKey(string.Concat(objectSet.Context.DefaultContainerName, ".", objectSet.EntitySet.Name), objectSet.EntitySet.ElementType.KeyMembers.Single().Name, key), out value);

        return (T)value;

    }

    public static T Get<T>(this ObjectSet<T> objectSet, params EntityKeyMember[] keys) where T : class

    {

        object value;

        objectSet.Context.TryGetObjectByKey(new EntityKey(string.Concat(objectSet.Context.DefaultContainerName, ".", objectSet.EntitySet.Name), keys), out value);

        return (T)value;

    }

}

[TestClass]

public class ObjectContextExtensionTest

{

    [TestMethod]

    public void Test()

    {

        using (var context = new NorthwindEntities())

        {

            var c = context.Categories.First();

            context.ActivateUndoRedoTracking(5);

            var cOriginalCategoryName = c.CategoryName;

            c.CategoryName = "CN";

            var c2 = context.Categories.OrderBy(c3 => c3.CategoryID).Skip(1).First();

            var c2OriginalCategoryName = c2.CategoryName;

            c2.CategoryName = "C2N";

            c.CategoryName = "CN2";

            context.Undo();

            Assert.AreEqual("CN", c.CategoryName);

            Assert.AreEqual("C2N", c2.CategoryName);

            context.Undo();

            Assert.AreEqual("CN", c.CategoryName);

            Assert.AreEqual(c2OriginalCategoryName, c2.CategoryName);

            context.Undo();

            Assert.AreEqual(cOriginalCategoryName, c.CategoryName);

            Assert.AreEqual(c2OriginalCategoryName, c2.CategoryName);

            context.Redo();

            Assert.AreEqual("CN", c.CategoryName);

            Assert.AreEqual(c2OriginalCategoryName, c2.CategoryName);

            context.Redo();

            Assert.AreEqual("CN", c.CategoryName);

            Assert.AreEqual("C2N", c2.CategoryName);

            context.Redo();

            Assert.AreEqual("CN2", c.CategoryName);

            Assert.AreEqual("C2N", c2.CategoryName);

            context.BeginGroupOfUndoActions();

            c.CategoryName = "CN3";

            c2.CategoryName = "C2N2";

            context.BeginGroupOfUndoActions();

            c.CategoryName = "CN4";

            c2.CategoryName = "C2N3";

            context.EndGroupOfUndoActions();

            c.CategoryName = "CN5";

            c2.CategoryName = "C2N4";

            context.Undo();

            Assert.AreEqual("CN5", c.CategoryName);

            Assert.AreEqual("C2N3", c2.CategoryName);

            context.Undo();

            Assert.AreEqual("CN4", c.CategoryName);

            Assert.AreEqual("C2N3", c2.CategoryName);

            context.Undo();

            Assert.AreEqual("CN3", c.CategoryName);

            Assert.AreEqual("C2N2", c2.CategoryName);

            context.Undo();

            Assert.AreEqual("CN2", c.CategoryName);

            Assert.AreEqual("C2N", c2.CategoryName);

            context.Redo();

            Assert.AreEqual("CN3", c.CategoryName);

            Assert.AreEqual("C2N2", c2.CategoryName);

            context.Redo();

            Assert.AreEqual("CN4", c.CategoryName);

            Assert.AreEqual("C2N3", c2.CategoryName);

            context.Redo();

            Assert.AreEqual("CN5", c.CategoryName);

            Assert.AreEqual("C2N3", c2.CategoryName);

            context.Redo();

            Assert.AreEqual("CN5", c.CategoryName);

            Assert.AreEqual("C2N4", c2.CategoryName);

        }

    }

}

private Supplier _supplier;

/// <remarks>

/// Changes aren't saved

/// </remarks>

public Supplier Supplier

{

    get

    {

        if (_supplier == null)

            _supplier = this.GetSupplier();

        return _supplier;

    }

    set { _supplier = value; }

}

private IEnumerable<Orders.OrderDetail> _orderDetails;

/// <remarks>

/// Changes aren't saved

/// </remarks>

public IEnumerable<Orders.OrderDetail> OrderDetails

{

    get

    {

        if (_orderDetails == null)

            _orderDetails = this.GetOrderDetails();

        return _orderDetails;

    }

    set { _orderDetails = value; }

}

using (var stockContext = new StocksEntities())

{

    var categories = stockContext.Categories.Include("Products").ToList();

    foreach (var p in stockContext.ObjectStateManager.GetObjectStateEntries(EntityState.Unchanged).Select(e => e.Entity).OfType<Entities.Stocks.Product>())

    {

        using (var supplierContext = new SuppliersEntities())

        {

            p.Supplier = (from p2 in supplierContext.Products

                          where p2.ProductID == p.ProductID

                          select p2.Supplier).FirstOrDefault();

        }

        using (var orderContext = new OrdersEntities())

        {

            p.OrderDetails = (from od in orderContext.OrderDetails.Include("Order.Customer")

                              where od.ProductID == p.ProductID

                              select od).ToList();

            foreach (var o in orderContext.ObjectStateManager.GetObjectStateEntries(EntityState.Unchanged).Select(e => e.Entity).OfType<Entities.Orders.Order>())

            {

                using (var employeeContext = new EmployeesEntities())

                {

                    o.Employee = (from oe in employeeContext.Orders

                                  where oe.OrderID == o.OrderID

                                  select oe.Employee).FirstOrDefault();

                }

            }

        }

    }

}

using (var stockContext = new StocksEntities())

{

    using (var supplierContext = new SuppliersEntities())

    {

        using (var orderContext = new OrdersEntities())

        {

            using (var employeeContext = new EmployeesEntities())

            {

                var categories = stockContext.Categories.Include("Products").ToList();

                var products = categories.SelectMany(c => c.Products);

                var suppliers = supplierContext.Suppliers.Where(BuildContainsExpression<Supplier, int>(s => s.SupplierID, (from p in products

               where p.SupplierID.HasValue

               select p.SupplierID.Value).Distinct())).ToList();

                var orderDetails = orderContext.OrderDetails.Include("Order.Customer").Where(BuildContainsExpression<Entities.Orders.OrderDetail, int>(od => od.ProductID, products.Select(p => p.ProductID))).ToList();

                var orders = orderDetails.Select(od => od.Order);

                var employees = employeeContext.Employees.Where(BuildContainsExpression<Employee, int>(e => e.

EmployeeID, (from o in orders

             where o.EmployeeID.HasValue

             select o.EmployeeID.Value).Distinct())).ToList();

                foreach (var p in products)

                {

                    p.Supplier = suppliers.FirstOrDefault(s => s.SupplierID == p.SupplierID);

                    p.OrderDetails = (from od in orderDetails

                                      where od.ProductID == p.ProductID

                                      select od);

                    foreach (var o in orders)

                        o.Employee = employees.FirstOrDefault(e => o.EmployeeID == e.EmployeeID);

                }

            }

        }

    }

}

using (var stockContext = new StocksEntities())

{

    using (var supplierContext = new SuppliersEntities())

    {

        using (var orderContext = new OrdersEntities())

        {

            using (var employeeContext = new EmployeesEntities())

            {

                var categories = stockContext.Categories.Include("Products").ToList();

                var products = categories.SelectMany(c => c.Products);

                var suppliers = supplierContext.Suppliers.ToList();

                var orderDetails = orderContext.OrderDetails.Include("Order.Customer").ToList();

                var orders = orderDetails.Select(od => od.Order);

                var employees = employeeContext.Employees.ToList();

                foreach (var p in products)

                {

                    p.Supplier = suppliers.FirstOrDefault(s => s.SupplierID == p.SupplierID);

                    p.OrderDetails = (from od in orderDetails

                                      where od.ProductID == p.ProductID

                                      select od);

                    foreach (var o in orders)

                        o.Employee = employees.FirstOrDefault(e => o.EmployeeID == e.EmployeeID);

                }

            }

        }

    }

}

<edmx:Options>

  <DesignerInfoPropertySet>

    <DesignerProperty Name="ValidateOnBuild" Value="false" />

  </DesignerInfoPropertySet>

</edmx:Options>

public interface IProduct

{

    int ProductID { get; }

}

public interface IOrder

{

    int OrderID { get; }

}

public interface IOrderDetail

{

    int ProductID { get; }

    int OrderID { get; }

}

public static class Product

{

    public static Category GetCategory(this IProduct product)

    {

        return GetCategory(product.ProductID);

    }

    public static Category GetCategory(int productID)

    {

        using (var context = new StocksEntities())

        {

            var p = new Stocks.Product { ProductID = productID };

            context.AttachTo("Products", p);

            p.CategoryReference.Load();

            return p.Category;

        }

    }

    public static Supplier GetSupplier(this IProduct product)

    {

        return GetSupplier(product.ProductID);

    }

    public static Supplier GetSupplier(int productID)

    {

        using (var context = new SuppliersEntities())

        {

            var p = new Suppliers.Product { ProductID = productID };

            context.AttachTo("Products", p);

            p.SupplierReference.Load();

            return p.Supplier;

        }

    }

    public static IEnumerable<IOrderDetail> GetOrderDetails(this IProduct product)

    {

        return GetOrderDetails(product.ProductID);

    }

    public static IEnumerable<IOrderDetail> GetOrderDetails(int productID)

    {

        using (var context = new OrdersEntities())

        {

            var p = new Orders.Product { ProductID = productID };

            context.AttachTo("Products", p);

            p.OrderDetails.Load();

            return p.OrderDetails.AsEnumerable().OfType<IOrderDetail>();

        }

    }

}

public static class Order

{

    public static Employee GetEmployee(this IOrder o)

    {

        return GetEmployee(o.OrderID);

    }

    public static Employee GetEmployee(int orderID)

    {

        using (var context = new EmployeesEntities())

        {

            var o = new Employees.Order { OrderID = orderID };

            context.AttachTo("Orders", o);

            o.EmployeeReference.Load();

            return o.Employee;

        }

    }

    public static Customer GetCustomer(this IOrder o)

    {

        return GetCustomer(o.OrderID);

    }

    public static Customer GetCustomer(int orderID)

    {

        using (var context = new OrdersEntities())

        {

            var o = new Orders.Order { OrderID = orderID };

            context.AttachTo("Orders", o);

            o.CustomerReference.Load();

            return o.Customer;

        }

    }

}

public static class OrderDetail

{

    public static IProduct GetProduct(this IOrderDetail od)

    {

        return GetProduct(od.OrderID, od.ProductID);

    }

    public static IProduct GetProduct(int orderID, int productID)

    {

        using (var context = new OrdersEntities())

        {

            var od = new Orders.OrderDetail { OrderID = orderID, ProductID = productID };

            context.AttachTo("OrderDetails", od);

            od.ProductReference.Load();

            return od.Product;

        }

    }

    public static Category GetCategory(this IOrderDetail od)

    {

        return Product.GetCategory(od.ProductID);

    }

    public static Employee GetEmployee(this IOrderDetail od)

    {

        return Order.GetEmployee(od.OrderID);

    }

    public static Customer GetCustomer(this IOrderDetail od)

    {

        return Order.GetCustomer(od.OrderID);

    }

}

using (var stockContext = new StocksEntities())

{

    var bestSupplierPerCategory = from c in stockContext.Categories.Include("Products").AsEnumerable()

                                  let productSuppliers = from p in c.Products

                                                         select p.GetSupplier()

                                  let suppliers = from s in productSuppliers.Distinct()

                                                  orderby productSuppliers.Count(su => su.SupplierID == s.SupplierID) descending

                                                  select s

                                  select new { Category = c, Supplier = suppliers.FirstOrDefault() };

}

using (var stockContext = new StocksEntities())

{

    using (var employeesContext = new EmployeesEntities())

    {

        var bestEmployeePerCategory =

            from c in

                (from c in stockContext.Categories

                 select new

                 {

                     Category = c,

                     ProductsID = (from p in c.Products

                                   select p.ProductID)

                 }).AsEnumerable()

            let bestEmployee = (from od in employeesContext.OrderDetails.Where(BuildContainsExpression<Entities.Employees.OrderDetail, int>(od2 => od2.ProductID, c.ProductsID))

                                let e = od.Order.Employee

                                group od by new { e.EmployeeID, e.LastName, e.FirstName } into g

                                let sold = g.Sum(od => (double)od.UnitPrice * (double)od.Quantity * (1D - (double)od.Discount))

                                orderby sold descending

                                select new { g.Key.EmployeeID, g.Key.LastName, g.Key.FirstName, Sold = sold }).FirstOrDefault()

            select new { Category = c.Category, Employee = bestEmployee };

    }

}

using (var context = new MyNorthwindEFEntities())

{

    foreach (var c in context.Categories.ToList())

        context.DeleteObject(c);

    context.SaveChanges();

}

using (var context = new MyNorthwindEFEntities())

{

    foreach (var cId in context.Categories.Select(c => c.CategoryID))

    {

        var c = new Categories{ CategoryID = cId };

        context.AttachTo("Categories", c);

        context.DeleteObject(c);

    }

    context.SaveChanges();

}

context.ExecuteStoreCommand("DELETE FROM Products");

context.CreateCategory(id:1, name:"C1", description:"D1");

using System;

using System.Data.Objects;

using System.Data.Objects.DataClasses;

using System.Data.EntityClient;

using System.ComponentModel;

using System.Xml.Serialization;

using System.Runtime.Serialization;

[assembly: EdmSchemaAttribute()]

#region EDM Relationship Metadata

[assembly: EdmRelationshipAttribute("Test", "CategoryProduct", "Category", System.Data.Metadata.Edm.RelationshipMultiplicity.ZeroOrOne, typeof(ConsoleApplication1.Category), "Product", System.Data.Metadata.Edm.RelationshipMultiplicity.Many, typeof(ConsoleApplication1.Product))]

[assembly: EdmRelationshipAttribute("Test", "SupplierProduct", "Supplier", System.Data.Metadata.Edm.RelationshipMultiplicity.ZeroOrOne, typeof(ConsoleApplication1.Supplier), "Product", System.Data.Metadata.Edm.RelationshipMultiplicity.Many, typeof(ConsoleApplication1.Product))]

#endregion

namespace ConsoleApplication1

{

    #region Contexts

    /// <summary>

    /// No Metadata Documentation available.

    /// </summary>

    public partial class TestContainer : ObjectContext

    {

        #region Constructors

        /// <summary>

        /// Initializes a new TestContainer object using the connection string found in the 'TestContainer' section of the application configuration file.

        /// </summary>

        public TestContainer()

            : base("name=TestContainer", "TestContainer")

        {

            OnContextCreated();

        }

        /// <summary>

        /// Initialize a new TestContainer object.

        /// </summary>

        public TestContainer(string connectionString)

            : base(connectionString, "TestContainer")

        {

            OnContextCreated();

        }

        /// <summary>

        /// Initialize a new TestContainer object.

        /// </summary>

        public TestContainer(EntityConnection connection)

            : base(connection, "TestContainer")

        {

            OnContextCreated();

        }

        #endregion

        #region Partial Methods

        partial void OnContextCreated();

        #endregion

        #region ObjectSet Properties

        /// <summary>

        /// No Metadata Documentation available.

        /// </summary>

        public ObjectSet<Category> Categories

        {

            get

            {

                if ((_Categories == null))

                {

                    _Categories = base.CreateObjectSet<Category>("Categories");

                }

                return _Categories;

            }

        }

        private ObjectSet<Category> _Categories;

        /// <summary>

        /// No Metadata Documentation available.

        /// </summary>

        public ObjectSet<Product> Products

        {

            get

            {

                if ((_Products == null))

                {

                    _Products = base.CreateObjectSet<Product>("Products");

                }

                return _Products;

            }

        }

        private ObjectSet<Product> _Products;

        /// <summary>

        /// No Metadata Documentation available.

        /// </summary>

        public ObjectSet<Supplier> Suppliers

        {

            get

            {

                if ((_Suppliers == null))

                {

                    _Suppliers = base.CreateObjectSet<Supplier>("Suppliers");

                }

                return _Suppliers;

            }

        }

        private ObjectSet<Supplier> _Suppliers;

        #endregion

        #region AddTo Methods

        /// <summary>

        /// Deprecated Method for adding a new object to the Categories EntitySet. Consider using the .Add method of the associated ObjectSet&lt;T&gt; property instead.

        /// </summary>

        public void AddToCategories(Category category)

        {

            base.AddObject("Categories", category);

        }

        /// <summary>

        /// Deprecated Method for adding a new object to the Products EntitySet. Consider using the .Add method of the associated ObjectSet&lt;T&gt; property instead.

        /// </summary>

        public void AddToProducts(Product product)

        {

            base.AddObject("Products", product);

        }

        /// <summary>

        /// Deprecated Method for adding a new object to the Suppliers EntitySet. Consider using the .Add method of the associated ObjectSet&lt;T&gt; property instead.

        /// </summary>

        public void AddToSuppliers(Supplier supplier)

        {

            base.AddObject("Suppliers", supplier);

        }

        #endregion

    }

    #endregion

    #region Entities

    /// <summary>

    /// No Metadata Documentation available.

    /// </summary>

    [EdmEntityTypeAttribute(NamespaceName = "Test", Name = "Category")]

    [Serializable()]

    [DataContractAttribute(IsReference = true)]

    public partial class Category : EntityObject

    {

        #region Factory Method

        /// <summary>

        /// Create a new Category object.

        /// </summary>

        /// <param name="id">Initial value of the Id property.</param>

        /// <param name="name">Initial value of the Name property.</param>

        /// <param name="description">Initial value of the Description property.</param>

        public static Category CreateCategory(global::System.Int32 id, global::System.String name, global::System.String description)

        {

            Category category = new Category();

            category.Id = id;

            category.Name = name;

            category.Description = description;

            return category;

        }

        #endregion

        #region Primitive Properties

        /// <summary>

        /// No Metadata Documentation available.

        /// </summary>

        [EdmScalarPropertyAttribute(EntityKeyProperty = true, IsNullable = false)]

        [DataMemberAttribute()]

        public global::System.Int32 Id

        {

            get

            {

                return _Id;

            }

            set

            {

                if (Id != value)

                {

                    OnIdChanging(value);

                    ReportPropertyChanging("Id");

                    _Id = StructuralObject.SetValidValue(value);

                    ReportPropertyChanged("Id");

                    OnIdChanged();

                }

            }

        }

        private global::System.Int32 _Id;

        partial void OnIdChanging(global::System.Int32 value);

        partial void OnIdChanged();

        /// <summary>

        /// No Metadata Documentation available.

        /// </summary>

        [EdmScalarPropertyAttribute(EntityKeyProperty = false, IsNullable = false)]

        [DataMemberAttribute()]

        public global::System.String Name

        {

            get

            {

                return _Name;

            }

            set

            {

                OnNameChanging(value);

                ReportPropertyChanging("Name");

                _Name = StructuralObject.SetValidValue(value, false);

                ReportPropertyChanged("Name");

                OnNameChanged();

            }

        }

        private global::System.String _Name;

        partial void OnNameChanging(global::System.String value);

        partial void OnNameChanged();

        /// <summary>

        /// No Metadata Documentation available.

        /// </summary>

        [EdmScalarPropertyAttribute(EntityKeyProperty = false, IsNullable = false)]

        [DataMemberAttribute()]

        public global::System.String Description

        {

            get

            {

                return _Description;

            }

            set

            {

                OnDescriptionChanging(value);

                ReportPropertyChanging("Description");

                _Description = StructuralObject.SetValidValue(value, false);

                ReportPropertyChanged("Description");

                OnDescriptionChanged();

            }

        }

        private global::System.String _Description;

        partial void OnDescriptionChanging(global::System.String value);

        partial void OnDescriptionChanged();

        #endregion

        #region Navigation Properties

        /// <summary>

        /// No Metadata Documentation available.

        /// </summary>

        [XmlIgnoreAttribute()]

        [SoapIgnoreAttribute()]

        [DataMemberAttribute()]

        [EdmRelationshipNavigationPropertyAttribute("Test", "CategoryProduct", "Product")]

        public EntityCollection<Product> Products

        {

            get

            {

                return ((IEntityWithRelationships)this).RelationshipManager.GetRelatedCollection<Product>("Test.CategoryProduct", "Product");

            }

            set

            {

                if ((value != null))

                {

                    ((IEntityWithRelationships)this).RelationshipManager.InitializeRelatedCollection<Product>("Test.CategoryProduct", "Product", value);

                }

            }

        }

        #endregion

    }

    /// <summary>

    /// No Metadata Documentation available.

    /// </summary>

    [EdmEntityTypeAttribute(NamespaceName = "Test", Name = "Product")]

    [Serializable()]

    [DataContractAttribute(IsReference = true)]

    public partial class Product : EntityObject

    {

        #region Factory Method

        /// <summary>

        /// Create a new Product object.

        /// </summary>

        /// <param name="id">Initial value of the Id property.</param>

        /// <param name="name">Initial value of the Name property.</param>

        public static Product CreateProduct(global::System.Int32 id, global::System.String name)

        {

            Product product = new Product();

            product.Id = id;

            product.Name = name;

            return product;

        }

        #endregion

        #region Primitive Properties

        /// <summary>

        /// No Metadata Documentation available.

        /// </summary>

        [EdmScalarPropertyAttribute(EntityKeyProperty = true, IsNullable = false)]

        [DataMemberAttribute()]

        public global::System.Int32 Id

        {

            get

            {

                return _Id;

            }

            set

            {

                if (Id != value)

                {

                    OnIdChanging(value);

                    ReportPropertyChanging("Id");

                    _Id = StructuralObject.SetValidValue(value);

                    ReportPropertyChanged("Id");

                    OnIdChanged();

                }

            }

        }

        private global::System.Int32 _Id;

        partial void OnIdChanging(global::System.Int32 value);

        partial void OnIdChanged();

        /// <summary>

        /// No Metadata Documentation available.

        /// </summary>

        [EdmScalarPropertyAttribute(EntityKeyProperty = false, IsNullable = false)]

        [DataMemberAttribute()]

        public global::System.String Name

        {

            get

            {

                return _Name;

            }

            set

            {

                OnNameChanging(value);

                ReportPropertyChanging("Name");

                _Name = StructuralObject.SetValidValue(value, false);

                ReportPropertyChanged("Name");

                OnNameChanged();

            }

        }

        private global::System.String _Name;

        partial void OnNameChanging(global::System.String value);

        partial void OnNameChanged();

        #endregion

        #region Navigation Properties

        /// <summary>

        /// No Metadata Documentation available.

        /// </summary>

        [XmlIgnoreAttribute()]

        [SoapIgnoreAttribute()]

        [DataMemberAttribute()]

        [EdmRelationshipNavigationPropertyAttribute("Test", "CategoryProduct", "Category")]

        public Category Category

        {

            get

            {

                return ((IEntityWithRelationships)this).RelationshipManager.GetRelatedReference<Category>("Test.CategoryProduct", "Category").Value;

            }

            set

            {

                ((IEntityWithRelationships)this).RelationshipManager.GetRelatedReference<Category>("Test.CategoryProduct", "Category").Value = value;

            }

        }

        /// <summary>

        /// No Metadata Documentation available.

        /// </summary>

        [BrowsableAttribute(false)]

        [DataMemberAttribute()]

        public EntityReference<Category> CategoryReference

        {

            get

            {

                return ((IEntityWithRelationships)this).RelationshipManager.GetRelatedReference<Category>("Test.CategoryProduct", "Category");

            }

            set

            {

                if ((value != null))

                {

                    ((IEntityWithRelationships)this).RelationshipManager.InitializeRelatedReference<Category>("Test.CategoryProduct", "Category", value);

                }

            }

        }

        /// <summary>

        /// No Metadata Documentation available.

        /// </summary>

        [XmlIgnoreAttribute()]

        [SoapIgnoreAttribute()]

        [DataMemberAttribute()]

        [EdmRelationshipNavigationPropertyAttribute("Test", "SupplierProduct", "Supplier")]

        public Supplier Supplier

        {

            get

            {

                return ((IEntityWithRelationships)this).RelationshipManager.GetRelatedReference<Supplier>("Test.SupplierProduct", "Supplier").Value;

            }

            set

            {

                ((IEntityWithRelationships)this).RelationshipManager.GetRelatedReference<Supplier>("Test.SupplierProduct", "Supplier").Value = value;

            }

        }

        /// <summary>

        /// No Metadata Documentation available.

        /// </summary>

        [BrowsableAttribute(false)]

        [DataMemberAttribute()]

        public EntityReference<Supplier> SupplierReference

        {

            get

            {

                return ((IEntityWithRelationships)this).RelationshipManager.GetRelatedReference<Supplier>("Test.SupplierProduct", "Supplier");

            }

            set

            {

                if ((value != null))

                {

                    ((IEntityWithRelationships)this).RelationshipManager.InitializeRelatedReference<Supplier>("Test.SupplierProduct", "Supplier", value);

                }

            }

        }

        #endregion

    }

    /// <summary>

    /// No Metadata Documentation available.

    /// </summary>

    [EdmEntityTypeAttribute(NamespaceName = "Test", Name = "Supplier")]

    [Serializable()]

    [DataContractAttribute(IsReference = true)]

    public partial class Supplier : EntityObject

    {

        #region Factory Method

        /// <summary>

        /// Create a new Supplier object.

        /// </summary>

        /// <param name="id">Initial value of the Id property.</param>

        /// <param name="companyName">Initial value of the CompanyName property.</param>

        /// <param name="address">Initial value of the Address property.</param>

        public static Supplier CreateSupplier(global::System.Int32 id, global::System.String companyName, Address address)

        {

            Supplier supplier = new Supplier();

            supplier.Id = id;

            supplier.CompanyName = companyName;

            supplier.Address = StructuralObject.VerifyComplexObjectIsNotNull(address, "Address");

            return supplier;

        }

        #endregion

        #region Primitive Properties

        /// <summary>

        /// No Metadata Documentation available.

        /// </summary>

        [EdmScalarPropertyAttribute(EntityKeyProperty = true, IsNullable = false)]

        [DataMemberAttribute()]

        public global::System.Int32 Id

        {

            get

            {

                return _Id;

            }

            set

            {

                if (Id != value)

                {

                    OnIdChanging(value);

                    ReportPropertyChanging("Id");

                    _Id = StructuralObject.SetValidValue(value);

                    ReportPropertyChanged("Id");

                    OnIdChanged();

                }

            }

        }

        private global::System.Int32 _Id;

        partial void OnIdChanging(global::System.Int32 value);

        partial void OnIdChanged();

        /// <summary>

        /// No Metadata Documentation available.

        /// </summary>

        [EdmScalarPropertyAttribute(EntityKeyProperty = false, IsNullable = false)]

        [DataMemberAttribute()]

        public global::System.String CompanyName

        {

            get

            {

                return _CompanyName;

            }

            set

            {

                OnCompanyNameChanging(value);

                ReportPropertyChanging("CompanyName");

                _CompanyName = StructuralObject.SetValidValue(value, false);

                ReportPropertyChanged("CompanyName");

                OnCompanyNameChanged();

            }

        }

        private global::System.String _CompanyName;

        partial void OnCompanyNameChanging(global::System.String value);

        partial void OnCompanyNameChanged();

        #endregion

        #region Complex Properties

        /// <summary>

        /// No Metadata Documentation available.

        /// </summary>

        [EdmComplexPropertyAttribute()]

        [DesignerSerializationVisibility(DesignerSerializationVisibility.Content)]

        [XmlElement(IsNullable = true)]

        [SoapElement(IsNullable = true)]

        [DataMemberAttribute()]

        public Address Address

        {

            get

            {

                _Address = GetValidValue(_Address, "Address", false, _AddressInitialized);

                _AddressInitialized = true;

                return _Address;

            }

            set

            {

                OnAddressChanging(value);

                ReportPropertyChanging("Address");

                _Address = SetValidValue(_Address, value, "Address");

                _AddressInitialized = true;

                ReportPropertyChanged("Address");

                OnAddressChanged();

            }

        }

        private Address _Address;

        private bool _AddressInitialized;

        partial void OnAddressChanging(Address value);

        partial void OnAddressChanged();

        #endregion

        #region Navigation Properties

        /// <summary>

        /// No Metadata Documentation available.

        /// </summary>

        [XmlIgnoreAttribute()]

        [SoapIgnoreAttribute()]

        [DataMemberAttribute()]

        [EdmRelationshipNavigationPropertyAttribute("Test", "SupplierProduct", "Product")]

        public EntityCollection<Product> Products

        {

            get

            {

                return ((IEntityWithRelationships)this).RelationshipManager.GetRelatedCollection<Product>("Test.SupplierProduct", "Product");

            }

            set

            {

                if ((value != null))

                {

                    ((IEntityWithRelationships)this).RelationshipManager.InitializeRelatedCollection<Product>("Test.SupplierProduct", "Product", value);

                }

            }

        }

        #endregion

    }

    #endregion

    #region ComplexTypes

    /// <summary>

    /// No Metadata Documentation available.

    /// </summary>

    [EdmComplexTypeAttribute(NamespaceName = "Test", Name = "Address")]

    [DataContractAttribute(IsReference = true)]

    [Serializable()]

    public partial class Address : ComplexObject

    {

        #region Factory Method

        /// <summary>

        /// Create a new Address object.

        /// </summary>

        /// <param name="addressLine">Initial value of the AddressLine property.</param>

        /// <param name="postalCode">Initial value of the PostalCode property.</param>

        /// <param name="city">Initial value of the City property.</param>

        /// <param name="region">Initial value of the Region property.</param>

        /// <param name="country">Initial value of the Country property.</param>

        public static Address CreateAddress(global::System.String addressLine, global::System.String postalCode, global::System.String city, global::System.String region, global::System.String country)

        {

            Address address = new Address();

            address.AddressLine = addressLine;

            address.PostalCode = postalCode;

            address.City = city;

            address.Region = region;

            address.Country = country;

            return address;

        }

        #endregion

        #region Primitive Properties

        /// <summary>

        /// No Metadata Documentation available.

        /// </summary>

        [EdmScalarPropertyAttribute(EntityKeyProperty = false, IsNullable = false)]

        [DataMemberAttribute()]

        public global::System.String AddressLine

        {

            get

            {

                return _AddressLine;

            }

            set

            {

                OnAddressLineChanging(value);

                ReportPropertyChanging("AddressLine");

                _AddressLine = StructuralObject.SetValidValue(value, false);

                ReportPropertyChanged("AddressLine");

                OnAddressLineChanged();

            }

        }

        private global::System.String _AddressLine;

        partial void OnAddressLineChanging(global::System.String value);

        partial void OnAddressLineChanged();

        /// <summary>

        /// No Metadata Documentation available.

        /// </summary>

        [EdmScalarPropertyAttribute(EntityKeyProperty = false, IsNullable = false)]

        [DataMemberAttribute()]

        public global::System.String PostalCode

        {

            get

            {

                return _PostalCode;

            }

            set

            {

                OnPostalCodeChanging(value);

                ReportPropertyChanging("PostalCode");

                _PostalCode = StructuralObject.SetValidValue(value, false);

                ReportPropertyChanged("PostalCode");

                OnPostalCodeChanged();

            }

        }

        private global::System.String _PostalCode;

        partial void OnPostalCodeChanging(global::System.String value);

        partial void OnPostalCodeChanged();

        /// <summary>

        /// No Metadata Documentation available.

        /// </summary>

        [EdmScalarPropertyAttribute(EntityKeyProperty = false, IsNullable = false)]

        [DataMemberAttribute()]

        public global::System.String City

        {

            get

            {

                return _City;

            }

            set

            {

                OnCityChanging(value);

                ReportPropertyChanging("City");

                _City = StructuralObject.SetValidValue(value, false);

                ReportPropertyChanged("City");

                OnCityChanged();

            }

        }

        private global::System.String _City;

        partial void OnCityChanging(global::System.String value);

        partial void OnCityChanged();

        /// <summary>

        /// No Metadata Documentation available.

        /// </summary>

        [EdmScalarPropertyAttribute(EntityKeyProperty = false, IsNullable = false)]

        [DataMemberAttribute()]

        public global::System.String Region

        {

            get

            {

                return _Region;

            }

            set

            {

                OnRegionChanging(value);

                ReportPropertyChanging("Region");

                _Region = StructuralObject.SetValidValue(value, false);

                ReportPropertyChanged("Region");

                OnRegionChanged();

            }

        }

        private global::System.String _Region;

        partial void OnRegionChanging(global::System.String value);

        partial void OnRegionChanged();

        /// <summary>

        /// No Metadata Documentation available.

        /// </summary>

        [EdmScalarPropertyAttribute(EntityKeyProperty = false, IsNullable = false)]

        [DataMemberAttribute()]

        public global::System.String Country

        {

            get

            {

                return _Country;

            }

            set

            {

                OnCountryChanging(value);

                ReportPropertyChanging("Country");

                _Country = StructuralObject.SetValidValue(value, false);

                ReportPropertyChanged("Country");

                OnCountryChanged();

            }

        }

        private global::System.String _Country;

        partial void OnCountryChanging(global::System.String value);

        partial void OnCountryChanged();

        #endregion

    }

    #endregion

}

using System;

using System.Data.Objects;

using System.Data.Objects.DataClasses;

using System.Data.EntityClient;

using System.ComponentModel;

using System.Xml.Serialization;

using System.Runtime.Serialization;

using System.Collections.Generic;

namespace ConsoleApplication1

{

    #region Contexts

    public interface ITestContainer

    {

        IObjectSet<Category> Categories { get; }

        IObjectSet<Product> Products { get; }

        IObjectSet<Supplier> Suppliers { get; }

    }

    /// <summary>

    /// No Metadata Documentation available.

    /// </summary>

    public partial class TestContainer : ObjectContext, ITestContainer

    {

        #region Constructors

        /// <summary>

        /// Initializes a new TestContainer object using the connection string found in the 'TestContainer' section of the application configuration file.

        /// </summary>

        public TestContainer()

            : base("name=TestContainer", "TestContainer")

        {

            OnContextCreated();

        }

        /// <summary>

        /// Initialize a new TestContainer object.

        /// </summary>

        public TestContainer(string connectionString)

            : base(connectionString, "TestContainer")

        {

            OnContextCreated();

        }

        /// <summary>

        /// Initialize a new TestContainer object.

        /// </summary>

        public TestContainer(EntityConnection connection)

            : base(connection, "TestContainer")

        {

            OnContextCreated();

        }

        #endregion

        #region Partial Methods

        partial void OnContextCreated();

        #endregion

        #region ObjectSet Properties

        /// <summary>

        /// No Metadata Documentation available.

        /// </summary>

        public ObjectSet<Category> Categories

        {

            get

            {

                if (_Categories == null)

                    _Categories = CreateObjectSet<Category>("Categories");

                return _Categories;

            }

        }

        private ObjectSet<Category> _Categories;

        IObjectSet<Category> ITestContainer.Categories { get { return Categories; } }

        /// <summary>

        /// No Metadata Documentation available.

        /// </summary>

        public ObjectSet<Product> Products

        {

            get

            {

                if (_Products == null)

                    _Products = CreateObjectSet<Product>("Products");

                return _Products;

            }

        }

        private ObjectSet<Product> _Products;

        IObjectSet<Product> ITestContainer.Products { get { return Products; } }

        /// <summary>

        /// No Metadata Documentation available.

        /// </summary>

        public ObjectSet<Supplier> Suppliers

        {

            get

            {

                if (_Suppliers == null)

                    _Suppliers = CreateObjectSet<Supplier>("Suppliers");

                return _Suppliers;

            }

        }

        private ObjectSet<Supplier> _Suppliers;

        IObjectSet<Supplier> ITestContainer.Suppliers { get { return Suppliers; } }

        #endregion

        #region AddTo Methods

        /// <summary>

        /// Deprecated Method for adding a new object to the Categories EntitySet. Consider using the .Add method of the associated ObjectSet&lt;T&gt; property instead.

        /// </summary>

        public void AddToCategories(Category category)

        {

            base.AddObject("Categories", category);

        }

        /// <summary>

        /// Deprecated Method for adding a new object to the Products EntitySet. Consider using the .Add method of the associated ObjectSet&lt;T&gt; property instead.

        /// </summary>

        public void AddToProducts(Product product)

        {

            base.AddObject("Products", product);

        }

        /// <summary>

        /// Deprecated Method for adding a new object to the Suppliers EntitySet. Consider using the .Add method of the associated ObjectSet&lt;T&gt; property instead.

        /// </summary>

        public void AddToSuppliers(Supplier supplier)

        {

            base.AddObject("Suppliers", supplier);

        }

        #endregion

    }

    #endregion

    #region Entities

    /// <summary>

    /// No Metadata Documentation available.

    /// </summary>

    [DataContractAttribute(IsReference = true)]

    public partial class Category

    {

        #region Primitive Properties

        /// <summary>

        /// No Metadata Documentation available.

        /// </summary>

        [DataMemberAttribute()]

        public Int32 Id { get; set; }

        /// <summary>

        /// No Metadata Documentation available.

        /// </summary>

        [DataMemberAttribute()]

        public virtual String Name { get; set; }

        /// <summary>

        /// No Metadata Documentation available.

        /// </summary>

        [DataMemberAttribute()]

        public virtual String Description { get; set; }

        #endregion

        #region Navigation Properties

        private List<Product> _products;

        [DataMemberAttribute()]

        /// <summary>

        /// No Metadata Documentation available.

        /// </summary>

        public virtual List<Product> Products

        {

            get

            {

                if (_products == null)

                    _products = new List<Product>();

                return _products;

            }

            set { _products = value; }

        }

        #endregion

    }

    /// <summary>

    /// No Metadata Documentation available.

    /// </summary>

    [DataContractAttribute(IsReference = true)]

    public partial class Product

    {

        #region Primitive Properties

        /// <summary>

        /// No Metadata Documentation available.

        /// </summary>

        [DataMemberAttribute()]

        public Int32 Id { get; set; }

        /// <summary>

        /// No Metadata Documentation available.

        /// </summary>

        [DataMemberAttribute()]

        public virtual String Name { get; set; }

        #endregion

        #region Navigation Properties

        /// <summary>

        /// No Metadata Documentation available.

        /// </summary>

        [DataMemberAttribute()]

        public virtual Category Category { get; set; }

        /// <summary>

        /// No Metadata Documentation available.

        /// </summary>

        [DataMemberAttribute()]

        public virtual Supplier Supplier { get; set; }

        #endregion

    }

    /// <summary>

    /// No Metadata Documentation available.

    /// </summary>

    [DataContractAttribute(IsReference = true)]

    public partial class Supplier

    {

        #region Primitive Properties

        /// <summary>

        /// No Metadata Documentation available.

        /// </summary>

        [DataMemberAttribute()]

        public Int32 Id { get; set; }

        /// <summary>

        /// No Metadata Documentation available.

        /// </summary>

        [DataMemberAttribute()]

        public virtual String CompanyName { get; set; }

        #endregion

        #region Complex Properties

        /// <summary>

        /// No Metadata Documentation available.

        /// </summary>

        [DataMemberAttribute()]

        public virtual Address Address { get; set; }

        #endregion

        #region Navigation Properties

        /// <summary>

        /// No Metadata Documentation available.

        /// </summary>

        [DataMemberAttribute()]

        private List<Product> _products;

        public virtual List<Product> Products

        {

            get

            {

                if (_products == null)

                    _products = new List<Product>();

                return _products;

            }

            set { _products = value; }

        }

        #endregion

    }

    #endregion

    #region ComplexTypes

    /// <summary>

    /// No Metadata Documentation available.

    /// </summary>

    [DataContractAttribute(IsReference = true)]

    public partial class Address

    {

        #region Primitive Properties

        /// <summary>

        /// No Metadata Documentation available.

        /// </summary>

        [DataMemberAttribute()]

        public virtual String AddressLine { get; set; }

        /// <summary>

        /// No Metadata Documentation available.

        /// </summary>

        [DataMemberAttribute()]

        public virtual String PostalCode { get; set; }

        /// <summary>

        /// No Metadata Documentation available.

        /// </summary>

        [DataMemberAttribute()]

        public virtual String City { get; set; }

        /// <summary>

        /// No Metadata Documentation available.

        /// </summary>

        [DataMemberAttribute()]

        public virtual String Region { get; set; }

        /// <summary>

        /// No Metadata Documentation available.

        /// </summary>

        [DataMemberAttribute()]

        public virtual String Country { get; set; }

        #endregion

    }

    #endregion

}

context.ContextOptions.DeferredLoadingEnabled = true;