Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

Added testlinq/NorthwindModel.EF6.2015.Designer.cs.

            1  +/********************************************************
            2  + * ADO.NET 2.0 Data Provider for SQLite Version 3.X
            3  + * Written by Robert Simpson (robert@blackcastlesoft.com)
            4  + *
            5  + * Released to the public domain, use at your own risk!
            6  + ********************************************************/
            7  +
            8  +//------------------------------------------------------------------------------
            9  +// <auto-generated>
           10  +//    This code was generated from a template.
           11  +//
           12  +//    Manual changes to this file may cause unexpected behavior in your application.
           13  +//    Manual changes to this file will be overwritten if the code is regenerated.
           14  +// </auto-generated>
           15  +//------------------------------------------------------------------------------
           16  +
           17  +using System;
           18  +using System.ComponentModel;
           19  +using System.Data.Entity.Core.EntityClient;
           20  +using System.Data.Entity.Core.Metadata.Edm;
           21  +using System.Data.Entity.Core.Objects;
           22  +using System.Data.Entity.Core.Objects.DataClasses;
           23  +using System.Runtime.Serialization;
           24  +using System.Xml.Serialization;
           25  +
           26  +[assembly: EdmSchemaAttribute()]
           27  +#region EDM Relationship Metadata
           28  +
           29  +[assembly: EdmRelationshipAttribute("northwindEFModel", "FK_Products_CategoryID_CategoryID", "Categories", RelationshipMultiplicity.ZeroOrOne, typeof(testlinq.Categories), "Products", RelationshipMultiplicity.Many, typeof(testlinq.Products))]
           30  +[assembly: EdmRelationshipAttribute("northwindEFModel", "FK_Orders_CustomerID_CustomerID", "Customers", RelationshipMultiplicity.ZeroOrOne, typeof(testlinq.Customers), "Orders", RelationshipMultiplicity.Many, typeof(testlinq.Orders))]
           31  +[assembly: EdmRelationshipAttribute("northwindEFModel", "FK_InternationalOrders_OrderID_OrderID", "Orders", RelationshipMultiplicity.One, typeof(testlinq.Orders), "InternationalOrders", RelationshipMultiplicity.ZeroOrOne, typeof(testlinq.InternationalOrders), true)]
           32  +[assembly: EdmRelationshipAttribute("northwindEFModel", "FK_OrderDetails_OrderID_OrderID", "Orders", RelationshipMultiplicity.One, typeof(testlinq.Orders), "OrderDetails", RelationshipMultiplicity.Many, typeof(testlinq.OrderDetails), true)]
           33  +[assembly: EdmRelationshipAttribute("northwindEFModel", "FK_OrderDetails_ProductID_ProductID", "Products", RelationshipMultiplicity.One, typeof(testlinq.Products), "OrderDetails", RelationshipMultiplicity.Many, typeof(testlinq.OrderDetails), true)]
           34  +[assembly: EdmRelationshipAttribute("northwindEFModel", "FK_Products_SupplierID_SupplierID", "Suppliers", RelationshipMultiplicity.ZeroOrOne, typeof(testlinq.Suppliers), "Products", RelationshipMultiplicity.Many, typeof(testlinq.Products))]
           35  +[assembly: EdmRelationshipAttribute("northwindEFModel", "FK_Territories_RegionID_RegionID", "Regions", RelationshipMultiplicity.One, typeof(testlinq.Regions), "Territories", RelationshipMultiplicity.Many, typeof(testlinq.Territories))]
           36  +[assembly: EdmRelationshipAttribute("northwindEFModel", "EmployeesTerritories", "Employees", RelationshipMultiplicity.Many, typeof(testlinq.Employees), "Territories", RelationshipMultiplicity.Many, typeof(testlinq.Territories))]
           37  +
           38  +#endregion
           39  +
           40  +namespace testlinq
           41  +{
           42  +    #region Contexts
           43  +
           44  +    /// <summary>
           45  +    /// No Metadata Documentation available.
           46  +    /// </summary>
           47  +    public partial class northwindEFEntities : ObjectContext
           48  +    {
           49  +        #region Constructors
           50  +
           51  +        /// <summary>
           52  +        /// Initializes a new northwindEFEntities object using the connection string found in the 'northwindEFEntities' section of the application configuration file.
           53  +        /// </summary>
           54  +        public northwindEFEntities() : base("name=northwindEFEntities", "northwindEFEntities")
           55  +        {
           56  +            OnContextCreated();
           57  +        }
           58  +
           59  +        /// <summary>
           60  +        /// Initialize a new northwindEFEntities object.
           61  +        /// </summary>
           62  +        public northwindEFEntities(string connectionString) : base(connectionString, "northwindEFEntities")
           63  +        {
           64  +            OnContextCreated();
           65  +        }
           66  +
           67  +        /// <summary>
           68  +        /// Initialize a new northwindEFEntities object.
           69  +        /// </summary>
           70  +        public northwindEFEntities(EntityConnection connection) : base(connection, "northwindEFEntities")
           71  +        {
           72  +            OnContextCreated();
           73  +        }
           74  +
           75  +        #endregion
           76  +
           77  +        #region Partial Methods
           78  +
           79  +        partial void OnContextCreated();
           80  +
           81  +        #endregion
           82  +
           83  +        #region ObjectSet Properties
           84  +
           85  +        /// <summary>
           86  +        /// No Metadata Documentation available.
           87  +        /// </summary>
           88  +        public ObjectSet<Categories> Categories
           89  +        {
           90  +            get
           91  +            {
           92  +                if ((_Categories == null))
           93  +                {
           94  +                    _Categories = base.CreateObjectSet<Categories>("Categories");
           95  +                }
           96  +                return _Categories;
           97  +            }
           98  +        }
           99  +        private ObjectSet<Categories> _Categories;
          100  +
          101  +        /// <summary>
          102  +        /// No Metadata Documentation available.
          103  +        /// </summary>
          104  +        public ObjectSet<Customers> Customers
          105  +        {
          106  +            get
          107  +            {
          108  +                if ((_Customers == null))
          109  +                {
          110  +                    _Customers = base.CreateObjectSet<Customers>("Customers");
          111  +                }
          112  +                return _Customers;
          113  +            }
          114  +        }
          115  +        private ObjectSet<Customers> _Customers;
          116  +
          117  +        /// <summary>
          118  +        /// No Metadata Documentation available.
          119  +        /// </summary>
          120  +        public ObjectSet<Employees> Employees
          121  +        {
          122  +            get
          123  +            {
          124  +                if ((_Employees == null))
          125  +                {
          126  +                    _Employees = base.CreateObjectSet<Employees>("Employees");
          127  +                }
          128  +                return _Employees;
          129  +            }
          130  +        }
          131  +        private ObjectSet<Employees> _Employees;
          132  +
          133  +        /// <summary>
          134  +        /// No Metadata Documentation available.
          135  +        /// </summary>
          136  +        public ObjectSet<InternationalOrders> InternationalOrders
          137  +        {
          138  +            get
          139  +            {
          140  +                if ((_InternationalOrders == null))
          141  +                {
          142  +                    _InternationalOrders = base.CreateObjectSet<InternationalOrders>("InternationalOrders");
          143  +                }
          144  +                return _InternationalOrders;
          145  +            }
          146  +        }
          147  +        private ObjectSet<InternationalOrders> _InternationalOrders;
          148  +
          149  +        /// <summary>
          150  +        /// No Metadata Documentation available.
          151  +        /// </summary>
          152  +        public ObjectSet<OrderDetails> OrderDetails
          153  +        {
          154  +            get
          155  +            {
          156  +                if ((_OrderDetails == null))
          157  +                {
          158  +                    _OrderDetails = base.CreateObjectSet<OrderDetails>("OrderDetails");
          159  +                }
          160  +                return _OrderDetails;
          161  +            }
          162  +        }
          163  +        private ObjectSet<OrderDetails> _OrderDetails;
          164  +
          165  +        /// <summary>
          166  +        /// No Metadata Documentation available.
          167  +        /// </summary>
          168  +        public ObjectSet<Orders> Orders
          169  +        {
          170  +            get
          171  +            {
          172  +                if ((_Orders == null))
          173  +                {
          174  +                    _Orders = base.CreateObjectSet<Orders>("Orders");
          175  +                }
          176  +                return _Orders;
          177  +            }
          178  +        }
          179  +        private ObjectSet<Orders> _Orders;
          180  +
          181  +        /// <summary>
          182  +        /// No Metadata Documentation available.
          183  +        /// </summary>
          184  +        public ObjectSet<PreviousEmployees> PreviousEmployees
          185  +        {
          186  +            get
          187  +            {
          188  +                if ((_PreviousEmployees == null))
          189  +                {
          190  +                    _PreviousEmployees = base.CreateObjectSet<PreviousEmployees>("PreviousEmployees");
          191  +                }
          192  +                return _PreviousEmployees;
          193  +            }
          194  +        }
          195  +        private ObjectSet<PreviousEmployees> _PreviousEmployees;
          196  +
          197  +        /// <summary>
          198  +        /// No Metadata Documentation available.
          199  +        /// </summary>
          200  +        public ObjectSet<Products> Products
          201  +        {
          202  +            get
          203  +            {
          204  +                if ((_Products == null))
          205  +                {
          206  +                    _Products = base.CreateObjectSet<Products>("Products");
          207  +                }
          208  +                return _Products;
          209  +            }
          210  +        }
          211  +        private ObjectSet<Products> _Products;
          212  +
          213  +        /// <summary>
          214  +        /// No Metadata Documentation available.
          215  +        /// </summary>
          216  +        public ObjectSet<Regions> Regions
          217  +        {
          218  +            get
          219  +            {
          220  +                if ((_Regions == null))
          221  +                {
          222  +                    _Regions = base.CreateObjectSet<Regions>("Regions");
          223  +                }
          224  +                return _Regions;
          225  +            }
          226  +        }
          227  +        private ObjectSet<Regions> _Regions;
          228  +
          229  +        /// <summary>
          230  +        /// No Metadata Documentation available.
          231  +        /// </summary>
          232  +        public ObjectSet<Suppliers> Suppliers
          233  +        {
          234  +            get
          235  +            {
          236  +                if ((_Suppliers == null))
          237  +                {
          238  +                    _Suppliers = base.CreateObjectSet<Suppliers>("Suppliers");
          239  +                }
          240  +                return _Suppliers;
          241  +            }
          242  +        }
          243  +        private ObjectSet<Suppliers> _Suppliers;
          244  +
          245  +        /// <summary>
          246  +        /// No Metadata Documentation available.
          247  +        /// </summary>
          248  +        public ObjectSet<Territories> Territories
          249  +        {
          250  +            get
          251  +            {
          252  +                if ((_Territories == null))
          253  +                {
          254  +                    _Territories = base.CreateObjectSet<Territories>("Territories");
          255  +                }
          256  +                return _Territories;
          257  +            }
          258  +        }
          259  +        private ObjectSet<Territories> _Territories;
          260  +
          261  +        #endregion
          262  +        #region AddTo Methods
          263  +
          264  +        /// <summary>
          265  +        /// 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.
          266  +        /// </summary>
          267  +        public void AddToCategories(Categories categories)
          268  +        {
          269  +            base.AddObject("Categories", categories);
          270  +        }
          271  +
          272  +        /// <summary>
          273  +        /// Deprecated Method for adding a new object to the Customers EntitySet. Consider using the .Add method of the associated ObjectSet&lt;T&gt; property instead.
          274  +        /// </summary>
          275  +        public void AddToCustomers(Customers customers)
          276  +        {
          277  +            base.AddObject("Customers", customers);
          278  +        }
          279  +
          280  +        /// <summary>
          281  +        /// Deprecated Method for adding a new object to the Employees EntitySet. Consider using the .Add method of the associated ObjectSet&lt;T&gt; property instead.
          282  +        /// </summary>
          283  +        public void AddToEmployees(Employees employees)
          284  +        {
          285  +            base.AddObject("Employees", employees);
          286  +        }
          287  +
          288  +        /// <summary>
          289  +        /// Deprecated Method for adding a new object to the InternationalOrders EntitySet. Consider using the .Add method of the associated ObjectSet&lt;T&gt; property instead.
          290  +        /// </summary>
          291  +        public void AddToInternationalOrders(InternationalOrders internationalOrders)
          292  +        {
          293  +            base.AddObject("InternationalOrders", internationalOrders);
          294  +        }
          295  +
          296  +        /// <summary>
          297  +        /// Deprecated Method for adding a new object to the OrderDetails EntitySet. Consider using the .Add method of the associated ObjectSet&lt;T&gt; property instead.
          298  +        /// </summary>
          299  +        public void AddToOrderDetails(OrderDetails orderDetails)
          300  +        {
          301  +            base.AddObject("OrderDetails", orderDetails);
          302  +        }
          303  +
          304  +        /// <summary>
          305  +        /// Deprecated Method for adding a new object to the Orders EntitySet. Consider using the .Add method of the associated ObjectSet&lt;T&gt; property instead.
          306  +        /// </summary>
          307  +        public void AddToOrders(Orders orders)
          308  +        {
          309  +            base.AddObject("Orders", orders);
          310  +        }
          311  +
          312  +        /// <summary>
          313  +        /// Deprecated Method for adding a new object to the PreviousEmployees EntitySet. Consider using the .Add method of the associated ObjectSet&lt;T&gt; property instead.
          314  +        /// </summary>
          315  +        public void AddToPreviousEmployees(PreviousEmployees previousEmployees)
          316  +        {
          317  +            base.AddObject("PreviousEmployees", previousEmployees);
          318  +        }
          319  +
          320  +        /// <summary>
          321  +        /// 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.
          322  +        /// </summary>
          323  +        public void AddToProducts(Products products)
          324  +        {
          325  +            base.AddObject("Products", products);
          326  +        }
          327  +
          328  +        /// <summary>
          329  +        /// Deprecated Method for adding a new object to the Regions EntitySet. Consider using the .Add method of the associated ObjectSet&lt;T&gt; property instead.
          330  +        /// </summary>
          331  +        public void AddToRegions(Regions regions)
          332  +        {
          333  +            base.AddObject("Regions", regions);
          334  +        }
          335  +
          336  +        /// <summary>
          337  +        /// 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.
          338  +        /// </summary>
          339  +        public void AddToSuppliers(Suppliers suppliers)
          340  +        {
          341  +            base.AddObject("Suppliers", suppliers);
          342  +        }
          343  +
          344  +        /// <summary>
          345  +        /// Deprecated Method for adding a new object to the Territories EntitySet. Consider using the .Add method of the associated ObjectSet&lt;T&gt; property instead.
          346  +        /// </summary>
          347  +        public void AddToTerritories(Territories territories)
          348  +        {
          349  +            base.AddObject("Territories", territories);
          350  +        }
          351  +
          352  +        #endregion
          353  +    }
          354  +
          355  +
          356  +    #endregion
          357  +
          358  +    #region Entities
          359  +
          360  +    /// <summary>
          361  +    /// No Metadata Documentation available.
          362  +    /// </summary>
          363  +    [EdmEntityTypeAttribute(NamespaceName="northwindEFModel", Name="Categories")]
          364  +    [Serializable()]
          365  +    [DataContractAttribute(IsReference=true)]
          366  +    public partial class Categories : EntityObject
          367  +    {
          368  +        #region Factory Method
          369  +
          370  +        /// <summary>
          371  +        /// Create a new Categories object.
          372  +        /// </summary>
          373  +        /// <param name="categoryID">Initial value of the CategoryID property.</param>
          374  +        /// <param name="categoryName">Initial value of the CategoryName property.</param>
          375  +        public static Categories CreateCategories(global::System.Int64 categoryID, global::System.String categoryName)
          376  +        {
          377  +            Categories categories = new Categories();
          378  +            categories.CategoryID = categoryID;
          379  +            categories.CategoryName = categoryName;
          380  +            return categories;
          381  +        }
          382  +
          383  +        #endregion
          384  +        #region Primitive Properties
          385  +
          386  +        /// <summary>
          387  +        /// No Metadata Documentation available.
          388  +        /// </summary>
          389  +        [EdmScalarPropertyAttribute(EntityKeyProperty=true, IsNullable=false)]
          390  +        [DataMemberAttribute()]
          391  +        public global::System.Int64 CategoryID
          392  +        {
          393  +            get
          394  +            {
          395  +                return _CategoryID;
          396  +            }
          397  +            set
          398  +            {
          399  +                if (_CategoryID != value)
          400  +                {
          401  +                    OnCategoryIDChanging(value);
          402  +                    ReportPropertyChanging("CategoryID");
          403  +                    _CategoryID = StructuralObject.SetValidValue(value);
          404  +                    ReportPropertyChanged("CategoryID");
          405  +                    OnCategoryIDChanged();
          406  +                }
          407  +            }
          408  +        }
          409  +        private global::System.Int64 _CategoryID;
          410  +        partial void OnCategoryIDChanging(global::System.Int64 value);
          411  +        partial void OnCategoryIDChanged();
          412  +
          413  +        /// <summary>
          414  +        /// No Metadata Documentation available.
          415  +        /// </summary>
          416  +        [EdmScalarPropertyAttribute(EntityKeyProperty=false, IsNullable=false)]
          417  +        [DataMemberAttribute()]
          418  +        public global::System.String CategoryName
          419  +        {
          420  +            get
          421  +            {
          422  +                return _CategoryName;
          423  +            }
          424  +            set
          425  +            {
          426  +                OnCategoryNameChanging(value);
          427  +                ReportPropertyChanging("CategoryName");
          428  +                _CategoryName = StructuralObject.SetValidValue(value, false);
          429  +                ReportPropertyChanged("CategoryName");
          430  +                OnCategoryNameChanged();
          431  +            }
          432  +        }
          433  +        private global::System.String _CategoryName;
          434  +        partial void OnCategoryNameChanging(global::System.String value);
          435  +        partial void OnCategoryNameChanged();
          436  +
          437  +        /// <summary>
          438  +        /// No Metadata Documentation available.
          439  +        /// </summary>
          440  +        [EdmScalarPropertyAttribute(EntityKeyProperty=false, IsNullable=true)]
          441  +        [DataMemberAttribute()]
          442  +        public global::System.String Description
          443  +        {
          444  +            get
          445  +            {
          446  +                return _Description;
          447  +            }
          448  +            set
          449  +            {
          450  +                OnDescriptionChanging(value);
          451  +                ReportPropertyChanging("Description");
          452  +                _Description = StructuralObject.SetValidValue(value, true);
          453  +                ReportPropertyChanged("Description");
          454  +                OnDescriptionChanged();
          455  +            }
          456  +        }
          457  +        private global::System.String _Description;
          458  +        partial void OnDescriptionChanging(global::System.String value);
          459  +        partial void OnDescriptionChanged();
          460  +
          461  +        /// <summary>
          462  +        /// No Metadata Documentation available.
          463  +        /// </summary>
          464  +        [EdmScalarPropertyAttribute(EntityKeyProperty=false, IsNullable=true)]
          465  +        [DataMemberAttribute()]
          466  +        public global::System.Byte[] Picture
          467  +        {
          468  +            get
          469  +            {
          470  +                return StructuralObject.GetValidValue(_Picture);
          471  +            }
          472  +            set
          473  +            {
          474  +                OnPictureChanging(value);
          475  +                ReportPropertyChanging("Picture");
          476  +                _Picture = StructuralObject.SetValidValue(value, true);
          477  +                ReportPropertyChanged("Picture");
          478  +                OnPictureChanged();
          479  +            }
          480  +        }
          481  +        private global::System.Byte[] _Picture;
          482  +        partial void OnPictureChanging(global::System.Byte[] value);
          483  +        partial void OnPictureChanged();
          484  +
          485  +        #endregion
          486  +
          487  +        #region Navigation Properties
          488  +
          489  +        /// <summary>
          490  +        /// No Metadata Documentation available.
          491  +        /// </summary>
          492  +        [XmlIgnoreAttribute()]
          493  +        [SoapIgnoreAttribute()]
          494  +        [DataMemberAttribute()]
          495  +        [EdmRelationshipNavigationPropertyAttribute("northwindEFModel", "FK_Products_CategoryID_CategoryID", "Products")]
          496  +        public EntityCollection<Products> Products
          497  +        {
          498  +            get
          499  +            {
          500  +                return ((IEntityWithRelationships)this).RelationshipManager.GetRelatedCollection<Products>("northwindEFModel.FK_Products_CategoryID_CategoryID", "Products");
          501  +            }
          502  +            set
          503  +            {
          504  +                if ((value != null))
          505  +                {
          506  +                    ((IEntityWithRelationships)this).RelationshipManager.InitializeRelatedCollection<Products>("northwindEFModel.FK_Products_CategoryID_CategoryID", "Products", value);
          507  +                }
          508  +            }
          509  +        }
          510  +
          511  +        #endregion
          512  +    }
          513  +
          514  +    /// <summary>
          515  +    /// No Metadata Documentation available.
          516  +    /// </summary>
          517  +    [EdmEntityTypeAttribute(NamespaceName="northwindEFModel", Name="Customers")]
          518  +    [Serializable()]
          519  +    [DataContractAttribute(IsReference=true)]
          520  +    public partial class Customers : EntityObject
          521  +    {
          522  +        #region Factory Method
          523  +
          524  +        /// <summary>
          525  +        /// Create a new Customers object.
          526  +        /// </summary>
          527  +        /// <param name="customerID">Initial value of the CustomerID property.</param>
          528  +        /// <param name="companyName">Initial value of the CompanyName property.</param>
          529  +        public static Customers CreateCustomers(global::System.String customerID, global::System.String companyName)
          530  +        {
          531  +            Customers customers = new Customers();
          532  +            customers.CustomerID = customerID;
          533  +            customers.CompanyName = companyName;
          534  +            return customers;
          535  +        }
          536  +
          537  +        #endregion
          538  +        #region Primitive Properties
          539  +
          540  +        /// <summary>
          541  +        /// No Metadata Documentation available.
          542  +        /// </summary>
          543  +        [EdmScalarPropertyAttribute(EntityKeyProperty=true, IsNullable=false)]
          544  +        [DataMemberAttribute()]
          545  +        public global::System.String CustomerID
          546  +        {
          547  +            get
          548  +            {
          549  +                return _CustomerID;
          550  +            }
          551  +            set
          552  +            {
          553  +                if (_CustomerID != value)
          554  +                {
          555  +                    OnCustomerIDChanging(value);
          556  +                    ReportPropertyChanging("CustomerID");
          557  +                    _CustomerID = StructuralObject.SetValidValue(value, false);
          558  +                    ReportPropertyChanged("CustomerID");
          559  +                    OnCustomerIDChanged();
          560  +                }
          561  +            }
          562  +        }
          563  +        private global::System.String _CustomerID;
          564  +        partial void OnCustomerIDChanging(global::System.String value);
          565  +        partial void OnCustomerIDChanged();
          566  +
          567  +        /// <summary>
          568  +        /// No Metadata Documentation available.
          569  +        /// </summary>
          570  +        [EdmScalarPropertyAttribute(EntityKeyProperty=false, IsNullable=false)]
          571  +        [DataMemberAttribute()]
          572  +        public global::System.String CompanyName
          573  +        {
          574  +            get
          575  +            {
          576  +                return _CompanyName;
          577  +            }
          578  +            set
          579  +            {
          580  +                OnCompanyNameChanging(value);
          581  +                ReportPropertyChanging("CompanyName");
          582  +                _CompanyName = StructuralObject.SetValidValue(value, false);
          583  +                ReportPropertyChanged("CompanyName");
          584  +                OnCompanyNameChanged();
          585  +            }
          586  +        }
          587  +        private global::System.String _CompanyName;
          588  +        partial void OnCompanyNameChanging(global::System.String value);
          589  +        partial void OnCompanyNameChanged();
          590  +
          591  +        /// <summary>
          592  +        /// No Metadata Documentation available.
          593  +        /// </summary>
          594  +        [EdmScalarPropertyAttribute(EntityKeyProperty=false, IsNullable=true)]
          595  +        [DataMemberAttribute()]
          596  +        public global::System.String ContactName
          597  +        {
          598  +            get
          599  +            {
          600  +                return _ContactName;
          601  +            }
          602  +            set
          603  +            {
          604  +                OnContactNameChanging(value);
          605  +                ReportPropertyChanging("ContactName");
          606  +                _ContactName = StructuralObject.SetValidValue(value, true);
          607  +                ReportPropertyChanged("ContactName");
          608  +                OnContactNameChanged();
          609  +            }
          610  +        }
          611  +        private global::System.String _ContactName;
          612  +        partial void OnContactNameChanging(global::System.String value);
          613  +        partial void OnContactNameChanged();
          614  +
          615  +        /// <summary>
          616  +        /// No Metadata Documentation available.
          617  +        /// </summary>
          618  +        [EdmScalarPropertyAttribute(EntityKeyProperty=false, IsNullable=true)]
          619  +        [DataMemberAttribute()]
          620  +        public global::System.String ContactTitle
          621  +        {
          622  +            get
          623  +            {
          624  +                return _ContactTitle;
          625  +            }
          626  +            set
          627  +            {
          628  +                OnContactTitleChanging(value);
          629  +                ReportPropertyChanging("ContactTitle");
          630  +                _ContactTitle = StructuralObject.SetValidValue(value, true);
          631  +                ReportPropertyChanged("ContactTitle");
          632  +                OnContactTitleChanged();
          633  +            }
          634  +        }
          635  +        private global::System.String _ContactTitle;
          636  +        partial void OnContactTitleChanging(global::System.String value);
          637  +        partial void OnContactTitleChanged();
          638  +
          639  +        /// <summary>
          640  +        /// No Metadata Documentation available.
          641  +        /// </summary>
          642  +        [EdmScalarPropertyAttribute(EntityKeyProperty=false, IsNullable=true)]
          643  +        [DataMemberAttribute()]
          644  +        public global::System.String Address
          645  +        {
          646  +            get
          647  +            {
          648  +                return _Address;
          649  +            }
          650  +            set
          651  +            {
          652  +                OnAddressChanging(value);
          653  +                ReportPropertyChanging("Address");
          654  +                _Address = StructuralObject.SetValidValue(value, true);
          655  +                ReportPropertyChanged("Address");
          656  +                OnAddressChanged();
          657  +            }
          658  +        }
          659  +        private global::System.String _Address;
          660  +        partial void OnAddressChanging(global::System.String value);
          661  +        partial void OnAddressChanged();
          662  +
          663  +        /// <summary>
          664  +        /// No Metadata Documentation available.
          665  +        /// </summary>
          666  +        [EdmScalarPropertyAttribute(EntityKeyProperty=false, IsNullable=true)]
          667  +        [DataMemberAttribute()]
          668  +        public global::System.String City
          669  +        {
          670  +            get
          671  +            {
          672  +                return _City;
          673  +            }
          674  +            set
          675  +            {
          676  +                OnCityChanging(value);
          677  +                ReportPropertyChanging("City");
          678  +                _City = StructuralObject.SetValidValue(value, true);
          679  +                ReportPropertyChanged("City");
          680  +                OnCityChanged();
          681  +            }
          682  +        }
          683  +        private global::System.String _City;
          684  +        partial void OnCityChanging(global::System.String value);
          685  +        partial void OnCityChanged();
          686  +
          687  +        /// <summary>
          688  +        /// No Metadata Documentation available.
          689  +        /// </summary>
          690  +        [EdmScalarPropertyAttribute(EntityKeyProperty=false, IsNullable=true)]
          691  +        [DataMemberAttribute()]
          692  +        public global::System.String Region
          693  +        {
          694  +            get
          695  +            {
          696  +                return _Region;
          697  +            }
          698  +            set
          699  +            {
          700  +                OnRegionChanging(value);
          701  +                ReportPropertyChanging("Region");
          702  +                _Region = StructuralObject.SetValidValue(value, true);
          703  +                ReportPropertyChanged("Region");
          704  +                OnRegionChanged();
          705  +            }
          706  +        }
          707  +        private global::System.String _Region;
          708  +        partial void OnRegionChanging(global::System.String value);
          709  +        partial void OnRegionChanged();
          710  +
          711  +        /// <summary>
          712  +        /// No Metadata Documentation available.
          713  +        /// </summary>
          714  +        [EdmScalarPropertyAttribute(EntityKeyProperty=false, IsNullable=true)]
          715  +        [DataMemberAttribute()]
          716  +        public global::System.String PostalCode
          717  +        {
          718  +            get
          719  +            {
          720  +                return _PostalCode;
          721  +            }
          722  +            set
          723  +            {
          724  +                OnPostalCodeChanging(value);
          725  +                ReportPropertyChanging("PostalCode");
          726  +                _PostalCode = StructuralObject.SetValidValue(value, true);
          727  +                ReportPropertyChanged("PostalCode");
          728  +                OnPostalCodeChanged();
          729  +            }
          730  +        }
          731  +        private global::System.String _PostalCode;
          732  +        partial void OnPostalCodeChanging(global::System.String value);
          733  +        partial void OnPostalCodeChanged();
          734  +
          735  +        /// <summary>
          736  +        /// No Metadata Documentation available.
          737  +        /// </summary>
          738  +        [EdmScalarPropertyAttribute(EntityKeyProperty=false, IsNullable=true)]
          739  +        [DataMemberAttribute()]
          740  +        public global::System.String Country
          741  +        {
          742  +            get
          743  +            {
          744  +                return _Country;
          745  +            }
          746  +            set
          747  +            {
          748  +                OnCountryChanging(value);
          749  +                ReportPropertyChanging("Country");
          750  +                _Country = StructuralObject.SetValidValue(value, true);
          751  +                ReportPropertyChanged("Country");
          752  +                OnCountryChanged();
          753  +            }
          754  +        }
          755  +        private global::System.String _Country;
          756  +        partial void OnCountryChanging(global::System.String value);
          757  +        partial void OnCountryChanged();
          758  +
          759  +        /// <summary>
          760  +        /// No Metadata Documentation available.
          761  +        /// </summary>
          762  +        [EdmScalarPropertyAttribute(EntityKeyProperty=false, IsNullable=true)]
          763  +        [DataMemberAttribute()]
          764  +        public global::System.String Phone
          765  +        {
          766  +            get
          767  +            {
          768  +                return _Phone;
          769  +            }
          770  +            set
          771  +            {
          772  +                OnPhoneChanging(value);
          773  +                ReportPropertyChanging("Phone");
          774  +                _Phone = StructuralObject.SetValidValue(value, true);
          775  +                ReportPropertyChanged("Phone");
          776  +                OnPhoneChanged();
          777  +            }
          778  +        }
          779  +        private global::System.String _Phone;
          780  +        partial void OnPhoneChanging(global::System.String value);
          781  +        partial void OnPhoneChanged();
          782  +
          783  +        /// <summary>
          784  +        /// No Metadata Documentation available.
          785  +        /// </summary>
          786  +        [EdmScalarPropertyAttribute(EntityKeyProperty=false, IsNullable=true)]
          787  +        [DataMemberAttribute()]
          788  +        public global::System.String Fax
          789  +        {
          790  +            get
          791  +            {
          792  +                return _Fax;
          793  +            }
          794  +            set
          795  +            {
          796  +                OnFaxChanging(value);
          797  +                ReportPropertyChanging("Fax");
          798  +                _Fax = StructuralObject.SetValidValue(value, true);
          799  +                ReportPropertyChanged("Fax");
          800  +                OnFaxChanged();
          801  +            }
          802  +        }
          803  +        private global::System.String _Fax;
          804  +        partial void OnFaxChanging(global::System.String value);
          805  +        partial void OnFaxChanged();
          806  +
          807  +        #endregion
          808  +
          809  +        #region Navigation Properties
          810  +
          811  +        /// <summary>
          812  +        /// No Metadata Documentation available.
          813  +        /// </summary>
          814  +        [XmlIgnoreAttribute()]
          815  +        [SoapIgnoreAttribute()]
          816  +        [DataMemberAttribute()]
          817  +        [EdmRelationshipNavigationPropertyAttribute("northwindEFModel", "FK_Orders_CustomerID_CustomerID", "Orders")]
          818  +        public EntityCollection<Orders> Orders
          819  +        {
          820  +            get
          821  +            {
          822  +                return ((IEntityWithRelationships)this).RelationshipManager.GetRelatedCollection<Orders>("northwindEFModel.FK_Orders_CustomerID_CustomerID", "Orders");
          823  +            }
          824  +            set
          825  +            {
          826  +                if ((value != null))
          827  +                {
          828  +                    ((IEntityWithRelationships)this).RelationshipManager.InitializeRelatedCollection<Orders>("northwindEFModel.FK_Orders_CustomerID_CustomerID", "Orders", value);
          829  +                }
          830  +            }
          831  +        }
          832  +
          833  +        #endregion
          834  +    }
          835  +
          836  +    /// <summary>
          837  +    /// No Metadata Documentation available.
          838  +    /// </summary>
          839  +    [EdmEntityTypeAttribute(NamespaceName="northwindEFModel", Name="Employees")]
          840  +    [Serializable()]
          841  +    [DataContractAttribute(IsReference=true)]
          842  +    public partial class Employees : EntityObject
          843  +    {
          844  +        #region Factory Method
          845  +
          846  +        /// <summary>
          847  +        /// Create a new Employees object.
          848  +        /// </summary>
          849  +        /// <param name="employeeID">Initial value of the EmployeeID property.</param>
          850  +        /// <param name="lastName">Initial value of the LastName property.</param>
          851  +        /// <param name="firstName">Initial value of the FirstName property.</param>
          852  +        public static Employees CreateEmployees(global::System.Int64 employeeID, global::System.String lastName, global::System.String firstName)
          853  +        {
          854  +            Employees employees = new Employees();
          855  +            employees.EmployeeID = employeeID;
          856  +            employees.LastName = lastName;
          857  +            employees.FirstName = firstName;
          858  +            return employees;
          859  +        }
          860  +
          861  +        #endregion
          862  +        #region Primitive Properties
          863  +
          864  +        /// <summary>
          865  +        /// No Metadata Documentation available.
          866  +        /// </summary>
          867  +        [EdmScalarPropertyAttribute(EntityKeyProperty=true, IsNullable=false)]
          868  +        [DataMemberAttribute()]
          869  +        public global::System.Int64 EmployeeID
          870  +        {
          871  +            get
          872  +            {
          873  +                return _EmployeeID;
          874  +            }
          875  +            set
          876  +            {
          877  +                if (_EmployeeID != value)
          878  +                {
          879  +                    OnEmployeeIDChanging(value);
          880  +                    ReportPropertyChanging("EmployeeID");
          881  +                    _EmployeeID = StructuralObject.SetValidValue(value);
          882  +                    ReportPropertyChanged("EmployeeID");
          883  +                    OnEmployeeIDChanged();
          884  +                }
          885  +            }
          886  +        }
          887  +        private global::System.Int64 _EmployeeID;
          888  +        partial void OnEmployeeIDChanging(global::System.Int64 value);
          889  +        partial void OnEmployeeIDChanged();
          890  +
          891  +        /// <summary>
          892  +        /// No Metadata Documentation available.
          893  +        /// </summary>
          894  +        [EdmScalarPropertyAttribute(EntityKeyProperty=false, IsNullable=false)]
          895  +        [DataMemberAttribute()]
          896  +        public global::System.String LastName
          897  +        {
          898  +            get
          899  +            {
          900  +                return _LastName;
          901  +            }
          902  +            set
          903  +            {
          904  +                OnLastNameChanging(value);
          905  +                ReportPropertyChanging("LastName");
          906  +                _LastName = StructuralObject.SetValidValue(value, false);
          907  +                ReportPropertyChanged("LastName");
          908  +                OnLastNameChanged();
          909  +            }
          910  +        }
          911  +        private global::System.String _LastName;
          912  +        partial void OnLastNameChanging(global::System.String value);
          913  +        partial void OnLastNameChanged();
          914  +
          915  +        /// <summary>
          916  +        /// No Metadata Documentation available.
          917  +        /// </summary>
          918  +        [EdmScalarPropertyAttribute(EntityKeyProperty=false, IsNullable=false)]
          919  +        [DataMemberAttribute()]
          920  +        public global::System.String FirstName
          921  +        {
          922  +            get
          923  +            {
          924  +                return _FirstName;
          925  +            }
          926  +            set
          927  +            {
          928  +                OnFirstNameChanging(value);
          929  +                ReportPropertyChanging("FirstName");
          930  +                _FirstName = StructuralObject.SetValidValue(value, false);
          931  +                ReportPropertyChanged("FirstName");
          932  +                OnFirstNameChanged();
          933  +            }
          934  +        }
          935  +        private global::System.String _FirstName;
          936  +        partial void OnFirstNameChanging(global::System.String value);
          937  +        partial void OnFirstNameChanged();
          938  +
          939  +        /// <summary>
          940  +        /// No Metadata Documentation available.
          941  +        /// </summary>
          942  +        [EdmScalarPropertyAttribute(EntityKeyProperty=false, IsNullable=true)]
          943  +        [DataMemberAttribute()]
          944  +        public global::System.String Title
          945  +        {
          946  +            get
          947  +            {
          948  +                return _Title;
          949  +            }
          950  +            set
          951  +            {
          952  +                OnTitleChanging(value);
          953  +                ReportPropertyChanging("Title");
          954  +                _Title = StructuralObject.SetValidValue(value, true);
          955  +                ReportPropertyChanged("Title");
          956  +                OnTitleChanged();
          957  +            }
          958  +        }
          959  +        private global::System.String _Title;
          960  +        partial void OnTitleChanging(global::System.String value);
          961  +        partial void OnTitleChanged();
          962  +
          963  +        /// <summary>
          964  +        /// No Metadata Documentation available.
          965  +        /// </summary>
          966  +        [EdmScalarPropertyAttribute(EntityKeyProperty=false, IsNullable=true)]
          967  +        [DataMemberAttribute()]
          968  +        public global::System.String TitleOfCourtesy
          969  +        {
          970  +            get
          971  +            {
          972  +                return _TitleOfCourtesy;
          973  +            }
          974  +            set
          975  +            {
          976  +                OnTitleOfCourtesyChanging(value);
          977  +                ReportPropertyChanging("TitleOfCourtesy");
          978  +                _TitleOfCourtesy = StructuralObject.SetValidValue(value, true);
          979  +                ReportPropertyChanged("TitleOfCourtesy");
          980  +                OnTitleOfCourtesyChanged();
          981  +            }
          982  +        }
          983  +        private global::System.String _TitleOfCourtesy;
          984  +        partial void OnTitleOfCourtesyChanging(global::System.String value);
          985  +        partial void OnTitleOfCourtesyChanged();
          986  +
          987  +        /// <summary>
          988  +        /// No Metadata Documentation available.
          989  +        /// </summary>
          990  +        [EdmScalarPropertyAttribute(EntityKeyProperty=false, IsNullable=true)]
          991  +        [DataMemberAttribute()]
          992  +        public Nullable<global::System.DateTime> BirthDate
          993  +        {
          994  +            get
          995  +            {
          996  +                return _BirthDate;
          997  +            }
          998  +            set
          999  +            {
         1000  +                OnBirthDateChanging(value);
         1001  +                ReportPropertyChanging("BirthDate");
         1002  +                _BirthDate = StructuralObject.SetValidValue(value);
         1003  +                ReportPropertyChanged("BirthDate");
         1004  +                OnBirthDateChanged();
         1005  +            }
         1006  +        }
         1007  +        private Nullable<global::System.DateTime> _BirthDate;
         1008  +        partial void OnBirthDateChanging(Nullable<global::System.DateTime> value);
         1009  +        partial void OnBirthDateChanged();
         1010  +
         1011  +        /// <summary>
         1012  +        /// No Metadata Documentation available.
         1013  +        /// </summary>
         1014  +        [EdmScalarPropertyAttribute(EntityKeyProperty=false, IsNullable=true)]
         1015  +        [DataMemberAttribute()]
         1016  +        public Nullable<global::System.DateTime> HireDate
         1017  +        {
         1018  +            get
         1019  +            {
         1020  +                return _HireDate;
         1021  +            }
         1022  +            set
         1023  +            {
         1024  +                OnHireDateChanging(value);
         1025  +                ReportPropertyChanging("HireDate");
         1026  +                _HireDate = StructuralObject.SetValidValue(value);
         1027  +                ReportPropertyChanged("HireDate");
         1028  +                OnHireDateChanged();
         1029  +            }
         1030  +        }
         1031  +        private Nullable<global::System.DateTime> _HireDate;
         1032  +        partial void OnHireDateChanging(Nullable<global::System.DateTime> value);
         1033  +        partial void OnHireDateChanged();
         1034  +
         1035  +        /// <summary>
         1036  +        /// No Metadata Documentation available.
         1037  +        /// </summary>
         1038  +        [EdmScalarPropertyAttribute(EntityKeyProperty=false, IsNullable=true)]
         1039  +        [DataMemberAttribute()]
         1040  +        public global::System.String Address
         1041  +        {
         1042  +            get
         1043  +            {
         1044  +                return _Address;
         1045  +            }
         1046  +            set
         1047  +            {
         1048  +                OnAddressChanging(value);
         1049  +                ReportPropertyChanging("Address");
         1050  +                _Address = StructuralObject.SetValidValue(value, true);
         1051  +                ReportPropertyChanged("Address");
         1052  +                OnAddressChanged();
         1053  +            }
         1054  +        }
         1055  +        private global::System.String _Address;
         1056  +        partial void OnAddressChanging(global::System.String value);
         1057  +        partial void OnAddressChanged();
         1058  +
         1059  +        /// <summary>
         1060  +        /// No Metadata Documentation available.
         1061  +        /// </summary>
         1062  +        [EdmScalarPropertyAttribute(EntityKeyProperty=false, IsNullable=true)]
         1063  +        [DataMemberAttribute()]
         1064  +        public global::System.String City
         1065  +        {
         1066  +            get
         1067  +            {
         1068  +                return _City;
         1069  +            }
         1070  +            set
         1071  +            {
         1072  +                OnCityChanging(value);
         1073  +                ReportPropertyChanging("City");
         1074  +                _City = StructuralObject.SetValidValue(value, true);
         1075  +                ReportPropertyChanged("City");
         1076  +                OnCityChanged();
         1077  +            }
         1078  +        }
         1079  +        private global::System.String _City;
         1080  +        partial void OnCityChanging(global::System.String value);
         1081  +        partial void OnCityChanged();
         1082  +
         1083  +        /// <summary>
         1084  +        /// No Metadata Documentation available.
         1085  +        /// </summary>
         1086  +        [EdmScalarPropertyAttribute(EntityKeyProperty=false, IsNullable=true)]
         1087  +        [DataMemberAttribute()]
         1088  +        public global::System.String Region
         1089  +        {
         1090  +            get
         1091  +            {
         1092  +                return _Region;
         1093  +            }
         1094  +            set
         1095  +            {
         1096  +                OnRegionChanging(value);
         1097  +                ReportPropertyChanging("Region");
         1098  +                _Region = StructuralObject.SetValidValue(value, true);
         1099  +                ReportPropertyChanged("Region");
         1100  +                OnRegionChanged();
         1101  +            }
         1102  +        }
         1103  +        private global::System.String _Region;
         1104  +        partial void OnRegionChanging(global::System.String value);
         1105  +        partial void OnRegionChanged();
         1106  +
         1107  +        /// <summary>
         1108  +        /// No Metadata Documentation available.
         1109  +        /// </summary>
         1110  +        [EdmScalarPropertyAttribute(EntityKeyProperty=false, IsNullable=true)]
         1111  +        [DataMemberAttribute()]
         1112  +        public global::System.String PostalCode
         1113  +        {
         1114  +            get
         1115  +            {
         1116  +                return _PostalCode;
         1117  +            }
         1118  +            set
         1119  +            {
         1120  +                OnPostalCodeChanging(value);
         1121  +                ReportPropertyChanging("PostalCode");
         1122  +                _PostalCode = StructuralObject.SetValidValue(value, true);
         1123  +                ReportPropertyChanged("PostalCode");
         1124  +                OnPostalCodeChanged();
         1125  +            }
         1126  +        }
         1127  +        private global::System.String _PostalCode;
         1128  +        partial void OnPostalCodeChanging(global::System.String value);
         1129  +        partial void OnPostalCodeChanged();
         1130  +
         1131  +        /// <summary>
         1132  +        /// No Metadata Documentation available.
         1133  +        /// </summary>
         1134  +        [EdmScalarPropertyAttribute(EntityKeyProperty=false, IsNullable=true)]
         1135  +        [DataMemberAttribute()]
         1136  +        public global::System.String Country
         1137  +        {
         1138  +            get
         1139  +            {
         1140  +                return _Country;
         1141  +            }
         1142  +            set
         1143  +            {
         1144  +                OnCountryChanging(value);
         1145  +                ReportPropertyChanging("Country");
         1146  +                _Country = StructuralObject.SetValidValue(value, true);
         1147  +                ReportPropertyChanged("Country");
         1148  +                OnCountryChanged();
         1149  +            }
         1150  +        }
         1151  +        private global::System.String _Country;
         1152  +        partial void OnCountryChanging(global::System.String value);
         1153  +        partial void OnCountryChanged();
         1154  +
         1155  +        /// <summary>
         1156  +        /// No Metadata Documentation available.
         1157  +        /// </summary>
         1158  +        [EdmScalarPropertyAttribute(EntityKeyProperty=false, IsNullable=true)]
         1159  +        [DataMemberAttribute()]
         1160  +        public global::System.String HomePhone
         1161  +        {
         1162  +            get
         1163  +            {
         1164  +                return _HomePhone;
         1165  +            }
         1166  +            set
         1167  +            {
         1168  +                OnHomePhoneChanging(value);
         1169  +                ReportPropertyChanging("HomePhone");
         1170  +                _HomePhone = StructuralObject.SetValidValue(value, true);
         1171  +                ReportPropertyChanged("HomePhone");
         1172  +                OnHomePhoneChanged();
         1173  +            }
         1174  +        }
         1175  +        private global::System.String _HomePhone;
         1176  +        partial void OnHomePhoneChanging(global::System.String value);
         1177  +        partial void OnHomePhoneChanged();
         1178  +
         1179  +        /// <summary>
         1180  +        /// No Metadata Documentation available.
         1181  +        /// </summary>
         1182  +        [EdmScalarPropertyAttribute(EntityKeyProperty=false, IsNullable=true)]
         1183  +        [DataMemberAttribute()]
         1184  +        public global::System.String Extension
         1185  +        {
         1186  +            get
         1187  +            {
         1188  +                return _Extension;
         1189  +            }
         1190  +            set
         1191  +            {
         1192  +                OnExtensionChanging(value);
         1193  +                ReportPropertyChanging("Extension");
         1194  +                _Extension = StructuralObject.SetValidValue(value, true);
         1195  +                ReportPropertyChanged("Extension");
         1196  +                OnExtensionChanged();
         1197  +            }
         1198  +        }
         1199  +        private global::System.String _Extension;
         1200  +        partial void OnExtensionChanging(global::System.String value);
         1201  +        partial void OnExtensionChanged();
         1202  +
         1203  +        /// <summary>
         1204  +        /// No Metadata Documentation available.
         1205  +        /// </summary>
         1206  +        [EdmScalarPropertyAttribute(EntityKeyProperty=false, IsNullable=true)]
         1207  +        [DataMemberAttribute()]
         1208  +        public global::System.Byte[] Photo
         1209  +        {
         1210  +            get
         1211  +            {
         1212  +                return StructuralObject.GetValidValue(_Photo);
         1213  +            }
         1214  +            set
         1215  +            {
         1216  +                OnPhotoChanging(value);
         1217  +                ReportPropertyChanging("Photo");
         1218  +                _Photo = StructuralObject.SetValidValue(value, true);
         1219  +                ReportPropertyChanged("Photo");
         1220  +                OnPhotoChanged();
         1221  +            }
         1222  +        }
         1223  +        private global::System.Byte[] _Photo;
         1224  +        partial void OnPhotoChanging(global::System.Byte[] value);
         1225  +        partial void OnPhotoChanged();
         1226  +
         1227  +        /// <summary>
         1228  +        /// No Metadata Documentation available.
         1229  +        /// </summary>
         1230  +        [EdmScalarPropertyAttribute(EntityKeyProperty=false, IsNullable=true)]
         1231  +        [DataMemberAttribute()]
         1232  +        public global::System.String Notes
         1233  +        {
         1234  +            get
         1235  +            {
         1236  +                return _Notes;
         1237  +            }
         1238  +            set
         1239  +            {
         1240  +                OnNotesChanging(value);
         1241  +                ReportPropertyChanging("Notes");
         1242  +                _Notes = StructuralObject.SetValidValue(value, true);
         1243  +                ReportPropertyChanged("Notes");
         1244  +                OnNotesChanged();
         1245  +            }
         1246  +        }
         1247  +        private global::System.String _Notes;
         1248  +        partial void OnNotesChanging(global::System.String value);
         1249  +        partial void OnNotesChanged();
         1250  +
         1251  +        /// <summary>
         1252  +        /// No Metadata Documentation available.
         1253  +        /// </summary>
         1254  +        [EdmScalarPropertyAttribute(EntityKeyProperty=false, IsNullable=true)]
         1255  +        [DataMemberAttribute()]
         1256  +        public global::System.String PhotoPath
         1257  +        {
         1258  +            get
         1259  +            {
         1260  +                return _PhotoPath;
         1261  +            }
         1262  +            set
         1263  +            {
         1264  +                OnPhotoPathChanging(value);
         1265  +                ReportPropertyChanging("PhotoPath");
         1266  +                _PhotoPath = StructuralObject.SetValidValue(value, true);
         1267  +                ReportPropertyChanged("PhotoPath");
         1268  +                OnPhotoPathChanged();
         1269  +            }
         1270  +        }
         1271  +        private global::System.String _PhotoPath;
         1272  +        partial void OnPhotoPathChanging(global::System.String value);
         1273  +        partial void OnPhotoPathChanged();
         1274  +
         1275  +        #endregion
         1276  +
         1277  +        #region Navigation Properties
         1278  +
         1279  +        /// <summary>
         1280  +        /// No Metadata Documentation available.
         1281  +        /// </summary>
         1282  +        [XmlIgnoreAttribute()]
         1283  +        [SoapIgnoreAttribute()]
         1284  +        [DataMemberAttribute()]
         1285  +        [EdmRelationshipNavigationPropertyAttribute("northwindEFModel", "EmployeesTerritories", "Territories")]
         1286  +        public EntityCollection<Territories> Territories
         1287  +        {
         1288  +            get
         1289  +            {
         1290  +                return ((IEntityWithRelationships)this).RelationshipManager.GetRelatedCollection<Territories>("northwindEFModel.EmployeesTerritories", "Territories");
         1291  +            }
         1292  +            set
         1293  +            {
         1294  +                if ((value != null))
         1295  +                {
         1296  +                    ((IEntityWithRelationships)this).RelationshipManager.InitializeRelatedCollection<Territories>("northwindEFModel.EmployeesTerritories", "Territories", value);
         1297  +                }
         1298  +            }
         1299  +        }
         1300  +
         1301  +        #endregion
         1302  +    }
         1303  +
         1304  +    /// <summary>
         1305  +    /// No Metadata Documentation available.
         1306  +    /// </summary>
         1307  +    [EdmEntityTypeAttribute(NamespaceName="northwindEFModel", Name="InternationalOrders")]
         1308  +    [Serializable()]
         1309  +    [DataContractAttribute(IsReference=true)]
         1310  +    public partial class InternationalOrders : EntityObject
         1311  +    {
         1312  +        #region Factory Method
         1313  +
         1314  +        /// <summary>
         1315  +        /// Create a new InternationalOrders object.
         1316  +        /// </summary>
         1317  +        /// <param name="orderID">Initial value of the OrderID property.</param>
         1318  +        /// <param name="customsDescription">Initial value of the CustomsDescription property.</param>
         1319  +        /// <param name="exciseTax">Initial value of the ExciseTax property.</param>
         1320  +        public static InternationalOrders CreateInternationalOrders(global::System.Int64 orderID, global::System.String customsDescription, global::System.Decimal exciseTax)
         1321  +        {
         1322  +            InternationalOrders internationalOrders = new InternationalOrders();
         1323  +            internationalOrders.OrderID = orderID;
         1324  +            internationalOrders.CustomsDescription = customsDescription;
         1325  +            internationalOrders.ExciseTax = exciseTax;
         1326  +            return internationalOrders;
         1327  +        }
         1328  +
         1329  +        #endregion
         1330  +        #region Primitive Properties
         1331  +
         1332  +        /// <summary>
         1333  +        /// No Metadata Documentation available.
         1334  +        /// </summary>
         1335  +        [EdmScalarPropertyAttribute(EntityKeyProperty=true, IsNullable=false)]
         1336  +        [DataMemberAttribute()]
         1337  +        public global::System.Int64 OrderID
         1338  +        {
         1339  +            get
         1340  +            {
         1341  +                return _OrderID;
         1342  +            }
         1343  +            set
         1344  +            {
         1345  +                if (_OrderID != value)
         1346  +                {
         1347  +                    OnOrderIDChanging(value);
         1348  +                    ReportPropertyChanging("OrderID");
         1349  +                    _OrderID = StructuralObject.SetValidValue(value);
         1350  +                    ReportPropertyChanged("OrderID");
         1351  +                    OnOrderIDChanged();
         1352  +                }
         1353  +            }
         1354  +        }
         1355  +        private global::System.Int64 _OrderID;
         1356  +        partial void OnOrderIDChanging(global::System.Int64 value);
         1357  +        partial void OnOrderIDChanged();
         1358  +
         1359  +        /// <summary>
         1360  +        /// No Metadata Documentation available.
         1361  +        /// </summary>
         1362  +        [EdmScalarPropertyAttribute(EntityKeyProperty=false, IsNullable=false)]
         1363  +        [DataMemberAttribute()]
         1364  +        public global::System.String CustomsDescription
         1365  +        {
         1366  +            get
         1367  +            {
         1368  +                return _CustomsDescription;
         1369  +            }
         1370  +            set
         1371  +            {
         1372  +                OnCustomsDescriptionChanging(value);
         1373  +                ReportPropertyChanging("CustomsDescription");
         1374  +                _CustomsDescription = StructuralObject.SetValidValue(value, false);
         1375  +                ReportPropertyChanged("CustomsDescription");
         1376  +                OnCustomsDescriptionChanged();
         1377  +            }
         1378  +        }
         1379  +        private global::System.String _CustomsDescription;
         1380  +        partial void OnCustomsDescriptionChanging(global::System.String value);
         1381  +        partial void OnCustomsDescriptionChanged();
         1382  +
         1383  +        /// <summary>
         1384  +        /// No Metadata Documentation available.
         1385  +        /// </summary>
         1386  +        [EdmScalarPropertyAttribute(EntityKeyProperty=false, IsNullable=false)]
         1387  +        [DataMemberAttribute()]
         1388  +        public global::System.Decimal ExciseTax
         1389  +        {
         1390  +            get
         1391  +            {
         1392  +                return _ExciseTax;
         1393  +            }
         1394  +            set
         1395  +            {
         1396  +                OnExciseTaxChanging(value);
         1397  +                ReportPropertyChanging("ExciseTax");
         1398  +                _ExciseTax = StructuralObject.SetValidValue(value);
         1399  +                ReportPropertyChanged("ExciseTax");
         1400  +                OnExciseTaxChanged();
         1401  +            }
         1402  +        }
         1403  +        private global::System.Decimal _ExciseTax;
         1404  +        partial void OnExciseTaxChanging(global::System.Decimal value);
         1405  +        partial void OnExciseTaxChanged();
         1406  +
         1407  +        #endregion
         1408  +
         1409  +        #region Navigation Properties
         1410  +
         1411  +        /// <summary>
         1412  +        /// No Metadata Documentation available.
         1413  +        /// </summary>
         1414  +        [XmlIgnoreAttribute()]
         1415  +        [SoapIgnoreAttribute()]
         1416  +        [DataMemberAttribute()]
         1417  +        [EdmRelationshipNavigationPropertyAttribute("northwindEFModel", "FK_InternationalOrders_OrderID_OrderID", "Orders")]
         1418  +        public Orders Orders
         1419  +        {
         1420  +            get
         1421  +            {
         1422  +                return ((IEntityWithRelationships)this).RelationshipManager.GetRelatedReference<Orders>("northwindEFModel.FK_InternationalOrders_OrderID_OrderID", "Orders").Value;
         1423  +            }
         1424  +            set
         1425  +            {
         1426  +                ((IEntityWithRelationships)this).RelationshipManager.GetRelatedReference<Orders>("northwindEFModel.FK_InternationalOrders_OrderID_OrderID", "Orders").Value = value;
         1427  +            }
         1428  +        }
         1429  +        /// <summary>
         1430  +        /// No Metadata Documentation available.
         1431  +        /// </summary>
         1432  +        [BrowsableAttribute(false)]
         1433  +        [DataMemberAttribute()]
         1434  +        public EntityReference<Orders> OrdersReference
         1435  +        {
         1436  +            get
         1437  +            {
         1438  +                return ((IEntityWithRelationships)this).RelationshipManager.GetRelatedReference<Orders>("northwindEFModel.FK_InternationalOrders_OrderID_OrderID", "Orders");
         1439  +            }
         1440  +            set
         1441  +            {
         1442  +                if ((value != null))
         1443  +                {
         1444  +                    ((IEntityWithRelationships)this).RelationshipManager.InitializeRelatedReference<Orders>("northwindEFModel.FK_InternationalOrders_OrderID_OrderID", "Orders", value);
         1445  +                }
         1446  +            }
         1447  +        }
         1448  +
         1449  +        #endregion
         1450  +    }
         1451  +
         1452  +    /// <summary>
         1453  +    /// No Metadata Documentation available.
         1454  +    /// </summary>
         1455  +    [EdmEntityTypeAttribute(NamespaceName="northwindEFModel", Name="OrderDetails")]
         1456  +    [Serializable()]
         1457  +    [DataContractAttribute(IsReference=true)]
         1458  +    public partial class OrderDetails : EntityObject
         1459  +    {
         1460  +        #region Factory Method
         1461  +
         1462  +        /// <summary>
         1463  +        /// Create a new OrderDetails object.
         1464  +        /// </summary>
         1465  +        /// <param name="orderID">Initial value of the OrderID property.</param>
         1466  +        /// <param name="productID">Initial value of the ProductID property.</param>
         1467  +        /// <param name="unitPrice">Initial value of the UnitPrice property.</param>
         1468  +        /// <param name="quantity">Initial value of the Quantity property.</param>
         1469  +        /// <param name="discount">Initial value of the Discount property.</param>
         1470  +        public static OrderDetails CreateOrderDetails(global::System.Int64 orderID, global::System.Int64 productID, global::System.Decimal unitPrice, global::System.Int16 quantity, global::System.Single discount)
         1471  +        {
         1472  +            OrderDetails orderDetails = new OrderDetails();
         1473  +            orderDetails.OrderID = orderID;
         1474  +            orderDetails.ProductID = productID;
         1475  +            orderDetails.UnitPrice = unitPrice;
         1476  +            orderDetails.Quantity = quantity;
         1477  +            orderDetails.Discount = discount;
         1478  +            return orderDetails;
         1479  +        }
         1480  +
         1481  +        #endregion
         1482  +        #region Primitive Properties
         1483  +
         1484  +        /// <summary>
         1485  +        /// No Metadata Documentation available.
         1486  +        /// </summary>
         1487  +        [EdmScalarPropertyAttribute(EntityKeyProperty=true, IsNullable=false)]
         1488  +        [DataMemberAttribute()]
         1489  +        public global::System.Int64 OrderID
         1490  +        {
         1491  +            get
         1492  +            {
         1493  +                return _OrderID;
         1494  +            }
         1495  +            set
         1496  +            {
         1497  +                if (_OrderID != value)
         1498  +                {
         1499  +                    OnOrderIDChanging(value);
         1500  +                    ReportPropertyChanging("OrderID");
         1501  +                    _OrderID = StructuralObject.SetValidValue(value);
         1502  +                    ReportPropertyChanged("OrderID");
         1503  +                    OnOrderIDChanged();
         1504  +                }
         1505  +            }
         1506  +        }
         1507  +        private global::System.Int64 _OrderID;
         1508  +        partial void OnOrderIDChanging(global::System.Int64 value);
         1509  +        partial void OnOrderIDChanged();
         1510  +
         1511  +        /// <summary>
         1512  +        /// No Metadata Documentation available.
         1513  +        /// </summary>
         1514  +        [EdmScalarPropertyAttribute(EntityKeyProperty=true, IsNullable=false)]
         1515  +        [DataMemberAttribute()]
         1516  +        public global::System.Int64 ProductID
         1517  +        {
         1518  +            get
         1519  +            {
         1520  +                return _ProductID;
         1521  +            }
         1522  +            set
         1523  +            {
         1524  +                if (_ProductID != value)
         1525  +                {
         1526  +                    OnProductIDChanging(value);
         1527  +                    ReportPropertyChanging("ProductID");
         1528  +                    _ProductID = StructuralObject.SetValidValue(value);
         1529  +                    ReportPropertyChanged("ProductID");
         1530  +                    OnProductIDChanged();
         1531  +                }
         1532  +            }
         1533  +        }
         1534  +        private global::System.Int64 _ProductID;
         1535  +        partial void OnProductIDChanging(global::System.Int64 value);
         1536  +        partial void OnProductIDChanged();
         1537  +
         1538  +        /// <summary>
         1539  +        /// No Metadata Documentation available.
         1540  +        /// </summary>
         1541  +        [EdmScalarPropertyAttribute(EntityKeyProperty=false, IsNullable=false)]
         1542  +        [DataMemberAttribute()]
         1543  +        public global::System.Decimal UnitPrice
         1544  +        {
         1545  +            get
         1546  +            {
         1547  +                return _UnitPrice;
         1548  +            }
         1549  +            set
         1550  +            {
         1551  +                OnUnitPriceChanging(value);
         1552  +                ReportPropertyChanging("UnitPrice");
         1553  +                _UnitPrice = StructuralObject.SetValidValue(value);
         1554  +                ReportPropertyChanged("UnitPrice");
         1555  +                OnUnitPriceChanged();
         1556  +            }
         1557  +        }
         1558  +        private global::System.Decimal _UnitPrice;
         1559  +        partial void OnUnitPriceChanging(global::System.Decimal value);
         1560  +        partial void OnUnitPriceChanged();
         1561  +
         1562  +        /// <summary>
         1563  +        /// No Metadata Documentation available.
         1564  +        /// </summary>
         1565  +        [EdmScalarPropertyAttribute(EntityKeyProperty=false, IsNullable=false)]
         1566  +        [DataMemberAttribute()]
         1567  +        public global::System.Int16 Quantity
         1568  +        {
         1569  +            get
         1570  +            {
         1571  +                return _Quantity;
         1572  +            }
         1573  +            set
         1574  +            {
         1575  +                OnQuantityChanging(value);
         1576  +                ReportPropertyChanging("Quantity");
         1577  +                _Quantity = StructuralObject.SetValidValue(value);
         1578  +                ReportPropertyChanged("Quantity");
         1579  +                OnQuantityChanged();
         1580  +            }
         1581  +        }
         1582  +        private global::System.Int16 _Quantity;
         1583  +        partial void OnQuantityChanging(global::System.Int16 value);
         1584  +        partial void OnQuantityChanged();
         1585  +
         1586  +        /// <summary>
         1587  +        /// No Metadata Documentation available.
         1588  +        /// </summary>
         1589  +        [EdmScalarPropertyAttribute(EntityKeyProperty=false, IsNullable=false)]
         1590  +        [DataMemberAttribute()]
         1591  +        public global::System.Single Discount
         1592  +        {
         1593  +            get
         1594  +            {
         1595  +                return _Discount;
         1596  +            }
         1597  +            set
         1598  +            {
         1599  +                OnDiscountChanging(value);
         1600  +                ReportPropertyChanging("Discount");
         1601  +                _Discount = StructuralObject.SetValidValue(value);
         1602  +                ReportPropertyChanged("Discount");
         1603  +                OnDiscountChanged();
         1604  +            }
         1605  +        }
         1606  +        private global::System.Single _Discount;
         1607  +        partial void OnDiscountChanging(global::System.Single value);
         1608  +        partial void OnDiscountChanged();
         1609  +
         1610  +        #endregion
         1611  +
         1612  +        #region Navigation Properties
         1613  +
         1614  +        /// <summary>
         1615  +        /// No Metadata Documentation available.
         1616  +        /// </summary>
         1617  +        [XmlIgnoreAttribute()]
         1618  +        [SoapIgnoreAttribute()]
         1619  +        [DataMemberAttribute()]
         1620  +        [EdmRelationshipNavigationPropertyAttribute("northwindEFModel", "FK_OrderDetails_OrderID_OrderID", "Orders")]
         1621  +        public Orders Orders
         1622  +        {
         1623  +            get
         1624  +            {
         1625  +                return ((IEntityWithRelationships)this).RelationshipManager.GetRelatedReference<Orders>("northwindEFModel.FK_OrderDetails_OrderID_OrderID", "Orders").Value;
         1626  +            }
         1627  +            set
         1628  +            {
         1629  +                ((IEntityWithRelationships)this).RelationshipManager.GetRelatedReference<Orders>("northwindEFModel.FK_OrderDetails_OrderID_OrderID", "Orders").Value = value;
         1630  +            }
         1631  +        }
         1632  +        /// <summary>
         1633  +        /// No Metadata Documentation available.
         1634  +        /// </summary>
         1635  +        [BrowsableAttribute(false)]
         1636  +        [DataMemberAttribute()]
         1637  +        public EntityReference<Orders> OrdersReference
         1638  +        {
         1639  +            get
         1640  +            {
         1641  +                return ((IEntityWithRelationships)this).RelationshipManager.GetRelatedReference<Orders>("northwindEFModel.FK_OrderDetails_OrderID_OrderID", "Orders");
         1642  +            }
         1643  +            set
         1644  +            {
         1645  +                if ((value != null))
         1646  +                {
         1647  +                    ((IEntityWithRelationships)this).RelationshipManager.InitializeRelatedReference<Orders>("northwindEFModel.FK_OrderDetails_OrderID_OrderID", "Orders", value);
         1648  +                }
         1649  +            }
         1650  +        }
         1651  +
         1652  +        /// <summary>
         1653  +        /// No Metadata Documentation available.
         1654  +        /// </summary>
         1655  +        [XmlIgnoreAttribute()]
         1656  +        [SoapIgnoreAttribute()]
         1657  +        [DataMemberAttribute()]
         1658  +        [EdmRelationshipNavigationPropertyAttribute("northwindEFModel", "FK_OrderDetails_ProductID_ProductID", "Products")]
         1659  +        public Products Products
         1660  +        {
         1661  +            get
         1662  +            {
         1663  +                return ((IEntityWithRelationships)this).RelationshipManager.GetRelatedReference<Products>("northwindEFModel.FK_OrderDetails_ProductID_ProductID", "Products").Value;
         1664  +            }
         1665  +            set
         1666  +            {
         1667  +                ((IEntityWithRelationships)this).RelationshipManager.GetRelatedReference<Products>("northwindEFModel.FK_OrderDetails_ProductID_ProductID", "Products").Value = value;
         1668  +            }
         1669  +        }
         1670  +        /// <summary>
         1671  +        /// No Metadata Documentation available.
         1672  +        /// </summary>
         1673  +        [BrowsableAttribute(false)]
         1674  +        [DataMemberAttribute()]
         1675  +        public EntityReference<Products> ProductsReference
         1676  +        {
         1677  +            get
         1678  +            {
         1679  +                return ((IEntityWithRelationships)this).RelationshipManager.GetRelatedReference<Products>("northwindEFModel.FK_OrderDetails_ProductID_ProductID", "Products");
         1680  +            }
         1681  +            set
         1682  +            {
         1683  +                if ((value != null))
         1684  +                {
         1685  +                    ((IEntityWithRelationships)this).RelationshipManager.InitializeRelatedReference<Products>("northwindEFModel.FK_OrderDetails_ProductID_ProductID", "Products", value);
         1686  +                }
         1687  +            }
         1688  +        }
         1689  +
         1690  +        #endregion
         1691  +    }
         1692  +
         1693  +    /// <summary>
         1694  +    /// No Metadata Documentation available.
         1695  +    /// </summary>
         1696  +    [EdmEntityTypeAttribute(NamespaceName="northwindEFModel", Name="Orders")]
         1697  +    [Serializable()]
         1698  +    [DataContractAttribute(IsReference=true)]
         1699  +    public partial class Orders : EntityObject
         1700  +    {
         1701  +        #region Factory Method
         1702  +
         1703  +        /// <summary>
         1704  +        /// Create a new Orders object.
         1705  +        /// </summary>
         1706  +        /// <param name="orderID">Initial value of the OrderID property.</param>
         1707  +        public static Orders CreateOrders(global::System.Int64 orderID)
         1708  +        {
         1709  +            Orders orders = new Orders();
         1710  +            orders.OrderID = orderID;
         1711  +            return orders;
         1712  +        }
         1713  +
         1714  +        #endregion
         1715  +        #region Primitive Properties
         1716  +
         1717  +        /// <summary>
         1718  +        /// No Metadata Documentation available.
         1719  +        /// </summary>
         1720  +        [EdmScalarPropertyAttribute(EntityKeyProperty=true, IsNullable=false)]
         1721  +        [DataMemberAttribute()]
         1722  +        public global::System.Int64 OrderID
         1723  +        {
         1724  +            get
         1725  +            {
         1726  +                return _OrderID;
         1727  +            }
         1728  +            set
         1729  +            {
         1730  +                if (_OrderID != value)
         1731  +                {
         1732  +                    OnOrderIDChanging(value);
         1733  +                    ReportPropertyChanging("OrderID");
         1734  +                    _OrderID = StructuralObject.SetValidValue(value);
         1735  +                    ReportPropertyChanged("OrderID");
         1736  +                    OnOrderIDChanged();
         1737  +                }
         1738  +            }
         1739  +        }
         1740  +        private global::System.Int64 _OrderID;
         1741  +        partial void OnOrderIDChanging(global::System.Int64 value);
         1742  +        partial void OnOrderIDChanged();
         1743  +
         1744  +        /// <summary>
         1745  +        /// No Metadata Documentation available.
         1746  +        /// </summary>
         1747  +        [EdmScalarPropertyAttribute(EntityKeyProperty=false, IsNullable=true)]
         1748  +        [DataMemberAttribute()]
         1749  +        public Nullable<global::System.Int64> EmployeeID
         1750  +        {
         1751  +            get
         1752  +            {
         1753  +                return _EmployeeID;
         1754  +            }
         1755  +            set
         1756  +            {
         1757  +                OnEmployeeIDChanging(value);
         1758  +                ReportPropertyChanging("EmployeeID");
         1759  +                _EmployeeID = StructuralObject.SetValidValue(value);
         1760  +                ReportPropertyChanged("EmployeeID");
         1761  +                OnEmployeeIDChanged();
         1762  +            }
         1763  +        }
         1764  +        private Nullable<global::System.Int64> _EmployeeID;
         1765  +        partial void OnEmployeeIDChanging(Nullable<global::System.Int64> value);
         1766  +        partial void OnEmployeeIDChanged();
         1767  +
         1768  +        /// <summary>
         1769  +        /// No Metadata Documentation available.
         1770  +        /// </summary>
         1771  +        [EdmScalarPropertyAttribute(EntityKeyProperty=false, IsNullable=true)]
         1772  +        [DataMemberAttribute()]
         1773  +        public Nullable<global::System.DateTime> OrderDate
         1774  +        {
         1775  +            get
         1776  +            {
         1777  +                return _OrderDate;
         1778  +            }
         1779  +            set
         1780  +            {
         1781  +                OnOrderDateChanging(value);
         1782  +                ReportPropertyChanging("OrderDate");
         1783  +                _OrderDate = StructuralObject.SetValidValue(value);
         1784  +                ReportPropertyChanged("OrderDate");
         1785  +                OnOrderDateChanged();
         1786  +            }
         1787  +        }
         1788  +        private Nullable<global::System.DateTime> _OrderDate;
         1789  +        partial void OnOrderDateChanging(Nullable<global::System.DateTime> value);
         1790  +        partial void OnOrderDateChanged();
         1791  +
         1792  +        /// <summary>
         1793  +        /// No Metadata Documentation available.
         1794  +        /// </summary>
         1795  +        [EdmScalarPropertyAttribute(EntityKeyProperty=false, IsNullable=true)]
         1796  +        [DataMemberAttribute()]
         1797  +        public Nullable<global::System.DateTime> RequiredDate
         1798  +        {
         1799  +            get
         1800  +            {
         1801  +                return _RequiredDate;
         1802  +            }
         1803  +            set
         1804  +            {
         1805  +                OnRequiredDateChanging(value);
         1806  +                ReportPropertyChanging("RequiredDate");
         1807  +                _RequiredDate = StructuralObject.SetValidValue(value);
         1808  +                ReportPropertyChanged("RequiredDate");
         1809  +                OnRequiredDateChanged();
         1810  +            }
         1811  +        }
         1812  +        private Nullable<global::System.DateTime> _RequiredDate;
         1813  +        partial void OnRequiredDateChanging(Nullable<global::System.DateTime> value);
         1814  +        partial void OnRequiredDateChanged();
         1815  +
         1816  +        /// <summary>
         1817  +        /// No Metadata Documentation available.
         1818  +        /// </summary>
         1819  +        [EdmScalarPropertyAttribute(EntityKeyProperty=false, IsNullable=true)]
         1820  +        [DataMemberAttribute()]
         1821  +        public Nullable<global::System.DateTime> ShippedDate
         1822  +        {
         1823  +            get
         1824  +            {
         1825  +                return _ShippedDate;
         1826  +            }
         1827  +            set
         1828  +            {
         1829  +                OnShippedDateChanging(value);
         1830  +                ReportPropertyChanging("ShippedDate");
         1831  +                _ShippedDate = StructuralObject.SetValidValue(value);
         1832  +                ReportPropertyChanged("ShippedDate");
         1833  +                OnShippedDateChanged();
         1834  +            }
         1835  +        }
         1836  +        private Nullable<global::System.DateTime> _ShippedDate;
         1837  +        partial void OnShippedDateChanging(Nullable<global::System.DateTime> value);
         1838  +        partial void OnShippedDateChanged();
         1839  +
         1840  +        /// <summary>
         1841  +        /// No Metadata Documentation available.
         1842  +        /// </summary>
         1843  +        [EdmScalarPropertyAttribute(EntityKeyProperty=false, IsNullable=true)]
         1844  +        [DataMemberAttribute()]
         1845  +        public Nullable<global::System.Decimal> Freight
         1846  +        {
         1847  +            get
         1848  +            {
         1849  +                return _Freight;
         1850  +            }
         1851  +            set
         1852  +            {
         1853  +                OnFreightChanging(value);
         1854  +                ReportPropertyChanging("Freight");
         1855  +                _Freight = StructuralObject.SetValidValue(value);
         1856  +                ReportPropertyChanged("Freight");
         1857  +                OnFreightChanged();
         1858  +            }
         1859  +        }
         1860  +        private Nullable<global::System.Decimal> _Freight;
         1861  +        partial void OnFreightChanging(Nullable<global::System.Decimal> value);
         1862  +        partial void OnFreightChanged();
         1863  +
         1864  +        /// <summary>
         1865  +        /// No Metadata Documentation available.
         1866  +        /// </summary>
         1867  +        [EdmScalarPropertyAttribute(EntityKeyProperty=false, IsNullable=true)]
         1868  +        [DataMemberAttribute()]
         1869  +        public global::System.String ShipName
         1870  +        {
         1871  +            get
         1872  +            {
         1873  +                return _ShipName;
         1874  +            }
         1875  +            set
         1876  +            {
         1877  +                OnShipNameChanging(value);
         1878  +                ReportPropertyChanging("ShipName");
         1879  +                _ShipName = StructuralObject.SetValidValue(value, true);
         1880  +                ReportPropertyChanged("ShipName");
         1881  +                OnShipNameChanged();
         1882  +            }
         1883  +        }
         1884  +        private global::System.String _ShipName;
         1885  +        partial void OnShipNameChanging(global::System.String value);
         1886  +        partial void OnShipNameChanged();
         1887  +
         1888  +        /// <summary>
         1889  +        /// No Metadata Documentation available.
         1890  +        /// </summary>
         1891  +        [EdmScalarPropertyAttribute(EntityKeyProperty=false, IsNullable=true)]
         1892  +        [DataMemberAttribute()]
         1893  +        public global::System.String ShipAddress
         1894  +        {
         1895  +            get
         1896  +            {
         1897  +                return _ShipAddress;
         1898  +            }
         1899  +            set
         1900  +            {
         1901  +                OnShipAddressChanging(value);
         1902  +                ReportPropertyChanging("ShipAddress");
         1903  +                _ShipAddress = StructuralObject.SetValidValue(value, true);
         1904  +                ReportPropertyChanged("ShipAddress");
         1905  +                OnShipAddressChanged();
         1906  +            }
         1907  +        }
         1908  +        private global::System.String _ShipAddress;
         1909  +        partial void OnShipAddressChanging(global::System.String value);
         1910  +        partial void OnShipAddressChanged();
         1911  +
         1912  +        /// <summary>
         1913  +        /// No Metadata Documentation available.
         1914  +        /// </summary>
         1915  +        [EdmScalarPropertyAttribute(EntityKeyProperty=false, IsNullable=true)]
         1916  +        [DataMemberAttribute()]
         1917  +        public global::System.String ShipCity
         1918  +        {
         1919  +            get
         1920  +            {
         1921  +                return _ShipCity;
         1922  +            }
         1923  +            set
         1924  +            {
         1925  +                OnShipCityChanging(value);
         1926  +                ReportPropertyChanging("ShipCity");
         1927  +                _ShipCity = StructuralObject.SetValidValue(value, true);
         1928  +                ReportPropertyChanged("ShipCity");
         1929  +                OnShipCityChanged();
         1930  +            }
         1931  +        }
         1932  +        private global::System.String _ShipCity;
         1933  +        partial void OnShipCityChanging(global::System.String value);
         1934  +        partial void OnShipCityChanged();
         1935  +
         1936  +        /// <summary>
         1937  +        /// No Metadata Documentation available.
         1938  +        /// </summary>
         1939  +        [EdmScalarPropertyAttribute(EntityKeyProperty=false, IsNullable=true)]
         1940  +        [DataMemberAttribute()]
         1941  +        public global::System.String ShipRegion
         1942  +        {
         1943  +            get
         1944  +            {
         1945  +                return _ShipRegion;
         1946  +            }
         1947  +            set
         1948  +            {
         1949  +                OnShipRegionChanging(value);
         1950  +                ReportPropertyChanging("ShipRegion");
         1951  +                _ShipRegion = StructuralObject.SetValidValue(value, true);
         1952  +                ReportPropertyChanged("ShipRegion");
         1953  +                OnShipRegionChanged();
         1954  +            }
         1955  +        }
         1956  +        private global::System.String _ShipRegion;
         1957  +        partial void OnShipRegionChanging(global::System.String value);
         1958  +        partial void OnShipRegionChanged();
         1959  +
         1960  +        /// <summary>
         1961  +        /// No Metadata Documentation available.
         1962  +        /// </summary>
         1963  +        [EdmScalarPropertyAttribute(EntityKeyProperty=false, IsNullable=true)]
         1964  +        [DataMemberAttribute()]
         1965  +        public global::System.String ShipPostalCode
         1966  +        {
         1967  +            get
         1968  +            {
         1969  +                return _ShipPostalCode;
         1970  +            }
         1971  +            set
         1972  +            {
         1973  +                OnShipPostalCodeChanging(value);
         1974  +                ReportPropertyChanging("ShipPostalCode");
         1975  +                _ShipPostalCode = StructuralObject.SetValidValue(value, true);
         1976  +                ReportPropertyChanged("ShipPostalCode");
         1977  +                OnShipPostalCodeChanged();
         1978  +            }
         1979  +        }
         1980  +        private global::System.String _ShipPostalCode;
         1981  +        partial void OnShipPostalCodeChanging(global::System.String value);
         1982  +        partial void OnShipPostalCodeChanged();
         1983  +
         1984  +        /// <summary>
         1985  +        /// No Metadata Documentation available.
         1986  +        /// </summary>
         1987  +        [EdmScalarPropertyAttribute(EntityKeyProperty=false, IsNullable=true)]
         1988  +        [DataMemberAttribute()]
         1989  +        public global::System.String ShipCountry
         1990  +        {
         1991  +            get
         1992  +            {
         1993  +                return _ShipCountry;
         1994  +            }
         1995  +            set
         1996  +            {
         1997  +                OnShipCountryChanging(value);
         1998  +                ReportPropertyChanging("ShipCountry");
         1999  +                _ShipCountry = StructuralObject.SetValidValue(value, true);
         2000  +                ReportPropertyChanged("ShipCountry");
         2001  +                OnShipCountryChanged();
         2002  +            }
         2003  +        }
         2004  +        private global::System.String _ShipCountry;
         2005  +        partial void OnShipCountryChanging(global::System.String value);
         2006  +        partial void OnShipCountryChanged();
         2007  +
         2008  +        #endregion
         2009  +
         2010  +        #region Navigation Properties
         2011  +
         2012  +        /// <summary>
         2013  +        /// No Metadata Documentation available.
         2014  +        /// </summary>
         2015  +        [XmlIgnoreAttribute()]
         2016  +        [SoapIgnoreAttribute()]
         2017  +        [DataMemberAttribute()]
         2018  +        [EdmRelationshipNavigationPropertyAttribute("northwindEFModel", "FK_Orders_CustomerID_CustomerID", "Customers")]
         2019  +        public Customers Customers
         2020  +        {
         2021  +            get
         2022  +            {
         2023  +                return ((IEntityWithRelationships)this).RelationshipManager.GetRelatedReference<Customers>("northwindEFModel.FK_Orders_CustomerID_CustomerID", "Customers").Value;
         2024  +            }
         2025  +            set
         2026  +            {
         2027  +                ((IEntityWithRelationships)this).RelationshipManager.GetRelatedReference<Customers>("northwindEFModel.FK_Orders_CustomerID_CustomerID", "Customers").Value = value;
         2028  +            }
         2029  +        }
         2030  +        /// <summary>
         2031  +        /// No Metadata Documentation available.
         2032  +        /// </summary>
         2033  +        [BrowsableAttribute(false)]
         2034  +        [DataMemberAttribute()]
         2035  +        public EntityReference<Customers> CustomersReference
         2036  +        {
         2037  +            get
         2038  +            {
         2039  +                return ((IEntityWithRelationships)this).RelationshipManager.GetRelatedReference<Customers>("northwindEFModel.FK_Orders_CustomerID_CustomerID", "Customers");
         2040  +            }
         2041  +            set
         2042  +            {
         2043  +                if ((value != null))
         2044  +                {
         2045  +                    ((IEntityWithRelationships)this).RelationshipManager.InitializeRelatedReference<Customers>("northwindEFModel.FK_Orders_CustomerID_CustomerID", "Customers", value);
         2046  +                }
         2047  +            }
         2048  +        }
         2049  +
         2050  +        /// <summary>
         2051  +        /// No Metadata Documentation available.
         2052  +        /// </summary>
         2053  +        [XmlIgnoreAttribute()]
         2054  +        [SoapIgnoreAttribute()]
         2055  +        [DataMemberAttribute()]
         2056  +        [EdmRelationshipNavigationPropertyAttribute("northwindEFModel", "FK_InternationalOrders_OrderID_OrderID", "InternationalOrders")]
         2057  +        public InternationalOrders InternationalOrders
         2058  +        {
         2059  +            get
         2060  +            {
         2061  +                return ((IEntityWithRelationships)this).RelationshipManager.GetRelatedReference<InternationalOrders>("northwindEFModel.FK_InternationalOrders_OrderID_OrderID", "InternationalOrders").Value;
         2062  +            }
         2063  +            set
         2064  +            {
         2065  +                ((IEntityWithRelationships)this).RelationshipManager.GetRelatedReference<InternationalOrders>("northwindEFModel.FK_InternationalOrders_OrderID_OrderID", "InternationalOrders").Value = value;
         2066  +            }
         2067  +        }
         2068  +        /// <summary>
         2069  +        /// No Metadata Documentation available.
         2070  +        /// </summary>
         2071  +        [BrowsableAttribute(false)]
         2072  +        [DataMemberAttribute()]
         2073  +        public EntityReference<InternationalOrders> InternationalOrdersReference
         2074  +        {
         2075  +            get
         2076  +            {
         2077  +                return ((IEntityWithRelationships)this).RelationshipManager.GetRelatedReference<InternationalOrders>("northwindEFModel.FK_InternationalOrders_OrderID_OrderID", "InternationalOrders");
         2078  +            }
         2079  +            set
         2080  +            {
         2081  +                if ((value != null))
         2082  +                {
         2083  +                    ((IEntityWithRelationships)this).RelationshipManager.InitializeRelatedReference<InternationalOrders>("northwindEFModel.FK_InternationalOrders_OrderID_OrderID", "InternationalOrders", value);
         2084  +                }
         2085  +            }
         2086  +        }
         2087  +
         2088  +        /// <summary>
         2089  +        /// No Metadata Documentation available.
         2090  +        /// </summary>
         2091  +        [XmlIgnoreAttribute()]
         2092  +        [SoapIgnoreAttribute()]
         2093  +        [DataMemberAttribute()]
         2094  +        [EdmRelationshipNavigationPropertyAttribute("northwindEFModel", "FK_OrderDetails_OrderID_OrderID", "OrderDetails")]
         2095  +        public EntityCollection<OrderDetails> OrderDetails
         2096  +        {
         2097  +            get
         2098  +            {
         2099  +                return ((IEntityWithRelationships)this).RelationshipManager.GetRelatedCollection<OrderDetails>("northwindEFModel.FK_OrderDetails_OrderID_OrderID", "OrderDetails");
         2100  +            }
         2101  +            set
         2102  +            {
         2103  +                if ((value != null))
         2104  +                {
         2105  +                    ((IEntityWithRelationships)this).RelationshipManager.InitializeRelatedCollection<OrderDetails>("northwindEFModel.FK_OrderDetails_OrderID_OrderID", "OrderDetails", value);
         2106  +                }
         2107  +            }
         2108  +        }
         2109  +
         2110  +        #endregion
         2111  +    }
         2112  +
         2113  +    /// <summary>
         2114  +    /// No Metadata Documentation available.
         2115  +    /// </summary>
         2116  +    [EdmEntityTypeAttribute(NamespaceName="northwindEFModel", Name="PreviousEmployees")]
         2117  +    [Serializable()]
         2118  +    [DataContractAttribute(IsReference=true)]
         2119  +    public partial class PreviousEmployees : EntityObject
         2120  +    {
         2121  +        #region Factory Method
         2122  +
         2123  +        /// <summary>
         2124  +        /// Create a new PreviousEmployees object.
         2125  +        /// </summary>
         2126  +        /// <param name="employeeID">Initial value of the EmployeeID property.</param>
         2127  +        /// <param name="lastName">Initial value of the LastName property.</param>
         2128  +        /// <param name="firstName">Initial value of the FirstName property.</param>
         2129  +        public static PreviousEmployees CreatePreviousEmployees(global::System.Int64 employeeID, global::System.String lastName, global::System.String firstName)
         2130  +        {
         2131  +            PreviousEmployees previousEmployees = new PreviousEmployees();
         2132  +            previousEmployees.EmployeeID = employeeID;
         2133  +            previousEmployees.LastName = lastName;
         2134  +            previousEmployees.FirstName = firstName;
         2135  +            return previousEmployees;
         2136  +        }
         2137  +
         2138  +        #endregion
         2139  +        #region Primitive Properties
         2140  +
         2141  +        /// <summary>
         2142  +        /// No Metadata Documentation available.
         2143  +        /// </summary>
         2144  +        [EdmScalarPropertyAttribute(EntityKeyProperty=true, IsNullable=false)]
         2145  +        [DataMemberAttribute()]
         2146  +        public global::System.Int64 EmployeeID
         2147  +        {
         2148  +            get
         2149  +            {
         2150  +                return _EmployeeID;
         2151  +            }
         2152  +            set
         2153  +            {
         2154  +                if (_EmployeeID != value)
         2155  +                {
         2156  +                    OnEmployeeIDChanging(value);
         2157  +                    ReportPropertyChanging("EmployeeID");
         2158  +                    _EmployeeID = StructuralObject.SetValidValue(value);
         2159  +                    ReportPropertyChanged("EmployeeID");
         2160  +                    OnEmployeeIDChanged();
         2161  +                }
         2162  +            }
         2163  +        }
         2164  +        private global::System.Int64 _EmployeeID;
         2165  +        partial void OnEmployeeIDChanging(global::System.Int64 value);
         2166  +        partial void OnEmployeeIDChanged();
         2167  +
         2168  +        /// <summary>
         2169  +        /// No Metadata Documentation available.
         2170  +        /// </summary>
         2171  +        [EdmScalarPropertyAttribute(EntityKeyProperty=false, IsNullable=false)]
         2172  +        [DataMemberAttribute()]
         2173  +        public global::System.String LastName
         2174  +        {
         2175  +            get
         2176  +            {
         2177  +                return _LastName;
         2178  +            }
         2179  +            set
         2180  +            {
         2181  +                OnLastNameChanging(value);
         2182  +                ReportPropertyChanging("LastName");
         2183  +                _LastName = StructuralObject.SetValidValue(value, false);
         2184  +                ReportPropertyChanged("LastName");
         2185  +                OnLastNameChanged();
         2186  +            }
         2187  +        }
         2188  +        private global::System.String _LastName;
         2189  +        partial void OnLastNameChanging(global::System.String value);
         2190  +        partial void OnLastNameChanged();
         2191  +
         2192  +        /// <summary>
         2193  +        /// No Metadata Documentation available.
         2194  +        /// </summary>
         2195  +        [EdmScalarPropertyAttribute(EntityKeyProperty=false, IsNullable=false)]
         2196  +        [DataMemberAttribute()]
         2197  +        public global::System.String FirstName
         2198  +        {
         2199  +            get
         2200  +            {
         2201  +                return _FirstName;
         2202  +            }
         2203  +            set
         2204  +            {
         2205  +                OnFirstNameChanging(value);
         2206  +                ReportPropertyChanging("FirstName");
         2207  +                _FirstName = StructuralObject.SetValidValue(value, false);
         2208  +                ReportPropertyChanged("FirstName");
         2209  +                OnFirstNameChanged();
         2210  +            }
         2211  +        }
         2212  +        private global::System.String _FirstName;
         2213  +        partial void OnFirstNameChanging(global::System.String value);
         2214  +        partial void OnFirstNameChanged();
         2215  +
         2216  +        /// <summary>
         2217  +        /// No Metadata Documentation available.
         2218  +        /// </summary>
         2219  +        [EdmScalarPropertyAttribute(EntityKeyProperty=false, IsNullable=true)]
         2220  +        [DataMemberAttribute()]
         2221  +        public global::System.String Title
         2222  +        {
         2223  +            get
         2224  +            {
         2225  +                return _Title;
         2226  +            }
         2227  +            set
         2228  +            {
         2229  +                OnTitleChanging(value);
         2230  +                ReportPropertyChanging("Title");
         2231  +                _Title = StructuralObject.SetValidValue(value, true);
         2232  +                ReportPropertyChanged("Title");
         2233  +                OnTitleChanged();
         2234  +            }
         2235  +        }
         2236  +        private global::System.String _Title;
         2237  +        partial void OnTitleChanging(global::System.String value);
         2238  +        partial void OnTitleChanged();
         2239  +
         2240  +        /// <summary>
         2241  +        /// No Metadata Documentation available.
         2242  +        /// </summary>
         2243  +        [EdmScalarPropertyAttribute(EntityKeyProperty=false, IsNullable=true)]
         2244  +        [DataMemberAttribute()]
         2245  +        public global::System.String TitleOfCourtesy
         2246  +        {
         2247  +            get
         2248  +            {
         2249  +                return _TitleOfCourtesy;
         2250  +            }
         2251  +            set
         2252  +            {
         2253  +                OnTitleOfCourtesyChanging(value);
         2254  +                ReportPropertyChanging("TitleOfCourtesy");
         2255  +                _TitleOfCourtesy = StructuralObject.SetValidValue(value, true);
         2256  +                ReportPropertyChanged("TitleOfCourtesy");
         2257  +                OnTitleOfCourtesyChanged();
         2258  +            }
         2259  +        }
         2260  +        private global::System.String _TitleOfCourtesy;
         2261  +        partial void OnTitleOfCourtesyChanging(global::System.String value);
         2262  +        partial void OnTitleOfCourtesyChanged();
         2263  +
         2264  +        /// <summary>
         2265  +        /// No Metadata Documentation available.
         2266  +        /// </summary>
         2267  +        [EdmScalarPropertyAttribute(EntityKeyProperty=false, IsNullable=true)]
         2268  +        [DataMemberAttribute()]
         2269  +        public Nullable<global::System.DateTime> BirthDate
         2270  +        {
         2271  +            get
         2272  +            {
         2273  +                return _BirthDate;
         2274  +            }
         2275  +            set
         2276  +            {
         2277  +                OnBirthDateChanging(value);
         2278  +                ReportPropertyChanging("BirthDate");
         2279  +                _BirthDate = StructuralObject.SetValidValue(value);
         2280  +                ReportPropertyChanged("BirthDate");
         2281  +                OnBirthDateChanged();
         2282  +            }
         2283  +        }
         2284  +        private Nullable<global::System.DateTime> _BirthDate;
         2285  +        partial void OnBirthDateChanging(Nullable<global::System.DateTime> value);
         2286  +        partial void OnBirthDateChanged();
         2287  +
         2288  +        /// <summary>
         2289  +        /// No Metadata Documentation available.
         2290  +        /// </summary>
         2291  +        [EdmScalarPropertyAttribute(EntityKeyProperty=false, IsNullable=true)]
         2292  +        [DataMemberAttribute()]
         2293  +        public Nullable<global::System.DateTime> HireDate
         2294  +        {
         2295  +            get
         2296  +            {
         2297  +                return _HireDate;
         2298  +            }
         2299  +            set
         2300  +            {
         2301  +                OnHireDateChanging(value);
         2302  +                ReportPropertyChanging("HireDate");
         2303  +                _HireDate = StructuralObject.SetValidValue(value);
         2304  +                ReportPropertyChanged("HireDate");
         2305  +                OnHireDateChanged();
         2306  +            }
         2307  +        }
         2308  +        private Nullable<global::System.DateTime> _HireDate;
         2309  +        partial void OnHireDateChanging(Nullable<global::System.DateTime> value);
         2310  +        partial void OnHireDateChanged();
         2311  +
         2312  +        /// <summary>
         2313  +        /// No Metadata Documentation available.
         2314  +        /// </summary>
         2315  +        [EdmScalarPropertyAttribute(EntityKeyProperty=false, IsNullable=true)]
         2316  +        [DataMemberAttribute()]
         2317  +        public global::System.String Address
         2318  +        {
         2319  +            get
         2320  +            {
         2321  +                return _Address;
         2322  +            }
         2323  +            set
         2324  +            {
         2325  +                OnAddressChanging(value);
         2326  +                ReportPropertyChanging("Address");
         2327  +                _Address = StructuralObject.SetValidValue(value, true);
         2328  +                ReportPropertyChanged("Address");
         2329  +                OnAddressChanged();
         2330  +            }
         2331  +        }
         2332  +        private global::System.String _Address;
         2333  +        partial void OnAddressChanging(global::System.String value);
         2334  +        partial void OnAddressChanged();
         2335  +
         2336  +        /// <summary>
         2337  +        /// No Metadata Documentation available.
         2338  +        /// </summary>
         2339  +        [EdmScalarPropertyAttribute(EntityKeyProperty=false, IsNullable=true)]
         2340  +        [DataMemberAttribute()]
         2341  +        public global::System.String City
         2342  +        {
         2343  +            get
         2344  +            {
         2345  +                return _City;
         2346  +            }
         2347  +            set
         2348  +            {
         2349  +                OnCityChanging(value);
         2350  +                ReportPropertyChanging("City");
         2351  +                _City = StructuralObject.SetValidValue(value, true);
         2352  +                ReportPropertyChanged("City");
         2353  +                OnCityChanged();
         2354  +            }
         2355  +        }
         2356  +        private global::System.String _City;
         2357  +        partial void OnCityChanging(global::System.String value);
         2358  +        partial void OnCityChanged();
         2359  +
         2360  +        /// <summary>
         2361  +        /// No Metadata Documentation available.
         2362  +        /// </summary>
         2363  +        [EdmScalarPropertyAttribute(EntityKeyProperty=false, IsNullable=true)]
         2364  +        [DataMemberAttribute()]
         2365  +        public global::System.String Region
         2366  +        {
         2367  +            get
         2368  +            {
         2369  +                return _Region;
         2370  +            }
         2371  +            set
         2372  +            {
         2373  +                OnRegionChanging(value);
         2374  +                ReportPropertyChanging("Region");
         2375  +                _Region = StructuralObject.SetValidValue(value, true);
         2376  +                ReportPropertyChanged("Region");
         2377  +                OnRegionChanged();
         2378  +            }
         2379  +        }
         2380  +        private global::System.String _Region;
         2381  +        partial void OnRegionChanging(global::System.String value);
         2382  +        partial void OnRegionChanged();
         2383  +
         2384  +        /// <summary>
         2385  +        /// No Metadata Documentation available.
         2386  +        /// </summary>
         2387  +        [EdmScalarPropertyAttribute(EntityKeyProperty=false, IsNullable=true)]
         2388  +        [DataMemberAttribute()]
         2389  +        public global::System.String PostalCode
         2390  +        {
         2391  +            get
         2392  +            {
         2393  +                return _PostalCode;
         2394  +            }
         2395  +            set
         2396  +            {
         2397  +                OnPostalCodeChanging(value);
         2398  +                ReportPropertyChanging("PostalCode");
         2399  +                _PostalCode = StructuralObject.SetValidValue(value, true);
         2400  +                ReportPropertyChanged("PostalCode");
         2401  +                OnPostalCodeChanged();
         2402  +            }
         2403  +        }
         2404  +        private global::System.String _PostalCode;
         2405  +        partial void OnPostalCodeChanging(global::System.String value);
         2406  +        partial void OnPostalCodeChanged();
         2407  +
         2408  +        /// <summary>
         2409  +        /// No Metadata Documentation available.
         2410  +        /// </summary>
         2411  +        [EdmScalarPropertyAttribute(EntityKeyProperty=false, IsNullable=true)]
         2412  +        [DataMemberAttribute()]
         2413  +        public global::System.String Country
         2414  +        {
         2415  +            get
         2416  +            {
         2417  +                return _Country;
         2418  +            }
         2419  +            set
         2420  +            {
         2421  +                OnCountryChanging(value);
         2422  +                ReportPropertyChanging("Country");
         2423  +                _Country = StructuralObject.SetValidValue(value, true);
         2424  +                ReportPropertyChanged("Country");
         2425  +                OnCountryChanged();
         2426  +            }
         2427  +        }
         2428  +        private global::System.String _Country;
         2429  +        partial void OnCountryChanging(global::System.String value);
         2430  +        partial void OnCountryChanged();
         2431  +
         2432  +        /// <summary>
         2433  +        /// No Metadata Documentation available.
         2434  +        /// </summary>
         2435  +        [EdmScalarPropertyAttribute(EntityKeyProperty=false, IsNullable=true)]
         2436  +        [DataMemberAttribute()]
         2437  +        public global::System.String HomePhone
         2438  +        {
         2439  +            get
         2440  +            {
         2441  +                return _HomePhone;
         2442  +            }
         2443  +            set
         2444  +            {
         2445  +                OnHomePhoneChanging(value);
         2446  +                ReportPropertyChanging("HomePhone");
         2447  +                _HomePhone = StructuralObject.SetValidValue(value, true);
         2448  +                ReportPropertyChanged("HomePhone");
         2449  +                OnHomePhoneChanged();
         2450  +            }
         2451  +        }
         2452  +        private global::System.String _HomePhone;
         2453  +        partial void OnHomePhoneChanging(global::System.String value);
         2454  +        partial void OnHomePhoneChanged();
         2455  +
         2456  +        /// <summary>
         2457  +        /// No Metadata Documentation available.
         2458  +        /// </summary>
         2459  +        [EdmScalarPropertyAttribute(EntityKeyProperty=false, IsNullable=true)]
         2460  +        [DataMemberAttribute()]
         2461  +        public global::System.String Extension
         2462  +        {
         2463  +            get
         2464  +            {
         2465  +                return _Extension;
         2466  +            }
         2467  +            set
         2468  +            {
         2469  +                OnExtensionChanging(value);
         2470  +                ReportPropertyChanging("Extension");
         2471  +                _Extension = StructuralObject.SetValidValue(value, true);
         2472  +                ReportPropertyChanged("Extension");
         2473  +                OnExtensionChanged();
         2474  +            }
         2475  +        }
         2476  +        private global::System.String _Extension;
         2477  +        partial void OnExtensionChanging(global::System.String value);
         2478  +        partial void OnExtensionChanged();
         2479  +
         2480  +        /// <summary>
         2481  +        /// No Metadata Documentation available.
         2482  +        /// </summary>
         2483  +        [EdmScalarPropertyAttribute(EntityKeyProperty=false, IsNullable=true)]
         2484  +        [DataMemberAttribute()]
         2485  +        public global::System.Byte[] Photo
         2486  +        {
         2487  +            get
         2488  +            {
         2489  +                return StructuralObject.GetValidValue(_Photo);
         2490  +            }
         2491  +            set
         2492  +            {
         2493  +                OnPhotoChanging(value);
         2494  +                ReportPropertyChanging("Photo");
         2495  +                _Photo = StructuralObject.SetValidValue(value, true);
         2496  +                ReportPropertyChanged("Photo");
         2497  +                OnPhotoChanged();
         2498  +            }
         2499  +        }
         2500  +        private global::System.Byte[] _Photo;
         2501  +        partial void OnPhotoChanging(global::System.Byte[] value);
         2502  +        partial void OnPhotoChanged();
         2503  +
         2504  +        /// <summary>
         2505  +        /// No Metadata Documentation available.
         2506  +        /// </summary>
         2507  +        [EdmScalarPropertyAttribute(EntityKeyProperty=false, IsNullable=true)]
         2508  +        [DataMemberAttribute()]
         2509  +        public global::System.String Notes
         2510  +        {
         2511  +            get
         2512  +            {
         2513  +                return _Notes;
         2514  +            }
         2515  +            set
         2516  +            {
         2517  +                OnNotesChanging(value);
         2518  +                ReportPropertyChanging("Notes");
         2519  +                _Notes = StructuralObject.SetValidValue(value, true);
         2520  +                ReportPropertyChanged("Notes");
         2521  +                OnNotesChanged();
         2522  +            }
         2523  +        }
         2524  +        private global::System.String _Notes;
         2525  +        partial void OnNotesChanging(global::System.String value);
         2526  +        partial void OnNotesChanged();
         2527  +
         2528  +        /// <summary>
         2529  +        /// No Metadata Documentation available.
         2530  +        /// </summary>
         2531  +        [EdmScalarPropertyAttribute(EntityKeyProperty=false, IsNullable=true)]
         2532  +        [DataMemberAttribute()]
         2533  +        public global::System.String PhotoPath
         2534  +        {
         2535  +            get
         2536  +            {
         2537  +                return _PhotoPath;
         2538  +            }
         2539  +            set
         2540  +            {
         2541  +                OnPhotoPathChanging(value);
         2542  +                ReportPropertyChanging("PhotoPath");
         2543  +                _PhotoPath = StructuralObject.SetValidValue(value, true);
         2544  +                ReportPropertyChanged("PhotoPath");
         2545  +                OnPhotoPathChanged();
         2546  +            }
         2547  +        }
         2548  +        private global::System.String _PhotoPath;
         2549  +        partial void OnPhotoPathChanging(global::System.String value);
         2550  +        partial void OnPhotoPathChanged();
         2551  +
         2552  +        #endregion
         2553  +
         2554  +    }
         2555  +
         2556  +    /// <summary>
         2557  +    /// No Metadata Documentation available.
         2558  +    /// </summary>
         2559  +    [EdmEntityTypeAttribute(NamespaceName="northwindEFModel", Name="Products")]
         2560  +    [Serializable()]
         2561  +    [DataContractAttribute(IsReference=true)]
         2562  +    public partial class Products : EntityObject
         2563  +    {
         2564  +        #region Factory Method
         2565  +
         2566  +        /// <summary>
         2567  +        /// Create a new Products object.
         2568  +        /// </summary>
         2569  +        /// <param name="productID">Initial value of the ProductID property.</param>
         2570  +        /// <param name="productName">Initial value of the ProductName property.</param>
         2571  +        /// <param name="discontinued">Initial value of the Discontinued property.</param>
         2572  +        public static Products CreateProducts(global::System.Int64 productID, global::System.String productName, global::System.Boolean discontinued)
         2573  +        {
         2574  +            Products products = new Products();
         2575  +            products.ProductID = productID;
         2576  +            products.ProductName = productName;
         2577  +            products.Discontinued = discontinued;
         2578  +            return products;
         2579  +        }
         2580  +
         2581  +        #endregion
         2582  +        #region Primitive Properties
         2583  +
         2584  +        /// <summary>
         2585  +        /// No Metadata Documentation available.
         2586  +        /// </summary>
         2587  +        [EdmScalarPropertyAttribute(EntityKeyProperty=true, IsNullable=false)]
         2588  +        [DataMemberAttribute()]
         2589  +        public global::System.Int64 ProductID
         2590  +        {
         2591  +            get
         2592  +            {
         2593  +                return _ProductID;
         2594  +            }
         2595  +            set
         2596  +            {
         2597  +                if (_ProductID != value)
         2598  +                {
         2599  +                    OnProductIDChanging(value);
         2600  +                    ReportPropertyChanging("ProductID");
         2601  +                    _ProductID = StructuralObject.SetValidValue(value);
         2602  +                    ReportPropertyChanged("ProductID");
         2603  +                    OnProductIDChanged();
         2604  +                }
         2605  +            }
         2606  +        }
         2607  +        private global::System.Int64 _ProductID;
         2608  +        partial void OnProductIDChanging(global::System.Int64 value);
         2609  +        partial void OnProductIDChanged();
         2610  +
         2611  +        /// <summary>
         2612  +        /// No Metadata Documentation available.
         2613  +        /// </summary>
         2614  +        [EdmScalarPropertyAttribute(EntityKeyProperty=false, IsNullable=false)]
         2615  +        [DataMemberAttribute()]
         2616  +        public global::System.String ProductName
         2617  +        {
         2618  +            get
         2619  +            {
         2620  +                return _ProductName;
         2621  +            }
         2622  +            set
         2623  +            {
         2624  +                OnProductNameChanging(value);
         2625  +                ReportPropertyChanging("ProductName");
         2626  +                _ProductName = StructuralObject.SetValidValue(value, false);
         2627  +                ReportPropertyChanged("ProductName");
         2628  +                OnProductNameChanged();
         2629  +            }
         2630  +        }
         2631  +        private global::System.String _ProductName;
         2632  +        partial void OnProductNameChanging(global::System.String value);
         2633  +        partial void OnProductNameChanged();
         2634  +
         2635  +        /// <summary>
         2636  +        /// No Metadata Documentation available.
         2637  +        /// </summary>
         2638  +        [EdmScalarPropertyAttribute(EntityKeyProperty=false, IsNullable=true)]
         2639  +        [DataMemberAttribute()]
         2640  +        public global::System.String QuantityPerUnit
         2641  +        {
         2642  +            get
         2643  +            {
         2644  +                return _QuantityPerUnit;
         2645  +            }
         2646  +            set
         2647  +            {
         2648  +                OnQuantityPerUnitChanging(value);
         2649  +                ReportPropertyChanging("QuantityPerUnit");
         2650  +                _QuantityPerUnit = StructuralObject.SetValidValue(value, true);
         2651  +                ReportPropertyChanged("QuantityPerUnit");
         2652  +                OnQuantityPerUnitChanged();
         2653  +            }
         2654  +        }
         2655  +        private global::System.String _QuantityPerUnit;
         2656  +        partial void OnQuantityPerUnitChanging(global::System.String value);
         2657  +        partial void OnQuantityPerUnitChanged();
         2658  +
         2659  +        /// <summary>
         2660  +        /// No Metadata Documentation available.
         2661  +        /// </summary>
         2662  +        [EdmScalarPropertyAttribute(EntityKeyProperty=false, IsNullable=true)]
         2663  +        [DataMemberAttribute()]
         2664  +        public Nullable<global::System.Decimal> UnitPrice
         2665  +        {
         2666  +            get
         2667  +            {
         2668  +                return _UnitPrice;
         2669  +            }
         2670  +            set
         2671  +            {
         2672  +                OnUnitPriceChanging(value);
         2673  +                ReportPropertyChanging("UnitPrice");
         2674  +                _UnitPrice = StructuralObject.SetValidValue(value);
         2675  +                ReportPropertyChanged("UnitPrice");
         2676  +                OnUnitPriceChanged();
         2677  +            }
         2678  +        }
         2679  +        private Nullable<global::System.Decimal> _UnitPrice;
         2680  +        partial void OnUnitPriceChanging(Nullable<global::System.Decimal> value);
         2681  +        partial void OnUnitPriceChanged();
         2682  +
         2683  +        /// <summary>
         2684  +        /// No Metadata Documentation available.
         2685  +        /// </summary>
         2686  +        [EdmScalarPropertyAttribute(EntityKeyProperty=false, IsNullable=true)]
         2687  +        [DataMemberAttribute()]
         2688  +        public Nullable<global::System.Int16> UnitsInStock
         2689  +        {
         2690  +            get
         2691  +            {
         2692  +                return _UnitsInStock;
         2693  +            }
         2694  +            set
         2695  +            {
         2696  +                OnUnitsInStockChanging(value);
         2697  +                ReportPropertyChanging("UnitsInStock");
         2698  +                _UnitsInStock = StructuralObject.SetValidValue(value);
         2699  +                ReportPropertyChanged("UnitsInStock");
         2700  +                OnUnitsInStockChanged();
         2701  +            }
         2702  +        }
         2703  +        private Nullable<global::System.Int16> _UnitsInStock;
         2704  +        partial void OnUnitsInStockChanging(Nullable<global::System.Int16> value);
         2705  +        partial void OnUnitsInStockChanged();
         2706  +
         2707  +        /// <summary>
         2708  +        /// No Metadata Documentation available.
         2709  +        /// </summary>
         2710  +        [EdmScalarPropertyAttribute(EntityKeyProperty=false, IsNullable=true)]
         2711  +        [DataMemberAttribute()]
         2712  +        public Nullable<global::System.Int16> UnitsOnOrder
         2713  +        {
         2714  +            get
         2715  +            {
         2716  +                return _UnitsOnOrder;
         2717  +            }
         2718  +            set
         2719  +            {
         2720  +                OnUnitsOnOrderChanging(value);
         2721  +                ReportPropertyChanging("UnitsOnOrder");
         2722  +                _UnitsOnOrder = StructuralObject.SetValidValue(value);
         2723  +                ReportPropertyChanged("UnitsOnOrder");
         2724  +                OnUnitsOnOrderChanged();
         2725  +            }
         2726  +        }
         2727  +        private Nullable<global::System.Int16> _UnitsOnOrder;
         2728  +        partial void OnUnitsOnOrderChanging(Nullable<global::System.Int16> value);
         2729  +        partial void OnUnitsOnOrderChanged();
         2730  +
         2731  +        /// <summary>
         2732  +        /// No Metadata Documentation available.
         2733  +        /// </summary>
         2734  +        [EdmScalarPropertyAttribute(EntityKeyProperty=false, IsNullable=true)]
         2735  +        [DataMemberAttribute()]
         2736  +        public Nullable<global::System.Int16> ReorderLevel
         2737  +        {
         2738  +            get
         2739  +            {
         2740  +                return _ReorderLevel;
         2741  +            }
         2742  +            set
         2743  +            {
         2744  +                OnReorderLevelChanging(value);
         2745  +                ReportPropertyChanging("ReorderLevel");
         2746  +                _ReorderLevel = StructuralObject.SetValidValue(value);
         2747  +                ReportPropertyChanged("ReorderLevel");
         2748  +                OnReorderLevelChanged();
         2749  +            }
         2750  +        }
         2751  +        private Nullable<global::System.Int16> _ReorderLevel;
         2752  +        partial void OnReorderLevelChanging(Nullable<global::System.Int16> value);
         2753  +        partial void OnReorderLevelChanged();
         2754  +
         2755  +        /// <summary>
         2756  +        /// No Metadata Documentation available.
         2757  +        /// </summary>
         2758  +        [EdmScalarPropertyAttribute(EntityKeyProperty=false, IsNullable=false)]
         2759  +        [DataMemberAttribute()]
         2760  +        public global::System.Boolean Discontinued
         2761  +        {
         2762  +            get
         2763  +            {
         2764  +                return _Discontinued;
         2765  +            }
         2766  +            set
         2767  +            {
         2768  +                OnDiscontinuedChanging(value);
         2769  +                ReportPropertyChanging("Discontinued");
         2770  +                _Discontinued = StructuralObject.SetValidValue(value);
         2771  +                ReportPropertyChanged("Discontinued");
         2772  +                OnDiscontinuedChanged();
         2773  +            }
         2774  +        }
         2775  +        private global::System.Boolean _Discontinued;
         2776  +        partial void OnDiscontinuedChanging(global::System.Boolean value);
         2777  +        partial void OnDiscontinuedChanged();
         2778  +
         2779  +        /// <summary>
         2780  +        /// No Metadata Documentation available.
         2781  +        /// </summary>
         2782  +        [EdmScalarPropertyAttribute(EntityKeyProperty=false, IsNullable=true)]
         2783  +        [DataMemberAttribute()]
         2784  +        public Nullable<global::System.DateTime> DiscontinuedDate
         2785  +        {
         2786  +            get
         2787  +            {
         2788  +                return _DiscontinuedDate;
         2789  +            }
         2790  +            set
         2791  +            {
         2792  +                OnDiscontinuedDateChanging(value);
         2793  +                ReportPropertyChanging("DiscontinuedDate");
         2794  +                _DiscontinuedDate = StructuralObject.SetValidValue(value);
         2795  +                ReportPropertyChanged("DiscontinuedDate");
         2796  +                OnDiscontinuedDateChanged();
         2797  +            }
         2798  +        }
         2799  +        private Nullable<global::System.DateTime> _DiscontinuedDate;
         2800  +        partial void OnDiscontinuedDateChanging(Nullable<global::System.DateTime> value);
         2801  +        partial void OnDiscontinuedDateChanged();
         2802  +
         2803  +        #endregion
         2804  +
         2805  +        #region Navigation Properties
         2806  +
         2807  +        /// <summary>
         2808  +        /// No Metadata Documentation available.
         2809  +        /// </summary>
         2810  +        [XmlIgnoreAttribute()]
         2811  +        [SoapIgnoreAttribute()]
         2812  +        [DataMemberAttribute()]
         2813  +        [EdmRelationshipNavigationPropertyAttribute("northwindEFModel", "FK_Products_CategoryID_CategoryID", "Categories")]
         2814  +        public Categories Categories
         2815  +        {
         2816  +            get
         2817  +            {
         2818  +                return ((IEntityWithRelationships)this).RelationshipManager.GetRelatedReference<Categories>("northwindEFModel.FK_Products_CategoryID_CategoryID", "Categories").Value;
         2819  +            }
         2820  +            set
         2821  +            {
         2822  +                ((IEntityWithRelationships)this).RelationshipManager.GetRelatedReference<Categories>("northwindEFModel.FK_Products_CategoryID_CategoryID", "Categories").Value = value;
         2823  +            }
         2824  +        }
         2825  +        /// <summary>
         2826  +        /// No Metadata Documentation available.
         2827  +        /// </summary>
         2828  +        [BrowsableAttribute(false)]
         2829  +        [DataMemberAttribute()]
         2830  +        public EntityReference<Categories> CategoriesReference
         2831  +        {
         2832  +            get
         2833  +            {
         2834  +                return ((IEntityWithRelationships)this).RelationshipManager.GetRelatedReference<Categories>("northwindEFModel.FK_Products_CategoryID_CategoryID", "Categories");
         2835  +            }
         2836  +            set
         2837  +            {
         2838  +                if ((value != null))
         2839  +                {
         2840  +                    ((IEntityWithRelationships)this).RelationshipManager.InitializeRelatedReference<Categories>("northwindEFModel.FK_Products_CategoryID_CategoryID", "Categories", value);
         2841  +                }
         2842  +            }
         2843  +        }
         2844  +
         2845  +        /// <summary>
         2846  +        /// No Metadata Documentation available.
         2847  +        /// </summary>
         2848  +        [XmlIgnoreAttribute()]
         2849  +        [SoapIgnoreAttribute()]
         2850  +        [DataMemberAttribute()]
         2851  +        [EdmRelationshipNavigationPropertyAttribute("northwindEFModel", "FK_OrderDetails_ProductID_ProductID", "OrderDetails")]
         2852  +        public EntityCollection<OrderDetails> OrderDetails
         2853  +        {
         2854  +            get
         2855  +            {
         2856  +                return ((IEntityWithRelationships)this).RelationshipManager.GetRelatedCollection<OrderDetails>("northwindEFModel.FK_OrderDetails_ProductID_ProductID", "OrderDetails");
         2857  +            }
         2858  +            set
         2859  +            {
         2860  +                if ((value != null))
         2861  +                {
         2862  +                    ((IEntityWithRelationships)this).RelationshipManager.InitializeRelatedCollection<OrderDetails>("northwindEFModel.FK_OrderDetails_ProductID_ProductID", "OrderDetails", value);
         2863  +                }
         2864  +            }
         2865  +        }
         2866  +
         2867  +        /// <summary>
         2868  +        /// No Metadata Documentation available.
         2869  +        /// </summary>
         2870  +        [XmlIgnoreAttribute()]
         2871  +        [SoapIgnoreAttribute()]
         2872  +        [DataMemberAttribute()]
         2873  +        [EdmRelationshipNavigationPropertyAttribute("northwindEFModel", "FK_Products_SupplierID_SupplierID", "Suppliers")]
         2874  +        public Suppliers Suppliers
         2875  +        {
         2876  +            get
         2877  +            {
         2878  +                return ((IEntityWithRelationships)this).RelationshipManager.GetRelatedReference<Suppliers>("northwindEFModel.FK_Products_SupplierID_SupplierID", "Suppliers").Value;
         2879  +            }
         2880  +            set
         2881  +            {
         2882  +                ((IEntityWithRelationships)this).RelationshipManager.GetRelatedReference<Suppliers>("northwindEFModel.FK_Products_SupplierID_SupplierID", "Suppliers").Value = value;
         2883  +            }
         2884  +        }
         2885  +        /// <summary>
         2886  +        /// No Metadata Documentation available.
         2887  +        /// </summary>
         2888  +        [BrowsableAttribute(false)]
         2889  +        [DataMemberAttribute()]
         2890  +        public EntityReference<Suppliers> SuppliersReference
         2891  +        {
         2892  +            get
         2893  +            {
         2894  +                return ((IEntityWithRelationships)this).RelationshipManager.GetRelatedReference<Suppliers>("northwindEFModel.FK_Products_SupplierID_SupplierID", "Suppliers");
         2895  +            }
         2896  +            set
         2897  +            {
         2898  +                if ((value != null))
         2899  +                {
         2900  +                    ((IEntityWithRelationships)this).RelationshipManager.InitializeRelatedReference<Suppliers>("northwindEFModel.FK_Products_SupplierID_SupplierID", "Suppliers", value);
         2901  +                }
         2902  +            }
         2903  +        }
         2904  +
         2905  +        #endregion
         2906  +    }
         2907  +
         2908  +    /// <summary>
         2909  +    /// No Metadata Documentation available.
         2910  +    /// </summary>
         2911  +    [EdmEntityTypeAttribute(NamespaceName="northwindEFModel", Name="Regions")]
         2912  +    [Serializable()]
         2913  +    [DataContractAttribute(IsReference=true)]
         2914  +    public partial class Regions : EntityObject
         2915  +    {
         2916  +        #region Factory Method
         2917  +
         2918  +        /// <summary>
         2919  +        /// Create a new Regions object.
         2920  +        /// </summary>
         2921  +        /// <param name="regionID">Initial value of the RegionID property.</param>
         2922  +        /// <param name="regionDescription">Initial value of the RegionDescription property.</param>
         2923  +        public static Regions CreateRegions(global::System.Int64 regionID, global::System.String regionDescription)
         2924  +        {
         2925  +            Regions regions = new Regions();
         2926  +            regions.RegionID = regionID;
         2927  +            regions.RegionDescription = regionDescription;
         2928  +            return regions;
         2929  +        }
         2930  +
         2931  +        #endregion
         2932  +        #region Primitive Properties
         2933  +
         2934  +        /// <summary>
         2935  +        /// No Metadata Documentation available.
         2936  +        /// </summary>
         2937  +        [EdmScalarPropertyAttribute(EntityKeyProperty=true, IsNullable=false)]
         2938  +        [DataMemberAttribute()]
         2939  +        public global::System.Int64 RegionID
         2940  +        {
         2941  +            get
         2942  +            {
         2943  +                return _RegionID;
         2944  +            }
         2945  +            set
         2946  +            {
         2947  +                if (_RegionID != value)
         2948  +                {
         2949  +                    OnRegionIDChanging(value);
         2950  +                    ReportPropertyChanging("RegionID");
         2951  +                    _RegionID = StructuralObject.SetValidValue(value);
         2952  +                    ReportPropertyChanged("RegionID");
         2953  +                    OnRegionIDChanged();
         2954  +                }
         2955  +            }
         2956  +        }
         2957  +        private global::System.Int64 _RegionID;
         2958  +        partial void OnRegionIDChanging(global::System.Int64 value);
         2959  +        partial void OnRegionIDChanged();
         2960  +
         2961  +        /// <summary>
         2962  +        /// No Metadata Documentation available.
         2963  +        /// </summary>
         2964  +        [EdmScalarPropertyAttribute(EntityKeyProperty=false, IsNullable=false)]
         2965  +        [DataMemberAttribute()]
         2966  +        public global::System.String RegionDescription
         2967  +        {
         2968  +            get
         2969  +            {
         2970  +                return _RegionDescription;
         2971  +            }
         2972  +            set
         2973  +            {
         2974  +                OnRegionDescriptionChanging(value);
         2975  +                ReportPropertyChanging("RegionDescription");
         2976  +                _RegionDescription = StructuralObject.SetValidValue(value, false);
         2977  +                ReportPropertyChanged("RegionDescription");
         2978  +                OnRegionDescriptionChanged();
         2979  +            }
         2980  +        }
         2981  +        private global::System.String _RegionDescription;
         2982  +        partial void OnRegionDescriptionChanging(global::System.String value);
         2983  +        partial void OnRegionDescriptionChanged();
         2984  +
         2985  +        #endregion
         2986  +
         2987  +        #region Navigation Properties
         2988  +
         2989  +        /// <summary>
         2990  +        /// No Metadata Documentation available.
         2991  +        /// </summary>
         2992  +        [XmlIgnoreAttribute()]
         2993  +        [SoapIgnoreAttribute()]
         2994  +        [DataMemberAttribute()]
         2995  +        [EdmRelationshipNavigationPropertyAttribute("northwindEFModel", "FK_Territories_RegionID_RegionID", "Territories")]
         2996  +        public EntityCollection<Territories> Territories
         2997  +        {
         2998  +            get
         2999  +            {
         3000  +                return ((IEntityWithRelationships)this).RelationshipManager.GetRelatedCollection<Territories>("northwindEFModel.FK_Territories_RegionID_RegionID", "Territories");
         3001  +            }
         3002  +            set
         3003  +            {
         3004  +                if ((value != null))
         3005  +                {
         3006  +                    ((IEntityWithRelationships)this).RelationshipManager.InitializeRelatedCollection<Territories>("northwindEFModel.FK_Territories_RegionID_RegionID", "Territories", value);
         3007  +                }
         3008  +            }
         3009  +        }
         3010  +
         3011  +        #endregion
         3012  +    }
         3013  +
         3014  +    /// <summary>
         3015  +    /// No Metadata Documentation available.
         3016  +    /// </summary>
         3017  +    [EdmEntityTypeAttribute(NamespaceName="northwindEFModel", Name="Suppliers")]
         3018  +    [Serializable()]
         3019  +    [DataContractAttribute(IsReference=true)]
         3020  +    public partial class Suppliers : EntityObject
         3021  +    {
         3022  +        #region Factory Method
         3023  +
         3024  +        /// <summary>
         3025  +        /// Create a new Suppliers object.
         3026  +        /// </summary>
         3027  +        /// <param name="supplierID">Initial value of the SupplierID property.</param>
         3028  +        /// <param name="companyName">Initial value of the CompanyName property.</param>
         3029  +        public static Suppliers CreateSuppliers(global::System.Int64 supplierID, global::System.String companyName)
         3030  +        {
         3031  +            Suppliers suppliers = new Suppliers();
         3032  +            suppliers.SupplierID = supplierID;
         3033  +            suppliers.CompanyName = companyName;
         3034  +            return suppliers;
         3035  +        }
         3036  +
         3037  +        #endregion
         3038  +        #region Primitive Properties
         3039  +
         3040  +        /// <summary>
         3041  +        /// No Metadata Documentation available.
         3042  +        /// </summary>
         3043  +        [EdmScalarPropertyAttribute(EntityKeyProperty=true, IsNullable=false)]
         3044  +        [DataMemberAttribute()]
         3045  +        public global::System.Int64 SupplierID
         3046  +        {
         3047  +            get
         3048  +            {
         3049  +                return _SupplierID;
         3050  +            }
         3051  +            set
         3052  +            {
         3053  +                if (_SupplierID != value)
         3054  +                {
         3055  +                    OnSupplierIDChanging(value);
         3056  +                    ReportPropertyChanging("SupplierID");
         3057  +                    _SupplierID = StructuralObject.SetValidValue(value);
         3058  +                    ReportPropertyChanged("SupplierID");
         3059  +                    OnSupplierIDChanged();
         3060  +                }
         3061  +            }
         3062  +        }
         3063  +        private global::System.Int64 _SupplierID;
         3064  +        partial void OnSupplierIDChanging(global::System.Int64 value);
         3065  +        partial void OnSupplierIDChanged();
         3066  +
         3067  +        /// <summary>
         3068  +        /// No Metadata Documentation available.
         3069  +        /// </summary>
         3070  +        [EdmScalarPropertyAttribute(EntityKeyProperty=false, IsNullable=false)]
         3071  +        [DataMemberAttribute()]
         3072  +        public global::System.String CompanyName
         3073  +        {
         3074  +            get
         3075  +            {
         3076  +                return _CompanyName;
         3077  +            }
         3078  +            set
         3079  +            {
         3080  +                OnCompanyNameChanging(value);
         3081  +                ReportPropertyChanging("CompanyName");
         3082  +                _CompanyName = StructuralObject.SetValidValue(value, false);
         3083  +                ReportPropertyChanged("CompanyName");
         3084  +                OnCompanyNameChanged();
         3085  +            }
         3086  +        }
         3087  +        private global::System.String _CompanyName;
         3088  +        partial void OnCompanyNameChanging(global::System.String value);
         3089  +        partial void OnCompanyNameChanged();
         3090  +
         3091  +        /// <summary>
         3092  +        /// No Metadata Documentation available.
         3093  +        /// </summary>
         3094  +        [EdmScalarPropertyAttribute(EntityKeyProperty=false, IsNullable=true)]
         3095  +        [DataMemberAttribute()]
         3096  +        public global::System.String ContactName
         3097  +        {
         3098  +            get
         3099  +            {
         3100  +                return _ContactName;
         3101  +            }
         3102  +            set
         3103  +            {
         3104  +                OnContactNameChanging(value);
         3105  +                ReportPropertyChanging("ContactName");
         3106  +                _ContactName = StructuralObject.SetValidValue(value, true);
         3107  +                ReportPropertyChanged("ContactName");
         3108  +                OnContactNameChanged();
         3109  +            }
         3110  +        }
         3111  +        private global::System.String _ContactName;
         3112  +        partial void OnContactNameChanging(global::System.String value);
         3113  +        partial void OnContactNameChanged();
         3114  +
         3115  +        /// <summary>
         3116  +        /// No Metadata Documentation available.
         3117  +        /// </summary>
         3118  +        [EdmScalarPropertyAttribute(EntityKeyProperty=false, IsNullable=true)]
         3119  +        [DataMemberAttribute()]
         3120  +        public global::System.String ContactTitle
         3121  +        {
         3122  +            get
         3123  +            {
         3124  +                return _ContactTitle;
         3125  +            }
         3126  +            set
         3127  +            {
         3128  +                OnContactTitleChanging(value);
         3129  +                ReportPropertyChanging("ContactTitle");
         3130  +                _ContactTitle = StructuralObject.SetValidValue(value, true);
         3131  +                ReportPropertyChanged("ContactTitle");
         3132  +                OnContactTitleChanged();
         3133  +            }
         3134  +        }
         3135  +        private global::System.String _ContactTitle;
         3136  +        partial void OnContactTitleChanging(global::System.String value);
         3137  +        partial void OnContactTitleChanged();
         3138  +
         3139  +        /// <summary>
         3140  +        /// No Metadata Documentation available.
         3141  +        /// </summary>
         3142  +        [EdmScalarPropertyAttribute(EntityKeyProperty=false, IsNullable=true)]
         3143  +        [DataMemberAttribute()]
         3144  +        public global::System.String Address
         3145  +        {
         3146  +            get
         3147  +            {
         3148  +                return _Address;
         3149  +            }
         3150  +            set
         3151  +            {
         3152  +                OnAddressChanging(value);
         3153  +                ReportPropertyChanging("Address");
         3154  +                _Address = StructuralObject.SetValidValue(value, true);
         3155  +                ReportPropertyChanged("Address");
         3156  +                OnAddressChanged();
         3157  +            }
         3158  +        }
         3159  +        private global::System.String _Address;
         3160  +        partial void OnAddressChanging(global::System.String value);
         3161  +        partial void OnAddressChanged();
         3162  +
         3163  +        /// <summary>
         3164  +        /// No Metadata Documentation available.
         3165  +        /// </summary>
         3166  +        [EdmScalarPropertyAttribute(EntityKeyProperty=false, IsNullable=true)]
         3167  +        [DataMemberAttribute()]
         3168  +        public global::System.String City
         3169  +        {
         3170  +            get
         3171  +            {
         3172  +                return _City;
         3173  +            }
         3174  +            set
         3175  +            {
         3176  +                OnCityChanging(value);
         3177  +                ReportPropertyChanging("City");
         3178  +                _City = StructuralObject.SetValidValue(value, true);
         3179  +                ReportPropertyChanged("City");
         3180  +                OnCityChanged();
         3181  +            }
         3182  +        }
         3183  +        private global::System.String _City;
         3184  +        partial void OnCityChanging(global::System.String value);
         3185  +        partial void OnCityChanged();
         3186  +
         3187  +        /// <summary>
         3188  +        /// No Metadata Documentation available.
         3189  +        /// </summary>
         3190  +        [EdmScalarPropertyAttribute(EntityKeyProperty=false, IsNullable=true)]
         3191  +        [DataMemberAttribute()]
         3192  +        public global::System.String Region
         3193  +        {
         3194  +            get
         3195  +            {
         3196  +                return _Region;
         3197  +            }
         3198  +            set
         3199  +            {
         3200  +                OnRegionChanging(value);
         3201  +                ReportPropertyChanging("Region");
         3202  +                _Region = StructuralObject.SetValidValue(value, true);
         3203  +                ReportPropertyChanged("Region");
         3204  +                OnRegionChanged();
         3205  +            }
         3206  +        }
         3207  +        private global::System.String _Region;
         3208  +        partial void OnRegionChanging(global::System.String value);
         3209  +        partial void OnRegionChanged();
         3210  +
         3211  +        /// <summary>
         3212  +        /// No Metadata Documentation available.
         3213  +        /// </summary>
         3214  +        [EdmScalarPropertyAttribute(EntityKeyProperty=false, IsNullable=true)]
         3215  +        [DataMemberAttribute()]
         3216  +        public global::System.String PostalCode
         3217  +        {
         3218  +            get
         3219  +            {
         3220  +                return _PostalCode;
         3221  +            }
         3222  +            set
         3223  +            {
         3224  +                OnPostalCodeChanging(value);
         3225  +                ReportPropertyChanging("PostalCode");
         3226  +                _PostalCode = StructuralObject.SetValidValue(value, true);
         3227  +                ReportPropertyChanged("PostalCode");
         3228  +                OnPostalCodeChanged();
         3229  +            }
         3230  +        }
         3231  +        private global::System.String _PostalCode;
         3232  +        partial void OnPostalCodeChanging(global::System.String value);
         3233  +        partial void OnPostalCodeChanged();
         3234  +
         3235  +        /// <summary>
         3236  +        /// No Metadata Documentation available.
         3237  +        /// </summary>
         3238  +        [EdmScalarPropertyAttribute(EntityKeyProperty=false, IsNullable=true)]
         3239  +        [DataMemberAttribute()]
         3240  +        public global::System.String Country
         3241  +        {
         3242  +            get
         3243  +            {
         3244  +                return _Country;
         3245  +            }
         3246  +            set
         3247  +            {
         3248  +                OnCountryChanging(value);
         3249  +                ReportPropertyChanging("Country");
         3250  +                _Country = StructuralObject.SetValidValue(value, true);
         3251  +                ReportPropertyChanged("Country");
         3252  +                OnCountryChanged();
         3253  +            }
         3254  +        }
         3255  +        private global::System.String _Country;
         3256  +        partial void OnCountryChanging(global::System.String value);
         3257  +        partial void OnCountryChanged();
         3258  +
         3259  +        /// <summary>
         3260  +        /// No Metadata Documentation available.
         3261  +        /// </summary>
         3262  +        [EdmScalarPropertyAttribute(EntityKeyProperty=false, IsNullable=true)]
         3263  +        [DataMemberAttribute()]
         3264  +        public global::System.String Phone
         3265  +        {
         3266  +            get
         3267  +            {
         3268  +                return _Phone;
         3269  +            }
         3270  +            set
         3271  +            {
         3272  +                OnPhoneChanging(value);
         3273  +                ReportPropertyChanging("Phone");
         3274  +                _Phone = StructuralObject.SetValidValue(value, true);
         3275  +                ReportPropertyChanged("Phone");
         3276  +                OnPhoneChanged();
         3277  +            }
         3278  +        }
         3279  +        private global::System.String _Phone;
         3280  +        partial void OnPhoneChanging(global::System.String value);
         3281  +        partial void OnPhoneChanged();
         3282  +
         3283  +        /// <summary>
         3284  +        /// No Metadata Documentation available.
         3285  +        /// </summary>
         3286  +        [EdmScalarPropertyAttribute(EntityKeyProperty=false, IsNullable=true)]
         3287  +        [DataMemberAttribute()]
         3288  +        public global::System.String Fax
         3289  +        {
         3290  +            get
         3291  +            {
         3292  +                return _Fax;
         3293  +            }
         3294  +            set
         3295  +            {
         3296  +                OnFaxChanging(value);
         3297  +                ReportPropertyChanging("Fax");
         3298  +                _Fax = StructuralObject.SetValidValue(value, true);
         3299  +                ReportPropertyChanged("Fax");
         3300  +                OnFaxChanged();
         3301  +            }
         3302  +        }
         3303  +        private global::System.String _Fax;
         3304  +        partial void OnFaxChanging(global::System.String value);
         3305  +        partial void OnFaxChanged();
         3306  +
         3307  +        /// <summary>
         3308  +        /// No Metadata Documentation available.
         3309  +        /// </summary>
         3310  +        [EdmScalarPropertyAttribute(EntityKeyProperty=false, IsNullable=true)]
         3311  +        [DataMemberAttribute()]
         3312  +        public global::System.String HomePage
         3313  +        {
         3314  +            get
         3315  +            {
         3316  +                return _HomePage;
         3317  +            }
         3318  +            set
         3319  +            {
         3320  +                OnHomePageChanging(value);
         3321  +                ReportPropertyChanging("HomePage");
         3322  +                _HomePage = StructuralObject.SetValidValue(value, true);
         3323  +                ReportPropertyChanged("HomePage");
         3324  +                OnHomePageChanged();
         3325  +            }
         3326  +        }
         3327  +        private global::System.String _HomePage;
         3328  +        partial void OnHomePageChanging(global::System.String value);
         3329  +        partial void OnHomePageChanged();
         3330  +
         3331  +        #endregion
         3332  +
         3333  +        #region Navigation Properties
         3334  +
         3335  +        /// <summary>
         3336  +        /// No Metadata Documentation available.
         3337  +        /// </summary>
         3338  +        [XmlIgnoreAttribute()]
         3339  +        [SoapIgnoreAttribute()]
         3340  +        [DataMemberAttribute()]
         3341  +        [EdmRelationshipNavigationPropertyAttribute("northwindEFModel", "FK_Products_SupplierID_SupplierID", "Products")]
         3342  +        public EntityCollection<Products> Products
         3343  +        {
         3344  +            get
         3345  +            {
         3346  +                return ((IEntityWithRelationships)this).RelationshipManager.GetRelatedCollection<Products>("northwindEFModel.FK_Products_SupplierID_SupplierID", "Products");
         3347  +            }
         3348  +            set
         3349  +            {
         3350  +                if ((value != null))
         3351  +                {
         3352  +                    ((IEntityWithRelationships)this).RelationshipManager.InitializeRelatedCollection<Products>("northwindEFModel.FK_Products_SupplierID_SupplierID", "Products", value);
         3353  +                }
         3354  +            }
         3355  +        }
         3356  +
         3357  +        #endregion
         3358  +    }
         3359  +
         3360  +    /// <summary>
         3361  +    /// No Metadata Documentation available.
         3362  +    /// </summary>
         3363  +    [EdmEntityTypeAttribute(NamespaceName="northwindEFModel", Name="Territories")]
         3364  +    [Serializable()]
         3365  +    [DataContractAttribute(IsReference=true)]
         3366  +    public partial class Territories : EntityObject
         3367  +    {
         3368  +        #region Factory Method
         3369  +
         3370  +        /// <summary>
         3371  +        /// Create a new Territories object.
         3372  +        /// </summary>
         3373  +        /// <param name="territoryID">Initial value of the TerritoryID property.</param>
         3374  +        /// <param name="territoryDescription">Initial value of the TerritoryDescription property.</param>
         3375  +        public static Territories CreateTerritories(global::System.Int64 territoryID, global::System.String territoryDescription)
         3376  +        {
         3377  +            Territories territories = new Territories();
         3378  +            territories.TerritoryID = territoryID;
         3379  +            territories.TerritoryDescription = territoryDescription;
         3380  +            return territories;
         3381  +        }
         3382  +
         3383  +        #endregion
         3384  +        #region Primitive Properties
         3385  +
         3386  +        /// <summary>
         3387  +        /// No Metadata Documentation available.
         3388  +        /// </summary>
         3389  +        [EdmScalarPropertyAttribute(EntityKeyProperty=true, IsNullable=false)]
         3390  +        [DataMemberAttribute()]
         3391  +        public global::System.Int64 TerritoryID
         3392  +        {
         3393  +            get
         3394  +            {
         3395  +                return _TerritoryID;
         3396  +            }
         3397  +            set
         3398  +            {
         3399  +                if (_TerritoryID != value)
         3400  +                {
         3401  +                    OnTerritoryIDChanging(value);
         3402  +                    ReportPropertyChanging("TerritoryID");
         3403  +                    _TerritoryID = StructuralObject.SetValidValue(value);
         3404  +                    ReportPropertyChanged("TerritoryID");
         3405  +                    OnTerritoryIDChanged();
         3406  +                }
         3407  +            }
         3408  +        }
         3409  +        private global::System.Int64 _TerritoryID;
         3410  +        partial void OnTerritoryIDChanging(global::System.Int64 value);
         3411  +        partial void OnTerritoryIDChanged();
         3412  +
         3413  +        /// <summary>
         3414  +        /// No Metadata Documentation available.
         3415  +        /// </summary>
         3416  +        [EdmScalarPropertyAttribute(EntityKeyProperty=false, IsNullable=false)]
         3417  +        [DataMemberAttribute()]
         3418  +        public global::System.String TerritoryDescription
         3419  +        {
         3420  +            get
         3421  +            {
         3422  +                return _TerritoryDescription;
         3423  +            }
         3424  +            set
         3425  +            {
         3426  +                OnTerritoryDescriptionChanging(value);
         3427  +                ReportPropertyChanging("TerritoryDescription");
         3428  +                _TerritoryDescription = StructuralObject.SetValidValue(value, false);
         3429  +                ReportPropertyChanged("TerritoryDescription");
         3430  +                OnTerritoryDescriptionChanged();
         3431  +            }
         3432  +        }
         3433  +        private global::System.String _TerritoryDescription;
         3434  +        partial void OnTerritoryDescriptionChanging(global::System.String value);
         3435  +        partial void OnTerritoryDescriptionChanged();
         3436  +
         3437  +        #endregion
         3438  +
         3439  +        #region Navigation Properties
         3440  +
         3441  +        /// <summary>
         3442  +        /// No Metadata Documentation available.
         3443  +        /// </summary>
         3444  +        [XmlIgnoreAttribute()]
         3445  +        [SoapIgnoreAttribute()]
         3446  +        [DataMemberAttribute()]
         3447  +        [EdmRelationshipNavigationPropertyAttribute("northwindEFModel", "FK_Territories_RegionID_RegionID", "Regions")]
         3448  +        public Regions Regions
         3449  +        {
         3450  +            get
         3451  +            {
         3452  +                return ((IEntityWithRelationships)this).RelationshipManager.GetRelatedReference<Regions>("northwindEFModel.FK_Territories_RegionID_RegionID", "Regions").Value;
         3453  +            }
         3454  +            set
         3455  +            {
         3456  +                ((IEntityWithRelationships)this).RelationshipManager.GetRelatedReference<Regions>("northwindEFModel.FK_Territories_RegionID_RegionID", "Regions").Value = value;
         3457  +            }
         3458  +        }
         3459  +        /// <summary>
         3460  +        /// No Metadata Documentation available.
         3461  +        /// </summary>
         3462  +        [BrowsableAttribute(false)]
         3463  +        [DataMemberAttribute()]
         3464  +        public EntityReference<Regions> RegionsReference
         3465  +        {
         3466  +            get
         3467  +            {
         3468  +                return ((IEntityWithRelationships)this).RelationshipManager.GetRelatedReference<Regions>("northwindEFModel.FK_Territories_RegionID_RegionID", "Regions");
         3469  +            }
         3470  +            set
         3471  +            {
         3472  +                if ((value != null))
         3473  +                {
         3474  +                    ((IEntityWithRelationships)this).RelationshipManager.InitializeRelatedReference<Regions>("northwindEFModel.FK_Territories_RegionID_RegionID", "Regions", value);
         3475  +                }
         3476  +            }
         3477  +        }
         3478  +
         3479  +        /// <summary>
         3480  +        /// No Metadata Documentation available.
         3481  +        /// </summary>
         3482  +        [XmlIgnoreAttribute()]
         3483  +        [SoapIgnoreAttribute()]
         3484  +        [DataMemberAttribute()]
         3485  +        [EdmRelationshipNavigationPropertyAttribute("northwindEFModel", "EmployeesTerritories", "Employees")]
         3486  +        public EntityCollection<Employees> Employees
         3487  +        {
         3488  +            get
         3489  +            {
         3490  +                return ((IEntityWithRelationships)this).RelationshipManager.GetRelatedCollection<Employees>("northwindEFModel.EmployeesTerritories", "Employees");
         3491  +            }
         3492  +            set
         3493  +            {
         3494  +                if ((value != null))
         3495  +                {
         3496  +                    ((IEntityWithRelationships)this).RelationshipManager.InitializeRelatedCollection<Employees>("northwindEFModel.EmployeesTerritories", "Employees", value);
         3497  +                }
         3498  +            }
         3499  +        }
         3500  +
         3501  +        #endregion
         3502  +    }
         3503  +
         3504  +    #endregion
         3505  +
         3506  +}

Added testlinq/NorthwindModel.EF6.2015.edmx.

            1  +<?xml version="1.0" encoding="utf-8"?>
            2  +
            3  +<!--
            4  +/********************************************************
            5  + * ADO.NET 2.0 Data Provider for SQLite Version 3.X
            6  + * Written by Robert Simpson (robert@blackcastlesoft.com)
            7  + *
            8  + * Released to the public domain, use at your own risk!
            9  + ********************************************************/
           10  +-->
           11  +
           12  +<edmx:Edmx Version="2.0" xmlns:edmx="http://schemas.microsoft.com/ado/2008/10/edmx">
           13  +  <!-- EF Runtime content -->
           14  +  <edmx:Runtime>
           15  +    <!-- SSDL content -->
           16  +    <edmx:StorageModels>
           17  +    <Schema Namespace="northwindEFModel.Store" Alias="Self" Provider="System.Data.SQLite.EF6" ProviderManifestToken="ISO8601" xmlns="http://schemas.microsoft.com/ado/2009/02/edm/ssdl">
           18  +        <EntityContainer Name="northwindEFModelStoreContainer">
           19  +          <EntitySet Name="Categories" EntityType="northwindEFModel.Store.Categories" store:Type="Tables" xmlns:store="http://schemas.microsoft.com/ado/2007/12/edm/EntityStoreSchemaGenerator" />
           20  +          <EntitySet Name="Customers" EntityType="northwindEFModel.Store.Customers" store:Type="Tables" xmlns:store="http://schemas.microsoft.com/ado/2007/12/edm/EntityStoreSchemaGenerator" />
           21  +          <EntitySet Name="Employees" EntityType="northwindEFModel.Store.Employees" store:Type="Tables" xmlns:store="http://schemas.microsoft.com/ado/2007/12/edm/EntityStoreSchemaGenerator" />
           22  +          <EntitySet Name="EmployeesTerritories" EntityType="northwindEFModel.Store.EmployeesTerritories" store:Type="Tables" xmlns:store="http://schemas.microsoft.com/ado/2007/12/edm/EntityStoreSchemaGenerator" />
           23  +          <EntitySet Name="InternationalOrders" EntityType="northwindEFModel.Store.InternationalOrders" store:Type="Tables" xmlns:store="http://schemas.microsoft.com/ado/2007/12/edm/EntityStoreSchemaGenerator" />
           24  +          <EntitySet Name="OrderDetails" EntityType="northwindEFModel.Store.OrderDetails" store:Type="Tables" xmlns:store="http://schemas.microsoft.com/ado/2007/12/edm/EntityStoreSchemaGenerator" />
           25  +          <EntitySet Name="Orders" EntityType="northwindEFModel.Store.Orders" store:Type="Tables" xmlns:store="http://schemas.microsoft.com/ado/2007/12/edm/EntityStoreSchemaGenerator" />
           26  +          <EntitySet Name="PreviousEmployees" EntityType="northwindEFModel.Store.PreviousEmployees" store:Type="Tables" xmlns:store="http://schemas.microsoft.com/ado/2007/12/edm/EntityStoreSchemaGenerator" />
           27  +          <EntitySet Name="Products" EntityType="northwindEFModel.Store.Products" store:Type="Tables" xmlns:store="http://schemas.microsoft.com/ado/2007/12/edm/EntityStoreSchemaGenerator" />
           28  +          <EntitySet Name="Regions" EntityType="northwindEFModel.Store.Regions" store:Type="Tables" xmlns:store="http://schemas.microsoft.com/ado/2007/12/edm/EntityStoreSchemaGenerator" />
           29  +          <EntitySet Name="Suppliers" EntityType="northwindEFModel.Store.Suppliers" store:Type="Tables" xmlns:store="http://schemas.microsoft.com/ado/2007/12/edm/EntityStoreSchemaGenerator" />
           30  +          <EntitySet Name="Territories" EntityType="northwindEFModel.Store.Territories" store:Type="Tables" xmlns:store="http://schemas.microsoft.com/ado/2007/12/edm/EntityStoreSchemaGenerator" />
           31  +          <AssociationSet Name="FK_EmployeesTerritories_EmployeeID_EmployeeID" Association="northwindEFModel.Store.FK_EmployeesTerritories_EmployeeID_EmployeeID">
           32  +            <End Role="Employees" EntitySet="Employees" />
           33  +            <End Role="EmployeesTerritories" EntitySet="EmployeesTerritories" />
           34  +          </AssociationSet>
           35  +          <AssociationSet Name="FK_EmployeesTerritories_TerritoryID_TerritoryID" Association="northwindEFModel.Store.FK_EmployeesTerritories_TerritoryID_TerritoryID">
           36  +            <End Role="Territories" EntitySet="Territories" />
           37  +            <End Role="EmployeesTerritories" EntitySet="EmployeesTerritories" />
           38  +          </AssociationSet>
           39  +          <AssociationSet Name="FK_InternationalOrders_OrderID_OrderID" Association="northwindEFModel.Store.FK_InternationalOrders_OrderID_OrderID">
           40  +            <End Role="Orders" EntitySet="Orders" />
           41  +            <End Role="InternationalOrders" EntitySet="InternationalOrders" />
           42  +          </AssociationSet>
           43  +          <AssociationSet Name="FK_OrderDetails_OrderID_OrderID" Association="northwindEFModel.Store.FK_OrderDetails_OrderID_OrderID">
           44  +            <End Role="Orders" EntitySet="Orders" />
           45  +            <End Role="OrderDetails" EntitySet="OrderDetails" />
           46  +          </AssociationSet>
           47  +          <AssociationSet Name="FK_OrderDetails_ProductID_ProductID" Association="northwindEFModel.Store.FK_OrderDetails_ProductID_ProductID">
           48  +            <End Role="Products" EntitySet="Products" />
           49  +            <End Role="OrderDetails" EntitySet="OrderDetails" />
           50  +          </AssociationSet>
           51  +          <AssociationSet Name="FK_Orders_CustomerID_CustomerID" Association="northwindEFModel.Store.FK_Orders_CustomerID_CustomerID">
           52  +            <End Role="Customers" EntitySet="Customers" />
           53  +            <End Role="Orders" EntitySet="Orders" />
           54  +          </AssociationSet>
           55  +          <AssociationSet Name="FK_Products_CategoryID_CategoryID" Association="northwindEFModel.Store.FK_Products_CategoryID_CategoryID">
           56  +            <End Role="Categories" EntitySet="Categories" />
           57  +            <End Role="Products" EntitySet="Products" />
           58  +          </AssociationSet>
           59  +          <AssociationSet Name="FK_Products_SupplierID_SupplierID" Association="northwindEFModel.Store.FK_Products_SupplierID_SupplierID">
           60  +            <End Role="Suppliers" EntitySet="Suppliers" />
           61  +            <End Role="Products" EntitySet="Products" />
           62  +          </AssociationSet>
           63  +          <AssociationSet Name="FK_Territories_RegionID_RegionID" Association="northwindEFModel.Store.FK_Territories_RegionID_RegionID">
           64  +            <End Role="Regions" EntitySet="Regions" />
           65  +            <End Role="Territories" EntitySet="Territories" />
           66  +          </AssociationSet>
           67  +        </EntityContainer>
           68  +        <EntityType Name="Categories">
           69  +          <Key>
           70  +            <PropertyRef Name="CategoryID" />
           71  +          </Key>
           72  +          <Property Name="CategoryID" Type="integer" Nullable="false" StoreGeneratedPattern="Identity" />
           73  +          <Property Name="CategoryName" Type="nvarchar" Nullable="false" MaxLength="15" />
           74  +          <Property Name="Description" Type="nvarchar" />
           75  +          <Property Name="Picture" Type="blob" />
           76  +        </EntityType>
           77  +        <EntityType Name="Customers">
           78  +          <Key>
           79  +            <PropertyRef Name="CustomerID" />
           80  +          </Key>
           81  +          <Property Name="CustomerID" Type="nvarchar" Nullable="false" MaxLength="5" />
           82  +          <Property Name="CompanyName" Type="nvarchar" Nullable="false" MaxLength="40" />
           83  +          <Property Name="ContactName" Type="nvarchar" MaxLength="30" />
           84  +          <Property Name="ContactTitle" Type="nvarchar" MaxLength="30" />
           85  +          <Property Name="Address" Type="nvarchar" MaxLength="60" />
           86  +          <Property Name="City" Type="nvarchar" MaxLength="15" />
           87  +          <Property Name="Region" Type="nvarchar" MaxLength="15" />
           88  +          <Property Name="PostalCode" Type="nvarchar" MaxLength="10" />
           89  +          <Property Name="Country" Type="nvarchar" MaxLength="15" />
           90  +          <Property Name="Phone" Type="nvarchar" MaxLength="24" />
           91  +          <Property Name="Fax" Type="nvarchar" MaxLength="24" />
           92  +        </EntityType>
           93  +        <EntityType Name="Employees">
           94  +          <Key>
           95  +            <PropertyRef Name="EmployeeID" />
           96  +          </Key>
           97  +          <Property Name="EmployeeID" Type="integer" Nullable="false" StoreGeneratedPattern="Identity" />
           98  +          <Property Name="LastName" Type="nvarchar" Nullable="false" MaxLength="20" />
           99  +          <Property Name="FirstName" Type="nvarchar" Nullable="false" MaxLength="10" />
          100  +          <Property Name="Title" Type="nvarchar" MaxLength="30" />
          101  +          <Property Name="TitleOfCourtesy" Type="nvarchar" MaxLength="25" />
          102  +          <Property Name="BirthDate" Type="datetime" />
          103  +          <Property Name="HireDate" Type="datetime" />
          104  +          <Property Name="Address" Type="nvarchar" MaxLength="60" />
          105  +          <Property Name="City" Type="nvarchar" MaxLength="15" />
          106  +          <Property Name="Region" Type="nvarchar" MaxLength="15" />
          107  +          <Property Name="PostalCode" Type="nvarchar" MaxLength="10" />
          108  +          <Property Name="Country" Type="nvarchar" MaxLength="15" />
          109  +          <Property Name="HomePhone" Type="nvarchar" MaxLength="24" />
          110  +          <Property Name="Extension" Type="nvarchar" MaxLength="4" />
          111  +          <Property Name="Photo" Type="blob" />
          112  +          <Property Name="Notes" Type="nvarchar" />
          113  +          <Property Name="PhotoPath" Type="nvarchar" MaxLength="255" />
          114  +        </EntityType>
          115  +        <EntityType Name="EmployeesTerritories">
          116  +          <Key>
          117  +            <PropertyRef Name="EmployeeID" />
          118  +            <PropertyRef Name="TerritoryID" />
          119  +          </Key>
          120  +          <Property Name="EmployeeID" Type="integer" Nullable="false" />
          121  +          <Property Name="TerritoryID" Type="integer" Nullable="false" />
          122  +        </EntityType>
          123  +        <EntityType Name="InternationalOrders">
          124  +          <Key>
          125  +            <PropertyRef Name="OrderID" />
          126  +          </Key>
          127  +          <Property Name="OrderID" Type="integer" Nullable="false" />
          128  +          <Property Name="CustomsDescription" Type="nvarchar" Nullable="false" MaxLength="100" />
          129  +          <Property Name="ExciseTax" Type="decimal" Nullable="false" Precision="53" />
          130  +        </EntityType>
          131  +        <EntityType Name="OrderDetails">
          132  +          <Key>
          133  +            <PropertyRef Name="OrderID" />
          134  +            <PropertyRef Name="ProductID" />
          135  +          </Key>
          136  +          <Property Name="OrderID" Type="integer" Nullable="false" />
          137  +          <Property Name="ProductID" Type="integer" Nullable="false" />
          138  +          <Property Name="UnitPrice" Type="decimal" Nullable="false" Precision="53" />
          139  +          <Property Name="Quantity" Type="smallint" Nullable="false" />
          140  +          <!--
          141  +              NOTE: The "Discount" column is not actually generated by the store;
          142  +                    however, it has a default value and can be utilized to test
          143  +                    generating an DbInsertCommandTree with a Returning property
          144  +                    value that is not null.
          145  +          -->
          146  +          <Property Name="Discount" Type="real" Nullable="false" StoreGeneratedPattern="Computed" />
          147  +        </EntityType>
          148  +        <EntityType Name="Orders">
          149  +          <Key>
          150  +            <PropertyRef Name="OrderID" />
          151  +          </Key>
          152  +          <Property Name="OrderID" Type="integer" Nullable="false" StoreGeneratedPattern="Identity" />
          153  +          <Property Name="CustomerID" Type="nvarchar" MaxLength="5" />
          154  +          <Property Name="EmployeeID" Type="integer" />
          155  +          <Property Name="OrderDate" Type="datetime" />
          156  +          <Property Name="RequiredDate" Type="datetime" />
          157  +          <Property Name="ShippedDate" Type="datetime" />
          158  +          <!--
          159  +              NOTE: The "Freight" column is not actually generated by the store;
          160  +                    however, it has a default value and can be utilized to test
          161  +                    generating an DbUpdateCommandTree with a Returning property
          162  +                    value that is not null.
          163  +          -->
          164  +          <Property Name="Freight" Type="decimal" Precision="53" StoreGeneratedPattern="Computed" />
          165  +          <Property Name="ShipName" Type="nvarchar" MaxLength="40" />
          166  +          <Property Name="ShipAddress" Type="nvarchar" MaxLength="60" />
          167  +          <Property Name="ShipCity" Type="nvarchar" MaxLength="15" />
          168  +          <Property Name="ShipRegion" Type="nvarchar" MaxLength="15" />
          169  +          <Property Name="ShipPostalCode" Type="nvarchar" MaxLength="10" />
          170  +          <Property Name="ShipCountry" Type="nvarchar" MaxLength="15" />
          171  +        </EntityType>
          172  +        <EntityType Name="PreviousEmployees">
          173  +          <Key>
          174  +            <PropertyRef Name="EmployeeID" />
          175  +          </Key>
          176  +          <Property Name="EmployeeID" Type="integer" Nullable="false" />
          177  +          <Property Name="LastName" Type="nvarchar" Nullable="false" MaxLength="20" />
          178  +          <Property Name="FirstName" Type="nvarchar" Nullable="false" MaxLength="10" />
          179  +          <Property Name="Title" Type="nvarchar" MaxLength="30" />
          180  +          <Property Name="TitleOfCourtesy" Type="nvarchar" MaxLength="25" />
          181  +          <Property Name="BirthDate" Type="datetime" />
          182  +          <Property Name="HireDate" Type="datetime" />
          183  +          <Property Name="Address" Type="nvarchar" MaxLength="60" />
          184  +          <Property Name="City" Type="nvarchar" MaxLength="15" />
          185  +          <Property Name="Region" Type="nvarchar" MaxLength="15" />
          186  +          <Property Name="PostalCode" Type="nvarchar" MaxLength="10" />
          187  +          <Property Name="Country" Type="nvarchar" MaxLength="15" />
          188  +          <Property Name="HomePhone" Type="nvarchar" MaxLength="24" />
          189  +          <Property Name="Extension" Type="nvarchar" MaxLength="4" />
          190  +          <Property Name="Photo" Type="blob" />
          191  +          <Property Name="Notes" Type="nvarchar" />
          192  +          <Property Name="PhotoPath" Type="nvarchar" MaxLength="255" />
          193  +        </EntityType>
          194  +        <EntityType Name="Products">
          195  +          <Key>
          196  +            <PropertyRef Name="ProductID" />
          197  +          </Key>
          198  +          <Property Name="ProductID" Type="integer" Nullable="false" StoreGeneratedPattern="Identity" />
          199  +          <Property Name="ProductName" Type="nvarchar" Nullable="false" MaxLength="40" />
          200  +          <Property Name="SupplierID" Type="integer" />
          201  +          <Property Name="CategoryID" Type="integer" />
          202  +          <Property Name="QuantityPerUnit" Type="nvarchar" MaxLength="20" />
          203  +          <Property Name="UnitPrice" Type="decimal" Precision="53" />
          204  +          <Property Name="UnitsInStock" Type="smallint" />
          205  +          <Property Name="UnitsOnOrder" Type="smallint" />
          206  +          <Property Name="ReorderLevel" Type="smallint" />
          207  +          <Property Name="Discontinued" Type="bit" Nullable="false" />
          208  +          <Property Name="DiscontinuedDate" Type="datetime" />
          209  +        </EntityType>
          210  +        <EntityType Name="Regions">
          211  +          <Key>
          212  +            <PropertyRef Name="RegionID" />
          213  +          </Key>
          214  +          <Property Name="RegionID" Type="integer" Nullable="false" />
          215  +          <Property Name="RegionDescription" Type="nvarchar" Nullable="false" MaxLength="50" />
          216  +        </EntityType>
          217  +        <EntityType Name="Suppliers">
          218  +          <Key>
          219  +            <PropertyRef Name="SupplierID" />
          220  +          </Key>
          221  +          <Property Name="SupplierID" Type="integer" Nullable="false" StoreGeneratedPattern="Identity" />
          222  +          <Property Name="CompanyName" Type="nvarchar" Nullable="false" MaxLength="40" />
          223  +          <Property Name="ContactName" Type="nvarchar" MaxLength="30" />
          224  +          <Property Name="ContactTitle" Type="nvarchar" MaxLength="30" />
          225  +          <Property Name="Address" Type="nvarchar" MaxLength="60" />
          226  +          <Property Name="City" Type="nvarchar" MaxLength="15" />
          227  +          <Property Name="Region" Type="nvarchar" MaxLength="15" />
          228  +          <Property Name="PostalCode" Type="nvarchar" MaxLength="10" />
          229  +          <Property Name="Country" Type="nvarchar" MaxLength="15" />
          230  +          <Property Name="Phone" Type="nvarchar" MaxLength="24" />
          231  +          <Property Name="Fax" Type="nvarchar" MaxLength="24" />
          232  +          <Property Name="HomePage" Type="nvarchar" />
          233  +        </EntityType>
          234  +        <EntityType Name="Territories">
          235  +          <Key>
          236  +            <PropertyRef Name="TerritoryID" />
          237  +          </Key>
          238  +          <Property Name="TerritoryID" Type="integer" Nullable="false" />
          239  +          <Property Name="TerritoryDescription" Type="nvarchar" Nullable="false" MaxLength="50" />
          240  +          <Property Name="RegionID" Type="integer" Nullable="false" />
          241  +        </EntityType>
          242  +        <Association Name="FK_EmployeesTerritories_EmployeeID_EmployeeID">
          243  +          <End Role="Employees" Type="northwindEFModel.Store.Employees" Multiplicity="1" />
          244  +          <End Role="EmployeesTerritories" Type="northwindEFModel.Store.EmployeesTerritories" Multiplicity="*" />
          245  +          <ReferentialConstraint>
          246  +            <Principal Role="Employees">
          247  +              <PropertyRef Name="EmployeeID" />
          248  +            </Principal>
          249  +            <Dependent Role="EmployeesTerritories">
          250  +              <PropertyRef Name="EmployeeID" />
          251  +            </Dependent>
          252  +          </ReferentialConstraint>
          253  +        </Association>
          254  +        <Association Name="FK_EmployeesTerritories_TerritoryID_TerritoryID">
          255  +          <End Role="Territories" Type="northwindEFModel.Store.Territories" Multiplicity="1" />
          256  +          <End Role="EmployeesTerritories" Type="northwindEFModel.Store.EmployeesTerritories" Multiplicity="*" />
          257  +          <ReferentialConstraint>
          258  +            <Principal Role="Territories">
          259  +              <PropertyRef Name="TerritoryID" />
          260  +            </Principal>
          261  +            <Dependent Role="EmployeesTerritories">
          262  +              <PropertyRef Name="TerritoryID" />
          263  +            </Dependent>
          264  +          </ReferentialConstraint>
          265  +        </Association>
          266  +        <Association Name="FK_InternationalOrders_OrderID_OrderID">
          267  +          <End Role="Orders" Type="northwindEFModel.Store.Orders" Multiplicity="1" />
          268  +          <End Role="InternationalOrders" Type="northwindEFModel.Store.InternationalOrders" Multiplicity="0..1" />
          269  +          <ReferentialConstraint>
          270  +            <Principal Role="Orders">
          271  +              <PropertyRef Name="OrderID" />
          272  +            </Principal>
          273  +            <Dependent Role="InternationalOrders">
          274  +              <PropertyRef Name="OrderID" />
          275  +            </Dependent>
          276  +          </ReferentialConstraint>
          277  +        </Association>
          278  +        <Association Name="FK_OrderDetails_OrderID_OrderID">
          279  +          <End Role="Orders" Type="northwindEFModel.Store.Orders" Multiplicity="1" />
          280  +          <End Role="OrderDetails" Type="northwindEFModel.Store.OrderDetails" Multiplicity="*" />
          281  +          <ReferentialConstraint>
          282  +            <Principal Role="Orders">
          283  +              <PropertyRef Name="OrderID" />
          284  +            </Principal>
          285  +            <Dependent Role="OrderDetails">
          286  +              <PropertyRef Name="OrderID" />
          287  +            </Dependent>
          288  +          </ReferentialConstraint>
          289  +        </Association>
          290  +        <Association Name="FK_OrderDetails_ProductID_ProductID">
          291  +          <End Role="Products" Type="northwindEFModel.Store.Products" Multiplicity="1" />
          292  +          <End Role="OrderDetails" Type="northwindEFModel.Store.OrderDetails" Multiplicity="*" />
          293  +          <ReferentialConstraint>
          294  +            <Principal Role="Products">
          295  +              <PropertyRef Name="ProductID" />
          296  +            </Principal>
          297  +            <Dependent Role="OrderDetails">
          298  +              <PropertyRef Name="ProductID" />
          299  +            </Dependent>
          300  +          </ReferentialConstraint>
          301  +        </Association>
          302  +        <Association Name="FK_Orders_CustomerID_CustomerID">
          303  +          <End Role="Customers" Type="northwindEFModel.Store.Customers" Multiplicity="0..1" />
          304  +          <End Role="Orders" Type="northwindEFModel.Store.Orders" Multiplicity="*" />
          305  +          <ReferentialConstraint>
          306  +            <Principal Role="Customers">
          307  +              <PropertyRef Name="CustomerID" />
          308  +            </Principal>
          309  +            <Dependent Role="Orders">
          310  +              <PropertyRef Name="CustomerID" />
          311  +            </Dependent>
          312  +          </ReferentialConstraint>
          313  +        </Association>
          314  +        <Association Name="FK_Products_CategoryID_CategoryID">
          315  +          <End Role="Categories" Type="northwindEFModel.Store.Categories" Multiplicity="0..1" />
          316  +          <End Role="Products" Type="northwindEFModel.Store.Products" Multiplicity="*" />
          317  +          <ReferentialConstraint>
          318  +            <Principal Role="Categories">
          319  +              <PropertyRef Name="CategoryID" />
          320  +            </Principal>
          321  +            <Dependent Role="Products">
          322  +              <PropertyRef Name="CategoryID" />
          323  +            </Dependent>
          324  +          </ReferentialConstraint>
          325  +        </Association>
          326  +        <Association Name="FK_Products_SupplierID_SupplierID">
          327  +          <End Role="Suppliers" Type="northwindEFModel.Store.Suppliers" Multiplicity="0..1" />
          328  +          <End Role="Products" Type="northwindEFModel.Store.Products" Multiplicity="*" />
          329  +          <ReferentialConstraint>
          330  +            <Principal Role="Suppliers">
          331  +              <PropertyRef Name="SupplierID" />
          332  +            </Principal>
          333  +            <Dependent Role="Products">
          334  +              <PropertyRef Name="SupplierID" />
          335  +            </Dependent>
          336  +          </ReferentialConstraint>
          337  +        </Association>
          338  +        <Association Name="FK_Territories_RegionID_RegionID">
          339  +          <End Role="Regions" Type="northwindEFModel.Store.Regions" Multiplicity="1" />
          340  +          <End Role="Territories" Type="northwindEFModel.Store.Territories" Multiplicity="*" />
          341  +          <ReferentialConstraint>
          342  +            <Principal Role="Regions">
          343  +              <PropertyRef Name="RegionID" />
          344  +            </Principal>
          345  +            <Dependent Role="Territories">
          346  +              <PropertyRef Name="RegionID" />
          347  +            </Dependent>
          348  +          </ReferentialConstraint>
          349  +        </Association>
          350  +      </Schema></edmx:StorageModels>
          351  +    <!-- CSDL content -->
          352  +    <edmx:ConceptualModels>
          353  +      <Schema Namespace="northwindEFModel" Alias="Self" xmlns="http://schemas.microsoft.com/ado/2008/09/edm">
          354  +        <EntityContainer Name="northwindEFEntities">
          355  +          <EntitySet Name="Categories" EntityType="northwindEFModel.Categories" />
          356  +          <EntitySet Name="Customers" EntityType="northwindEFModel.Customers" />
          357  +          <EntitySet Name="Employees" EntityType="northwindEFModel.Employees" />
          358  +          <EntitySet Name="InternationalOrders" EntityType="northwindEFModel.InternationalOrders" />
          359  +          <EntitySet Name="OrderDetails" EntityType="northwindEFModel.OrderDetails" />
          360  +          <EntitySet Name="Orders" EntityType="northwindEFModel.Orders" />
          361  +          <EntitySet Name="PreviousEmployees" EntityType="northwindEFModel.PreviousEmployees" />
          362  +          <EntitySet Name="Products" EntityType="northwindEFModel.Products" />
          363  +          <EntitySet Name="Regions" EntityType="northwindEFModel.Regions" />
          364  +          <EntitySet Name="Suppliers" EntityType="northwindEFModel.Suppliers" />
          365  +          <EntitySet Name="Territories" EntityType="northwindEFModel.Territories" />
          366  +          <AssociationSet Name="FK_Products_CategoryID_CategoryID" Association="northwindEFModel.FK_Products_CategoryID_CategoryID">
          367  +            <End Role="Categories" EntitySet="Categories" />
          368  +            <End Role="Products" EntitySet="Products" />
          369  +          </AssociationSet>
          370  +          <AssociationSet Name="FK_Orders_CustomerID_CustomerID" Association="northwindEFModel.FK_Orders_CustomerID_CustomerID">
          371  +            <End Role="Customers" EntitySet="Customers" />
          372  +            <End Role="Orders" EntitySet="Orders" />
          373  +          </AssociationSet>
          374  +          <AssociationSet Name="FK_InternationalOrders_OrderID_OrderID" Association="northwindEFModel.FK_InternationalOrders_OrderID_OrderID">
          375  +            <End Role="Orders" EntitySet="Orders" />
          376  +            <End Role="InternationalOrders" EntitySet="InternationalOrders" />
          377  +          </AssociationSet>
          378  +          <AssociationSet Name="FK_OrderDetails_OrderID_OrderID" Association="northwindEFModel.FK_OrderDetails_OrderID_OrderID">
          379  +            <End Role="Orders" EntitySet="Orders" />
          380  +            <End Role="OrderDetails" EntitySet="OrderDetails" />
          381  +          </AssociationSet>
          382  +          <AssociationSet Name="FK_OrderDetails_ProductID_ProductID" Association="northwindEFModel.FK_OrderDetails_ProductID_ProductID">
          383  +            <End Role="Products" EntitySet="Products" />
          384  +            <End Role="OrderDetails" EntitySet="OrderDetails" />
          385  +          </AssociationSet>
          386  +          <AssociationSet Name="FK_Products_SupplierID_SupplierID" Association="northwindEFModel.FK_Products_SupplierID_SupplierID">
          387  +            <End Role="Suppliers" EntitySet="Suppliers" />
          388  +            <End Role="Products" EntitySet="Products" />
          389  +          </AssociationSet>
          390  +          <AssociationSet Name="FK_Territories_RegionID_RegionID" Association="northwindEFModel.FK_Territories_RegionID_RegionID">
          391  +            <End Role="Regions" EntitySet="Regions" />
          392  +            <End Role="Territories" EntitySet="Territories" />
          393  +          </AssociationSet>
          394  +          <AssociationSet Name="EmployeesTerritories" Association="northwindEFModel.EmployeesTerritories">
          395  +            <End Role="Employees" EntitySet="Employees" />
          396  +            <End Role="Territories" EntitySet="Territories" />
          397  +          </AssociationSet>
          398  +          </EntityContainer>
          399  +        <EntityType Name="Categories">
          400  +          <Key>
          401  +            <PropertyRef Name="CategoryID" />
          402  +          </Key>
          403  +          <Property Name="CategoryID" Type="Int64" Nullable="false" />
          404  +          <Property Name="CategoryName" Type="String" Nullable="false" MaxLength="15" Unicode="true" FixedLength="false" />
          405  +          <Property Name="Description" Type="String" MaxLength="2147483647" Unicode="true" FixedLength="false" />
          406  +          <Property Name="Picture" Type="Binary" MaxLength="2147483647" FixedLength="false" />
          407  +          <NavigationProperty Name="Products" Relationship="northwindEFModel.FK_Products_CategoryID_CategoryID" FromRole="Categories" ToRole="Products" />
          408  +        </EntityType>
          409  +        <EntityType Name="Customers">
          410  +          <Key>
          411  +            <PropertyRef Name="CustomerID" />
          412  +          </Key>
          413  +          <Property Name="CustomerID" Type="String" Nullable="false" MaxLength="5" Unicode="true" FixedLength="false" />
          414  +          <Property Name="CompanyName" Type="String" Nullable="false" MaxLength="40" Unicode="true" FixedLength="false" />
          415  +          <Property Name="ContactName" Type="String" MaxLength="30" Unicode="true" FixedLength="false" />
          416  +          <Property Name="ContactTitle" Type="String" MaxLength="30" Unicode="true" FixedLength="false" />
          417  +          <Property Name="Address" Type="String" MaxLength="60" Unicode="true" FixedLength="false" />
          418  +          <Property Name="City" Type="String" MaxLength="15" Unicode="true" FixedLength="false" />
          419  +          <Property Name="Region" Type="String" MaxLength="15" Unicode="true" FixedLength="false" />
          420  +          <Property Name="PostalCode" Type="String" MaxLength="10" Unicode="true" FixedLength="false" />
          421  +          <Property Name="Country" Type="String" MaxLength="15" Unicode="true" FixedLength="false" />
          422  +          <Property Name="Phone" Type="String" MaxLength="24" Unicode="true" FixedLength="false" />
          423  +          <Property Name="Fax" Type="String" MaxLength="24" Unicode="true" FixedLength="false" />
          424  +          <NavigationProperty Name="Orders" Relationship="northwindEFModel.FK_Orders_CustomerID_CustomerID" FromRole="Customers" ToRole="Orders" />
          425  +        </EntityType>
          426  +        <EntityType Name="Employees">
          427  +          <Key>
          428  +            <PropertyRef Name="EmployeeID" />
          429  +          </Key>
          430  +          <Property Name="EmployeeID" Type="Int64" Nullable="false" />
          431  +          <Property Name="LastName" Type="String" Nullable="false" MaxLength="20" Unicode="true" FixedLength="false" />
          432  +          <Property Name="FirstName" Type="String" Nullable="false" MaxLength="10" Unicode="true" FixedLength="false" />
          433  +          <Property Name="Title" Type="String" MaxLength="30" Unicode="true" FixedLength="false" />
          434  +          <Property Name="TitleOfCourtesy" Type="String" MaxLength="25" Unicode="true" FixedLength="false" />
          435  +          <Property Name="BirthDate" Type="DateTime" />
          436  +          <Property Name="HireDate" Type="DateTime" />
          437  +          <Property Name="Address" Type="String" MaxLength="60" Unicode="true" FixedLength="false" />
          438  +          <Property Name="City" Type="String" MaxLength="15" Unicode="true" FixedLength="false" />
          439  +          <Property Name="Region" Type="String" MaxLength="15" Unicode="true" FixedLength="false" />
          440  +          <Property Name="PostalCode" Type="String" MaxLength="10" Unicode="true" FixedLength="false" />
          441  +          <Property Name="Country" Type="String" MaxLength="15" Unicode="true" FixedLength="false" />
          442  +          <Property Name="HomePhone" Type="String" MaxLength="24" Unicode="true" FixedLength="false" />
          443  +          <Property Name="Extension" Type="String" MaxLength="4" Unicode="true" FixedLength="false" />
          444  +          <Property Name="Photo" Type="Binary" MaxLength="2147483647" FixedLength="false" />
          445  +          <Property Name="Notes" Type="String" MaxLength="2147483647" Unicode="true" FixedLength="false" />
          446  +          <Property Name="PhotoPath" Type="String" MaxLength="255" Unicode="true" FixedLength="false" />
          447  +          <NavigationProperty Name="Territories" Relationship="northwindEFModel.EmployeesTerritories" FromRole="Employees" ToRole="Territories" />
          448  +        </EntityType>
          449  +        <EntityType Name="InternationalOrders">
          450  +          <Key>
          451  +            <PropertyRef Name="OrderID" />
          452  +          </Key>
          453  +          <Property Name="OrderID" Type="Int64" Nullable="false" />
          454  +          <Property Name="CustomsDescription" Type="String" Nullable="false" MaxLength="100" Unicode="true" FixedLength="false" />
          455  +          <Property Name="ExciseTax" Type="Decimal" Nullable="false" Precision="53" Scale="0" />
          456  +          <NavigationProperty Name="Orders" Relationship="northwindEFModel.FK_InternationalOrders_OrderID_OrderID" FromRole="InternationalOrders" ToRole="Orders" />
          457  +        </EntityType>
          458  +        <EntityType Name="OrderDetails">
          459  +          <Key>
          460  +            <PropertyRef Name="OrderID" />
          461  +            <PropertyRef Name="ProductID" />
          462  +          </Key>
          463  +          <Property Name="OrderID" Type="Int64" Nullable="false" />
          464  +          <Property Name="ProductID" Type="Int64" Nullable="false" />
          465  +          <Property Name="UnitPrice" Type="Decimal" Nullable="false" Precision="53" Scale="0" />
          466  +          <Property Name="Quantity" Type="Int16" Nullable="false" />
          467  +          <Property Name="Discount" Type="Single" Nullable="false" />
          468  +          <NavigationProperty Name="Orders" Relationship="northwindEFModel.FK_OrderDetails_OrderID_OrderID" FromRole="OrderDetails" ToRole="Orders" />
          469  +          <NavigationProperty Name="Products" Relationship="northwindEFModel.FK_OrderDetails_ProductID_ProductID" FromRole="OrderDetails" ToRole="Products" />
          470  +        </EntityType>
          471  +        <EntityType Name="Orders">
          472  +          <Key>
          473  +            <PropertyRef Name="OrderID" />
          474  +          </Key>
          475  +          <Property Name="OrderID" Type="Int64" Nullable="false" />
          476  +          <Property Name="EmployeeID" Type="Int64" />
          477  +          <Property Name="OrderDate" Type="DateTime" />
          478  +          <Property Name="RequiredDate" Type="DateTime" />
          479  +          <Property Name="ShippedDate" Type="DateTime" />
          480  +          <Property Name="Freight" Type="Decimal" Precision="53" Scale="0" />
          481  +          <Property Name="ShipName" Type="String" MaxLength="40" Unicode="true" FixedLength="false" />
          482  +          <Property Name="ShipAddress" Type="String" MaxLength="60" Unicode="true" FixedLength="false" />
          483  +          <Property Name="ShipCity" Type="String" MaxLength="15" Unicode="true" FixedLength="false" />
          484  +          <Property Name="ShipRegion" Type="String" MaxLength="15" Unicode="true" FixedLength="false" />
          485  +          <Property Name="ShipPostalCode" Type="String" MaxLength="10" Unicode="true" FixedLength="false" />
          486  +          <Property Name="ShipCountry" Type="String" MaxLength="15" Unicode="true" FixedLength="false" />
          487  +          <NavigationProperty Name="Customers" Relationship="northwindEFModel.FK_Orders_CustomerID_CustomerID" FromRole="Orders" ToRole="Customers" />
          488  +          <NavigationProperty Name="InternationalOrders" Relationship="northwindEFModel.FK_InternationalOrders_OrderID_OrderID" FromRole="Orders" ToRole="InternationalOrders" />
          489  +          <NavigationProperty Name="OrderDetails" Relationship="northwindEFModel.FK_OrderDetails_OrderID_OrderID" FromRole="Orders" ToRole="OrderDetails" />
          490  +        </EntityType>
          491  +        <EntityType Name="PreviousEmployees">
          492  +          <Key>
          493  +            <PropertyRef Name="EmployeeID" />
          494  +          </Key>
          495  +          <Property Name="EmployeeID" Type="Int64" Nullable="false" />
          496  +          <Property Name="LastName" Type="String" Nullable="false" MaxLength="20" Unicode="true" FixedLength="false" />
          497  +          <Property Name="FirstName" Type="String" Nullable="false" MaxLength="10" Unicode="true" FixedLength="false" />
          498  +          <Property Name="Title" Type="String" MaxLength="30" Unicode="true" FixedLength="false" />
          499  +          <Property Name="TitleOfCourtesy" Type="String" MaxLength="25" Unicode="true" FixedLength="false" />
          500  +          <Property Name="BirthDate" Type="DateTime" />
          501  +          <Property Name="HireDate" Type="DateTime" />
          502  +          <Property Name="Address" Type="String" MaxLength="60" Unicode="true" FixedLength="false" />
          503  +          <Property Name="City" Type="String" MaxLength="15" Unicode="true" FixedLength="false" />
          504  +          <Property Name="Region" Type="String" MaxLength="15" Unicode="true" FixedLength="false" />
          505  +          <Property Name="PostalCode" Type="String" MaxLength="10" Unicode="true" FixedLength="false" />
          506  +          <Property Name="Country" Type="String" MaxLength="15" Unicode="true" FixedLength="false" />
          507  +          <Property Name="HomePhone" Type="String" MaxLength="24" Unicode="true" FixedLength="false" />
          508  +          <Property Name="Extension" Type="String" MaxLength="4" Unicode="true" FixedLength="false" />
          509  +          <Property Name="Photo" Type="Binary" MaxLength="2147483647" FixedLength="false" />
          510  +          <Property Name="Notes" Type="String" MaxLength="2147483647" Unicode="true" FixedLength="false" />
          511  +          <Property Name="PhotoPath" Type="String" MaxLength="255" Unicode="true" FixedLength="false" />
          512  +        </EntityType>
          513  +        <EntityType Name="Products">
          514  +          <Key>
          515  +            <PropertyRef Name="ProductID" />
          516  +          </Key>
          517  +          <Property Name="ProductID" Type="Int64" Nullable="false" />
          518  +          <Property Name="ProductName" Type="String" Nullable="false" MaxLength="40" Unicode="true" FixedLength="false" />
          519  +          <Property Name="QuantityPerUnit" Type="String" MaxLength="20" Unicode="true" FixedLength="false" />
          520  +          <Property Name="UnitPrice" Type="Decimal" Precision="53" Scale="0" />
          521  +          <Property Name="UnitsInStock" Type="Int16" />
          522  +          <Property Name="UnitsOnOrder" Type="Int16" />
          523  +          <Property Name="ReorderLevel" Type="Int16" />
          524  +          <Property Name="Discontinued" Type="Boolean" Nullable="false" />
          525  +          <Property Name="DiscontinuedDate" Type="DateTime" />
          526  +          <NavigationProperty Name="Categories" Relationship="northwindEFModel.FK_Products_CategoryID_CategoryID" FromRole="Products" ToRole="Categories" />
          527  +          <NavigationProperty Name="OrderDetails" Relationship="northwindEFModel.FK_OrderDetails_ProductID_ProductID" FromRole="Products" ToRole="OrderDetails" />
          528  +          <NavigationProperty Name="Suppliers" Relationship="northwindEFModel.FK_Products_SupplierID_SupplierID" FromRole="Products" ToRole="Suppliers" />
          529  +        </EntityType>
          530  +        <EntityType Name="Regions">
          531  +          <Key>
          532  +            <PropertyRef Name="RegionID" />
          533  +          </Key>
          534  +          <Property Name="RegionID" Type="Int64" Nullable="false" />
          535  +          <Property Name="RegionDescription" Type="String" Nullable="false" MaxLength="50" Unicode="true" FixedLength="false" />
          536  +          <NavigationProperty Name="Territories" Relationship="northwindEFModel.FK_Territories_RegionID_RegionID" FromRole="Regions" ToRole="Territories" />
          537  +        </EntityType>
          538  +        <EntityType Name="Suppliers">
          539  +          <Key>
          540  +            <PropertyRef Name="SupplierID" />
          541  +          </Key>
          542  +          <Property Name="SupplierID" Type="Int64" Nullable="false" />
          543  +          <Property Name="CompanyName" Type="String" Nullable="false" MaxLength="40" Unicode="true" FixedLength="false" />
          544  +          <Property Name="ContactName" Type="String" MaxLength="30" Unicode="true" FixedLength="false" />
          545  +          <Property Name="ContactTitle" Type="String" MaxLength="30" Unicode="true" FixedLength="false" />
          546  +          <Property Name="Address" Type="String" MaxLength="60" Unicode="true" FixedLength="false" />
          547  +          <Property Name="City" Type="String" MaxLength="15" Unicode="true" FixedLength="false" />
          548  +          <Property Name="Region" Type="String" MaxLength="15" Unicode="true" FixedLength="false" />
          549  +          <Property Name="PostalCode" Type="String" MaxLength="10" Unicode="true" FixedLength="false" />
          550  +          <Property Name="Country" Type="String" MaxLength="15" Unicode="true" FixedLength="false" />
          551  +          <Property Name="Phone" Type="String" MaxLength="24" Unicode="true" FixedLength="false" />
          552  +          <Property Name="Fax" Type="String" MaxLength="24" Unicode="true" FixedLength="false" />
          553  +          <Property Name="HomePage" Type="String" MaxLength="2147483647" Unicode="true" FixedLength="false" />
          554  +          <NavigationProperty Name="Products" Relationship="northwindEFModel.FK_Products_SupplierID_SupplierID" FromRole="Suppliers" ToRole="Products" />
          555  +        </EntityType>
          556  +        <EntityType Name="Territories">
          557  +          <Key>
          558  +            <PropertyRef Name="TerritoryID" />
          559  +          </Key>
          560  +          <Property Name="TerritoryID" Type="Int64" Nullable="false" />
          561  +          <Property Name="TerritoryDescription" Type="String" Nullable="false" MaxLength="50" Unicode="true" FixedLength="false" />
          562  +          <NavigationProperty Name="Regions" Relationship="northwindEFModel.FK_Territories_RegionID_RegionID" FromRole="Territories" ToRole="Regions" />
          563  +          <NavigationProperty Name="Employees" Relationship="northwindEFModel.EmployeesTerritories" FromRole="Territories" ToRole="Employees" />
          564  +        </EntityType>
          565  +        <Association Name="FK_Products_CategoryID_CategoryID">
          566  +          <End Role="Categories" Type="northwindEFModel.Categories" Multiplicity="0..1" />
          567  +          <End Role="Products" Type="northwindEFModel.Products" Multiplicity="*" />
          568  +        </Association>
          569  +        <Association Name="FK_Orders_CustomerID_CustomerID">
          570  +          <End Role="Customers" Type="northwindEFModel.Customers" Multiplicity="0..1" />
          571  +          <End Role="Orders" Type="northwindEFModel.Orders" Multiplicity="*" />
          572  +        </Association>
          573  +        <Association Name="FK_InternationalOrders_OrderID_OrderID">
          574  +          <End Role="Orders" Type="northwindEFModel.Orders" Multiplicity="1" />
          575  +          <End Role="InternationalOrders" Type="northwindEFModel.InternationalOrders" Multiplicity="0..1" />
          576  +          <ReferentialConstraint>
          577  +            <Principal Role="Orders">
          578  +              <PropertyRef Name="OrderID" />
          579  +            </Principal>
          580  +            <Dependent Role="InternationalOrders">
          581  +              <PropertyRef Name="OrderID" />
          582  +            </Dependent>
          583  +          </ReferentialConstraint>
          584  +        </Association>
          585  +        <Association Name="FK_OrderDetails_OrderID_OrderID">
          586  +          <End Role="Orders" Type="northwindEFModel.Orders" Multiplicity="1" />
          587  +          <End Role="OrderDetails" Type="northwindEFModel.OrderDetails" Multiplicity="*" />
          588  +          <ReferentialConstraint>
          589  +            <Principal Role="Orders">
          590  +              <PropertyRef Name="OrderID" />
          591  +            </Principal>
          592  +            <Dependent Role="OrderDetails">
          593  +              <PropertyRef Name="OrderID" />
          594  +            </Dependent>
          595  +          </ReferentialConstraint>
          596  +        </Association>
          597  +        <Association Name="FK_OrderDetails_ProductID_ProductID">
          598  +          <End Role="Products" Type="northwindEFModel.Products" Multiplicity="1" />
          599  +          <End Role="OrderDetails" Type="northwindEFModel.OrderDetails" Multiplicity="*" />
          600  +          <ReferentialConstraint>
          601  +            <Principal Role="Products">
          602  +              <PropertyRef Name="ProductID" />
          603  +            </Principal>
          604  +            <Dependent Role="OrderDetails">
          605  +              <PropertyRef Name="ProductID" />
          606  +            </Dependent>
          607  +          </ReferentialConstraint>
          608  +        </Association>
          609  +        <Association Name="FK_Products_SupplierID_SupplierID">
          610  +          <End Role="Suppliers" Type="northwindEFModel.Suppliers" Multiplicity="0..1" />
          611  +          <End Role="Products" Type="northwindEFModel.Products" Multiplicity="*" />
          612  +        </Association>
          613  +        <Association Name="FK_Territories_RegionID_RegionID">
          614  +          <End Role="Regions" Type="northwindEFModel.Regions" Multiplicity="1" />
          615  +          <End Role="Territories" Type="northwindEFModel.Territories" Multiplicity="*" />
          616  +        </Association>
          617  +        <Association Name="EmployeesTerritories">
          618  +          <End Role="Employees" Type="northwindEFModel.Employees" Multiplicity="*" />
          619  +          <End Role="Territories" Type="northwindEFModel.Territories" Multiplicity="*" />
          620  +        </Association>
          621  +        </Schema>
          622  +    </edmx:ConceptualModels>
          623  +    <!-- C-S mapping content -->
          624  +    <edmx:Mappings>
          625  +      <Mapping Space="C-S" xmlns="http://schemas.microsoft.com/ado/2008/09/mapping/cs">
          626  +        <EntityContainerMapping StorageEntityContainer="northwindEFModelStoreContainer" CdmEntityContainer="northwindEFEntities">
          627  +          <EntitySetMapping Name="Categories">
          628  +            <EntityTypeMapping TypeName="IsTypeOf(northwindEFModel.Categories)">
          629  +              <MappingFragment StoreEntitySet="Categories">
          630  +                <ScalarProperty Name="CategoryID" ColumnName="CategoryID" />
          631  +                <ScalarProperty Name="CategoryName" ColumnName="CategoryName" />
          632  +                <ScalarProperty Name="Description" ColumnName="Description" />
          633  +                <ScalarProperty Name="Picture" ColumnName="Picture" />
          634  +              </MappingFragment>
          635  +            </EntityTypeMapping>
          636  +          </EntitySetMapping>
          637  +          <EntitySetMapping Name="Customers">
          638  +            <EntityTypeMapping TypeName="IsTypeOf(northwindEFModel.Customers)">
          639  +              <MappingFragment StoreEntitySet="Customers">
          640  +                <ScalarProperty Name="CustomerID" ColumnName="CustomerID" />
          641  +                <ScalarProperty Name="CompanyName" ColumnName="CompanyName" />
          642  +                <ScalarProperty Name="ContactName" ColumnName="ContactName" />
          643  +                <ScalarProperty Name="ContactTitle" ColumnName="ContactTitle" />
          644  +                <ScalarProperty Name="Address" ColumnName="Address" />
          645  +                <ScalarProperty Name="City" ColumnName="City" />
          646  +                <ScalarProperty Name="Region" ColumnName="Region" />
          647  +                <ScalarProperty Name="PostalCode" ColumnName="PostalCode" />
          648  +                <ScalarProperty Name="Country" ColumnName="Country" />
          649  +                <ScalarProperty Name="Phone" ColumnName="Phone" />
          650  +                <ScalarProperty Name="Fax" ColumnName="Fax" />
          651  +              </MappingFragment>
          652  +            </EntityTypeMapping>
          653  +          </EntitySetMapping>
          654  +          <EntitySetMapping Name="Employees">
          655  +            <EntityTypeMapping TypeName="IsTypeOf(northwindEFModel.Employees)">
          656  +              <MappingFragment StoreEntitySet="Employees">
          657  +                <ScalarProperty Name="EmployeeID" ColumnName="EmployeeID" />
          658  +                <ScalarProperty Name="LastName" ColumnName="LastName" />
          659  +                <ScalarProperty Name="FirstName" ColumnName="FirstName" />
          660  +                <ScalarProperty Name="Title" ColumnName="Title" />
          661  +                <ScalarProperty Name="TitleOfCourtesy" ColumnName="TitleOfCourtesy" />
          662  +                <ScalarProperty Name="BirthDate" ColumnName="BirthDate" />
          663  +                <ScalarProperty Name="HireDate" ColumnName="HireDate" />
          664  +                <ScalarProperty Name="Address" ColumnName="Address" />
          665  +                <ScalarProperty Name="City" ColumnName="City" />
          666  +                <ScalarProperty Name="Region" ColumnName="Region" />
          667  +                <ScalarProperty Name="PostalCode" ColumnName="PostalCode" />
          668  +                <ScalarProperty Name="Country" ColumnName="Country" />
          669  +                <ScalarProperty Name="HomePhone" ColumnName="HomePhone" />
          670  +                <ScalarProperty Name="Extension" ColumnName="Extension" />
          671  +                <ScalarProperty Name="Photo" ColumnName="Photo" />
          672  +                <ScalarProperty Name="Notes" ColumnName="Notes" />
          673  +                <ScalarProperty Name="PhotoPath" ColumnName="PhotoPath" />
          674  +              </MappingFragment>
          675  +            </EntityTypeMapping>
          676  +          </EntitySetMapping>
          677  +          <EntitySetMapping Name="InternationalOrders">
          678  +            <EntityTypeMapping TypeName="IsTypeOf(northwindEFModel.InternationalOrders)">
          679  +              <MappingFragment StoreEntitySet="InternationalOrders">
          680  +                <ScalarProperty Name="OrderID" ColumnName="OrderID" />
          681  +                <ScalarProperty Name="CustomsDescription" ColumnName="CustomsDescription" />
          682  +                <ScalarProperty Name="ExciseTax" ColumnName="ExciseTax" />
          683  +              </MappingFragment>
          684  +            </EntityTypeMapping>
          685  +          </EntitySetMapping>
          686  +          <EntitySetMapping Name="OrderDetails">
          687  +            <EntityTypeMapping TypeName="IsTypeOf(northwindEFModel.OrderDetails)">
          688  +              <MappingFragment StoreEntitySet="OrderDetails">
          689  +                <ScalarProperty Name="OrderID" ColumnName="OrderID" />
          690  +                <ScalarProperty Name="ProductID" ColumnName="ProductID" />
          691  +                <ScalarProperty Name="UnitPrice" ColumnName="UnitPrice" />
          692  +                <ScalarProperty Name="Quantity" ColumnName="Quantity" />
          693  +                <ScalarProperty Name="Discount" ColumnName="Discount" />
          694  +              </MappingFragment>
          695  +            </EntityTypeMapping>
          696  +          </EntitySetMapping>
          697  +          <EntitySetMapping Name="Orders">
          698  +            <EntityTypeMapping TypeName="IsTypeOf(northwindEFModel.Orders)">
          699  +              <MappingFragment StoreEntitySet="Orders">
          700  +                <ScalarProperty Name="OrderID" ColumnName="OrderID" />
          701  +                <ScalarProperty Name="EmployeeID" ColumnName="EmployeeID" />
          702  +                <ScalarProperty Name="OrderDate" ColumnName="OrderDate" />
          703  +                <ScalarProperty Name="RequiredDate" ColumnName="RequiredDate" />
          704  +                <ScalarProperty Name="ShippedDate" ColumnName="ShippedDate" />
          705  +                <ScalarProperty Name="Freight" ColumnName="Freight" />
          706  +                <ScalarProperty Name="ShipName" ColumnName="ShipName" />
          707  +                <ScalarProperty Name="ShipAddress" ColumnName="ShipAddress" />
          708  +                <ScalarProperty Name="ShipCity" ColumnName="ShipCity" />
          709  +                <ScalarProperty Name="ShipRegion" ColumnName="ShipRegion" />
          710  +                <ScalarProperty Name="ShipPostalCode" ColumnName="ShipPostalCode" />
          711  +                <ScalarProperty Name="ShipCountry" ColumnName="ShipCountry" />
          712  +              </MappingFragment>
          713  +            </EntityTypeMapping>
          714  +          </EntitySetMapping>
          715  +          <EntitySetMapping Name="PreviousEmployees">
          716  +            <EntityTypeMapping TypeName="IsTypeOf(northwindEFModel.PreviousEmployees)">
          717  +              <MappingFragment StoreEntitySet="PreviousEmployees">
          718  +                <ScalarProperty Name="EmployeeID" ColumnName="EmployeeID" />
          719  +                <ScalarProperty Name="LastName" ColumnName="LastName" />
          720  +                <ScalarProperty Name="FirstName" ColumnName="FirstName" />
          721  +                <ScalarProperty Name="Title" ColumnName="Title" />
          722  +                <ScalarProperty Name="TitleOfCourtesy" ColumnName="TitleOfCourtesy" />
          723  +                <ScalarProperty Name="BirthDate" ColumnName="BirthDate" />
          724  +                <ScalarProperty Name="HireDate" ColumnName="HireDate" />
          725  +                <ScalarProperty Name="Address" ColumnName="Address" />
          726  +                <ScalarProperty Name="City" ColumnName="City" />
          727  +                <ScalarProperty Name="Region" ColumnName="Region" />
          728  +                <ScalarProperty Name="PostalCode" ColumnName="PostalCode" />
          729  +                <ScalarProperty Name="Country" ColumnName="Country" />
          730  +                <ScalarProperty Name="HomePhone" ColumnName="HomePhone" />
          731  +                <ScalarProperty Name="Extension" ColumnName="Extension" />
          732  +                <ScalarProperty Name="Photo" ColumnName="Photo" />
          733  +                <ScalarProperty Name="Notes" ColumnName="Notes" />
          734  +                <ScalarProperty Name="PhotoPath" ColumnName="PhotoPath" />
          735  +              </MappingFragment>
          736  +            </EntityTypeMapping>
          737  +          </EntitySetMapping>
          738  +          <EntitySetMapping Name="Products">
          739  +            <EntityTypeMapping TypeName="IsTypeOf(northwindEFModel.Products)">
          740  +              <MappingFragment StoreEntitySet="Products">
          741  +                <ScalarProperty Name="ProductID" ColumnName="ProductID" />
          742  +                <ScalarProperty Name="ProductName" ColumnName="ProductName" />
          743  +                <ScalarProperty Name="QuantityPerUnit" ColumnName="QuantityPerUnit" />
          744  +                <ScalarProperty Name="UnitPrice" ColumnName="UnitPrice" />
          745  +                <ScalarProperty Name="UnitsInStock" ColumnName="UnitsInStock" />
          746  +                <ScalarProperty Name="UnitsOnOrder" ColumnName="UnitsOnOrder" />
          747  +                <ScalarProperty Name="ReorderLevel" ColumnName="ReorderLevel" />
          748  +                <ScalarProperty Name="Discontinued" ColumnName="Discontinued" />
          749  +                <ScalarProperty Name="DiscontinuedDate" ColumnName="DiscontinuedDate" />
          750  +              </MappingFragment>
          751  +            </EntityTypeMapping>
          752  +          </EntitySetMapping>
          753  +          <EntitySetMapping Name="Regions">
          754  +            <EntityTypeMapping TypeName="IsTypeOf(northwindEFModel.Regions)">
          755  +              <MappingFragment StoreEntitySet="Regions">
          756  +                <ScalarProperty Name="RegionID" ColumnName="RegionID" />
          757  +                <ScalarProperty Name="RegionDescription" ColumnName="RegionDescription" />
          758  +              </MappingFragment>
          759  +            </EntityTypeMapping>
          760  +          </EntitySetMapping>
          761  +          <EntitySetMapping Name="Suppliers">
          762  +            <EntityTypeMapping TypeName="IsTypeOf(northwindEFModel.Suppliers)">
          763  +              <MappingFragment StoreEntitySet="Suppliers">
          764  +                <ScalarProperty Name="SupplierID" ColumnName="SupplierID" />
          765  +                <ScalarProperty Name="CompanyName" ColumnName="CompanyName" />
          766  +                <ScalarProperty Name="ContactName" ColumnName="ContactName" />
          767  +                <ScalarProperty Name="ContactTitle" ColumnName="ContactTitle" />
          768  +                <ScalarProperty Name="Address" ColumnName="Address" />
          769  +                <ScalarProperty Name="City" ColumnName="City" />
          770  +                <ScalarProperty Name="Region" ColumnName="Region" />
          771  +                <ScalarProperty Name="PostalCode" ColumnName="PostalCode" />
          772  +                <ScalarProperty Name="Country" ColumnName="Country" />
          773  +                <ScalarProperty Name="Phone" ColumnName="Phone" />
          774  +                <ScalarProperty Name="Fax" ColumnName="Fax" />
          775  +                <ScalarProperty Name="HomePage" ColumnName="HomePage" />
          776  +              </MappingFragment>
          777  +            </EntityTypeMapping>
          778  +          </EntitySetMapping>
          779  +          <EntitySetMapping Name="Territories">
          780  +            <EntityTypeMapping TypeName="IsTypeOf(northwindEFModel.Territories)">
          781  +              <MappingFragment StoreEntitySet="Territories">
          782  +                <ScalarProperty Name="TerritoryID" ColumnName="TerritoryID" />
          783  +                <ScalarProperty Name="TerritoryDescription" ColumnName="TerritoryDescription" />
          784  +              </MappingFragment>
          785  +            </EntityTypeMapping>
          786  +          </EntitySetMapping>
          787  +          <AssociationSetMapping Name="FK_Products_CategoryID_CategoryID" TypeName="northwindEFModel.FK_Products_CategoryID_CategoryID" StoreEntitySet="Products">
          788  +            <EndProperty Name="Categories">
          789  +              <ScalarProperty Name="CategoryID" ColumnName="CategoryID" />
          790  +            </EndProperty>
          791  +            <EndProperty Name="Products">
          792  +              <ScalarProperty Name="ProductID" ColumnName="ProductID" />
          793  +            </EndProperty>
          794  +            <Condition ColumnName="CategoryID" IsNull="false" />
          795  +          </AssociationSetMapping>
          796  +          <AssociationSetMapping Name="FK_Orders_CustomerID_CustomerID" TypeName="northwindEFModel.FK_Orders_CustomerID_CustomerID" StoreEntitySet="Orders">
          797  +            <EndProperty Name="Customers">
          798  +              <ScalarProperty Name="CustomerID" ColumnName="CustomerID" />
          799  +            </EndProperty>
          800  +            <EndProperty Name="Orders">
          801  +              <ScalarProperty Name="OrderID" ColumnName="OrderID" />
          802  +            </EndProperty>
          803  +            <Condition ColumnName="CustomerID" IsNull="false" />
          804  +          </AssociationSetMapping>
          805  +          <AssociationSetMapping Name="FK_InternationalOrders_OrderID_OrderID" TypeName="northwindEFModel.FK_InternationalOrders_OrderID_OrderID" StoreEntitySet="InternationalOrders">
          806  +            <EndProperty Name="Orders">
          807  +              <ScalarProperty Name="OrderID" ColumnName="OrderID" />
          808  +            </EndProperty>
          809  +            <EndProperty Name="InternationalOrders">
          810  +              <ScalarProperty Name="OrderID" ColumnName="OrderID" />
          811  +            </EndProperty>
          812  +          </AssociationSetMapping>
          813  +          <AssociationSetMapping Name="FK_OrderDetails_OrderID_OrderID" TypeName="northwindEFModel.FK_OrderDetails_OrderID_OrderID" StoreEntitySet="OrderDetails">
          814  +            <EndProperty Name="Orders">
          815  +              <ScalarProperty Name="OrderID" ColumnName="OrderID" />
          816  +            </EndProperty>
          817  +            <EndProperty Name="OrderDetails">
          818  +              <ScalarProperty Name="OrderID" ColumnName="OrderID" />
          819  +              <ScalarProperty Name="ProductID" ColumnName="ProductID" />
          820  +            </EndProperty>
          821  +          </AssociationSetMapping>
          822  +          <AssociationSetMapping Name="FK_OrderDetails_ProductID_ProductID" TypeName="northwindEFModel.FK_OrderDetails_ProductID_ProductID" StoreEntitySet="OrderDetails">
          823  +            <EndProperty Name="Products">
          824  +              <ScalarProperty Name="ProductID" ColumnName="ProductID" />
          825  +            </EndProperty>
          826  +            <EndProperty Name="OrderDetails">
          827  +              <ScalarProperty Name="OrderID" ColumnName="OrderID" />
          828  +              <ScalarProperty Name="ProductID" ColumnName="ProductID" />
          829  +            </EndProperty>
          830  +          </AssociationSetMapping>
          831  +          <AssociationSetMapping Name="FK_Products_SupplierID_SupplierID" TypeName="northwindEFModel.FK_Products_SupplierID_SupplierID" StoreEntitySet="Products">
          832  +            <EndProperty Name="Suppliers">
          833  +              <ScalarProperty Name="SupplierID" ColumnName="SupplierID" />
          834  +            </EndProperty>
          835  +            <EndProperty Name="Products">
          836  +              <ScalarProperty Name="ProductID" ColumnName="ProductID" />
          837  +            </EndProperty>
          838  +            <Condition ColumnName="SupplierID" IsNull="false" />
          839  +          </AssociationSetMapping>
          840  +          <AssociationSetMapping Name="FK_Territories_RegionID_RegionID" TypeName="northwindEFModel.FK_Territories_RegionID_RegionID" StoreEntitySet="Territories">
          841  +            <EndProperty Name="Regions">
          842  +              <ScalarProperty Name="RegionID" ColumnName="RegionID" />
          843  +            </EndProperty>
          844  +            <EndProperty Name="Territories">
          845  +              <ScalarProperty Name="TerritoryID" ColumnName="TerritoryID" />
          846  +            </EndProperty>
          847  +          </AssociationSetMapping>
          848  +          <AssociationSetMapping Name="EmployeesTerritories" TypeName="northwindEFModel.EmployeesTerritories" StoreEntitySet="EmployeesTerritories">
          849  +            <EndProperty Name="Employees">
          850  +              <ScalarProperty Name="EmployeeID" ColumnName="EmployeeID" />
          851  +            </EndProperty>
          852  +            <EndProperty Name="Territories">
          853  +              <ScalarProperty Name="TerritoryID" ColumnName="TerritoryID" />
          854  +            </EndProperty>
          855  +          </AssociationSetMapping>
          856  +          </EntityContainerMapping>
          857  +      </Mapping>
          858  +    </edmx:Mappings>
          859  +  </edmx:Runtime>
          860  +  <!-- EF Designer content (DO NOT EDIT MANUALLY BELOW HERE) -->
          861  +  <edmx:Designer>
          862  +    <edmx:Connection>
          863  +      <DesignerInfoPropertySet xmlns="http://schemas.microsoft.com/ado/2008/10/edmx">
          864  +        <DesignerProperty Name="MetadataArtifactProcessing" Value="EmbedInOutputAssembly" />
          865  +      </DesignerInfoPropertySet>
          866  +    </edmx:Connection>
          867  +    <edmx:Options>
          868  +      <DesignerInfoPropertySet xmlns="http://schemas.microsoft.com/ado/2008/10/edmx">
          869  +        <DesignerProperty Name="ValidateOnBuild" Value="true" />
          870  +      </DesignerInfoPropertySet>
          871  +    </edmx:Options>
          872  +    <!-- Diagram content (shape and connector positions) -->
          873  +    <edmx:Diagrams>
          874  +      <Diagram Name="NorthwindModel" xmlns="http://schemas.microsoft.com/ado/2008/10/edmx">
          875  +        <EntityTypeShape EntityType="northwindEFModel.Categories" Width="1.5" PointX="0.75" PointY="1.625" Height="1.9802864583333335" IsExpanded="true" />
          876  +        <EntityTypeShape EntityType="northwindEFModel.Customers" Width="1.5" PointX="0.75" PointY="9.625" Height="3.3263964843749996" IsExpanded="true" />
          877  +        <EntityTypeShape EntityType="northwindEFModel.Employees" Width="1.5" PointX="2.75" PointY="14.625" Height="4.4802050781250014" IsExpanded="true" />
          878  +        <EntityTypeShape EntityType="northwindEFModel.InternationalOrders" Width="1.5" PointX="5.25" PointY="10.375" Height="1.7879850260416674" IsExpanded="true" />
          879  +        <EntityTypeShape EntityType="northwindEFModel.OrderDetails" Width="1.5" PointX="5.25" PointY="1.5" Height="2.3648893229166656" IsExpanded="true" />
          880  +        <EntityTypeShape EntityType="northwindEFModel.Orders" Width="1.5" PointX="3" PointY="9.25" Height="3.9033007812499996" IsExpanded="true" />
          881  +        <EntityTypeShape EntityType="northwindEFModel.PreviousEmployees" Width="1.5" PointX="7.75" PointY="0.75" Height="4.2879036458333317" IsExpanded="true" />
          882  +        <EntityTypeShape EntityType="northwindEFModel.Products" Width="1.5" PointX="3" PointY="1" Height="3.3263964843749996" IsExpanded="true" />
          883  +        <EntityTypeShape EntityType="northwindEFModel.Regions" Width="1.5" PointX="2.75" PointY="6" Height="1.5956835937499996" IsExpanded="true" />
          884  +        <EntityTypeShape EntityType="northwindEFModel.Suppliers" Width="1.5" PointX="0.75" PointY="4.875" Height="3.5186979166666656" IsExpanded="true" />
          885  +        <EntityTypeShape EntityType="northwindEFModel.Territories" Width="1.5" PointX="5" PointY="5.875" Height="1.7879850260416674" IsExpanded="true" />
          886  +        <AssociationConnector Association="northwindEFModel.FK_Products_CategoryID_CategoryID" ManuallyRouted="false">
          887  +          <ConnectorPoint PointX="2.25" PointY="2.6151432291666667" />
          888  +          <ConnectorPoint PointX="3" PointY="2.6151432291666667" /></AssociationConnector>
          889  +        <AssociationConnector Association="northwindEFModel.FK_Orders_CustomerID_CustomerID" ManuallyRouted="false">
          890  +          <ConnectorPoint PointX="2.25" PointY="11.2881982421875" />
          891  +          <ConnectorPoint PointX="3" PointY="11.2881982421875" /></AssociationConnector>
          892  +        <AssociationConnector Association="northwindEFModel.FK_InternationalOrders_OrderID_OrderID" ManuallyRouted="false">
          893  +          <ConnectorPoint PointX="4.5" PointY="11.268992513020834" />
          894  +          <ConnectorPoint PointX="5.010416666666667" PointY="11.268992513020834" />
          895  +          <ConnectorPoint PointX="5.177083333333333" PointY="11.268992513020834" />
          896  +          <ConnectorPoint PointX="5.25" PointY="11.268992513020834" /></AssociationConnector>
          897  +        <AssociationConnector Association="northwindEFModel.FK_OrderDetails_OrderID_OrderID" ManuallyRouted="false">
          898  +          <ConnectorPoint PointX="3.75" PointY="9.25" />
          899  +          <ConnectorPoint PointX="3.75" PointY="7.84568359375" />
          900  +          <ConnectorPoint PointX="4.75" PointY="7.84568359375" />
          901  +          <ConnectorPoint PointX="4.75" PointY="2.6824446614583328" />
          902  +          <ConnectorPoint PointX="5.25" PointY="2.6824446614583328" /></AssociationConnector>
          903  +        <AssociationConnector Association="northwindEFModel.FK_OrderDetails_ProductID_ProductID" ManuallyRouted="false">
          904  +          <ConnectorPoint PointX="4.5" PointY="2.0287223307291664" />
          905  +          <ConnectorPoint PointX="5.25" PointY="2.0287223307291664" /></AssociationConnector>
          906  +        <AssociationConnector Association="northwindEFModel.FK_Products_SupplierID_SupplierID" ManuallyRouted="false">
          907  +          <ConnectorPoint PointX="2.25" PointY="5.40625" />
          908  +          <ConnectorPoint PointX="4.40625" PointY="5.40625" />
          909  +          <ConnectorPoint PointX="4.40625" PointY="4.326396484375" /></AssociationConnector>
          910  +        <AssociationConnector Association="northwindEFModel.FK_Territories_RegionID_RegionID" ManuallyRouted="false">
          911  +          <ConnectorPoint PointX="4.25" PointY="6.797841796875" />
          912  +          <ConnectorPoint PointX="4.666666666666667" PointY="6.7978417968749989" />
          913  +          <ConnectorPoint PointX="4.833333333333333" PointY="6.797841796875" />
          914  +          <ConnectorPoint PointX="5" PointY="6.797841796875" /></AssociationConnector>
          915  +        <AssociationConnector Association="northwindEFModel.EmployeesTerritories" ManuallyRouted="false">
          916  +          <ConnectorPoint PointX="4.25" PointY="16.8651025390625" />
          917  +          <ConnectorPoint PointX="5.09375" PointY="16.8651025390625" />
          918  +          <ConnectorPoint PointX="5.09375" PointY="7.6629850260416674" /></AssociationConnector>
          919  +        </Diagram></edmx:Diagrams>
          920  +  </edmx:Designer>
          921  +</edmx:Edmx>