MARKUS

<?xml version="1.0"?>

<!-- For more information on using app.config transformation visit http://go.microsoft.com/fwlink/?LinkId=125889 -->

<!-- In case configuration is not the root element, replace it with root element in source configuration file -->

<configuration xmlns:xdt="http://schemas.microsoft.com/XML-Document-Transform">

</configuration>

<?xml version="1.0"?>

<!-- For more information on using app.config transformation visit http://go.microsoft.com/fwlink/?LinkId=125889 -->

<!-- In case configuration is not the root element, replace it with root element in source configuration file -->

<configuration xmlns:xdt="http://schemas.microsoft.com/XML-Document-Transform">

</configuration>

<?xml version="1.0" encoding="utf-8"?>

<configuration>

  <configSections></configSections>

  <connectionStrings>

    <add name="ColorList.Properties.Settings.설정" connectionString="Data Source=192.168.0.67;Initial Catalog=markus;Persist Security Info=True;User ID=doftech;Password=dof1073#" providerName="System.Data.SqlClient" />

    <add name="markusEntities" connectionString="metadata=res://*/ModelMarkus.csdl|res://*/ModelMarkus.ssdl|res://*/ModelMarkus.msl;provider=System.Data.SqlClient;provider connection string=&quot;data source=192.168.0.67;initial catalog=markus;persist security info=True;user id=doftech;password=dof1073#;MultipleActiveResultSets=True;App=EntityFramework&quot;" providerName="System.Data.EntityClient" />

  </connectionStrings>

  <startup>

    <supportedRuntime version="v4.0" sku=".NETFramework,Version=v4.6.1" />

  </startup>

</configuration>

<Application

    x:Class="ColorList.App"

    xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"

    xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"

    xmlns:local="clr-namespace:ColorList"

    StartupUri="MainWindow.xaml">

    <Application.Resources />

</Application>

using System;

using System.Collections.Generic;

using System.Configuration;

using System.Data;

using System.Linq;

using System.Threading.Tasks;

using System.Windows;

namespace ColorList

{

    /// <summary>

    /// App.xaml에 대한 상호 작용 논리

    /// </summary>

    public partial class App : Application

    {

    }

}

<?xml version="1.0" encoding="utf-8"?>

<Project ToolsVersion="15.0" xmlns="http://schemas.microsoft.com/developer/msbuild/2003">

  <Import Project="$(MSBuildExtensionsPath)\$(MSBuildToolsVersion)\Microsoft.Common.props" Condition="Exists('$(MSBuildExtensionsPath)\$(MSBuildToolsVersion)\Microsoft.Common.props')" />

  <PropertyGroup>

    <Configuration Condition=" '$(Configuration)' == '' ">Debug</Configuration>

    <Platform Condition=" '$(Platform)' == '' ">AnyCPU</Platform>

    <ProjectGuid>{AC15A6B9-8556-4492-A1D7-DA16F00EF86B}</ProjectGuid>

    <OutputType>WinExe</OutputType>

    <RootNamespace>ColorList</RootNamespace>

    <AssemblyName>ColorList</AssemblyName>

    <TargetFrameworkVersion>v4.6.1</TargetFrameworkVersion>

    <FileAlignment>512</FileAlignment>

    <ProjectTypeGuids>{60dc8134-eba5-43b8-bcc9-bb4bc16c2548};{FAE04EC0-301F-11D3-BF4B-00C04F79EFBC}</ProjectTypeGuids>

    <WarningLevel>4</WarningLevel>

    <AutoGenerateBindingRedirects>true</AutoGenerateBindingRedirects>

    <Deterministic>true</Deterministic>

    <TargetFrameworkProfile />

  </PropertyGroup>

  <PropertyGroup Condition=" '$(Configuration)|$(Platform)' == 'Debug|AnyCPU' ">

    <PlatformTarget>AnyCPU</PlatformTarget>

    <DebugSymbols>true</DebugSymbols>

    <DebugType>full</DebugType>

    <Optimize>false</Optimize>

    <OutputPath>bin\Debug\</OutputPath>

    <DefineConstants>DEBUG;TRACE</DefineConstants>

    <ErrorReport>prompt</ErrorReport>

    <WarningLevel>4</WarningLevel>

  </PropertyGroup>

  <PropertyGroup Condition=" '$(Configuration)|$(Platform)' == 'Release|AnyCPU' ">

    <PlatformTarget>AnyCPU</PlatformTarget>

    <DebugType>pdbonly</DebugType>

    <Optimize>true</Optimize>

    <OutputPath>bin\Release\</OutputPath>

    <DefineConstants>TRACE</DefineConstants>

    <ErrorReport>prompt</ErrorReport>

    <WarningLevel>4</WarningLevel>

  </PropertyGroup>

  <ItemGroup>

    <Reference Include="System" />

    <Reference Include="System.Data" />

    <Reference Include="System.Runtime.Serialization" />

    <Reference Include="System.Security" />

    <Reference Include="System.Xml" />

    <Reference Include="Microsoft.CSharp" />

    <Reference Include="System.Core" />

    <Reference Include="System.Xml.Linq" />

    <Reference Include="System.Data.DataSetExtensions" />

    <Reference Include="System.Net.Http" />

    <Reference Include="System.Xaml">

      <RequiredTargetFramework>4.0</RequiredTargetFramework>

    </Reference>

    <Reference Include="Telerik.Windows.Controls, Version=2019.3.917.45, Culture=neutral, PublicKeyToken=5803cfa389c90ce7, processorArchitecture=MSIL">

      <HintPath>..\lib\RCWPF\2019.3.917.45\Telerik.Windows.Controls.dll</HintPath>

      <Private>True</Private>

    </Reference>

    <Reference Include="Telerik.Windows.Controls.Docking, Version=2019.3.917.45, Culture=neutral, PublicKeyToken=5803cfa389c90ce7, processorArchitecture=MSIL">

      <HintPath>..\lib\RCWPF\2019.3.917.45\Telerik.Windows.Controls.Docking.dll</HintPath>

      <Private>True</Private>

    </Reference>

    <Reference Include="Telerik.Windows.Controls.Input, Version=2019.3.917.45, Culture=neutral, PublicKeyToken=5803cfa389c90ce7, processorArchitecture=MSIL">

      <HintPath>..\lib\RCWPF\2019.3.917.45\Telerik.Windows.Controls.Input.dll</HintPath>

      <Private>True</Private>

    </Reference>

    <Reference Include="Telerik.Windows.Controls.Navigation, Version=2019.3.917.45, Culture=neutral, PublicKeyToken=5803cfa389c90ce7, processorArchitecture=MSIL">

      <HintPath>..\lib\RCWPF\2019.3.917.45\Telerik.Windows.Controls.Navigation.dll</HintPath>

      <Private>True</Private>

    </Reference>

    <Reference Include="Telerik.Windows.Data, Version=2019.3.917.45, Culture=neutral, PublicKeyToken=5803cfa389c90ce7, processorArchitecture=MSIL">

      <HintPath>..\lib\RCWPF\2019.3.917.45\Telerik.Windows.Data.dll</HintPath>

      <Private>True</Private>

    </Reference>

    <Reference Include="WindowsBase" />

    <Reference Include="PresentationCore" />

    <Reference Include="PresentationFramework" />

  </ItemGroup>

  <ItemGroup>

    <ApplicationDefinition Include="App.xaml">

      <Generator>MSBuild:Compile</Generator>

      <SubType>Designer</SubType>

    </ApplicationDefinition>

    <Compile Include="MainWindow.xaml.cs">

      <DependentUpon>MainWindow.xaml</DependentUpon>

    </Compile>

    <Compile Include="App.xaml.cs">

      <DependentUpon>App.xaml</DependentUpon>

      <SubType>Code</SubType>

    </Compile>

    <Compile Include="RaisePropertyChange.cs" />

    <Page Include="MainWindow.xaml">

      <Generator>MSBuild:Compile</Generator>

      <SubType>Designer</SubType>

    </Page>

  </ItemGroup>

  <ItemGroup>

    <Compile Include="ModelMarkus.Context.cs">

      <AutoGen>True</AutoGen>

      <DesignTime>True</DesignTime>

      <DependentUpon>ModelMarkus.Context.tt</DependentUpon>

    </Compile>

    <Compile Include="ModelMarkus.cs">

      <AutoGen>True</AutoGen>

      <DesignTime>True</DesignTime>

      <DependentUpon>ModelMarkus.tt</DependentUpon>

    </Compile>

    <Compile Include="ModelMarkus.Designer.cs">

      <AutoGen>True</AutoGen>

      <DesignTime>True</DesignTime>

      <DependentUpon>ModelMarkus.edmx</DependentUpon>

    </Compile>

    <Compile Include="PROPERTIES.cs">

      <DependentUpon>ModelMarkus.tt</DependentUpon>

    </Compile>

    <Compile Include="Properties\AssemblyInfo.cs">

      <SubType>Code</SubType>

    </Compile>

    <Compile Include="Properties\Resources.Designer.cs">

      <AutoGen>True</AutoGen>

      <DesignTime>True</DesignTime>

      <DependentUpon>Resources.resx</DependentUpon>

    </Compile>

    <Compile Include="Properties\Settings.Designer.cs">

      <AutoGen>True</AutoGen>

      <DependentUpon>Settings.settings</DependentUpon>

      <DesignTimeSharedInput>True</DesignTimeSharedInput>

    </Compile>

    <EmbeddedResource Include="Properties\Resources.resx">

      <Generator>ResXFileCodeGenerator</Generator>

      <LastGenOutput>Resources.Designer.cs</LastGenOutput>

    </EmbeddedResource>

    <None Include="App.Debug.config">

      <DependentUpon>App.config</DependentUpon>

    </None>

    <None Include="App.Release.config">

      <DependentUpon>App.config</DependentUpon>

    </None>

    <EntityDeploy Include="ModelMarkus.edmx">

      <Generator>EntityModelCodeGenerator</Generator>

      <LastGenOutput>ModelMarkus.Designer.cs</LastGenOutput>

    </EntityDeploy>

    <None Include="ModelMarkus.edmx.diagram">

      <DependentUpon>ModelMarkus.edmx</DependentUpon>

    </None>

    <None Include="Properties\Settings.settings">

      <Generator>SettingsSingleFileGenerator</Generator>

      <LastGenOutput>Settings.Designer.cs</LastGenOutput>

    </None>

  </ItemGroup>

  <ItemGroup>

    <None Include="App.config" />

  </ItemGroup>

  <ItemGroup>

    <Resource Include="sample.png" />

  </ItemGroup>

  <ItemGroup>

    <ProjectReference Include="..\ZoomAndPan\ZoomAndPan.csproj">

      <Project>{6c950af4-04d2-4638-8b78-472e39f78b45}</Project>

      <Name>ZoomAndPan</Name>

    </ProjectReference>

  </ItemGroup>

  <ItemGroup>

    <Content Include="ModelMarkus.Context.tt">

      <Generator>TextTemplatingFileGenerator</Generator>

      <DependentUpon>ModelMarkus.edmx</DependentUpon>

      <LastGenOutput>ModelMarkus.Context.cs</LastGenOutput>

    </Content>

    <Content Include="ModelMarkus.tt">

      <Generator>TextTemplatingFileGenerator</Generator>

      <DependentUpon>ModelMarkus.edmx</DependentUpon>

      <LastGenOutput>ModelMarkus.cs</LastGenOutput>

    </Content>

  </ItemGroup>

  <ItemGroup>

    <PackageReference Include="EntityFramework">

      <Version>6.2.0</Version>

    </PackageReference>

    <PackageReference Include="EntityFramework.ko">

      <Version>6.2.0</Version>

    </PackageReference>

  </ItemGroup>

  <ItemGroup>

    <Service Include="{508349B6-6B84-4DF5-91F0-309BEEBAD82D}" />

  </ItemGroup>

  <Import Project="$(MSBuildToolsPath)\Microsoft.CSharp.targets" />

</Project>

<Window

    x:Class="ColorList.MainWindow"

    xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"

    xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"

    xmlns:ZoomAndPan="clr-namespace:ZoomAndPan;assembly=ZoomAndPan"

    xmlns:d="http://schemas.microsoft.com/expression/blend/2008"

    xmlns:mc="http://schemas.openxmlformats.org/markup-compatibility/2006"

    xmlns:telerik="http://schemas.telerik.com/2008/xaml/presentation"

    Title="Color List"

    Width="600"

    Height="600">

    <Grid>

        <Grid.RowDefinitions>

            <RowDefinition Height="Auto" />

            <RowDefinition />

        </Grid.RowDefinitions>

        <Grid.ColumnDefinitions>

            <ColumnDefinition Width="Auto" MinWidth="150" />

            <ColumnDefinition />

        </Grid.ColumnDefinitions>

        <ZoomAndPan:ZoomAndPanControl

            x:Name="zoomAndPanControl"

            Grid.Row="1"

            Grid.Column="1"

            Background="LightGray"

            ConstrainedContentViewportHeight="{Binding ActualHeight, ElementName=image, Mode=OneWay}"

            ConstrainedContentViewportWidth="{Binding ActualWidth, ElementName=image, Mode=OneWay}"

            ContentScale="1"

            MouseWheel="zoomAndPanControl_MouseWheel">

            <Canvas x:Name="canvas">

                <Canvas.RenderTransform>

                    <TransformGroup>

                        <RotateTransform x:Name="rotate" Angle="0" />

                        <TranslateTransform x:Name="translate" X="1" Y="1" />

                    </TransformGroup>

                </Canvas.RenderTransform>

                <Image

                    x:Name="image"

                    Canvas.Left="-226"

                    Canvas.Top="-340"

                    Source="/sample.png"

                    Stretch="None" />

            </Canvas>

        </ZoomAndPan:ZoomAndPanControl>

        <StackPanel Margin="5">

            <Button

                Width="100"

                Height="24"

                Click="Button_Click"

                Content="Save" />

        </StackPanel>

        <telerik:RadListBox x:Name="listBox" Grid.Row="1">

            <telerik:RadListBox.ItemTemplate>

                <DataTemplate>

                    <StackPanel>

                        <Border

                            Background="{Binding Color}"

                            BorderBrush="#FFE0E0E0"

                            BorderThickness="1" />

                        <TextBlock Text="{Binding Inx}" />

                    </StackPanel>

                </DataTemplate>

            </telerik:RadListBox.ItemTemplate>

        </telerik:RadListBox>

    </Grid>

</Window>

using System;

using System.Collections.Generic;

using System.Linq;

using System.Text;

using System.Windows;

using System.Windows.Controls;

using System.Windows.Data;

using System.Windows.Documents;

using System.Windows.Input;

using System.Windows.Media;

using System.Windows.Media.Imaging;

using System.Windows.Shapes;

using Telerik.Windows.Controls;

namespace ColorList

{

    /// <summary>

    /// Interaction logic for Window.xaml

    /// </summary>

    public partial class MainWindow : Window

    {

        public const string DISPLAY_COLOR = "DisplayColor";

        public MainWindow()

        {

            InitializeComponent();

            using(markusEntities entities = new markusEntities())

            {

                listBox.ItemsSource = entities.PROPERTIES.Where(x => x.TYPE == DISPLAY_COLOR).Select((x,inx) => new ColorItem {Inx = inx,Color = x.VALUE });

            }

        }

        private void zoomAndPanControl_MouseWheel(object sender, MouseWheelEventArgs e)

        {

            e.Handled = true;

            if (e.Delta > 0)

            {

                Point currentContentMousePoint = e.GetPosition(canvas);

                ZoomIn(currentContentMousePoint);

            }

            else

            {

                Point currentContentMousePoint = e.GetPosition(canvas);

                ZoomOut(currentContentMousePoint);

                }

        }

        private void ZoomOut(Point contentZoomCenter)

        {

            if (zoomAndPanControl.ContentScale > 0.39)

            {

                zoomAndPanControl.ZoomAboutPoint(zoomAndPanControl.ContentScale - 0.2, contentZoomCenter);

            }

            else

            {

                zoomAndPanControl.ZoomAboutPoint(zoomAndPanControl.ContentScale / 2, contentZoomCenter);

            }

        }

        private void ZoomIn(Point contentZoomCenter)

        {

            if (zoomAndPanControl.ContentScale > 0.19)

            {

                zoomAndPanControl.ZoomAboutPoint(zoomAndPanControl.ContentScale + 0.2, contentZoomCenter);

            }

            else

            {

                zoomAndPanControl.ZoomAboutPoint(zoomAndPanControl.ContentScale * 2, contentZoomCenter);

            }

        }

        private async void Button_Click(object sender, RoutedEventArgs e)

        {

            using (markusEntities entities = new markusEntities())

            {

                foreach (var item in listBox.ItemsSource.Cast<ColorItem>())

                {

                    var result = await entities.PROPERTIES.FindAsync(item.ID);

                    if(result != null)

                    {

                        result.VALUE = item.Color;

                    }

                }

                 var value = await entities.SaveChangesAsync();

                if(value > -1)

                {

                }

            } 

        }

    }

    public class ColorItem : NotifyPropertyChange

    {

        private int id;

        private int inx;

        private string color;

        public int ID { get => id; set => SetProperty(ref id, value); }

        public int Inx { get => inx; set => SetProperty(ref inx, value); }

        public string Color { get => color; set => SetProperty(ref color, value); }

    }

}

//------------------------------------------------------------------------------

// <auto-generated>

//     이 코드는 템플릿에서 생성되었습니다.

//

//     이 파일을 수동으로 변경하면 응용 프로그램에서 예기치 않은 동작이 발생할 수 있습니다.

//     이 파일을 수동으로 변경하면 코드가 다시 생성될 때 변경 내용을 덮어씁니다.

// </auto-generated>

//------------------------------------------------------------------------------

namespace ColorList

{

    using System;

    using System.Data.Entity;

    using System.Data.Entity.Infrastructure;

    public partial class markusEntities : DbContext

    {

        public markusEntities()

            : base("name=markusEntities")

        {

        }

        protected override void OnModelCreating(DbModelBuilder modelBuilder)

        {

            throw new UnintentionalCodeFirstException();

        }

        public virtual DbSet<PROPERTIES> PROPERTIES { get; set; }

    }

}

<#@ template language="C#" debug="false" hostspecific="true"#>

<#@ include file="EF6.Utility.CS.ttinclude"#><#@

 output extension=".cs"#><#

const string inputFile = @"ModelMarkus.edmx";

var textTransform = DynamicTextTransformation.Create(this);

var code = new CodeGenerationTools(this);

var ef = new MetadataTools(this);

var typeMapper = new TypeMapper(code, ef, textTransform.Errors);

var loader = new EdmMetadataLoader(textTransform.Host, textTransform.Errors);

var itemCollection = loader.CreateEdmItemCollection(inputFile);

var modelNamespace = loader.GetModelNamespace(inputFile);

var codeStringGenerator = new CodeStringGenerator(code, typeMapper, ef);

var container = itemCollection.OfType<EntityContainer>().FirstOrDefault();

if (container == null)

{

    return string.Empty;

}

#>

//------------------------------------------------------------------------------

// <auto-generated>

// <#=CodeGenerationTools.GetResourceString("Template_GeneratedCodeCommentLine1")#>

//

// <#=CodeGenerationTools.GetResourceString("Template_GeneratedCodeCommentLine2")#>

// <#=CodeGenerationTools.GetResourceString("Template_GeneratedCodeCommentLine3")#>

// </auto-generated>

//------------------------------------------------------------------------------

<#

var codeNamespace = code.VsNamespaceSuggestion();

if (!String.IsNullOrEmpty(codeNamespace))

{

#>

namespace <#=code.EscapeNamespace(codeNamespace)#>

{

<#

    PushIndent("    ");

}

#>

using System;

using System.Data.Entity;

using System.Data.Entity.Infrastructure;

<#

if (container.FunctionImports.Any())

{

#>

using System.Data.Entity.Core.Objects;

using System.Linq;

<#

}

#>

<#=Accessibility.ForType(container)#> partial class <#=code.Escape(container)#> : DbContext

{

    public <#=code.Escape(container)#>()

        : base("name=<#=container.Name#>")

    {

<#

if (!loader.IsLazyLoadingEnabled(container))

{

#>

        this.Configuration.LazyLoadingEnabled = false;

<#

}

foreach (var entitySet in container.BaseEntitySets.OfType<EntitySet>())

{

    // Note: the DbSet members are defined below such that the getter and

    // setter always have the same accessibility as the DbSet definition

    if (Accessibility.ForReadOnlyProperty(entitySet) != "public")

    {

#>

        <#=codeStringGenerator.DbSetInitializer(entitySet)#>

<#

    }

}

#>

    }

    protected override void OnModelCreating(DbModelBuilder modelBuilder)

    {

        throw new UnintentionalCodeFirstException();

    }

<#

    foreach (var entitySet in container.BaseEntitySets.OfType<EntitySet>())

    {

#>

    <#=codeStringGenerator.DbSet(entitySet)#>

<#

    }

    foreach (var edmFunction in container.FunctionImports)

    {

        WriteFunctionImport(typeMapper, codeStringGenerator, edmFunction, modelNamespace, includeMergeOption: false);

    }

#>

}

<#

if (!String.IsNullOrEmpty(codeNamespace))

{

    PopIndent();

#>

}

<#

}

#>

<#+

private void WriteFunctionImport(TypeMapper typeMapper, CodeStringGenerator codeStringGenerator, EdmFunction edmFunction, string modelNamespace, bool includeMergeOption)

{

    if (typeMapper.IsComposable(edmFunction))

    {

#>

    [DbFunction("<#=edmFunction.NamespaceName#>", "<#=edmFunction.Name#>")]

    <#=codeStringGenerator.ComposableFunctionMethod(edmFunction, modelNamespace)#>

    {

<#+

        codeStringGenerator.WriteFunctionParameters(edmFunction, WriteFunctionParameter);

#>

        <#=codeStringGenerator.ComposableCreateQuery(edmFunction, modelNamespace)#>

    }

<#+

    }

    else

    {

#>

    <#=codeStringGenerator.FunctionMethod(edmFunction, modelNamespace, includeMergeOption)#>

    {

<#+

        codeStringGenerator.WriteFunctionParameters(edmFunction, WriteFunctionParameter);

#>

        <#=codeStringGenerator.ExecuteFunction(edmFunction, modelNamespace, includeMergeOption)#>

    }

<#+

        if (typeMapper.GenerateMergeOptionFunction(edmFunction, includeMergeOption))

        {

            WriteFunctionImport(typeMapper, codeStringGenerator, edmFunction, modelNamespace, includeMergeOption: true);

        }

    }

}

public void WriteFunctionParameter(string name, string isNotNull, string notNullInit, string nullInit)

{

#>

        var <#=name#> = <#=isNotNull#> ?

            <#=notNullInit#> :

            <#=nullInit#>;

<#+

}

public const string TemplateId = "CSharp_DbContext_Context_EF6";

public class CodeStringGenerator

{

    private readonly CodeGenerationTools _code;

    private readonly TypeMapper _typeMapper;

    private readonly MetadataTools _ef;

    public CodeStringGenerator(CodeGenerationTools code, TypeMapper typeMapper, MetadataTools ef)

    {

        ArgumentNotNull(code, "code");

        ArgumentNotNull(typeMapper, "typeMapper");

        ArgumentNotNull(ef, "ef");

        _code = code;

        _typeMapper = typeMapper;

        _ef = ef;

    }

    public string Property(EdmProperty edmProperty)

    {

        return string.Format(

            CultureInfo.InvariantCulture,

            "{0} {1} {2} {{ {3}get; {4}set; }}",

            Accessibility.ForProperty(edmProperty),

            _typeMapper.GetTypeName(edmProperty.TypeUsage),

            _code.Escape(edmProperty),

            _code.SpaceAfter(Accessibility.ForGetter(edmProperty)),

            _code.SpaceAfter(Accessibility.ForSetter(edmProperty)));

    }

    public string NavigationProperty(NavigationProperty navProp)

    {

        var endType = _typeMapper.GetTypeName(navProp.ToEndMember.GetEntityType());

        return string.Format(

            CultureInfo.InvariantCulture,

            "{0} {1} {2} {{ {3}get; {4}set; }}",

            AccessibilityAndVirtual(Accessibility.ForNavigationProperty(navProp)),

            navProp.ToEndMember.RelationshipMultiplicity == RelationshipMultiplicity.Many ? ("ICollection<" + endType + ">") : endType,

            _code.Escape(navProp),

            _code.SpaceAfter(Accessibility.ForGetter(navProp)),

            _code.SpaceAfter(Accessibility.ForSetter(navProp)));

    }

    public string AccessibilityAndVirtual(string accessibility)

    {

        return accessibility + (accessibility != "private" ? " virtual" : "");

    }

    public string EntityClassOpening(EntityType entity)

    {

        return string.Format(

            CultureInfo.InvariantCulture,

            "{0} {1}partial class {2}{3}",

            Accessibility.ForType(entity),

            _code.SpaceAfter(_code.AbstractOption(entity)),

            _code.Escape(entity),

            _code.StringBefore(" : ", _typeMapper.GetTypeName(entity.BaseType)));

    }

    public string EnumOpening(SimpleType enumType)

    {

        return string.Format(

            CultureInfo.InvariantCulture,

            "{0} enum {1} : {2}",

            Accessibility.ForType(enumType),

            _code.Escape(enumType),

            _code.Escape(_typeMapper.UnderlyingClrType(enumType)));

        }

    public void WriteFunctionParameters(EdmFunction edmFunction, Action<string, string, string, string> writeParameter)

    {

        var parameters = FunctionImportParameter.Create(edmFunction.Parameters, _code, _ef);

        foreach (var parameter in parameters.Where(p => p.NeedsLocalVariable))

        {

            var isNotNull = parameter.IsNullableOfT ? parameter.FunctionParameterName + ".HasValue" : parameter.FunctionParameterName + " != null";

            var notNullInit = "new ObjectParameter(\"" + parameter.EsqlParameterName + "\", " + parameter.FunctionParameterName + ")";

            var nullInit = "new ObjectParameter(\"" + parameter.EsqlParameterName + "\", typeof(" + TypeMapper.FixNamespaces(parameter.RawClrTypeName) + "))";

            writeParameter(parameter.LocalVariableName, isNotNull, notNullInit, nullInit);

        }

    }

    public string ComposableFunctionMethod(EdmFunction edmFunction, string modelNamespace)

    {

        var parameters = _typeMapper.GetParameters(edmFunction);

        return string.Format(

            CultureInfo.InvariantCulture,

            "{0} IQueryable<{1}> {2}({3})",

            AccessibilityAndVirtual(Accessibility.ForMethod(edmFunction)),

            _typeMapper.GetTypeName(_typeMapper.GetReturnType(edmFunction), modelNamespace),

            _code.Escape(edmFunction),

            string.Join(", ", parameters.Select(p => TypeMapper.FixNamespaces(p.FunctionParameterType) + " " + p.FunctionParameterName).ToArray()));

    }

    public string ComposableCreateQuery(EdmFunction edmFunction, string modelNamespace)

    {

        var parameters = _typeMapper.GetParameters(edmFunction);

        return string.Format(

            CultureInfo.InvariantCulture,

            "return ((IObjectContextAdapter)this).ObjectContext.CreateQuery<{0}>(\"[{1}].[{2}]({3})\"{4});",

            _typeMapper.GetTypeName(_typeMapper.GetReturnType(edmFunction), modelNamespace),

            edmFunction.NamespaceName,

            edmFunction.Name,

            string.Join(", ", parameters.Select(p => "@" + p.EsqlParameterName).ToArray()),

            _code.StringBefore(", ", string.Join(", ", parameters.Select(p => p.ExecuteParameterName).ToArray())));

    }

    public string FunctionMethod(EdmFunction edmFunction, string modelNamespace, bool includeMergeOption)

    {

        var parameters = _typeMapper.GetParameters(edmFunction);

        var returnType = _typeMapper.GetReturnType(edmFunction);

        var paramList = String.Join(", ", parameters.Select(p => TypeMapper.FixNamespaces(p.FunctionParameterType) + " " + p.FunctionParameterName).ToArray());

        if (includeMergeOption)

        {

            paramList = _code.StringAfter(paramList, ", ") + "MergeOption mergeOption";

        }

        return string.Format(

            CultureInfo.InvariantCulture,

            "{0} {1} {2}({3})",

            AccessibilityAndVirtual(Accessibility.ForMethod(edmFunction)),

            returnType == null ? "int" : "ObjectResult<" + _typeMapper.GetTypeName(returnType, modelNamespace) + ">",

            _code.Escape(edmFunction),

            paramList);

    }

    public string ExecuteFunction(EdmFunction edmFunction, string modelNamespace, bool includeMergeOption)

    {

        var parameters = _typeMapper.GetParameters(edmFunction);

        var returnType = _typeMapper.GetReturnType(edmFunction);

        var callParams = _code.StringBefore(", ", String.Join(", ", parameters.Select(p => p.ExecuteParameterName).ToArray()));

        if (includeMergeOption)

        {

            callParams = ", mergeOption" + callParams;

        }

        return string.Format(

            CultureInfo.InvariantCulture,

            "return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction{0}(\"{1}\"{2});",

            returnType == null ? "" : "<" + _typeMapper.GetTypeName(returnType, modelNamespace) + ">",

            edmFunction.Name,

            callParams);

    }

    public string DbSet(EntitySet entitySet)

    {

        return string.Format(

            CultureInfo.InvariantCulture,

            "{0} virtual DbSet<{1}> {2} {{ get; set; }}",

            Accessibility.ForReadOnlyProperty(entitySet),

            _typeMapper.GetTypeName(entitySet.ElementType),

            _code.Escape(entitySet));

    }

    public string DbSetInitializer(EntitySet entitySet)

    {

        return string.Format(

            CultureInfo.InvariantCulture,

            "{0} = Set<{1}>();",

            _code.Escape(entitySet),

            _typeMapper.GetTypeName(entitySet.ElementType));

    }

    public string UsingDirectives(bool inHeader, bool includeCollections = true)

    {

        return inHeader == string.IsNullOrEmpty(_code.VsNamespaceSuggestion())

            ? string.Format(

                CultureInfo.InvariantCulture,

                "{0}using System;{1}" +

                "{2}",

                inHeader ? Environment.NewLine : "",

                includeCollections ? (Environment.NewLine + "using System.Collections.Generic;") : "",

                inHeader ? "" : Environment.NewLine)

            : "";

    }

}

public class TypeMapper

{

    private const string ExternalTypeNameAttributeName = @"http://schemas.microsoft.com/ado/2006/04/codegeneration:ExternalTypeName";

    private readonly System.Collections.IList _errors;

    private readonly CodeGenerationTools _code;

    private readonly MetadataTools _ef;

    public static string FixNamespaces(string typeName)

    {

        return typeName.Replace("System.Data.Spatial.", "System.Data.Entity.Spatial.");

    }

    public TypeMapper(CodeGenerationTools code, MetadataTools ef, System.Collections.IList errors)

    {

        ArgumentNotNull(code, "code");

        ArgumentNotNull(ef, "ef");

        ArgumentNotNull(errors, "errors");

        _code = code;

        _ef = ef;

        _errors = errors;

    }

    public string GetTypeName(TypeUsage typeUsage)

    {

        return typeUsage == null ? null : GetTypeName(typeUsage.EdmType, _ef.IsNullable(typeUsage), modelNamespace: null);

    }

    public string GetTypeName(EdmType edmType)

    {

        return GetTypeName(edmType, isNullable: null, modelNamespace: null);

    }

    public string GetTypeName(TypeUsage typeUsage, string modelNamespace)

    {

        return typeUsage == null ? null : GetTypeName(typeUsage.EdmType, _ef.IsNullable(typeUsage), modelNamespace);

    }

    public string GetTypeName(EdmType edmType, string modelNamespace)

    {

        return GetTypeName(edmType, isNullable: null, modelNamespace: modelNamespace);

    }

    public string GetTypeName(EdmType edmType, bool? isNullable, string modelNamespace)

    {

        if (edmType == null)

        {

            return null;

        }

        var collectionType = edmType as CollectionType;

        if (collectionType != null)

        {

            return String.Format(CultureInfo.InvariantCulture, "ICollection<{0}>", GetTypeName(collectionType.TypeUsage, modelNamespace));

        }

        var typeName = _code.Escape(edmType.MetadataProperties

                                .Where(p => p.Name == ExternalTypeNameAttributeName)

                                .Select(p => (string)p.Value)

                                .FirstOrDefault())

            ?? (modelNamespace != null && edmType.NamespaceName != modelNamespace ?

                _code.CreateFullName(_code.EscapeNamespace(edmType.NamespaceName), _code.Escape(edmType)) :

                _code.Escape(edmType));

        if (edmType is StructuralType)

        {

            return typeName;

        }

        if (edmType is SimpleType)

        {

            var clrType = UnderlyingClrType(edmType);

            if (!IsEnumType(edmType))

            {

                typeName = _code.Escape(clrType);

            }

            typeName = FixNamespaces(typeName);

            return clrType.IsValueType && isNullable == true ?

                String.Format(CultureInfo.InvariantCulture, "Nullable<{0}>", typeName) :

                typeName;

        }

        throw new ArgumentException("edmType");

    }

    public Type UnderlyingClrType(EdmType edmType)

    {

        ArgumentNotNull(edmType, "edmType");

        var primitiveType = edmType as PrimitiveType;

        if (primitiveType != null)

        {

            return primitiveType.ClrEquivalentType;

        }

        if (IsEnumType(edmType))

        {

            return GetEnumUnderlyingType(edmType).ClrEquivalentType;

        }

        return typeof(object);

    }

    public object GetEnumMemberValue(MetadataItem enumMember)

    {

        ArgumentNotNull(enumMember, "enumMember");

        var valueProperty = enumMember.GetType().GetProperty("Value");

        return valueProperty == null ? null : valueProperty.GetValue(enumMember, null);

    }

    public string GetEnumMemberName(MetadataItem enumMember)

    {

        ArgumentNotNull(enumMember, "enumMember");

        var nameProperty = enumMember.GetType().GetProperty("Name");

        return nameProperty == null ? null : (string)nameProperty.GetValue(enumMember, null);

    }

    public System.Collections.IEnumerable GetEnumMembers(EdmType enumType)

    {

        ArgumentNotNull(enumType, "enumType");

        var membersProperty = enumType.GetType().GetProperty("Members");

        return membersProperty != null 

            ? (System.Collections.IEnumerable)membersProperty.GetValue(enumType, null)

            : Enumerable.Empty<MetadataItem>();

    }

    public bool EnumIsFlags(EdmType enumType)

    {

        ArgumentNotNull(enumType, "enumType");

        var isFlagsProperty = enumType.GetType().GetProperty("IsFlags");

        return isFlagsProperty != null && (bool)isFlagsProperty.GetValue(enumType, null);

    }

    public bool IsEnumType(GlobalItem edmType)

    {

        ArgumentNotNull(edmType, "edmType");

        return edmType.GetType().Name == "EnumType";

    }

    public PrimitiveType GetEnumUnderlyingType(EdmType enumType)

    {

        ArgumentNotNull(enumType, "enumType");

        return (PrimitiveType)enumType.GetType().GetProperty("UnderlyingType").GetValue(enumType, null);

    }

    public string CreateLiteral(object value)

    {

        if (value == null || value.GetType() != typeof(TimeSpan))

        {

            return _code.CreateLiteral(value);

        }

        return string.Format(CultureInfo.InvariantCulture, "new TimeSpan({0})", ((TimeSpan)value).Ticks);

    }

    public bool VerifyCaseInsensitiveTypeUniqueness(IEnumerable<string> types, string sourceFile)

    {

        ArgumentNotNull(types, "types");

        ArgumentNotNull(sourceFile, "sourceFile");

        var hash = new HashSet<string>(StringComparer.InvariantCultureIgnoreCase);

        if (types.Any(item => !hash.Add(item)))

        {

            _errors.Add(

                new CompilerError(sourceFile, -1, -1, "6023",

                    String.Format(CultureInfo.CurrentCulture, CodeGenerationTools.GetResourceString("Template_CaseInsensitiveTypeConflict"))));

            return false;

        }

        return true;

    }

    public IEnumerable<SimpleType> GetEnumItemsToGenerate(IEnumerable<GlobalItem> itemCollection)

    {

        return GetItemsToGenerate<SimpleType>(itemCollection)

            .Where(e => IsEnumType(e));

    }

    public IEnumerable<T> GetItemsToGenerate<T>(IEnumerable<GlobalItem> itemCollection) where T: EdmType

    {

        return itemCollection

            .OfType<T>()

            .Where(i => !i.MetadataProperties.Any(p => p.Name == ExternalTypeNameAttributeName))

            .OrderBy(i => i.Name);

    }

    public IEnumerable<string> GetAllGlobalItems(IEnumerable<GlobalItem> itemCollection)

    {

        return itemCollection

            .Where(i => i is EntityType || i is ComplexType || i is EntityContainer || IsEnumType(i))

            .Select(g => GetGlobalItemName(g));

    }

    public string GetGlobalItemName(GlobalItem item)

    {

        if (item is EdmType)

        {

            return ((EdmType)item).Name;

        }

        else

        {

            return ((EntityContainer)item).Name;

        }

    }

    public IEnumerable<EdmProperty> GetSimpleProperties(EntityType type)

    {

        return type.Properties.Where(p => p.TypeUsage.EdmType is SimpleType && p.DeclaringType == type);

    }

    public IEnumerable<EdmProperty> GetSimpleProperties(ComplexType type)

    {

        return type.Properties.Where(p => p.TypeUsage.EdmType is SimpleType && p.DeclaringType == type);

    }

    public IEnumerable<EdmProperty> GetComplexProperties(EntityType type)

    {

        return type.Properties.Where(p => p.TypeUsage.EdmType is ComplexType && p.DeclaringType == type);

    }

    public IEnumerable<EdmProperty> GetComplexProperties(ComplexType type)

    {

        return type.Properties.Where(p => p.TypeUsage.EdmType is ComplexType && p.DeclaringType == type);

    }

    public IEnumerable<EdmProperty> GetPropertiesWithDefaultValues(EntityType type)

    {

        return type.Properties.Where(p => p.TypeUsage.EdmType is SimpleType && p.DeclaringType == type && p.DefaultValue != null);

    }

    public IEnumerable<EdmProperty> GetPropertiesWithDefaultValues(ComplexType type)

    {

        return type.Properties.Where(p => p.TypeUsage.EdmType is SimpleType && p.DeclaringType == type && p.DefaultValue != null);

    }

    public IEnumerable<NavigationProperty> GetNavigationProperties(EntityType type)

    {

        return type.NavigationProperties.Where(np => np.DeclaringType == type);

    }

    public IEnumerable<NavigationProperty> GetCollectionNavigationProperties(EntityType type)

    {

        return type.NavigationProperties.Where(np => np.DeclaringType == type && np.ToEndMember.RelationshipMultiplicity == RelationshipMultiplicity.Many);

    }

    public FunctionParameter GetReturnParameter(EdmFunction edmFunction)

    {

        ArgumentNotNull(edmFunction, "edmFunction");

        var returnParamsProperty = edmFunction.GetType().GetProperty("ReturnParameters");

        return returnParamsProperty == null

            ? edmFunction.ReturnParameter

            : ((IEnumerable<FunctionParameter>)returnParamsProperty.GetValue(edmFunction, null)).FirstOrDefault();

    }

    public bool IsComposable(EdmFunction edmFunction)

    {

        ArgumentNotNull(edmFunction, "edmFunction");

        var isComposableProperty = edmFunction.GetType().GetProperty("IsComposableAttribute");

        return isComposableProperty != null && (bool)isComposableProperty.GetValue(edmFunction, null);

    }

    public IEnumerable<FunctionImportParameter> GetParameters(EdmFunction edmFunction)

    {

        return FunctionImportParameter.Create(edmFunction.Parameters, _code, _ef);

    }

    public TypeUsage GetReturnType(EdmFunction edmFunction)

    {

        var returnParam = GetReturnParameter(edmFunction);

        return returnParam == null ? null : _ef.GetElementType(returnParam.TypeUsage);

    }

    public bool GenerateMergeOptionFunction(EdmFunction edmFunction, bool includeMergeOption)

    {

        var returnType = GetReturnType(edmFunction);

        return !includeMergeOption && returnType != null && returnType.EdmType.BuiltInTypeKind == BuiltInTypeKind.EntityType;

    }

}

public static void ArgumentNotNull<T>(T arg, string name) where T : class

{

    if (arg == null)

    {

        throw new ArgumentNullException(name);

    }

}

#>

// 모델 'D:\Source\Repos\MARKUS\ColorList\ModelMarkus.edmx'에 대해 T4 코드 생성이 사용됩니다. 

// 레거시 코드 생성을 사용하려면 '코드 생성 전략' 디자이너 속성의 값을

// 'Legacy ObjectContext'로 변경하십시오. 이 속성은 모델이 디자이너에서 열릴 때

// 속성 창에서 사용할 수 있습니다.

// 컨텍스트 및 엔터티 클래스가 생성되지 않은 경우 빈 모델을 만들었기 때문일 수도 있지만

// 사용할 Entity Framework 버전을 선택하지 않았기 때문일 수도 있습니다. 모델에 맞는 컨텍스트 클래스 및

// 엔터티 클래스를 생성하려면 디자이너에서 모델을 열고 디자이너 화면에서 마우스 오른쪽 단추를 클릭한

// 다음 '데이터베이스에서 모델 업데이트...', '모델에서 데이터베이스 생성...' 또는 '코드 생성 항목 추가...'를

// 선택하십시오.

//------------------------------------------------------------------------------

// <auto-generated>

//     이 코드는 템플릿에서 생성되었습니다.

//

//     이 파일을 수동으로 변경하면 응용 프로그램에서 예기치 않은 동작이 발생할 수 있습니다.

//     이 파일을 수동으로 변경하면 코드가 다시 생성될 때 변경 내용을 덮어씁니다.

// </auto-generated>

//------------------------------------------------------------------------------

<?xml version="1.0" encoding="utf-8"?>

<edmx:Edmx Version="3.0" xmlns:edmx="http://schemas.microsoft.com/ado/2009/11/edmx">

  <!-- EF Runtime content -->

  <edmx:Runtime>

    <!-- SSDL content -->

    <edmx:StorageModels>

      <Schema Namespace="markusModel.Store" Provider="System.Data.SqlClient" ProviderManifestToken="2012" Alias="Self" xmlns:store="http://schemas.microsoft.com/ado/2007/12/edm/EntityStoreSchemaGenerator" xmlns:customannotation="http://schemas.microsoft.com/ado/2013/11/edm/customannotation" xmlns="http://schemas.microsoft.com/ado/2009/11/edm/ssdl">

        <EntityType Name="PROPERTIES">

          <Key>

            <PropertyRef Name="ID" />

          </Key>

          <Property Name="ID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />

          <Property Name="TYPE" Type="nvarchar" MaxLength="50" Nullable="false" />

          <Property Name="PROPERTY" Type="nvarchar" MaxLength="100" Nullable="false" />

          <Property Name="VALUE" Type="varchar(max)" Nullable="false" />

        </EntityType>

        <EntityContainer Name="markusModelStoreContainer">

          <EntitySet Name="PROPERTIES" EntityType="Self.PROPERTIES" Schema="dbo" store:Type="Tables" />

        </EntityContainer>

      </Schema>

    </edmx:StorageModels>

    <!-- CSDL content -->

    <edmx:ConceptualModels>

      <Schema Namespace="markusModel" Alias="Self" annotation:UseStrongSpatialTypes="false" xmlns:annotation="http://schemas.microsoft.com/ado/2009/02/edm/annotation" xmlns:customannotation="http://schemas.microsoft.com/ado/2013/11/edm/customannotation" xmlns="http://schemas.microsoft.com/ado/2009/11/edm">

        <EntityType Name="PROPERTIES">

          <Key>

            <PropertyRef Name="ID" />

          </Key>

          <Property Name="ID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />

          <Property Name="TYPE" Type="String" MaxLength="50" FixedLength="false" Unicode="true" Nullable="false" />

          <Property Name="PROPERTY" Type="String" MaxLength="100" FixedLength="false" Unicode="true" Nullable="false" />

          <Property Name="VALUE" Type="String" MaxLength="Max" FixedLength="false" Unicode="false" Nullable="false" />

        </EntityType>

        <EntityContainer Name="markusEntities" annotation:LazyLoadingEnabled="true">

          <EntitySet Name="PROPERTIES" EntityType="Self.PROPERTIES" />

        </EntityContainer>

      </Schema>

    </edmx:ConceptualModels>

    <!-- C-S mapping content -->

    <edmx:Mappings>

      <Mapping Space="C-S" xmlns="http://schemas.microsoft.com/ado/2009/11/mapping/cs">

        <EntityContainerMapping StorageEntityContainer="markusModelStoreContainer" CdmEntityContainer="markusEntities">

          <EntitySetMapping Name="PROPERTIES">

            <EntityTypeMapping TypeName="markusModel.PROPERTIES">

              <MappingFragment StoreEntitySet="PROPERTIES">

                <ScalarProperty Name="ID" ColumnName="ID" />

                <ScalarProperty Name="TYPE" ColumnName="TYPE" />

                <ScalarProperty Name="PROPERTY" ColumnName="PROPERTY" />

                <ScalarProperty Name="VALUE" ColumnName="VALUE" />

              </MappingFragment>

            </EntityTypeMapping>

          </EntitySetMapping>

        </EntityContainerMapping>

      </Mapping>

    </edmx:Mappings>

  </edmx:Runtime>

  <!-- EF Designer content (DO NOT EDIT MANUALLY BELOW HERE) -->

  <Designer xmlns="http://schemas.microsoft.com/ado/2009/11/edmx">

    <Connection>

      <DesignerInfoPropertySet>

        <DesignerProperty Name="MetadataArtifactProcessing" Value="EmbedInOutputAssembly" />

      </DesignerInfoPropertySet>

    </Connection>

    <Options>

      <DesignerInfoPropertySet>

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

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

        <DesignerProperty Name="IncludeForeignKeysInModel" Value="true" />

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

        <DesignerProperty Name="CodeGenerationStrategy" Value="없음" />

      </DesignerInfoPropertySet>

    </Options>

    <!-- Diagram content (shape and connector positions) -->

    <Diagrams></Diagrams>

  </Designer>

</edmx:Edmx>

<?xml version="1.0" encoding="utf-8"?>

<edmx:Edmx Version="3.0" xmlns:edmx="http://schemas.microsoft.com/ado/2009/11/edmx">

 <!-- EF Designer content (DO NOT EDIT MANUALLY BELOW HERE) -->

  <edmx:Designer xmlns="http://schemas.microsoft.com/ado/2009/11/edmx">

    <!-- Diagram content (shape and connector positions) -->

    <edmx:Diagrams>

      <Diagram DiagramId="dfd82d7b4582489a96da29feb9d4fd95" Name="Diagram1">

        <EntityTypeShape EntityType="markusModel.PROPERTIES" Width="1.5" PointX="0.75" PointY="0.75" IsExpanded="true" />

      </Diagram>

    </edmx:Diagrams>

  </edmx:Designer>

</edmx:Edmx>

<#@ template language="C#" debug="false" hostspecific="true"#>

<#@ include file="EF6.Utility.CS.ttinclude"#><#@ 

 output extension=".cs"#><#

const string inputFile = @"ModelMarkus.edmx";

var textTransform = DynamicTextTransformation.Create(this);

var code = new CodeGenerationTools(this);

var ef = new MetadataTools(this);

var typeMapper = new TypeMapper(code, ef, textTransform.Errors);

var	fileManager = EntityFrameworkTemplateFileManager.Create(this);

var itemCollection = new EdmMetadataLoader(textTransform.Host, textTransform.Errors).CreateEdmItemCollection(inputFile);

var codeStringGenerator = new CodeStringGenerator(code, typeMapper, ef);

if (!typeMapper.VerifyCaseInsensitiveTypeUniqueness(typeMapper.GetAllGlobalItems(itemCollection), inputFile))

{

    return string.Empty;

}

WriteHeader(codeStringGenerator, fileManager);

foreach (var entity in typeMapper.GetItemsToGenerate<EntityType>(itemCollection))

{

    fileManager.StartNewFile(entity.Name + ".cs");

    BeginNamespace(code);

#>

<#=codeStringGenerator.UsingDirectives(inHeader: false)#>

<#=codeStringGenerator.EntityClassOpening(entity)#>

{

<#

    var propertiesWithDefaultValues = typeMapper.GetPropertiesWithDefaultValues(entity);

    var collectionNavigationProperties = typeMapper.GetCollectionNavigationProperties(entity);

    var complexProperties = typeMapper.GetComplexProperties(entity);

    if (propertiesWithDefaultValues.Any() || collectionNavigationProperties.Any() || complexProperties.Any())

    {

#>

    [System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage", "CA2214:DoNotCallOverridableMethodsInConstructors")]

    public <#=code.Escape(entity)#>()

    {

<#

        foreach (var edmProperty in propertiesWithDefaultValues)

        {

#>

        this.<#=code.Escape(edmProperty)#> = <#=typeMapper.CreateLiteral(edmProperty.DefaultValue)#>;

<#

        }

        foreach (var navigationProperty in collectionNavigationProperties)

        {

#>

        this.<#=code.Escape(navigationProperty)#> = new HashSet<<#=typeMapper.GetTypeName(navigationProperty.ToEndMember.GetEntityType())#>>();

<#

        }

        foreach (var complexProperty in complexProperties)

        {

#>

        this.<#=code.Escape(complexProperty)#> = new <#=typeMapper.GetTypeName(complexProperty.TypeUsage)#>();

<#

        }

#>

    }

<#

    }

    var simpleProperties = typeMapper.GetSimpleProperties(entity);

    if (simpleProperties.Any())

    {

        foreach (var edmProperty in simpleProperties)

        {

#>

    <#=codeStringGenerator.Property(edmProperty)#>

<#

        }

    }

    if (complexProperties.Any())

    {

#>

<#

        foreach(var complexProperty in complexProperties)

        {

#>

    <#=codeStringGenerator.Property(complexProperty)#>

<#

        }

    }

    var navigationProperties = typeMapper.GetNavigationProperties(entity);

    if (navigationProperties.Any())

    {

#>

<#

        foreach (var navigationProperty in navigationProperties)

        {

            if (navigationProperty.ToEndMember.RelationshipMultiplicity == RelationshipMultiplicity.Many)

            {

#>

    [System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage", "CA2227:CollectionPropertiesShouldBeReadOnly")]

<#

            }

#>

    <#=codeStringGenerator.NavigationProperty(navigationProperty)#>

<#

        }

    }

#>

}

<#

    EndNamespace(code);

}

foreach (var complex in typeMapper.GetItemsToGenerate<ComplexType>(itemCollection))

{

    fileManager.StartNewFile(complex.Name + ".cs");

    BeginNamespace(code);

#>

<#=codeStringGenerator.UsingDirectives(inHeader: false, includeCollections: false)#>

<#=Accessibility.ForType(complex)#> partial class <#=code.Escape(complex)#>

{

<#

    var complexProperties = typeMapper.GetComplexProperties(complex);

    var propertiesWithDefaultValues = typeMapper.GetPropertiesWithDefaultValues(complex);

    if (propertiesWithDefaultValues.Any() || complexProperties.Any())

    {

#>

    public <#=code.Escape(complex)#>()

    {

<#

        foreach (var edmProperty in propertiesWithDefaultValues)

        {

#>

        this.<#=code.Escape(edmProperty)#> = <#=typeMapper.CreateLiteral(edmProperty.DefaultValue)#>;

<#

        }

        foreach (var complexProperty in complexProperties)

        {

#>

        this.<#=code.Escape(complexProperty)#> = new <#=typeMapper.GetTypeName(complexProperty.TypeUsage)#>();

<#

        }

#>

    }

<#

    }

    var simpleProperties = typeMapper.GetSimpleProperties(complex);

    if (simpleProperties.Any())

    {

        foreach(var edmProperty in simpleProperties)

        {

#>

    <#=codeStringGenerator.Property(edmProperty)#>

<#

        }

    }

    if (complexProperties.Any())

    {

#>

<#

        foreach(var edmProperty in complexProperties)

        {

#>

    <#=codeStringGenerator.Property(edmProperty)#>

<#

        }

    }

#>

}

<#

    EndNamespace(code);

}

foreach (var enumType in typeMapper.GetEnumItemsToGenerate(itemCollection))

{

    fileManager.StartNewFile(enumType.Name + ".cs");

    BeginNamespace(code);

#>

<#=codeStringGenerator.UsingDirectives(inHeader: false, includeCollections: false)#>

<#

    if (typeMapper.EnumIsFlags(enumType))

    {

#>

[Flags]

<#

    }

#>

<#=codeStringGenerator.EnumOpening(enumType)#>

{

<#

    var foundOne = false;

    foreach (MetadataItem member in typeMapper.GetEnumMembers(enumType))

    {

        foundOne = true;

#>

    <#=code.Escape(typeMapper.GetEnumMemberName(member))#> = <#=typeMapper.GetEnumMemberValue(member)#>,

<#

    }

    if (foundOne)

    {

        this.GenerationEnvironment.Remove(this.GenerationEnvironment.Length - 3, 1);

    }

#>

}

<#

    EndNamespace(code);

}