System.Data.SQLite
Check-in [7161ddc5c2]
Not logged in

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

Overview
Comment:Split the NorthwindModel* and App.Config files for the 'testlinq' project into VS2008/VS2010 specific variants. More refinements to release automation. Remove hard-coded assembly version number from SQLiteFactory class. Remove 'v4.0' from all assembly version info. Remove unused 'using' statements from the System.Data.SQLite.Linq project.
Downloads: Tarball | ZIP archive | SQL archive
Timelines: family | ancestors | descendants | both | build-enhancements
Files: files | file ages | folders
SHA1: 7161ddc5c26e19d4fd78c610765bd5a82b7a2f7d
User & Date: mistachkin 2011-07-01 11:03:27
Context
2011-07-01
11:05
Add App.config for VS2010 version of 'testlinq' project, missing from previous commit. check-in: d57ce3a2f8 user: mistachkin tags: build-enhancements
11:03
Split the NorthwindModel* and App.Config files for the 'testlinq' project into VS2008/VS2010 specific variants. More refinements to release automation. Remove hard-coded assembly version number from SQLiteFactory class. Remove 'v4.0' from all assembly version info. Remove unused 'using' statements from the System.Data.SQLite.Linq project. check-in: 7161ddc5c2 user: mistachkin tags: build-enhancements
08:33
Add 'testlinq' project to the new build system. Cleanup in both test apps. Fix XML doc warnings. check-in: bd2f09af59 user: mistachkin tags: build-enhancements
Changes
Hide Diffs Side-by-Side Diffs Ignore Whitespace Patch

Changes to SQLite.Designer/AssemblyInfo.cs.

     4      4   using System.Runtime.ConstrainedExecution;
     5      5   using System.Resources;
     6      6   
     7      7   // General Information about an assembly is controlled through the following 
     8      8   // set of attributes. Change these attribute values to modify the information
     9      9   // associated with an assembly.
    10     10   [assembly: AssemblyTitle("SQLite.Designer")]
    11         -[assembly: AssemblyDescription("ADO.NET 4.0 Data Designer for SQLite")]
           11  +[assembly: AssemblyDescription("ADO.NET Data Designer for SQLite")]
    12     12   [assembly: AssemblyConfiguration("")]
    13     13   [assembly: AssemblyCompany("http://system.data.sqlite.org")]
    14     14   [assembly: AssemblyProduct("SQLite Designer")]
    15     15   [assembly: AssemblyCopyright("Public Domain")]
    16     16   [assembly: AssemblyTrademark("")]
    17     17   [assembly: AssemblyCulture("")]
    18     18   

Changes to SQLite.Designer/source.extension.vsixmanifest.

     1      1   <?xml version="1.0" encoding="utf-8"?>
     2      2   <Vsix Version="1.0.0" xmlns="http://schemas.microsoft.com/developer/vsx-schema/2010">
     3      3     <Identifier Id="67b5f3a9-cde1-430f-a12b-af95bb064851">
     4      4       <Name>SQLite Designer</Name>
     5      5       <Author>Robert Simpson</Author>
     6      6       <Version>1.0.38.1</Version>
     7         -    <Description>ADO.NET 4.0 Data Designer for SQLite</Description>
            7  +    <Description>ADO.NET Data Designer for SQLite</Description>
     8      8       <Locale>1033</Locale>
     9      9       <InstalledByMsi>false</InstalledByMsi>
    10     10       <SupportedProducts>
    11     11         <VisualStudio Version="10.0">
    12     12           <Edition>Pro</Edition>
    13     13         </VisualStudio>
    14     14       </SupportedProducts>

Changes to SQLite.NET.2008.MSBuild.sln.

    21     21   	EndProjectSection
    22     22   EndProject
    23     23   Project("{FAE04EC0-301F-11D3-BF4B-00C04F79EFBC}") = "System.Data.SQLite.Linq.2008", "System.Data.SQLite.Linq\System.Data.SQLite.Linq.2008.csproj", "{E6BF9F74-58E2-413B-A7CE-EA653ECB728D}"
    24     24   EndProject
    25     25   Project("{FAE04EC0-301F-11D3-BF4B-00C04F79EFBC}") = "testlinq.2008", "testlinq\testlinq.2008.csproj", "{9D3CF7A6-092A-4B05-B0E4-BEF6944525B3}"
    26     26   	ProjectSection(ProjectDependencies) = postProject
    27     27   		{AC139952-261A-4463-B6FA-AEBC25283A66} = {AC139952-261A-4463-B6FA-AEBC25283A66}
           28  +		{E6BF9F74-58E2-413B-A7CE-EA653ECB728D} = {E6BF9F74-58E2-413B-A7CE-EA653ECB728D}
    28     29   	EndProjectSection
    29     30   EndProject
    30     31   Global
    31     32   	GlobalSection(SolutionConfigurationPlatforms) = preSolution
    32     33   		Debug|Any CPU = Debug|Any CPU
    33     34   		Debug|Mixed Platforms = Debug|Mixed Platforms
    34     35   		Debug|Win32 = Debug|Win32

Changes to SQLite.NET.2008.sln.

    25     25   Project("{FAE04EC0-301F-11D3-BF4B-00C04F79EFBC}") = "System.Data.SQLite.Linq.2008", "System.Data.SQLite.Linq\System.Data.SQLite.Linq.2008.csproj", "{E6BF9F74-58E2-413B-A7CE-EA653ECB728D}"
    26     26   EndProject
    27     27   Project("{FAE04EC0-301F-11D3-BF4B-00C04F79EFBC}") = "SQLite.Designer.2008", "SQLite.Designer\SQLite.Designer.2008.csproj", "{9B4A5CF6-5BE5-4926-ACC7-B729A8C05198}"
    28     28   EndProject
    29     29   Project("{FAE04EC0-301F-11D3-BF4B-00C04F79EFBC}") = "testlinq.2008", "testlinq\testlinq.2008.csproj", "{9D3CF7A6-092A-4B05-B0E4-BEF6944525B3}"
    30     30   	ProjectSection(ProjectDependencies) = postProject
    31     31   		{AC139952-261A-4463-B6FA-AEBC25283A66} = {AC139952-261A-4463-B6FA-AEBC25283A66}
           32  +		{E6BF9F74-58E2-413B-A7CE-EA653ECB728D} = {E6BF9F74-58E2-413B-A7CE-EA653ECB728D}
    32     33   	EndProjectSection
    33     34   EndProject
    34     35   Global
    35     36   	GlobalSection(SolutionConfigurationPlatforms) = preSolution
    36     37   		Debug|Any CPU = Debug|Any CPU
    37     38   		Debug|Mixed Platforms = Debug|Mixed Platforms
    38     39   		Debug|Win32 = Debug|Win32

Changes to SQLite.NET.2010.MSBuild.sln.

    21     21   	EndProjectSection
    22     22   EndProject
    23     23   Project("{FAE04EC0-301F-11D3-BF4B-00C04F79EFBC}") = "System.Data.SQLite.Linq.2010", "System.Data.SQLite.Linq\System.Data.SQLite.Linq.2010.csproj", "{E6BF9F74-58E2-413B-A7CE-EA653ECB728D}"
    24     24   EndProject
    25     25   Project("{FAE04EC0-301F-11D3-BF4B-00C04F79EFBC}") = "testlinq.2010", "testlinq\testlinq.2010.csproj", "{9D3CF7A6-092A-4B05-B0E4-BEF6944525B3}"
    26     26   	ProjectSection(ProjectDependencies) = postProject
    27     27   		{AC139952-261A-4463-B6FA-AEBC25283A66} = {AC139952-261A-4463-B6FA-AEBC25283A66}
           28  +		{E6BF9F74-58E2-413B-A7CE-EA653ECB728D} = {E6BF9F74-58E2-413B-A7CE-EA653ECB728D}
    28     29   	EndProjectSection
    29     30   EndProject
    30     31   Global
    31     32   	GlobalSection(SolutionConfigurationPlatforms) = preSolution
    32     33   		Debug|Any CPU = Debug|Any CPU
    33     34   		Debug|Mixed Platforms = Debug|Mixed Platforms
    34     35   		Debug|Win32 = Debug|Win32

Changes to SQLite.NET.2010.sln.

    23     23   Project("{FAE04EC0-301F-11D3-BF4B-00C04F79EFBC}") = "System.Data.SQLite.Linq.2010", "System.Data.SQLite.Linq\System.Data.SQLite.Linq.2010.csproj", "{E6BF9F74-58E2-413B-A7CE-EA653ECB728D}"
    24     24   EndProject
    25     25   Project("{FAE04EC0-301F-11D3-BF4B-00C04F79EFBC}") = "SQLite.Designer.2010", "SQLite.Designer\SQLite.Designer.2010.csproj", "{9B4A5CF6-5BE5-4926-ACC7-B729A8C05198}"
    26     26   EndProject
    27     27   Project("{FAE04EC0-301F-11D3-BF4B-00C04F79EFBC}") = "testlinq.2010", "testlinq\testlinq.2010.csproj", "{9D3CF7A6-092A-4B05-B0E4-BEF6944525B3}"
    28     28   	ProjectSection(ProjectDependencies) = postProject
    29     29   		{AC139952-261A-4463-B6FA-AEBC25283A66} = {AC139952-261A-4463-B6FA-AEBC25283A66}
           30  +		{E6BF9F74-58E2-413B-A7CE-EA653ECB728D} = {E6BF9F74-58E2-413B-A7CE-EA653ECB728D}
    30     31   	EndProjectSection
    31     32   EndProject
    32     33   Global
    33     34   	GlobalSection(SolutionConfigurationPlatforms) = preSolution
    34     35   		Debug|Any CPU = Debug|Any CPU
    35     36   		Debug|Mixed Platforms = Debug|Mixed Platforms
    36     37   		Debug|Win32 = Debug|Win32

Changes to Setup/archive.bat.

    62     62   
    63     63   :skip_mungeVersion
    64     64   
    65     65   %_VECHO% Version = '%VERSION%'
    66     66   
    67     67   CALL :fn_ResetErrorLevel
    68     68   
    69         -%_ECHO% zip.exe -r sqlite-dotnet-source-%VERSION%.zip * -x@exclude_src.txt
           69  +%_ECHO% zip.exe -r Setup\Output\sqlite-dotnet-source-%VERSION%.zip * -x@exclude_src.txt
    70     70   
    71     71   IF ERRORLEVEL 1 (
    72     72     ECHO Failed to archive source files.
    73     73     GOTO errors
    74     74   )
    75     75   
    76     76   %_ECHO% POPD

Added Setup/release.bat.

            1  +@ECHO OFF
            2  +
            3  +::
            4  +:: release.bat --
            5  +::
            6  +:: Binary Release Tool
            7  +::
            8  +:: Written by Joe Mistachkin.
            9  +:: Released to the public domain, use at your own risk!
           10  +::
           11  +
           12  +SETLOCAL
           13  +
           14  +REM SET _ECHO=ECHO
           15  +IF NOT DEFINED _AECHO (SET _AECHO=REM)
           16  +IF NOT DEFINED _CECHO (SET _CECHO=REM)
           17  +IF NOT DEFINED _VECHO (SET _VECHO=REM)
           18  +
           19  +%_AECHO% Running %0 %*
           20  +
           21  +SET CONFIGURATION=%1
           22  +
           23  +IF DEFINED CONFIGURATION (
           24  +  SET CONFIGURATION=%CONFIGURATION:"=%
           25  +  REM "
           26  +) ELSE (
           27  +  %_AECHO% No configuration specified, using default...
           28  +  SET CONFIGURATION=Release
           29  +)
           30  +
           31  +%_VECHO% Configuration = '%CONFIGURATION%'
           32  +
           33  +SET PLATFORM=%2
           34  +
           35  +IF DEFINED PLATFORM (
           36  +  SET PLATFORM=%PLATFORM:"=%
           37  +  REM "
           38  +) ELSE (
           39  +  %_AECHO% No platform specified, using default...
           40  +  SET PLATFORM=Win32
           41  +)
           42  +
           43  +%_VECHO% Platform = '%PLATFORM%'
           44  +
           45  +SET YEAR=%3
           46  +
           47  +IF DEFINED YEAR (
           48  +  SET YEAR=%YEAR:"=%
           49  +  REM "
           50  +) ELSE (
           51  +  %_AECHO% No year specified, using default...
           52  +  SET YEAR=2008
           53  +)
           54  +
           55  +%_VECHO% Year = '%YEAR%'
           56  +
           57  +SET BASE_CONFIGURATION=%CONFIGURATION:NativeOnly=%
           58  +
           59  +%_VECHO% BaseConfiguration = '%BASE_CONFIGURATION%'
           60  +
           61  +IF "%CONFIGURATION%" == "%BASE_CONFIGURATION%" (
           62  +  SET TYPE=binary-bundle
           63  +) ELSE (
           64  +  SET TYPE=binary
           65  +)
           66  +
           67  +%_VECHO% Type = '%TYPE%'
           68  +
           69  +SET ROOT=%~dp0\..
           70  +SET ROOT=%ROOT:\\=\%
           71  +
           72  +SET TOOLS=%~dp0
           73  +SET TOOLS=%TOOLS:~0,-1%
           74  +
           75  +%_VECHO% Root = '%ROOT%'
           76  +%_VECHO% Tools = '%TOOLS%'
           77  +
           78  +CALL :fn_ResetErrorLevel
           79  +
           80  +%_ECHO% PUSHD "%ROOT%"
           81  +
           82  +IF ERRORLEVEL 1 (
           83  +  ECHO Could not change directory to "%ROOT%".
           84  +  GOTO errors
           85  +)
           86  +
           87  +CALL :fn_ResetErrorLevel
           88  +
           89  +%_ECHO% zip.exe -r Setup\Output\sqlite-dotnet-%TYPE%-%PLATFORM%-%YEAR%-%VERSION%.zip * -x@exclude_bin.txt
           90  +
           91  +IF ERRORLEVEL 1 (
           92  +  ECHO Failed to archive binary files.
           93  +  GOTO errors
           94  +)
           95  +
           96  +%_ECHO% POPD
           97  +
           98  +IF ERRORLEVEL 1 (
           99  +  ECHO Could not restore directory.
          100  +  GOTO errors
          101  +)
          102  +
          103  +GOTO no_errors
          104  +
          105  +:fn_ResetErrorLevel
          106  +  VERIFY > NUL
          107  +  GOTO :EOF
          108  +
          109  +:fn_SetErrorLevel
          110  +  VERIFY MAYBE 2> NUL
          111  +  GOTO :EOF
          112  +
          113  +:usage
          114  +  ECHO.
          115  +  ECHO Usage: %~nx0 [configuration] [platform] [year]
          116  +  ECHO.
          117  +  GOTO errors
          118  +
          119  +:errors
          120  +  CALL :fn_SetErrorLevel
          121  +  ENDLOCAL
          122  +  ECHO.
          123  +  ECHO Release failure, errors were encountered.
          124  +  GOTO end_of_file
          125  +
          126  +:no_errors
          127  +  CALL :fn_ResetErrorLevel
          128  +  ENDLOCAL
          129  +  ECHO.
          130  +  ECHO Release success, no errors were encountered.
          131  +  GOTO end_of_file
          132  +
          133  +:end_of_file
          134  +%_ECHO% EXIT /B %ERRORLEVEL%

Changes to System.Data.SQLite.Linq/AssemblyInfo.cs.

     1      1   using System;
     2      2   using System.Reflection;
     3         -using System.Runtime.CompilerServices;
     4      3   using System.Runtime.InteropServices;
     5         -using System.Security.Permissions;
     6      4   using System.Security;
     7      5   using System.Runtime.ConstrainedExecution;
     8      6   
     9      7   // General Information about an assembly is controlled through the following 
    10      8   // set of attributes. Change these attribute values to modify the information
    11      9   // associated with an assembly.
    12     10   [assembly: AssemblyTitle("System.Data.SQLite.Linq")]
    13         -[assembly: AssemblyDescription("ADO.NET 4.0 Entity Framework support for SQLite")]
           11  +[assembly: AssemblyDescription("ADO.NET Entity Framework support for SQLite")]
    14     12   [assembly: AssemblyConfiguration("")]
    15     13   [assembly: AssemblyCompany("http://system.data.sqlite.org")]
    16     14   [assembly: AssemblyProduct("System.Data.SQLite")]
    17     15   [assembly: AssemblyCopyright("Public Domain")]
    18     16   [assembly: AssemblyTrademark("")]
    19     17   [assembly: AssemblyCulture("")]
    20     18   

Changes to System.Data.SQLite.Linq/SQL Generation/DmlSqlGenerator.cs.

    10     10   
    11     11   namespace System.Data.SQLite
    12     12   {
    13     13     using System;
    14     14     using System.Collections.Generic;
    15     15     using System.Diagnostics;
    16     16     using System.Globalization;
    17         -  using System.IO;
    18     17     using System.Text;
    19     18     using System.Data;
    20     19     using System.Data.Common;
    21     20     using System.Data.Metadata.Edm;
    22     21     using System.Data.Common.CommandTrees;
    23         -  using System.Data.Common.Utils;
    24         -  using System.Data.Mapping.Update.Internal;
    25     22   
    26         -  /// <summary>
           23  +    /// <summary>
    27     24     /// Class generating SQL for a DML command tree.
    28     25     /// </summary>
    29     26     internal static class DmlSqlGenerator
    30     27     {
    31     28       private static readonly int s_commandTextBuilderInitialCapacity = 256;
    32     29   
    33     30       internal static string GenerateUpdateSql(DbUpdateCommandTree tree, out List<DbParameter> parameters)

Changes to System.Data.SQLite.Linq/SQL Generation/ISqlFragment.cs.

     6      6   //      or License.txt for details.
     7      7   //      All rights reserved.
     8      8   // </copyright>
     9      9   //---------------------------------------------------------------------
    10     10   
    11     11   namespace System.Data.SQLite
    12     12   {
    13         -  using System;
    14         -  using System.Collections.Generic;
    15         -  using System.Diagnostics;
    16         -  using System.IO;
    17         -  using System.Text;
    18         -  using System.Data.Metadata.Edm;
    19     13     using System.Data.Common.CommandTrees;
    20     14   
    21     15     /// <summary>
    22     16     /// Represents the sql fragment for any node in the query tree.
    23     17     /// </summary>
    24     18     /// <remarks>
    25     19     /// The nodes in a query tree produce various kinds of sql

Changes to System.Data.SQLite.Linq/SQL Generation/InternalBase.cs.

     1      1   /********************************************************
     2      2    * ADO.NET 2.0 Data Provider for SQLite Version 3.X
     3      3    * Written by Robert Simpson (robert@blackcastlesoft.com)
     4      4    * 
     5      5    * Released to the public domain, use at your own risk!
     6      6    ********************************************************/
     7      7   
     8         -using System;
     9         -using System.Collections.Generic;
    10         -using System.Linq;
    11      8   using System.Text;
            9  +
           10  +#if !NET_20
    12     11   using System.Runtime;
           12  +#endif
    13     13   
    14     14   namespace System.Data.SQLite
    15     15   {
    16     16   	internal abstract class InternalBase
    17     17   	{
    18     18   		// Methods
    19     19   #if !NET_20

Changes to System.Data.SQLite.Linq/SQL Generation/JoinSymbol.cs.

     8      8   // </copyright>
     9      9   //---------------------------------------------------------------------
    10     10   
    11     11   namespace System.Data.SQLite
    12     12   {
    13     13     using System;
    14     14     using System.Collections.Generic;
    15         -  using System.Diagnostics;
    16         -  using System.IO;
    17         -  using System.Text;
    18     15     using System.Data.Metadata.Edm;
    19     16     using System.Data.Common.CommandTrees;
    20     17   
    21     18     /// <summary>
    22     19     /// A Join symbol is a special kind of Symbol.
    23     20     /// It has to carry additional information
    24     21     /// <list type="bullet">

Changes to System.Data.SQLite.Linq/SQL Generation/KeyToListMap.cs.

     1      1   /********************************************************
     2      2    * ADO.NET 2.0 Data Provider for SQLite Version 3.X
     3      3    * Written by Robert Simpson (robert@blackcastlesoft.com)
     4      4    * 
     5      5    * Released to the public domain, use at your own risk!
     6      6    ********************************************************/
     7      7   
     8         -using System;
     9      8   using System.Collections.Generic;
    10         -using System.Linq;
    11      9   using System.Text;
    12     10   using System.Collections.ObjectModel;
    13         -using System.Runtime;
    14         -using System.Runtime.CompilerServices;
    15     11   using System.Collections;
           12  +
           13  +#if !NET_20
           14  +using System.Runtime;
           15  +#endif
    16     16   
    17     17   namespace System.Data.SQLite
    18     18   {
    19     19   	internal class KeyToListMap<TKey, TValue> : InternalBase
    20     20   	{
    21     21   		// Fields
    22     22   		private Dictionary<TKey, List<TValue>> m_map;

Changes to System.Data.SQLite.Linq/SQL Generation/MetadataHelpers.cs.

     8      8   // </copyright>
     9      9   //---------------------------------------------------------------------
    10     10   
    11     11   namespace System.Data.SQLite
    12     12   {
    13     13     using System;
    14     14     using System.Data;
    15         -  using System.Data.Common;
    16     15     using System.Collections.Generic;
    17     16     using System.Data.Metadata.Edm;
    18     17     using System.Diagnostics;
    19     18   
    20     19     /// <summary>
    21     20     /// A set of static helpers for type metadata
    22     21     /// </summary>

Changes to System.Data.SQLite.Linq/SQL Generation/SqlBuilder.cs.

     9      9   //---------------------------------------------------------------------
    10     10   
    11     11   namespace System.Data.SQLite
    12     12   {
    13     13     using System;
    14     14     using System.Collections.Generic;
    15     15     using System.Diagnostics;
    16         -  using System.IO;
    17         -  using System.Text;
    18         -  using System.Data.Metadata.Edm;
    19     16     using System.Data.Common.CommandTrees;
    20     17   
    21     18     /// <summary>
    22     19     /// This class is like StringBuilder.  While traversing the tree for the first time, 
    23     20     /// we do not know all the strings that need to be appended e.g. things that need to be
    24     21     /// renamed, nested select statements etc.  So, we use a builder that can collect
    25     22     /// all kinds of sql fragments.

Changes to System.Data.SQLite.Linq/SQL Generation/SqlChecker.cs.

     5      5    * Released to the public domain, use at your own risk!
     6      6    ********************************************************/
     7      7   
     8      8   namespace System.Data.SQLite
     9      9   {
    10     10     using System;
    11     11     using System.Collections.Generic;
    12         -  using System.Data;
    13     12     using System.Data.Common.CommandTrees;
    14         -  using System.Data.Entity;
    15         -  using System.Runtime.CompilerServices;
    16     13   
    17         -  internal class SqlChecker : DbExpressionVisitor<bool>
           14  +    internal class SqlChecker : DbExpressionVisitor<bool>
    18     15     {
    19     16       private static Type sql8rewriter;
    20     17   
    21     18       static SqlChecker()
    22     19       {
    23     20         sql8rewriter = Type.GetType("System.Data.SqlClient.SqlGen.Sql8ExpressionRewriter, System.Data.Entity, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089", false);
    24     21       }

Changes to System.Data.SQLite.Linq/SQL Generation/SqlGenerator.cs.

    10     10   
    11     11   namespace System.Data.SQLite
    12     12   {
    13     13     using System;
    14     14     using System.Linq;
    15     15     using System.Diagnostics;
    16     16     using System.Globalization;
    17         -  using System.IO;
    18     17     using System.Text;
    19     18     using System.Data.Common;
    20     19     using System.Data.Metadata.Edm;
    21     20     using System.Data.Common.CommandTrees;
    22     21     using System.Data;
    23     22     using System.Collections.ObjectModel;
    24     23     using System.Collections.Generic;

Changes to System.Data.SQLite.Linq/SQL Generation/SqlSelectStatement.cs.

     6      6   //      or License.txt for details.
     7      7   //      All rights reserved.
     8      8   // </copyright>
     9      9   //---------------------------------------------------------------------
    10     10   
    11     11   namespace System.Data.SQLite
    12     12   {
    13         -  using System;
    14     13     using System.Collections.Generic;
    15     14     using System.Diagnostics;
    16         -  using System.IO;
    17         -  using System.Text;
    18         -  using System.Data.Metadata.Edm;
    19     15     using System.Data.Common.CommandTrees;
    20     16   
    21     17     /// <summary>
    22     18     /// A SqlSelectStatement represents a canonical SQL SELECT statement.
    23     19     /// It has fields for the 5 main clauses
    24     20     /// <list type="number">
    25     21     /// <item>SELECT</item>

Changes to System.Data.SQLite.Linq/SQL Generation/SqlWriter.cs.

     6      6   //      or License.txt for details.
     7      7   //      All rights reserved.
     8      8   // </copyright>
     9      9   //---------------------------------------------------------------------
    10     10   
    11     11   namespace System.Data.SQLite
    12     12   {
    13         -  using System;
    14         -  using System.Collections.Generic;
    15         -  using System.Diagnostics;
    16     13     using System.IO;
    17     14     using System.Text;
    18         -  using System.Data.Metadata.Edm;
    19         -  using System.Data.Common.CommandTrees;
    20     15   
    21         -  /// <summary>
           16  +    /// <summary>
    22     17     /// This extends StringWriter primarily to add the ability to add an indent
    23     18     /// to each line that is written out.
    24     19     /// </summary>
    25     20     class SqlWriter : StringWriter
    26     21     {
    27     22       // We start at -1, since the first select statement will increment it to 0.
    28     23       int indent = -1;

Changes to System.Data.SQLite.Linq/SQL Generation/StringUtil.cs.

     1      1   /********************************************************
     2      2    * ADO.NET 2.0 Data Provider for SQLite Version 3.X
     3      3    * Written by Robert Simpson (robert@blackcastlesoft.com)
     4      4    * 
     5      5    * Released to the public domain, use at your own risk!
     6      6    ********************************************************/
     7      7   
     8         -using System;
     9      8   using System.Collections.Generic;
    10         -using System.Linq;
    11      9   using System.Text;
    12     10   using System.Globalization;
    13         -using System.Runtime;
    14     11   using System.Collections;
           12  +
           13  +#if !NET_20
           14  +using System.Runtime;
           15  +#endif
    15     16   
    16     17   namespace System.Data.SQLite
    17     18   {
    18     19   	internal static class StringUtil
    19     20   	{
    20     21   		// Fields
    21     22   		private const string s_defaultDelimiter = ", ";

Changes to System.Data.SQLite.Linq/SQL Generation/Symbol.cs.

     8      8   // </copyright>
     9      9   //---------------------------------------------------------------------
    10     10   
    11     11   namespace System.Data.SQLite
    12     12   {
    13     13     using System;
    14     14     using System.Collections.Generic;
    15         -  using System.Diagnostics;
    16         -  using System.IO;
    17         -  using System.Text;
    18     15     using System.Data.Metadata.Edm;
    19         -  using System.Data.Common.CommandTrees;
    20     16   
    21         -  /// <summary>
           17  +    /// <summary>
    22     18     /// <see cref="SymbolTable"/>
    23     19     /// This class represents an extent/nested select statement,
    24     20     /// or a column.
    25     21     ///
    26     22     /// The important fields are Name, Type and NewName.
    27     23     /// NewName starts off the same as Name, and is then modified as necessary.
    28     24     ///

Changes to System.Data.SQLite.Linq/SQL Generation/SymbolPair.cs.

     6      6   //      or License.txt for details.
     7      7   //      All rights reserved.
     8      8   // </copyright>
     9      9   //---------------------------------------------------------------------
    10     10   
    11     11   namespace System.Data.SQLite
    12     12   {
    13         -  using System;
    14         -  using System.Collections.Generic;
    15     13     using System.Diagnostics;
    16         -  using System.IO;
    17         -  using System.Text;
    18         -  using System.Data.Metadata.Edm;
    19     14     using System.Data.Common.CommandTrees;
    20     15   
    21     16     /// <summary>
    22     17     /// The SymbolPair exists to solve the record flattening problem.
    23     18     /// <see cref="SqlGenerator.Visit(DbPropertyExpression)"/>
    24     19     /// Consider a property expression D(v, "j3.j2.j1.a.x")
    25     20     /// where v is a VarRef, j1, j2, j3 are joins, a is an extent and x is a columns.

Changes to System.Data.SQLite.Linq/SQL Generation/SymbolTable.cs.

     8      8   // </copyright>
     9      9   //---------------------------------------------------------------------
    10     10   
    11     11   namespace System.Data.SQLite
    12     12   {
    13     13     using System;
    14     14     using System.Collections.Generic;
    15         -  using System.Diagnostics;
    16         -  using System.IO;
    17         -  using System.Text;
    18         -  using System.Data.Metadata.Edm;
    19     15     using System.Data.Common.CommandTrees;
    20     16   
    21     17     /// <summary>
    22     18     /// The symbol table is quite primitive - it is a stack with a new entry for
    23     19     /// each scope.  Lookups search from the top of the stack to the bottom, until
    24     20     /// an entry is found.
    25     21     /// 

Changes to System.Data.SQLite.Linq/SQL Generation/TopClause.cs.

     7      7   //      All rights reserved.
     8      8   // </copyright>
     9      9   //---------------------------------------------------------------------
    10     10   
    11     11   namespace System.Data.SQLite
    12     12   {
    13     13     using System;
    14         -  using System.Collections.Generic;
    15         -  using System.Diagnostics;
    16     14     using System.Globalization;
    17         -  using System.IO;
    18         -  using System.Text;
    19         -  using System.Data.Metadata.Edm;
    20         -  using System.Data.Common.CommandTrees;
    21     15   
    22         -  /// <summary>
           16  +    /// <summary>
    23     17     /// TopClause represents the a TOP expression in a SqlSelectStatement. 
    24     18     /// It has a count property, which indicates how many TOP rows should be selected and a 
    25     19     /// boolen WithTies property.
    26     20     /// </summary>
    27     21     class TopClause : ISqlFragment
    28     22     {
    29     23       ISqlFragment topCount;

Changes to System.Data.SQLite.Linq/SQLiteProviderManifest.cs.

     8      8   namespace System.Data.SQLite
     9      9   {
    10     10     using System;
    11     11     using System.Data;
    12     12     using System.Reflection;
    13     13     using System.IO;
    14     14     using System.Xml;
    15         -  using System.Collections.Generic;
    16         -  using System.Collections.ObjectModel;
    17         -  using System.Data.EntityModel.SchemaObjectModel;
    18         -  using System.Data.EntityModel;
    19     15     using System.Data.Common;
    20         -  using System.Data.Entity;
    21     16     using System.Data.Metadata.Edm;
    22     17   
    23     18     /// <summary>
    24     19     /// The Provider Manifest for SQL Server
    25     20     /// </summary>
    26     21     internal class SQLiteProviderManifest : DbXmlEnabledProviderManifest
    27     22     {

Changes to System.Data.SQLite.Linq/SQLiteProviderServices.cs.

     9      9   {
    10     10     using System;
    11     11     using System.Data.Common;
    12     12     using System.Data.Common.CommandTrees;
    13     13     using System.Data.Metadata.Edm;
    14     14     using System.Diagnostics;
    15     15     using System.Collections.Generic;
    16         -  using System.Data.SQLite;
    17     16     using System.Text;
    18     17     using System.Globalization;
    19     18   
    20     19     internal class SQLiteProviderServices : DbProviderServices, ISQLiteSchemaExtensions
    21     20     {
    22     21       internal static readonly SQLiteProviderServices Instance = new SQLiteProviderServices();
    23     22   

Changes to System.Data.SQLite/LINQ/SQLiteFactory_Linq.cs.

    39     39         }
    40     40         return null;
    41     41       }
    42     42   
    43     43       [ReflectionPermission(SecurityAction.Assert, MemberAccess = true)]
    44     44       private object GetSQLiteProviderServicesInstance()
    45     45       {
    46         -      if (_sqliteServices == null)
    47         -      {
    48         -        Type type = Type.GetType("System.Data.SQLite.SQLiteProviderServices, System.Data.SQLite.Linq, Version=1.0.73.0, Culture=neutral, PublicKeyToken=db937bc2d44ff139", false);
    49         -        if (type != null)
           46  +        if (_sqliteServices == null)
    50     47           {
    51         -          FieldInfo field = type.GetField("Instance", BindingFlags.NonPublic | BindingFlags.Static | BindingFlags.Instance);
    52         -          _sqliteServices = field.GetValue(null);
           48  +            Version version = this.GetType().Assembly.GetName().Version;
           49  +            Type type = Type.GetType(String.Format("System.Data.SQLite.SQLiteProviderServices, System.Data.SQLite.Linq, Version={0}, Culture=neutral, PublicKeyToken=db937bc2d44ff139", version), false);
           50  +
           51  +            if (type != null)
           52  +            {
           53  +                FieldInfo field = type.GetField("Instance", BindingFlags.NonPublic | BindingFlags.Static | BindingFlags.Instance);
           54  +                _sqliteServices = field.GetValue(null);
           55  +            }
    53     56           }
    54         -      }
    55         -      return _sqliteServices;
           57  +        return _sqliteServices;
    56     58       }
    57     59     }
    58     60   }

Added exclude_bin.txt.

            1  +*.exp
            2  +*.lib
            3  +*.map
            4  +Microsoft.*

Changes to exclude_src.txt.

     8      8   _FOSSIL_
     9      9   bin/*
    10     10   Externals/*
    11     11   Membership/obj/*
    12     12   obj/*
    13     13   Setup/Output/*
    14     14   SQLite.Designer/obj/*
           15  +SQLite.Designer/Properties/*
           16  +SQLite.Designer/VSDesign/*
    15     17   System.Data.SQLite.Linq/obj/*
    16     18   System.Data.SQLite/obj/*
    17     19   System.Data.SQLite/Properties/*
    18     20   test/obj/*
    19     21   testce/obj/*
    20     22   testlinq/obj/*
    21     23   Tests/*
    22     24   tools/*
    23     25   www/*

Name change from testlinq/App.Config to testlinq/2008/App.config.

     3      3     <system.data>
     4      4       <DbProviderFactories>
     5      5         <clear />
     6      6         <add name="SQLite Data Provider" invariant="System.Data.SQLite" description=".Net Framework Data Provider for SQLite" type="System.Data.SQLite.SQLiteFactory, System.Data.SQLite, Version=1.0, Culture=neutral, PublicKeyToken=db937bc2d44ff139" />
     7      7       </DbProviderFactories>
     8      8     </system.data>
     9      9     <connectionStrings>
    10         -    <add name="northwindEFEntities" connectionString="metadata=res://*/NorthwindModel.csdl|res://*/NorthwindModel.ssdl|res://*/NorthwindModel.msl;provider=System.Data.SQLite;provider connection string=&quot;data source=.\northwindEF.db&quot;" providerName="System.Data.EntityClient" />
           10  +    <add name="northwindEFEntities" connectionString="metadata=res://*/NorthwindModel2008.csdl|res://*/NorthwindModel2008.ssdl|res://*/NorthwindModel2008.msl;provider=System.Data.SQLite;provider connection string=&quot;data source=.\northwindEF.db&quot;" providerName="System.Data.EntityClient" />
    11     11     </connectionStrings>
    12     12   </configuration>

Added testlinq/NorthwindModel2008.Designer.cs.

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

Added testlinq/NorthwindModel2008.edmx.

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

Name change from testlinq/NorthwindModel.Designer.cs to testlinq/NorthwindModel2010.Designer.cs.


Name change from testlinq/NorthwindModel.edmx to testlinq/NorthwindModel2010.edmx.


Changes to testlinq/testlinq.2008.csproj.

    14     14       <ProductVersion>9.0.30729</ProductVersion>
    15     15       <SchemaVersion>2.0</SchemaVersion>
    16     16       <ProjectGuid>{9D3CF7A6-092A-4B05-B0E4-BEF6944525B3}</ProjectGuid>
    17     17       <AppDesignerFolder>Properties</AppDesignerFolder>
    18     18       <OutputType>Exe</OutputType>
    19     19       <RootNamespace>testlinq</RootNamespace>
    20     20       <AssemblyName>testlinq</AssemblyName>
           21  +    <TargetFrameworkVersion>v3.5</TargetFrameworkVersion>
    21     22       <OldToolsVersion>2.0</OldToolsVersion>
    22     23       <SQLiteNetDir>$(MSBuildProjectDirectory)\..</SQLiteNetDir>
    23     24       <NetFx20>true</NetFx20>
    24     25       <ConfigurationYear>2008</ConfigurationYear>
    25     26     </PropertyGroup>
    26     27     <Import Project="$(SQLiteNetDir)\SQLite.NET.Settings.targets" />
    27     28     <PropertyGroup Condition="'$(BinaryOutputPath)' != ''">
................................................................................
    39     40       <DebugType>pdbonly</DebugType>
    40     41       <Optimize>true</Optimize>
    41     42       <DefineConstants>TRACE</DefineConstants>
    42     43       <ErrorReport>prompt</ErrorReport>
    43     44     </PropertyGroup>
    44     45     <ItemGroup>
    45     46       <Reference Include="System" />
           47  +    <Reference Include="System.Core" />
    46     48       <Reference Include="System.Data.Entity" />
    47     49       <Reference Include="System.Runtime.Serialization" />
    48     50       <Reference Include="System.Xml" />
    49     51       <Reference Include="System.Data" />
    50     52     </ItemGroup>
    51     53     <ItemGroup>
    52         -    <Compile Include="NorthwindModel.Designer.cs">
           54  +    <Compile Include="NorthwindModel2008.Designer.cs">
    53     55         <AutoGen>True</AutoGen>
    54     56         <DesignTime>True</DesignTime>
    55         -      <DependentUpon>NorthwindModel.edmx</DependentUpon>
           57  +      <DependentUpon>NorthwindModel2008.edmx</DependentUpon>
    56     58       </Compile>
    57     59       <Compile Include="Program.cs" />
    58     60       <Compile Include="Properties\AssemblyInfo.cs" />
    59     61     </ItemGroup>
    60     62     <ItemGroup>
    61         -    <None Include="App.Config" />
           63  +    <None Include="2008\App.Config" />
    62     64       <None Include="northwindEF.db">
    63     65         <CopyToOutputDirectory>Always</CopyToOutputDirectory>
    64     66       </None>
    65         -    <EntityDeploy Include="NorthwindModel.edmx">
           67  +    <EntityDeploy Include="NorthwindModel2008.edmx">
    66     68         <Generator>EntityModelCodeGenerator</Generator>
    67         -      <LastGenOutput>NorthwindModel.Designer.cs</LastGenOutput>
           69  +      <LastGenOutput>NorthwindModel2008.Designer.cs</LastGenOutput>
    68     70       </EntityDeploy>
    69     71     </ItemGroup>
    70     72     <ItemGroup>
    71     73       <Service Include="{C8F2D6AC-F9F4-4E40-A399-22F9A9A5CBD2}" />
    72     74     </ItemGroup>
    73     75     <Import Project="$(MSBuildBinPath)\Microsoft.CSharp.targets" />
    74     76     <!-- To modify your build process, add your task inside one of the targets below and uncomment it. 

Changes to testlinq/testlinq.2010.csproj.

    44     44       <Reference Include="System" />
    45     45       <Reference Include="System.Data.Entity" />
    46     46       <Reference Include="System.Runtime.Serialization" />
    47     47       <Reference Include="System.Xml" />
    48     48       <Reference Include="System.Data" />
    49     49     </ItemGroup>
    50     50     <ItemGroup>
    51         -    <Compile Include="NorthwindModel.Designer.cs">
           51  +    <Compile Include="NorthwindModel2010.Designer.cs">
    52     52         <AutoGen>True</AutoGen>
    53     53         <DesignTime>True</DesignTime>
    54         -      <DependentUpon>NorthwindModel.edmx</DependentUpon>
           54  +      <DependentUpon>NorthwindModel2010.edmx</DependentUpon>
    55     55       </Compile>
    56     56       <Compile Include="Program.cs" />
    57     57       <Compile Include="Properties\AssemblyInfo.cs" />
    58     58     </ItemGroup>
    59     59     <ItemGroup>
    60         -    <None Include="App.Config" />
           60  +    <None Include="2010\App.Config" />
    61     61       <None Include="northwindEF.db">
    62     62         <CopyToOutputDirectory>Always</CopyToOutputDirectory>
    63     63       </None>
    64         -    <EntityDeploy Include="NorthwindModel.edmx">
           64  +    <EntityDeploy Include="NorthwindModel2010.edmx">
    65     65         <Generator>EntityModelCodeGenerator</Generator>
    66         -      <LastGenOutput>NorthwindModel.Designer.cs</LastGenOutput>
           66  +      <LastGenOutput>NorthwindModel2010.Designer.cs</LastGenOutput>
    67     67       </EntityDeploy>
    68     68     </ItemGroup>
    69     69     <ItemGroup>
    70     70       <Service Include="{C8F2D6AC-F9F4-4E40-A399-22F9A9A5CBD2}" />
    71     71     </ItemGroup>
    72     72     <Import Project="$(MSBuildBinPath)\Microsoft.CSharp.targets" />
    73     73     <!-- To modify your build process, add your task inside one of the targets below and uncomment it. 

Changes to tools/install/Properties/AssemblyInfo.cs.

     2      2   using System.Runtime.CompilerServices;
     3      3   using System.Runtime.InteropServices;
     4      4   
     5      5   // General Information about an assembly is controlled through the following 
     6      6   // set of attributes. Change these attribute values to modify the information
     7      7   // associated with an assembly.
     8      8   [assembly: AssemblyTitle("SQLite.Designer Installer")]
     9         -[assembly: AssemblyDescription("SQLite ADO.NET 4.0 Design-Time Installer")]
            9  +[assembly: AssemblyDescription("SQLite ADO.NET Design-Time Installer")]
    10     10   [assembly: AssemblyConfiguration("")]
    11     11   [assembly: AssemblyCompany("http://system.data.sqlite.org")]
    12     12   [assembly: AssemblyProduct("SQLite Installer")]
    13     13   [assembly: AssemblyCopyright("Public Domain")]
    14     14   [assembly: AssemblyTrademark("")]
    15     15   [assembly: AssemblyCulture("")]
    16     16   

Changes to tools/setup/exe/setup/setup.rc.

    70     70    FILESUBTYPE 0x0L
    71     71   BEGIN
    72     72       BLOCK "StringFileInfo"
    73     73       BEGIN
    74     74           BLOCK "040904b0"
    75     75           BEGIN
    76     76               VALUE "Comments", "http://sqlite.phxsoftware.com"
    77         -            VALUE "FileDescription", "SQLite ADO.NET 4.0 Setup"
           77  +            VALUE "FileDescription", "SQLite ADO.NET Setup"
    78     78               VALUE "FileVersion", "1.0.67.0"
    79     79               VALUE "InternalName", "setup"
    80     80               VALUE "LegalCopyright", "Released to the public domain"
    81     81               VALUE "OriginalFilename", "setup.exe"
    82     82               VALUE "ProductName", "System.Data.SQLite"
    83     83               VALUE "ProductVersion", "1.0"
    84     84           END

Changes to tools/setup/sqlite_setup.vdproj.

   612    612           {
   613    613           "LangId" = "3:1033"
   614    614           "RequiresElevation" = "11:FALSE"
   615    615           }
   616    616           "Product"
   617    617           {
   618    618           "Name" = "8:Microsoft Visual Studio"
   619         -        "ProductName" = "8:SQLite ADO.NET 4.0 Provider"
          619  +        "ProductName" = "8:SQLite ADO.NET Provider"
   620    620           "ProductCode" = "8:{902C69AF-5B0C-4E21-89F2-064462C2BBC4}"
   621    621           "PackageCode" = "8:{73B9EABC-05DF-499D-B771-8FB6F1E5AF1B}"
   622    622           "UpgradeCode" = "8:{E779C0FF-CCE2-493A-B8C2-6DD04E26072C}"
   623    623           "AspNetVersion" = "8:4.0.30319.0"
   624    624           "RestartWWWService" = "11:FALSE"
   625    625           "RemovePreviousVersions" = "11:TRUE"
   626    626           "DetectNewerInstalledVersion" = "11:TRUE"
   627    627           "InstallAllUsers" = "11:TRUE"
   628    628           "ProductVersion" = "8:1.066.1"
   629    629           "Manufacturer" = "8:Phoenix Software Solutions, LLC"
   630    630           "ARPHELPTELEPHONE" = "8:"
   631    631           "ARPHELPLINK" = "8:http://sqlite.phxsoftware.com"
   632         -        "Title" = "8:SQLite ADO.NET 4.0 Provider"
          632  +        "Title" = "8:SQLite ADO.NET Provider"
   633    633           "Subject" = "8:"
   634    634           "ARPCONTACT" = "8:Phoenix Software Solutions, LLC"
   635    635           "Keywords" = "8:"
   636    636           "ARPCOMMENTS" = "8:"
   637    637           "ARPURLINFOABOUT" = "8:"
   638    638           "ARPPRODUCTICON" = "8:"
   639    639           "ARPIconIndex" = "3:0"