Skip to content

Instantly share code, notes, and snippets.

@masaru-b-cl

masaru-b-cl/.gitignore

Last active December 11, 2015 03:08
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save masaru-b-cl/4535523 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save masaru-b-cl/4535523 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
.gitignore
bin/
obj/
*.suo
*.user
TestResults/
Raw
About.aspx
<%@ Page Title="" Language="C#" MasterPageFile="~/Site.master" AutoEventWireup="true"
CodeFile="About.aspx.cs" Inherits="About" %>
<asp:Content ID="HeaderContent" runat="server" ContentPlaceHolderID="HeadContent">
</asp:Content>
<asp:Content ID="BodyContent" runat="server" ContentPlaceHolderID="MainContent">
<h2>
Student Body Statistics
</h2>
<asp:EntityDataSource ID="StudentStatisticsEntityDataSource" runat="server" ContextTypeName="ContosoUniversity.DAL.SchoolEntities"
EnableFlattening="False" EntitySetName="People" EntityTypeFilter="Student" GroupBy="it.EnrollmentDate"
OrderBy="it.EnrollmentDate" Select="it.EnrollmentDate, Count(it.EnrollmentDate) AS NumberOfStudents">
</asp:EntityDataSource>
<asp:GridView ID="StudentStatisticsGridView" runat="server" AutoGenerateColumns="False"
DataSourceID="StudentStatisticsEntityDataSource">
<Columns>
<asp:BoundField DataField="EnrollmentDate" HeaderText="Date of Enrollment" ReadOnly="True"
SortExpression="EnrollmentDate" DataFormatString="{0:d}" />
<asp:BoundField DataField="NumberOfStudents" HeaderText="Students" ReadOnly="True"
SortExpression="NumberOfStudents" />
</Columns>
</asp:GridView>
</asp:Content>
Raw
About.aspx.cs
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
public partial class About : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
}
}
Raw
App.Config
<?xml version="1.0" encoding="utf-8"?>
<configuration>
<connectionStrings>
<add name="SchoolEntities" connectionString="metadata=res://*/SchoolModel.csdl|res://*/SchoolModel.ssdl|res://*/SchoolModel.msl;provider=System.Data.SqlClient;provider connection string=&quot;data source=.\SQLEXPRESS;attachdbfilename=C:\gitrepos\ASP.NET-WebForms-EF-Tutorials\ContosoUniversity\App_Data\School.mdf;integrated security=True;user instance=True;multipleactiveresultsets=True;App=EntityFramework&quot;" providerName="System.Data.EntityClient" />
</connectionStrings>
</configuration>
Raw
AssemblyInfo.cs
using System.Reflection;
using System.Runtime.CompilerServices;
using System.Runtime.InteropServices;
// アセンブリに関する一般情報は以下の属性セットをとおして制御されます。
// アセンブリに関連付けられている情報を変更するには、
// これらの属性値を変更してください。
[assembly: AssemblyTitle("ContosoUniversity.BLL")]
[assembly: AssemblyDescription("")]
[assembly: AssemblyConfiguration("")]
[assembly: AssemblyCompany("")]
[assembly: AssemblyProduct("ContosoUniversity.BLL")]
[assembly: AssemblyCopyright("Copyright © 2012")]
[assembly: AssemblyTrademark("")]
[assembly: AssemblyCulture("")]
// ComVisible を false に設定すると、その型はこのアセンブリ内で COM コンポーネントから
// 参照不可能になります。COM からこのアセンブリ内の型にアクセスする場合は、
// その型の ComVisible 属性を true に設定してください。
[assembly: ComVisible(false)]
// 次の GUID は、このプロジェクトが COM に公開される場合の、typelib の ID です
[assembly: Guid("680330c7-b462-4d5c-9013-953de6df265e")]
// アセンブリのバージョン情報は、以下の 4 つの値で構成されています:
//
// Major Version
// Minor Version
// Build Number
// Revision
//
// すべての値を指定するか、下のように '*' を使ってビルドおよびリビジョン番号を
// 既定値にすることができます:
// [assembly: AssemblyVersion("1.0.*")]
[assembly: AssemblyVersion("1.0.0.0")]
[assembly: AssemblyFileVersion("1.0.0.0")]
Raw
AssemblyInfo.cs
using System.Reflection;
using System.Runtime.CompilerServices;
using System.Runtime.InteropServices;
// アセンブリに関する一般情報は以下の属性セットをとおして制御されます。
// アセンブリに関連付けられている情報を変更するには、
// これらの属性値を変更してください。
[assembly: AssemblyTitle("ContosoUniversity.DAL")]
[assembly: AssemblyDescription("")]
[assembly: AssemblyConfiguration("")]
[assembly: AssemblyCompany("")]
[assembly: AssemblyProduct("ContosoUniversity.DAL")]
[assembly: AssemblyCopyright("Copyright © 2012")]
[assembly: AssemblyTrademark("")]
[assembly: AssemblyCulture("")]
// ComVisible を false に設定すると、その型はこのアセンブリ内で COM コンポーネントから
// 参照不可能になります。COM からこのアセンブリ内の型にアクセスする場合は、
// その型の ComVisible 属性を true に設定してください。
[assembly: ComVisible(false)]
// 次の GUID は、このプロジェクトが COM に公開される場合の、typelib の ID です
[assembly: Guid("d1fc6f24-56b9-443b-9f8f-71dfd7b0e3b3")]
// アセンブリのバージョン情報は、以下の 4 つの値で構成されています:
//
// Major Version
// Minor Version
// Build Number
// Revision
//
// すべての値を指定するか、下のように '*' を使ってビルドおよびリビジョン番号を
// 既定値にすることができます:
// [assembly: AssemblyVersion("1.0.*")]
[assembly: AssemblyVersion("1.0.0.0")]
[assembly: AssemblyFileVersion("1.0.0.0")]
Raw
AssemblyInfo.cs
using System.Reflection;
using System.Runtime.CompilerServices;
using System.Runtime.InteropServices;
// アセンブリに関する一般情報は以下の属性セットを通して制御されます。
// アセンブリに関連付けられている情報を変更するには、
// これらの属性値を変更してください。
[assembly: AssemblyTitle("ContosoUniversity.Tests")]
[assembly: AssemblyDescription("")]
[assembly: AssemblyConfiguration("")]
[assembly: AssemblyCompany("")]
[assembly: AssemblyProduct("ContosoUniversity.Tests")]
[assembly: AssemblyCopyright("Copyright © 2012")]
[assembly: AssemblyTrademark("")]
[assembly: AssemblyCulture("")]
// ComVisible を false に設定すると、その型はこのアセンブリ内で COM コンポーネントから
// 参照できなくなります。このアセンブリ内で COM から型にアクセスする必要がある場合は、
// その型の ComVisible 属性を true に設定してください。
[assembly: ComVisible(false)]
// このプロジェクトが COM に公開される場合、次の GUID がタイプ ライブラリの ID になります。
[assembly: Guid("eec03467-aad4-4424-9a0e-d791b572e325")]
// アセンブリのバージョン情報は、以下の 4 つの値で構成されています:
//
// Major Version
// Minor Version
// Build Number
// Revision
//
// すべての値を指定するか、以下のように '*' を使用してビルド番号とリビジョン番号を
// 既定値にすることができます:
[assembly: AssemblyVersion("1.0.0.0")]
[assembly: AssemblyFileVersion("1.0.0.0")]
Raw
ChangePassword.aspx
<%@ Page Title="パスワードの変更" Language="C#" MasterPageFile="~/Site.master" AutoEventWireup="true"
CodeFile="ChangePassword.aspx.cs" Inherits="Account_ChangePassword" %>
<asp:Content ID="HeaderContent" runat="server" ContentPlaceHolderID="HeadContent">
</asp:Content>
<asp:Content ID="BodyContent" runat="server" ContentPlaceHolderID="MainContent">
<h2>
パスワードの変更
</h2>
<p>
パスワードを変更するには、以下のフォームを使用してください。
</p>
<p>
新しいパスワードは、<%= Membership.MinRequiredPasswordLength %> 文字以上であることが必要です。
</p>
<asp:ChangePassword ID="ChangeUserPassword" runat="server" CancelDestinationPageUrl="~/" EnableViewState="false" RenderOuterTable="false"
SuccessPageUrl="ChangePasswordSuccess.aspx">
<ChangePasswordTemplate>
<span class="failureNotification">
<asp:Literal ID="FailureText" runat="server"></asp:Literal>
</span>
<asp:ValidationSummary ID="ChangeUserPasswordValidationSummary" runat="server" CssClass="failureNotification"
ValidationGroup="ChangeUserPasswordValidationGroup"/>
<div class="accountInfo">
<fieldset class="changePassword">
<legend>アカウント情報</legend>
<p>
<asp:Label ID="CurrentPasswordLabel" runat="server" AssociatedControlID="CurrentPassword">古いパスワード:</asp:Label>
<asp:TextBox ID="CurrentPassword" runat="server" CssClass="passwordEntry" TextMode="Password"></asp:TextBox>
<asp:RequiredFieldValidator ID="CurrentPasswordRequired" runat="server" ControlToValidate="CurrentPassword"
CssClass="failureNotification" ErrorMessage="パスワードが必要です。" ToolTip="古いパスワードが必要です。"
ValidationGroup="ChangeUserPasswordValidationGroup">*</asp:RequiredFieldValidator>
</p>
<p>
<asp:Label ID="NewPasswordLabel" runat="server" AssociatedControlID="NewPassword">新しいパスワード:</asp:Label>
<asp:TextBox ID="NewPassword" runat="server" CssClass="passwordEntry" TextMode="Password"></asp:TextBox>
<asp:RequiredFieldValidator ID="NewPasswordRequired" runat="server" ControlToValidate="NewPassword"
CssClass="failureNotification" ErrorMessage="新しいパスワードが必要です。" ToolTip="新しいパスワードが必要です。"
ValidationGroup="ChangeUserPasswordValidationGroup">*</asp:RequiredFieldValidator>
</p>
<p>
<asp:Label ID="ConfirmNewPasswordLabel" runat="server" AssociatedControlID="ConfirmNewPassword">新しいパスワードの確認入力:</asp:Label>
<asp:TextBox ID="ConfirmNewPassword" runat="server" CssClass="passwordEntry" TextMode="Password"></asp:TextBox>
<asp:RequiredFieldValidator ID="ConfirmNewPasswordRequired" runat="server" ControlToValidate="ConfirmNewPassword"
CssClass="failureNotification" Display="Dynamic" ErrorMessage="新しいパスワードの確認入力が必要です。"
ToolTip="新しいパスワードの確認入力が必要です。" ValidationGroup="ChangeUserPasswordValidationGroup">*</asp:RequiredFieldValidator>
<asp:CompareValidator ID="NewPasswordCompare" runat="server" ControlToCompare="NewPassword" ControlToValidate="ConfirmNewPassword"
CssClass="failureNotification" Display="Dynamic" ErrorMessage="新しいパスワードの確認入力は、新しいパスワードの入力と一致しなければなりません。"
ValidationGroup="ChangeUserPasswordValidationGroup">*</asp:CompareValidator>
</p>
</fieldset>
<p class="submitButton">
<asp:Button ID="CancelPushButton" runat="server" CausesValidation="False" CommandName="Cancel" Text="キャンセル"/>
<asp:Button ID="ChangePasswordPushButton" runat="server" CommandName="ChangePassword" Text="パスワードの変更"
ValidationGroup="ChangeUserPasswordValidationGroup"/>
</p>
</div>
</ChangePasswordTemplate>
</asp:ChangePassword>
</asp:Content>
Raw
ChangePassword.aspx.cs
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
public partial class Account_ChangePassword : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
}
}
Raw
ChangePasswordSuccess.aspx
<%@ Page Title="パスワードの変更" Language="C#" MasterPageFile="~/Site.master" AutoEventWireup="true"
CodeFile="ChangePasswordSuccess.aspx.cs" Inherits="Account_ChangePasswordSuccess" %>
<asp:Content ID="HeaderContent" runat="server" ContentPlaceHolderID="HeadContent">
</asp:Content>
<asp:Content ID="BodyContent" runat="server" ContentPlaceHolderID="MainContent">
<h2>
パスワードの変更
</h2>
<p>
パスワードが更新されました。
</p>
</asp:Content>
Raw
ChangePasswordSuccess.aspx.cs
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
public partial class Account_ChangePasswordSuccess : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
}
}
Raw
ContosoUniversity.BLL.csproj
<?xml version="1.0" encoding="utf-8"?>
<Project ToolsVersion="4.0" DefaultTargets="Build" xmlns="http://schemas.microsoft.com/developer/msbuild/2003">
<PropertyGroup>
<Configuration Condition=" '$(Configuration)' == '' ">Debug</Configuration>
<Platform Condition=" '$(Platform)' == '' ">AnyCPU</Platform>
<ProductVersion>8.0.30703</ProductVersion>
<SchemaVersion>2.0</SchemaVersion>
<ProjectGuid>{B0DF13FB-A41A-4809-8213-B10AA81CC351}</ProjectGuid>
<OutputType>Library</OutputType>
<AppDesignerFolder>Properties</AppDesignerFolder>
<RootNamespace>ContosoUniversity.BLL</RootNamespace>
<AssemblyName>ContosoUniversity.BLL</AssemblyName>
<TargetFrameworkVersion>v4.0</TargetFrameworkVersion>
<FileAlignment>512</FileAlignment>
</PropertyGroup>
<PropertyGroup Condition=" '$(Configuration)|$(Platform)' == 'Debug|AnyCPU' ">
<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' ">
<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.Core" />
<Reference Include="System.Data.Entity" />
<Reference Include="System.Xml.Linq" />
<Reference Include="System.Data.DataSetExtensions" />
<Reference Include="Microsoft.CSharp" />
<Reference Include="System.Data" />
<Reference Include="System.Xml" />
</ItemGroup>
<ItemGroup>
<Compile Include="DuplicateAdministratorException.cs" />
<Compile Include="Properties\AssemblyInfo.cs" />
<Compile Include="SchoolBL.cs" />
</ItemGroup>
<ItemGroup>
<ProjectReference Include="..\ContosoUniversity.DAL\ContosoUniversity.DAL.csproj">
<Project>{0F631E00-8E45-42DF-9A06-395EF60256F1}</Project>
<Name>ContosoUniversity.DAL</Name>
</ProjectReference>
</ItemGroup>
<Import Project="$(MSBuildToolsPath)\Microsoft.CSharp.targets" />
<!-- To modify your build process, add your task inside one of the targets below and uncomment it.
Other similar extension points exist, see Microsoft.Common.targets.
<Target Name="BeforeBuild">
</Target>
<Target Name="AfterBuild">
</Target>
-->
</Project>
Raw
ContosoUniversity.DAL.csproj
<?xml version="1.0" encoding="utf-8"?>
<Project ToolsVersion="4.0" DefaultTargets="Build" xmlns="http://schemas.microsoft.com/developer/msbuild/2003">
<PropertyGroup>
<Configuration Condition=" '$(Configuration)' == '' ">Debug</Configuration>
<Platform Condition=" '$(Platform)' == '' ">AnyCPU</Platform>
<ProductVersion>8.0.30703</ProductVersion>
<SchemaVersion>2.0</SchemaVersion>
<ProjectGuid>{0F631E00-8E45-42DF-9A06-395EF60256F1}</ProjectGuid>
<OutputType>Library</OutputType>
<AppDesignerFolder>Properties</AppDesignerFolder>
<RootNamespace>ContosoUniversity.DAL</RootNamespace>
<AssemblyName>ContosoUniversity.DAL</AssemblyName>
<TargetFrameworkVersion>v4.0</TargetFrameworkVersion>
<FileAlignment>512</FileAlignment>
</PropertyGroup>
<PropertyGroup Condition=" '$(Configuration)|$(Platform)' == 'Debug|AnyCPU' ">
<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' ">
<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.ComponentModel.DataAnnotations" />
<Reference Include="System.Configuration" />
<Reference Include="System.Core" />
<Reference Include="System.Data.Entity" />
<Reference Include="System.Runtime.Serialization" />
<Reference Include="System.Security" />
<Reference Include="System.Xml.Linq" />
<Reference Include="System.Data.DataSetExtensions" />
<Reference Include="Microsoft.CSharp" />
<Reference Include="System.Data" />
<Reference Include="System.Xml" />
</ItemGroup>
<ItemGroup>
<Compile Include="Department.cs" />
<Compile Include="ISchoolRepository.cs" />
<Compile Include="Properties\AssemblyInfo.cs" />
<Compile Include="SchoolModel.Designer.cs">
<AutoGen>True</AutoGen>
<DesignTime>True</DesignTime>
<DependentUpon>SchoolModel.edmx</DependentUpon>
</Compile>
<Compile Include="SchoolRepository.cs" />
<Compile Include="Student.cs" />
</ItemGroup>
<ItemGroup>
<EntityDeploy Include="SchoolModel.edmx">
<Generator>EntityModelCodeGenerator</Generator>
<LastGenOutput>SchoolModel.Designer.cs</LastGenOutput>
</EntityDeploy>
</ItemGroup>
<ItemGroup>
<None Include="App.Config" />
</ItemGroup>
<Import Project="$(MSBuildToolsPath)\Microsoft.CSharp.targets" />
<!-- To modify your build process, add your task inside one of the targets below and uncomment it.
Other similar extension points exist, see Microsoft.Common.targets.
<Target Name="BeforeBuild">
</Target>
<Target Name="AfterBuild">
</Target>
-->
</Project>
Raw
ContosoUniversity.sln

Microsoft Visual Studio Solution File, Format Version 11.00
# Visual Studio 2010
Project("{E24C65DC-7377-472B-9ABA-BC803B73C61A}") = "localhost", "http://localhost:3112", "{05B49A64-5E64-4D1E-8226-D8193DFC40AD}"
ProjectSection(WebsiteProperties) = preProject
UseIISExpress = "true"
TargetFrameworkMoniker = ".NETFramework,Version%3Dv4.0"
ProjectReferences = "{0F631E00-8E45-42DF-9A06-395EF60256F1}|ContosoUniversity.DAL.dll;{B0DF13FB-A41A-4809-8213-B10AA81CC351}|ContosoUniversity.BLL.dll;"
Debug.AspNetCompiler.VirtualPath = "/localhost_3112"
Debug.AspNetCompiler.PhysicalPath = "ContosoUniversity\"
Debug.AspNetCompiler.TargetPath = "PrecompiledWeb\localhost_3112\"
Debug.AspNetCompiler.Updateable = "true"
Debug.AspNetCompiler.ForceOverwrite = "true"
Debug.AspNetCompiler.FixedNames = "false"
Debug.AspNetCompiler.Debug = "True"
Release.AspNetCompiler.VirtualPath = "/localhost_3112"
Release.AspNetCompiler.PhysicalPath = "ContosoUniversity\"
Release.AspNetCompiler.TargetPath = "PrecompiledWeb\localhost_3112\"
Release.AspNetCompiler.Updateable = "true"
Release.AspNetCompiler.ForceOverwrite = "true"
Release.AspNetCompiler.FixedNames = "false"
Release.AspNetCompiler.Debug = "False"
SlnRelativePath = "..\..\..\..\..\..\gitrepos\ASP.NET-WebForms-EF-Tutorials\ContosoUniversity\"
DefaultWebSiteLanguage = "Visual C#"
EndProjectSection
EndProject
Project("{FAE04EC0-301F-11D3-BF4B-00C04F79EFBC}") = "ContosoUniversity.Tests", "ContosoUniversity.Tests\ContosoUniversity.Tests.csproj", "{39BF25D8-5878-474F-8E08-DB4AC7936036}"
EndProject
Project("{2150E333-8FDC-42A3-9474-1A3956D46DE8}") = "Solution Items", "Solution Items", "{597E9BBD-3BD8-4928-8E74-E6B833214FAC}"
ProjectSection(SolutionItems) = preProject
ContosoUniversity.vsmdi = ContosoUniversity.vsmdi
Local.testsettings = Local.testsettings
TraceAndTestImpact.testsettings = TraceAndTestImpact.testsettings
EndProjectSection
EndProject
Project("{FAE04EC0-301F-11D3-BF4B-00C04F79EFBC}") = "ContosoUniversity.DAL", "ContosoUniversity.DAL\ContosoUniversity.DAL.csproj", "{0F631E00-8E45-42DF-9A06-395EF60256F1}"
EndProject
Project("{FAE04EC0-301F-11D3-BF4B-00C04F79EFBC}") = "ContosoUniversity.BLL", "ContosoUniversity.BLL\ContosoUniversity.BLL.csproj", "{B0DF13FB-A41A-4809-8213-B10AA81CC351}"
EndProject
Global
GlobalSection(TestCaseManagementSettings) = postSolution
CategoryFile = ContosoUniversity.vsmdi
EndGlobalSection
GlobalSection(SolutionConfigurationPlatforms) = preSolution
Debug|Any CPU = Debug|Any CPU
Release|Any CPU = Release|Any CPU
EndGlobalSection
GlobalSection(ProjectConfigurationPlatforms) = postSolution
{05B49A64-5E64-4D1E-8226-D8193DFC40AD}.Debug|Any CPU.ActiveCfg = Debug|Any CPU
{05B49A64-5E64-4D1E-8226-D8193DFC40AD}.Debug|Any CPU.Build.0 = Debug|Any CPU
{05B49A64-5E64-4D1E-8226-D8193DFC40AD}.Release|Any CPU.ActiveCfg = Debug|Any CPU
{05B49A64-5E64-4D1E-8226-D8193DFC40AD}.Release|Any CPU.Build.0 = Debug|Any CPU
{39BF25D8-5878-474F-8E08-DB4AC7936036}.Debug|Any CPU.ActiveCfg = Debug|Any CPU
{39BF25D8-5878-474F-8E08-DB4AC7936036}.Debug|Any CPU.Build.0 = Debug|Any CPU
{39BF25D8-5878-474F-8E08-DB4AC7936036}.Release|Any CPU.ActiveCfg = Release|Any CPU
{39BF25D8-5878-474F-8E08-DB4AC7936036}.Release|Any CPU.Build.0 = Release|Any CPU
{0F631E00-8E45-42DF-9A06-395EF60256F1}.Debug|Any CPU.ActiveCfg = Debug|Any CPU
{0F631E00-8E45-42DF-9A06-395EF60256F1}.Debug|Any CPU.Build.0 = Debug|Any CPU
{0F631E00-8E45-42DF-9A06-395EF60256F1}.Release|Any CPU.ActiveCfg = Release|Any CPU
{0F631E00-8E45-42DF-9A06-395EF60256F1}.Release|Any CPU.Build.0 = Release|Any CPU
{B0DF13FB-A41A-4809-8213-B10AA81CC351}.Debug|Any CPU.ActiveCfg = Debug|Any CPU
{B0DF13FB-A41A-4809-8213-B10AA81CC351}.Debug|Any CPU.Build.0 = Debug|Any CPU
{B0DF13FB-A41A-4809-8213-B10AA81CC351}.Release|Any CPU.ActiveCfg = Release|Any CPU
{B0DF13FB-A41A-4809-8213-B10AA81CC351}.Release|Any CPU.Build.0 = Release|Any CPU
EndGlobalSection
GlobalSection(SolutionProperties) = preSolution
HideSolutionNode = FALSE
EndGlobalSection
EndGlobal
Raw
ContosoUniversity.Tests.csproj
<?xml version="1.0" encoding="utf-8"?>
<Project ToolsVersion="4.0" DefaultTargets="Build" xmlns="http://schemas.microsoft.com/developer/msbuild/2003">
<PropertyGroup>
<Configuration Condition=" '$(Configuration)' == '' ">Debug</Configuration>
<Platform Condition=" '$(Platform)' == '' ">AnyCPU</Platform>
<ProductVersion>
</ProductVersion>
<SchemaVersion>2.0</SchemaVersion>
<ProjectGuid>{39BF25D8-5878-474F-8E08-DB4AC7936036}</ProjectGuid>
<OutputType>Library</OutputType>
<AppDesignerFolder>Properties</AppDesignerFolder>
<RootNamespace>ContosoUniversity.Tests</RootNamespace>
<AssemblyName>ContosoUniversity.Tests</AssemblyName>
<TargetFrameworkVersion>v4.0</TargetFrameworkVersion>
<FileAlignment>512</FileAlignment>
<ProjectTypeGuids>{3AC096D0-A1C2-E12C-1390-A8335801FDAB};{FAE04EC0-301F-11D3-BF4B-00C04F79EFBC}</ProjectTypeGuids>
</PropertyGroup>
<PropertyGroup Condition=" '$(Configuration)|$(Platform)' == 'Debug|AnyCPU' ">
<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' ">
<DebugType>pdbonly</DebugType>
<Optimize>true</Optimize>
<OutputPath>bin\Release\</OutputPath>
<DefineConstants>TRACE</DefineConstants>
<ErrorReport>prompt</ErrorReport>
<WarningLevel>4</WarningLevel>
</PropertyGroup>
<ItemGroup>
<Reference Include="Microsoft.CSharp" />
<Reference Include="Microsoft.VisualStudio.QualityTools.UnitTestFramework, Version=10.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a, processorArchitecture=MSIL" />
<Reference Include="System" />
<Reference Include="System.ComponentModel.DataAnnotations" />
<Reference Include="System.Core">
<RequiredTargetFramework>3.5</RequiredTargetFramework>
</Reference>
<Reference Include="System.Data" />
<Reference Include="System.Data.DataSetExtensions" />
<Reference Include="System.Data.Entity" />
<Reference Include="System.Runtime.Serialization" />
<Reference Include="System.Security" />
<Reference Include="System.Xml" />
<Reference Include="System.Xml.Linq" />
</ItemGroup>
<ItemGroup>
<CodeAnalysisDependentAssemblyPaths Condition=" '$(VS100COMNTOOLS)' != '' " Include="$(VS100COMNTOOLS)..\IDE\PrivateAssemblies">
<Visible>False</Visible>
</CodeAnalysisDependentAssemblyPaths>
</ItemGroup>
<ItemGroup>
<Compile Include="MockSchoolRepository.cs" />
<Compile Include="Properties\AssemblyInfo.cs" />
<Compile Include="SchoolBLTest.cs" />
</ItemGroup>
<ItemGroup>
<ProjectReference Include="..\ContosoUniversity.BLL\ContosoUniversity.BLL.csproj">
<Project>{B0DF13FB-A41A-4809-8213-B10AA81CC351}</Project>
<Name>ContosoUniversity.BLL</Name>
</ProjectReference>
<ProjectReference Include="..\ContosoUniversity.DAL\ContosoUniversity.DAL.csproj">
<Project>{0F631E00-8E45-42DF-9A06-395EF60256F1}</Project>
<Name>ContosoUniversity.DAL</Name>
</ProjectReference>
</ItemGroup>
<Import Project="$(MSBuildBinPath)\Microsoft.CSharp.targets" />
<!-- To modify your build process, add your task inside one of the targets below and uncomment it.
Other similar extension points exist, see Microsoft.Common.targets.
<Target Name="BeforeBuild">
</Target>
<Target Name="AfterBuild">
</Target>
-->
</Project>
Raw
ContosoUniversity.vsmdi
<?xml version="1.0" encoding="UTF-8"?>
<TestLists xmlns="http://microsoft.com/schemas/VisualStudio/TeamTest/2010">
<TestList name="テストの一覧" id="8c43106b-9dc1-4907-a29f-aa66a61bf5b6">
<RunConfiguration id="162abe8f-2cf0-433a-b580-e7e3153513b8" name="ローカル" storage="local.testsettings" type="Microsoft.VisualStudio.TestTools.Common.TestRunConfiguration, Microsoft.VisualStudio.QualityTools.Common, Version=10.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" />
</TestList>
</TestLists>
Raw
Department.cs
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.ComponentModel.DataAnnotations;
namespace ContosoUniversity.DAL
{
[MetadataType(typeof(DepartmentMetaData))]
public partial class Department
{
}
public class DepartmentMetaData
{
[DataType(DataType.Currency)]
[Range(0, 1000000, ErrorMessage = "Budget must be less than \\1,000,000.00")]
public Decimal Budget { get; set; }
[DisplayFormat(DataFormatString = "{0:d}", ApplyFormatInEditMode = true)]
public DateTime StartDate { get; set; }
}
}
Raw
DuplicateAdministratorException.cs
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
namespace ContosoUniversity.BLL
{
public class DuplicateAdministratorException : Exception
{
public DuplicateAdministratorException(string message)
: base(message)
{
}
}
}
Raw
ISchoolRepository.cs
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
namespace ContosoUniversity.DAL
{
public interface ISchoolRepository : IDisposable
{
IEnumerable<Department> GetDepartments();
void InsertDepartment(Department department);
void DeleteDepartment(Department department);
void UpdateDepartment(Department department, Department origDepartment);
IEnumerable<InstructorName> GetInstructorNames();
IEnumerable<Department> GetDepartmentsByAdministrator(int administrator);
}
}
Raw
Login.aspx
<%@ Page Title="ログイン" Language="C#" MasterPageFile="~/Site.master" AutoEventWireup="true"
CodeFile="Login.aspx.cs" Inherits="Account_Login" %>
<asp:Content ID="HeaderContent" runat="server" ContentPlaceHolderID="HeadContent">
</asp:Content>
<asp:Content ID="BodyContent" runat="server" ContentPlaceHolderID="MainContent">
<h2>
ログイン
</h2>
<p>
ユーザー名とパスワードを入力してください。
<asp:HyperLink ID="RegisterHyperLink" runat="server" EnableViewState="false">登録する</asp:HyperLink> (アカウントがない場合)。
</p>
<asp:Login ID="LoginUser" runat="server" EnableViewState="false" RenderOuterTable="false">
<LayoutTemplate>
<span class="failureNotification">
<asp:Literal ID="FailureText" runat="server"></asp:Literal>
</span>
<asp:ValidationSummary ID="LoginUserValidationSummary" runat="server" CssClass="failureNotification"
ValidationGroup="LoginUserValidationGroup"/>
<div class="accountInfo">
<fieldset class="login">
<legend>アカウント情報</legend>
<p>
<asp:Label ID="UserNameLabel" runat="server" AssociatedControlID="UserName">ユーザー名:</asp:Label>
<asp:TextBox ID="UserName" runat="server" CssClass="textEntry"></asp:TextBox>
<asp:RequiredFieldValidator ID="UserNameRequired" runat="server" ControlToValidate="UserName"
CssClass="failureNotification" ErrorMessage="ユーザー名が必要です。" ToolTip="ユーザー名が必要です。"
ValidationGroup="LoginUserValidationGroup">*</asp:RequiredFieldValidator>
</p>
<p>
<asp:Label ID="PasswordLabel" runat="server" AssociatedControlID="Password">パスワード:</asp:Label>
<asp:TextBox ID="Password" runat="server" CssClass="passwordEntry" TextMode="Password"></asp:TextBox>
<asp:RequiredFieldValidator ID="PasswordRequired" runat="server" ControlToValidate="Password"
CssClass="failureNotification" ErrorMessage="パスワードが必要です。" ToolTip="パスワードが必要です。"
ValidationGroup="LoginUserValidationGroup">*</asp:RequiredFieldValidator>
</p>
<p>
<asp:CheckBox ID="RememberMe" runat="server"/>
<asp:Label ID="RememberMeLabel" runat="server" AssociatedControlID="RememberMe" CssClass="inline">ログインしたままにする</asp:Label>
</p>
</fieldset>
<p class="submitButton">
<asp:Button ID="LoginButton" runat="server" CommandName="Login" Text="ログイン" ValidationGroup="LoginUserValidationGroup"/>
</p>
</div>
</LayoutTemplate>
</asp:Login>
</asp:Content>
Raw
Login.aspx.cs
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
public partial class Account_Login : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
RegisterHyperLink.NavigateUrl = "Register.aspx?ReturnUrl=" + HttpUtility.UrlEncode(Request.QueryString["ReturnUrl"]);
}
}
Raw
MockSchoolRepository.cs
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using ContosoUniversity.DAL;
namespace ContosoUniversity.Tests
{
class MockSchoolRepository : ISchoolRepository, IDisposable
{
List<Department> departments = new List<Department>();
List<InstructorName> instructors = new List<InstructorName>();
public IEnumerable<Department> GetDepartments()
{
return departments;
}
public void InsertDepartment(Department department)
{
departments.Add(department);
}
public void DeleteDepartment(Department department)
{
departments.Remove(department);
}
public void UpdateDepartment(Department department, Department origDepartment)
{
departments.Remove(origDepartment);
departments.Add(department);
}
public IEnumerable<InstructorName> GetInstructorNames()
{
return instructors;
}
public void Dispose()
{
}
public IEnumerable<Department> GetDepartmentsByAdministrator(int administrator)
{
return departments.Where(x=>x.Administrator == administrator);
}
}
}
Raw
Register.aspx
<%@ Page Title="登録する" Language="C#" MasterPageFile="~/Site.master" AutoEventWireup="true"
CodeFile="Register.aspx.cs" Inherits="Account_Register" %>
<asp:Content ID="HeaderContent" runat="server" ContentPlaceHolderID="HeadContent">
</asp:Content>
<asp:Content ID="BodyContent" runat="server" ContentPlaceHolderID="MainContent">
<asp:CreateUserWizard ID="RegisterUser" runat="server" EnableViewState="false" OnCreatedUser="RegisterUser_CreatedUser">
<LayoutTemplate>
<asp:PlaceHolder ID="wizardStepPlaceholder" runat="server"></asp:PlaceHolder>
<asp:PlaceHolder ID="navigationPlaceholder" runat="server"></asp:PlaceHolder>
</LayoutTemplate>
<WizardSteps>
<asp:CreateUserWizardStep ID="RegisterUserWizardStep" runat="server">
<ContentTemplate>
<h2>
アカウントの新規作成
</h2>
<p>
新しいアカウントを作成するには、以下のフォームを使用してください。
</p>
<p>
パスワードは、<%= Membership.MinRequiredPasswordLength %> 文字以上であることが必要です。
</p>
<span class="failureNotification">
<asp:Literal ID="ErrorMessage" runat="server"></asp:Literal>
</span>
<asp:ValidationSummary ID="RegisterUserValidationSummary" runat="server" CssClass="failureNotification"
ValidationGroup="RegisterUserValidationGroup"/>
<div class="accountInfo">
<fieldset class="register">
<legend>アカウント情報</legend>
<p>
<asp:Label ID="UserNameLabel" runat="server" AssociatedControlID="UserName">ユーザー名:</asp:Label>
<asp:TextBox ID="UserName" runat="server" CssClass="textEntry"></asp:TextBox>
<asp:RequiredFieldValidator ID="UserNameRequired" runat="server" ControlToValidate="UserName"
CssClass="failureNotification" ErrorMessage="ユーザー名が必要です。" ToolTip="ユーザー名が必要です。"
ValidationGroup="RegisterUserValidationGroup">*</asp:RequiredFieldValidator>
</p>
<p>
<asp:Label ID="EmailLabel" runat="server" AssociatedControlID="Email">電子メール:</asp:Label>
<asp:TextBox ID="Email" runat="server" CssClass="textEntry"></asp:TextBox>
<asp:RequiredFieldValidator ID="EmailRequired" runat="server" ControlToValidate="Email"
CssClass="failureNotification" ErrorMessage="電子メールが必要です。" ToolTip="電子メールが必要です。"
ValidationGroup="RegisterUserValidationGroup">*</asp:RequiredFieldValidator>
</p>
<p>
<asp:Label ID="PasswordLabel" runat="server" AssociatedControlID="Password">パスワード:</asp:Label>
<asp:TextBox ID="Password" runat="server" CssClass="passwordEntry" TextMode="Password"></asp:TextBox>
<asp:RequiredFieldValidator ID="PasswordRequired" runat="server" ControlToValidate="Password"
CssClass="failureNotification" ErrorMessage="パスワードが必要です。" ToolTip="パスワードが必要です。"
ValidationGroup="RegisterUserValidationGroup">*</asp:RequiredFieldValidator>
</p>
<p>
<asp:Label ID="ConfirmPasswordLabel" runat="server" AssociatedControlID="ConfirmPassword">パスワードの確認入力:</asp:Label>
<asp:TextBox ID="ConfirmPassword" runat="server" CssClass="passwordEntry" TextMode="Password"></asp:TextBox>
<asp:RequiredFieldValidator ControlToValidate="ConfirmPassword" CssClass="failureNotification" Display="Dynamic"
ErrorMessage="パスワードの確認入力が必要です。" ID="ConfirmPasswordRequired" runat="server"
ToolTip="パスワードの確認入力が必要です。" ValidationGroup="RegisterUserValidationGroup">*</asp:RequiredFieldValidator>
<asp:CompareValidator ID="PasswordCompare" runat="server" ControlToCompare="Password" ControlToValidate="ConfirmPassword"
CssClass="failureNotification" Display="Dynamic" ErrorMessage="パスワードと確認用パスワードは一致しなければなりません。"
ValidationGroup="RegisterUserValidationGroup">*</asp:CompareValidator>
</p>
</fieldset>
<p class="submitButton">
<asp:Button ID="CreateUserButton" runat="server" CommandName="MoveNext" Text="ユーザーの作成"
ValidationGroup="RegisterUserValidationGroup"/>
</p>
</div>
</ContentTemplate>
<CustomNavigationTemplate>
</CustomNavigationTemplate>
</asp:CreateUserWizardStep>
</WizardSteps>
</asp:CreateUserWizard>
</asp:Content>
Raw
Register.aspx.cs
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
public partial class Account_Register : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
RegisterUser.ContinueDestinationPageUrl = Request.QueryString["ReturnUrl"];
}
protected void RegisterUser_CreatedUser(object sender, EventArgs e)
{
FormsAuthentication.SetAuthCookie(RegisterUser.UserName, false /* createPersistentCookie */);
string continueUrl = RegisterUser.ContinueDestinationPageUrl;
if (String.IsNullOrEmpty(continueUrl))
{
continueUrl = "~/";
}
Response.Redirect(continueUrl);
}
}
Raw
SchoolBL.cs
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using ContosoUniversity.DAL;
namespace ContosoUniversity.BLL
{
public class SchoolBL : IDisposable
{
private ISchoolRepository schoolRepository;
public SchoolBL()
{
this.schoolRepository = new SchoolRepository();
}
public SchoolBL(ISchoolRepository schoolRepository)
{
this.schoolRepository = schoolRepository;
}
public IEnumerable<Department> GetDepartments()
{
return schoolRepository.GetDepartments();
}
public void InsertDepartment(Department department)
{
ValidateOneAdministratorAssignmentPerInstructor(department);
schoolRepository.InsertDepartment(department);
}
public void DeleteDepartment(Department department)
{
ValidateOneAdministratorAssignmentPerInstructor(department);
schoolRepository.DeleteDepartment(department);
}
public void UpdateDepartment(Department department, Department origDepartment)
{
ValidateOneAdministratorAssignmentPerInstructor(department);
schoolRepository.UpdateDepartment(department, origDepartment);
}
public IEnumerable<InstructorName> GetInstructorNames()
{
return schoolRepository.GetInstructorNames();
}
private bool disposedValue = false;
protected virtual void Dispose(bool disposing)
{
if (!this.disposedValue)
{
if (disposing)
{
schoolRepository.Dispose();
}
}
this.disposedValue = true;
}
public void Dispose()
{
Dispose(true);
GC.SuppressFinalize(this);
}
private void ValidateOneAdministratorAssignmentPerInstructor(Department department)
{
if (department.Administrator != null)
{
var duplicateDepartment = schoolRepository.GetDepartmentsByAdministrator(department.Administrator.GetValueOrDefault()).FirstOrDefault();
if (duplicateDepartment != null && duplicateDepartment.DepartmentID != department.DepartmentID)
{
throw new DuplicateAdministratorException(String.Format(
"Instructor {0} {1} is already administrator of the {2} department.",
duplicateDepartment.Person.FirstMidName,
duplicateDepartment.Person.LastName,
duplicateDepartment.Name));
}
}
}
}
}
Raw
SchoolBLTest.cs
using System.Linq;
using Microsoft.VisualStudio.TestTools.UnitTesting;
using ContosoUniversity.BLL;
using ContosoUniversity.DAL;
namespace ContosoUniversity.Tests
{
[TestClass()]
public class SchoolBLTest
{
private SchoolBL CreateSchoolBL()
{
var schoolRepository = new MockSchoolRepository();
var schoolBL = new SchoolBL(schoolRepository);
schoolBL.InsertDepartment(new Department() { Name = "First Department", DepartmentID = 0, Administrator = 1, Person = new Instructor() { FirstMidName = "Admin", LastName = "One" } });
schoolBL.InsertDepartment(new Department() { Name = "Second Department", DepartmentID = 1, Administrator = 2, Person = new Instructor() { FirstMidName = "Admin", LastName = "Two" } });
schoolBL.InsertDepartment(new Department() { Name = "Third Department", DepartmentID = 2, Administrator = 3, Person = new Instructor() { FirstMidName = "Admin", LastName = "Three" } });
return schoolBL;
}
[TestMethod]
[ExpectedException(typeof(DuplicateAdministratorException))]
public void AdministratorAssignmentRestrictionOnInsert()
{
var schoolBL = CreateSchoolBL();
schoolBL.InsertDepartment(new Department() { Name = "Fourth Department", DepartmentID = 3, Administrator = 2, Person = new Instructor() { FirstMidName = "Admin", LastName = "Two" } });
}
[TestMethod]
[ExpectedException(typeof(DuplicateAdministratorException))]
public void AdministratorAssignmentRestrictionOnUpdate()
{
var schoolBL = CreateSchoolBL();
var origDepartment = (from d in schoolBL.GetDepartments()
where d.Name == "Second Department"
select d).First();
var department = (from d in schoolBL.GetDepartments()
where d.Name == "Second Department"
select d).First();
department.Administrator = 1;
schoolBL.UpdateDepartment(department, origDepartment);
}
}
}
Raw
SchoolModel.Designer.cs
//------------------------------------------------------------------------------
// <auto-generated>
// このコードはテンプレートから生成されました。
//
// このファイルを手動で変更すると、アプリケーションで予期しない動作が発生する可能性があります。
// このファイルに対する手動の変更は、コードが再生成されると上書きされます。
// </auto-generated>
//------------------------------------------------------------------------------
using System;
using System.Data.Objects;
using System.Data.Objects.DataClasses;
using System.Data.EntityClient;
using System.ComponentModel;
using System.Xml.Serialization;
using System.Runtime.Serialization;
[assembly: EdmSchemaAttribute()]
#region EDM リレーションシップのメタデータ
[assembly: EdmRelationshipAttribute("SchoolModel", "FK_Course_Department", "Department", System.Data.Metadata.Edm.RelationshipMultiplicity.One, typeof(ContosoUniversity.DAL.Department), "Course", System.Data.Metadata.Edm.RelationshipMultiplicity.Many, typeof(ContosoUniversity.DAL.Course), true)]
[assembly: EdmRelationshipAttribute("SchoolModel", "FK_OnlineCourse_Course", "Course", System.Data.Metadata.Edm.RelationshipMultiplicity.One, typeof(ContosoUniversity.DAL.Course), "OnlineCourse", System.Data.Metadata.Edm.RelationshipMultiplicity.ZeroOrOne, typeof(ContosoUniversity.DAL.OnlineCourse), true)]
[assembly: EdmRelationshipAttribute("SchoolModel", "FK_OnsiteCourse_Course", "Course", System.Data.Metadata.Edm.RelationshipMultiplicity.One, typeof(ContosoUniversity.DAL.Course), "OnsiteCourse", System.Data.Metadata.Edm.RelationshipMultiplicity.ZeroOrOne, typeof(ContosoUniversity.DAL.OnsiteCourse), true)]
[assembly: EdmRelationshipAttribute("SchoolModel", "FK_StudentGrade_Course", "Course", System.Data.Metadata.Edm.RelationshipMultiplicity.One, typeof(ContosoUniversity.DAL.Course), "StudentGrade", System.Data.Metadata.Edm.RelationshipMultiplicity.Many, typeof(ContosoUniversity.DAL.StudentGrade), true)]
[assembly: EdmRelationshipAttribute("SchoolModel", "FK_Department_Person", "Person", System.Data.Metadata.Edm.RelationshipMultiplicity.ZeroOrOne, typeof(ContosoUniversity.DAL.Person), "Department", System.Data.Metadata.Edm.RelationshipMultiplicity.Many, typeof(ContosoUniversity.DAL.Department), true)]
[assembly: EdmRelationshipAttribute("SchoolModel", "FK_OfficeAssignment_Person", "Person", System.Data.Metadata.Edm.RelationshipMultiplicity.One, typeof(ContosoUniversity.DAL.Person), "OfficeAssignment", System.Data.Metadata.Edm.RelationshipMultiplicity.ZeroOrOne, typeof(ContosoUniversity.DAL.OfficeAssignment), true)]
[assembly: EdmRelationshipAttribute("SchoolModel", "FK_StudentGrade_Student", "Person", System.Data.Metadata.Edm.RelationshipMultiplicity.One, typeof(ContosoUniversity.DAL.Person), "StudentGrade", System.Data.Metadata.Edm.RelationshipMultiplicity.Many, typeof(ContosoUniversity.DAL.StudentGrade), true)]
[assembly: EdmRelationshipAttribute("SchoolModel", "CourseInstructor", "Course", System.Data.Metadata.Edm.RelationshipMultiplicity.Many, typeof(ContosoUniversity.DAL.Course), "Person", System.Data.Metadata.Edm.RelationshipMultiplicity.Many, typeof(ContosoUniversity.DAL.Person))]
#endregion
namespace ContosoUniversity.DAL
{
#region コンテキスト
/// <summary>
/// 使用できるメタデータ ドキュメントはありません。
/// </summary>
public partial class SchoolEntities : ObjectContext
{
#region コンストラクター
/// <summary>
/// アプリケーション構成ファイルの 'SchoolEntities' セクションにある接続文字列を使用して新しい SchoolEntities オブジェクトを初期化します。
/// </summary>
public SchoolEntities() : base("name=SchoolEntities", "SchoolEntities")
{
this.ContextOptions.LazyLoadingEnabled = true;
OnContextCreated();
}
/// <summary>
/// 新しい SchoolEntities オブジェクトを初期化します。
/// </summary>
public SchoolEntities(string connectionString) : base(connectionString, "SchoolEntities")
{
this.ContextOptions.LazyLoadingEnabled = true;
OnContextCreated();
}
/// <summary>
/// 新しい SchoolEntities オブジェクトを初期化します。
/// </summary>
public SchoolEntities(EntityConnection connection) : base(connection, "SchoolEntities")
{
this.ContextOptions.LazyLoadingEnabled = true;
OnContextCreated();
}
#endregion
#region 部分メソッド
partial void OnContextCreated();
#endregion
#region ObjectSet プロパティ
/// <summary>
/// 使用できるメタデータ ドキュメントはありません。
/// </summary>
public ObjectSet<Course> Courses
{
get
{
if ((_Courses == null))
{
_Courses = base.CreateObjectSet<Course>("Courses");
}
return _Courses;
}
}
private ObjectSet<Course> _Courses;
/// <summary>
/// 使用できるメタデータ ドキュメントはありません。
/// </summary>
public ObjectSet<Department> Departments
{
get
{
if ((_Departments == null))
{
_Departments = base.CreateObjectSet<Department>("Departments");
}
return _Departments;
}
}
private ObjectSet<Department> _Departments;
/// <summary>
/// 使用できるメタデータ ドキュメントはありません。
/// </summary>
public ObjectSet<OfficeAssignment> OfficeAssignments
{
get
{
if ((_OfficeAssignments == null))
{
_OfficeAssignments = base.CreateObjectSet<OfficeAssignment>("OfficeAssignments");
}
return _OfficeAssignments;
}
}
private ObjectSet<OfficeAssignment> _OfficeAssignments;
/// <summary>
/// 使用できるメタデータ ドキュメントはありません。
/// </summary>
public ObjectSet<OnlineCourse> OnlineCourses
{
get
{
if ((_OnlineCourses == null))
{
_OnlineCourses = base.CreateObjectSet<OnlineCourse>("OnlineCourses");
}
return _OnlineCourses;
}
}
private ObjectSet<OnlineCourse> _OnlineCourses;
/// <summary>
/// 使用できるメタデータ ドキュメントはありません。
/// </summary>
public ObjectSet<OnsiteCourse> OnsiteCourses
{
get
{
if ((_OnsiteCourses == null))
{
_OnsiteCourses = base.CreateObjectSet<OnsiteCourse>("OnsiteCourses");
}
return _OnsiteCourses;
}
}
private ObjectSet<OnsiteCourse> _OnsiteCourses;
/// <summary>
/// 使用できるメタデータ ドキュメントはありません。
/// </summary>
public ObjectSet<Person> People
{
get
{
if ((_People == null))
{
_People = base.CreateObjectSet<Person>("People");
}
return _People;
}
}
private ObjectSet<Person> _People;
/// <summary>
/// 使用できるメタデータ ドキュメントはありません。
/// </summary>
public ObjectSet<StudentGrade> StudentGrades
{
get
{
if ((_StudentGrades == null))
{
_StudentGrades = base.CreateObjectSet<StudentGrade>("StudentGrades");
}
return _StudentGrades;
}
}
private ObjectSet<StudentGrade> _StudentGrades;
/// <summary>
/// 使用できるメタデータ ドキュメントはありません。
/// </summary>
public ObjectSet<InstructorName> InstructorNames
{
get
{
if ((_InstructorNames == null))
{
_InstructorNames = base.CreateObjectSet<InstructorName>("InstructorNames");
}
return _InstructorNames;
}
}
private ObjectSet<InstructorName> _InstructorNames;
#endregion
#region AddTo メソッド
/// <summary>
/// Courses EntitySet に新しいオブジェクトを追加するための非推奨のメソッドです。代わりに、関連付けられている ObjectSet&lt;T&gt; プロパティの .Add メソッドを使用してください。
/// </summary>
public void AddToCourses(Course course)
{
base.AddObject("Courses", course);
}
/// <summary>
/// Departments EntitySet に新しいオブジェクトを追加するための非推奨のメソッドです。代わりに、関連付けられている ObjectSet&lt;T&gt; プロパティの .Add メソッドを使用してください。
/// </summary>
public void AddToDepartments(Department department)
{
base.AddObject("Departments", department);
}
/// <summary>
/// OfficeAssignments EntitySet に新しいオブジェクトを追加するための非推奨のメソッドです。代わりに、関連付けられている ObjectSet&lt;T&gt; プロパティの .Add メソッドを使用してください。
/// </summary>
public void AddToOfficeAssignments(OfficeAssignment officeAssignment)
{
base.AddObject("OfficeAssignments", officeAssignment);
}
/// <summary>
/// OnlineCourses EntitySet に新しいオブジェクトを追加するための非推奨のメソッドです。代わりに、関連付けられている ObjectSet&lt;T&gt; プロパティの .Add メソッドを使用してください。
/// </summary>
public void AddToOnlineCourses(OnlineCourse onlineCourse)
{
base.AddObject("OnlineCourses", onlineCourse);
}
/// <summary>
/// OnsiteCourses EntitySet に新しいオブジェクトを追加するための非推奨のメソッドです。代わりに、関連付けられている ObjectSet&lt;T&gt; プロパティの .Add メソッドを使用してください。
/// </summary>
public void AddToOnsiteCourses(OnsiteCourse onsiteCourse)
{
base.AddObject("OnsiteCourses", onsiteCourse);
}
/// <summary>
/// People EntitySet に新しいオブジェクトを追加するための非推奨のメソッドです。代わりに、関連付けられている ObjectSet&lt;T&gt; プロパティの .Add メソッドを使用してください。
/// </summary>
public void AddToPeople(Person person)
{
base.AddObject("People", person);
}
/// <summary>
/// StudentGrades EntitySet に新しいオブジェクトを追加するための非推奨のメソッドです。代わりに、関連付けられている ObjectSet&lt;T&gt; プロパティの .Add メソッドを使用してください。
/// </summary>
public void AddToStudentGrades(StudentGrade studentGrade)
{
base.AddObject("StudentGrades", studentGrade);
}
/// <summary>
/// InstructorNames EntitySet に新しいオブジェクトを追加するための非推奨のメソッドです。代わりに、関連付けられている ObjectSet&lt;T&gt; プロパティの .Add メソッドを使用してください。
/// </summary>
public void AddToInstructorNames(InstructorName instructorName)
{
base.AddObject("InstructorNames", instructorName);
}
#endregion
#region 関数インポート
/// <summary>
/// 使用できるメタデータ ドキュメントはありません。
/// </summary>
public ObjectResult<Course> GetCourses()
{
return base.ExecuteFunction<Course>("GetCourses");
}
/// <summary>
/// 使用できるメタデータ ドキュメントはありません。
/// </summary>
/// <param name="mergeOption"></param>
public ObjectResult<Course> GetCourses(MergeOption mergeOption)
{
return base.ExecuteFunction<Course>("GetCourses", mergeOption);
}
#endregion
}
#endregion
#region エンティティ
/// <summary>
/// 使用できるメタデータ ドキュメントはありません。
/// </summary>
[EdmEntityTypeAttribute(NamespaceName="SchoolModel", Name="Course")]
[Serializable()]
[DataContractAttribute(IsReference=true)]
public partial class Course : EntityObject
{
#region ファクトリ メソッド
/// <summary>
/// 新しい Course オブジェクトを作成します。
/// </summary>
/// <param name="courseID">CourseID プロパティの初期値。</param>
/// <param name="title">Title プロパティの初期値。</param>
/// <param name="credits">Credits プロパティの初期値。</param>
/// <param name="departmentID">DepartmentID プロパティの初期値。</param>
public static Course CreateCourse(global::System.Int32 courseID, global::System.String title, global::System.Int32 credits, global::System.Int32 departmentID)
{
Course course = new Course();
course.CourseID = courseID;
course.Title = title;
course.Credits = credits;
course.DepartmentID = departmentID;
return course;
}
#endregion
#region プリミティブ プロパティ
/// <summary>
/// 使用できるメタデータ ドキュメントはありません。
/// </summary>
[EdmScalarPropertyAttribute(EntityKeyProperty=true, IsNullable=false)]
[DataMemberAttribute()]
public global::System.Int32 CourseID
{
get
{
return _CourseID;
}
set
{
if (_CourseID != value)
{
OnCourseIDChanging(value);
ReportPropertyChanging("CourseID");
_CourseID = StructuralObject.SetValidValue(value);
ReportPropertyChanged("CourseID");
OnCourseIDChanged();
}
}
}
private global::System.Int32 _CourseID;
partial void OnCourseIDChanging(global::System.Int32 value);
partial void OnCourseIDChanged();
/// <summary>
/// 使用できるメタデータ ドキュメントはありません。
/// </summary>
[EdmScalarPropertyAttribute(EntityKeyProperty=false, IsNullable=false)]
[DataMemberAttribute()]
public global::System.String Title
{
get
{
return _Title;
}
set
{
OnTitleChanging(value);
ReportPropertyChanging("Title");
_Title = StructuralObject.SetValidValue(value, false);
ReportPropertyChanged("Title");
OnTitleChanged();
}
}
private global::System.String _Title;
partial void OnTitleChanging(global::System.String value);
partial void OnTitleChanged();
/// <summary>
/// 使用できるメタデータ ドキュメントはありません。
/// </summary>
[EdmScalarPropertyAttribute(EntityKeyProperty=false, IsNullable=false)]
[DataMemberAttribute()]
public global::System.Int32 Credits
{
get
{
return _Credits;
}
set
{
OnCreditsChanging(value);
ReportPropertyChanging("Credits");
_Credits = StructuralObject.SetValidValue(value);
ReportPropertyChanged("Credits");
OnCreditsChanged();
}
}
private global::System.Int32 _Credits;
partial void OnCreditsChanging(global::System.Int32 value);
partial void OnCreditsChanged();
/// <summary>
/// 使用できるメタデータ ドキュメントはありません。
/// </summary>
[EdmScalarPropertyAttribute(EntityKeyProperty=false, IsNullable=false)]
[DataMemberAttribute()]
public global::System.Int32 DepartmentID
{
get
{
return _DepartmentID;
}
set
{
OnDepartmentIDChanging(value);
ReportPropertyChanging("DepartmentID");
_DepartmentID = StructuralObject.SetValidValue(value);
ReportPropertyChanged("DepartmentID");
OnDepartmentIDChanged();
}
}
private global::System.Int32 _DepartmentID;
partial void OnDepartmentIDChanging(global::System.Int32 value);
partial void OnDepartmentIDChanged();
#endregion
#region ナビゲーション プロパティ
/// <summary>
/// 使用できるメタデータ ドキュメントはありません。
/// </summary>
[XmlIgnoreAttribute()]
[SoapIgnoreAttribute()]
[DataMemberAttribute()]
[EdmRelationshipNavigationPropertyAttribute("SchoolModel", "FK_Course_Department", "Department")]
public Department Department
{
get
{
return ((IEntityWithRelationships)this).RelationshipManager.GetRelatedReference<Department>("SchoolModel.FK_Course_Department", "Department").Value;
}
set
{
((IEntityWithRelationships)this).RelationshipManager.GetRelatedReference<Department>("SchoolModel.FK_Course_Department", "Department").Value = value;
}
}
/// <summary>
/// 使用できるメタデータ ドキュメントはありません。
/// </summary>
[BrowsableAttribute(false)]
[DataMemberAttribute()]
public EntityReference<Department> DepartmentReference
{
get
{
return ((IEntityWithRelationships)this).RelationshipManager.GetRelatedReference<Department>("SchoolModel.FK_Course_Department", "Department");
}
set
{
if ((value != null))
{
((IEntityWithRelationships)this).RelationshipManager.InitializeRelatedReference<Department>("SchoolModel.FK_Course_Department", "Department", value);
}
}
}
/// <summary>
/// 使用できるメタデータ ドキュメントはありません。
/// </summary>
[XmlIgnoreAttribute()]
[SoapIgnoreAttribute()]
[DataMemberAttribute()]
[EdmRelationshipNavigationPropertyAttribute("SchoolModel", "FK_OnlineCourse_Course", "OnlineCourse")]
public OnlineCourse OnlineCourse
{
get
{
return ((IEntityWithRelationships)this).RelationshipManager.GetRelatedReference<OnlineCourse>("SchoolModel.FK_OnlineCourse_Course", "OnlineCourse").Value;
}
set
{
((IEntityWithRelationships)this).RelationshipManager.GetRelatedReference<OnlineCourse>("SchoolModel.FK_OnlineCourse_Course", "OnlineCourse").Value = value;
}
}
/// <summary>
/// 使用できるメタデータ ドキュメントはありません。
/// </summary>
[BrowsableAttribute(false)]
[DataMemberAttribute()]
public EntityReference<OnlineCourse> OnlineCourseReference
{
get
{
return ((IEntityWithRelationships)this).RelationshipManager.GetRelatedReference<OnlineCourse>("SchoolModel.FK_OnlineCourse_Course", "OnlineCourse");
}
set
{
if ((value != null))
{
((IEntityWithRelationships)this).RelationshipManager.InitializeRelatedReference<OnlineCourse>("SchoolModel.FK_OnlineCourse_Course", "OnlineCourse", value);
}
}
}
/// <summary>
/// 使用できるメタデータ ドキュメントはありません。
/// </summary>
[XmlIgnoreAttribute()]
[SoapIgnoreAttribute()]
[DataMemberAttribute()]
[EdmRelationshipNavigationPropertyAttribute("SchoolModel", "FK_OnsiteCourse_Course", "OnsiteCourse")]
public OnsiteCourse OnsiteCourse
{
get
{
return ((IEntityWithRelationships)this).RelationshipManager.GetRelatedReference<OnsiteCourse>("SchoolModel.FK_OnsiteCourse_Course", "OnsiteCourse").Value;
}
set
{
((IEntityWithRelationships)this).RelationshipManager.GetRelatedReference<OnsiteCourse>("SchoolModel.FK_OnsiteCourse_Course", "OnsiteCourse").Value = value;
}
}
/// <summary>
/// 使用できるメタデータ ドキュメントはありません。
/// </summary>
[BrowsableAttribute(false)]
[DataMemberAttribute()]
public EntityReference<OnsiteCourse> OnsiteCourseReference
{
get
{
return ((IEntityWithRelationships)this).RelationshipManager.GetRelatedReference<OnsiteCourse>("SchoolModel.FK_OnsiteCourse_Course", "OnsiteCourse");
}
set
{
if ((value != null))
{
((IEntityWithRelationships)this).RelationshipManager.InitializeRelatedReference<OnsiteCourse>("SchoolModel.FK_OnsiteCourse_Course", "OnsiteCourse", value);
}
}
}
/// <summary>
/// 使用できるメタデータ ドキュメントはありません。
/// </summary>
[XmlIgnoreAttribute()]
[SoapIgnoreAttribute()]
[DataMemberAttribute()]
[EdmRelationshipNavigationPropertyAttribute("SchoolModel", "FK_StudentGrade_Course", "StudentGrade")]
public EntityCollection<StudentGrade> StudentGrades
{
get
{
return ((IEntityWithRelationships)this).RelationshipManager.GetRelatedCollection<StudentGrade>("SchoolModel.FK_StudentGrade_Course", "StudentGrade");
}
set
{
if ((value != null))
{
((IEntityWithRelationships)this).RelationshipManager.InitializeRelatedCollection<StudentGrade>("SchoolModel.FK_StudentGrade_Course", "StudentGrade", value);
}
}
}
/// <summary>
/// 使用できるメタデータ ドキュメントはありません。
/// </summary>
[XmlIgnoreAttribute()]
[SoapIgnoreAttribute()]
[DataMemberAttribute()]
[EdmRelationshipNavigationPropertyAttribute("SchoolModel", "CourseInstructor", "Person")]
public EntityCollection<Person> People
{
get
{
return ((IEntityWithRelationships)this).RelationshipManager.GetRelatedCollection<Person>("SchoolModel.CourseInstructor", "Person");
}
set
{
if ((value != null))
{
((IEntityWithRelationships)this).RelationshipManager.InitializeRelatedCollection<Person>("SchoolModel.CourseInstructor", "Person", value);
}
}
}
#endregion
}
/// <summary>
/// 使用できるメタデータ ドキュメントはありません。
/// </summary>
[EdmEntityTypeAttribute(NamespaceName="SchoolModel", Name="Department")]
[Serializable()]
[DataContractAttribute(IsReference=true)]
public partial class Department : EntityObject
{
#region ファクトリ メソッド
/// <summary>
/// 新しい Department オブジェクトを作成します。
/// </summary>
/// <param name="departmentID">DepartmentID プロパティの初期値。</param>
/// <param name="name">Name プロパティの初期値。</param>
/// <param name="budget">Budget プロパティの初期値。</param>
/// <param name="startDate">StartDate プロパティの初期値。</param>
public static Department CreateDepartment(global::System.Int32 departmentID, global::System.String name, global::System.Decimal budget, global::System.DateTime startDate)
{
Department department = new Department();
department.DepartmentID = departmentID;
department.Name = name;
department.Budget = budget;
department.StartDate = startDate;
return department;
}
#endregion
#region プリミティブ プロパティ
/// <summary>
/// 使用できるメタデータ ドキュメントはありません。
/// </summary>
[EdmScalarPropertyAttribute(EntityKeyProperty=true, IsNullable=false)]
[DataMemberAttribute()]
public global::System.Int32 DepartmentID
{
get
{
return _DepartmentID;
}
set
{
if (_DepartmentID != value)
{
OnDepartmentIDChanging(value);
ReportPropertyChanging("DepartmentID");
_DepartmentID = StructuralObject.SetValidValue(value);
ReportPropertyChanged("DepartmentID");
OnDepartmentIDChanged();
}
}
}
private global::System.Int32 _DepartmentID;
partial void OnDepartmentIDChanging(global::System.Int32 value);
partial void OnDepartmentIDChanged();
/// <summary>
/// 使用できるメタデータ ドキュメントはありません。
/// </summary>
[EdmScalarPropertyAttribute(EntityKeyProperty=false, IsNullable=false)]
[DataMemberAttribute()]
public global::System.String Name
{
get
{
return _Name;
}
set
{
OnNameChanging(value);
ReportPropertyChanging("Name");
_Name = StructuralObject.SetValidValue(value, false);
ReportPropertyChanged("Name");
OnNameChanged();
}
}
private global::System.String _Name;
partial void OnNameChanging(global::System.String value);
partial void OnNameChanged();
/// <summary>
/// 使用できるメタデータ ドキュメントはありません。
/// </summary>
[EdmScalarPropertyAttribute(EntityKeyProperty=false, IsNullable=false)]
[DataMemberAttribute()]
public global::System.Decimal Budget
{
get
{
return _Budget;
}
set
{
OnBudgetChanging(value);
ReportPropertyChanging("Budget");
_Budget = StructuralObject.SetValidValue(value);
ReportPropertyChanged("Budget");
OnBudgetChanged();
}
}
private global::System.Decimal _Budget;
partial void OnBudgetChanging(global::System.Decimal value);
partial void OnBudgetChanged();
/// <summary>
/// 使用できるメタデータ ドキュメントはありません。
/// </summary>
[EdmScalarPropertyAttribute(EntityKeyProperty=false, IsNullable=false)]
[DataMemberAttribute()]
public global::System.DateTime StartDate
{
get
{
return _StartDate;
}
set
{
OnStartDateChanging(value);
ReportPropertyChanging("StartDate");
_StartDate = StructuralObject.SetValidValue(value);
ReportPropertyChanged("StartDate");
OnStartDateChanged();
}
}
private global::System.DateTime _StartDate;
partial void OnStartDateChanging(global::System.DateTime value);
partial void OnStartDateChanged();
/// <summary>
/// 使用できるメタデータ ドキュメントはありません。
/// </summary>
[EdmScalarPropertyAttribute(EntityKeyProperty=false, IsNullable=true)]
[DataMemberAttribute()]
public Nullable<global::System.Int32> Administrator
{
get
{
return _Administrator;
}
set
{
OnAdministratorChanging(value);
ReportPropertyChanging("Administrator");
_Administrator = StructuralObject.SetValidValue(value);
ReportPropertyChanged("Administrator");
OnAdministratorChanged();
}
}
private Nullable<global::System.Int32> _Administrator;
partial void OnAdministratorChanging(Nullable<global::System.Int32> value);
partial void OnAdministratorChanged();
#endregion
#region ナビゲーション プロパティ
/// <summary>
/// 使用できるメタデータ ドキュメントはありません。
/// </summary>
[XmlIgnoreAttribute()]
[SoapIgnoreAttribute()]
[DataMemberAttribute()]
[EdmRelationshipNavigationPropertyAttribute("SchoolModel", "FK_Course_Department", "Course")]
public EntityCollection<Course> Courses
{
get
{
return ((IEntityWithRelationships)this).RelationshipManager.GetRelatedCollection<Course>("SchoolModel.FK_Course_Department", "Course");
}
set
{
if ((value != null))
{
((IEntityWithRelationships)this).RelationshipManager.InitializeRelatedCollection<Course>("SchoolModel.FK_Course_Department", "Course", value);
}
}
}
/// <summary>
/// 使用できるメタデータ ドキュメントはありません。
/// </summary>
[XmlIgnoreAttribute()]
[SoapIgnoreAttribute()]
[DataMemberAttribute()]
[EdmRelationshipNavigationPropertyAttribute("SchoolModel", "FK_Department_Person", "Person")]
public Person Person
{
get
{
return ((IEntityWithRelationships)this).RelationshipManager.GetRelatedReference<Person>("SchoolModel.FK_Department_Person", "Person").Value;
}
set
{
((IEntityWithRelationships)this).RelationshipManager.GetRelatedReference<Person>("SchoolModel.FK_Department_Person", "Person").Value = value;
}
}
/// <summary>
/// 使用できるメタデータ ドキュメントはありません。
/// </summary>
[BrowsableAttribute(false)]
[DataMemberAttribute()]
public EntityReference<Person> PersonReference
{
get
{
return ((IEntityWithRelationships)this).RelationshipManager.GetRelatedReference<Person>("SchoolModel.FK_Department_Person", "Person");
}
set
{
if ((value != null))
{
((IEntityWithRelationships)this).RelationshipManager.InitializeRelatedReference<Person>("SchoolModel.FK_Department_Person", "Person", value);
}
}
}
#endregion
}
/// <summary>
/// 使用できるメタデータ ドキュメントはありません。
/// </summary>
[EdmEntityTypeAttribute(NamespaceName="SchoolModel", Name="Instructor")]
[Serializable()]
[DataContractAttribute(IsReference=true)]
public partial class Instructor : Person
{
#region ファクトリ メソッド
/// <summary>
/// 新しい Instructor オブジェクトを作成します。
/// </summary>
/// <param name="personID">PersonID プロパティの初期値。</param>
/// <param name="lastName">LastName プロパティの初期値。</param>
/// <param name="firstMidName">FirstMidName プロパティの初期値。</param>
/// <param name="hireDate">HireDate プロパティの初期値。</param>
public static Instructor CreateInstructor(global::System.Int32 personID, global::System.String lastName, global::System.String firstMidName, global::System.DateTime hireDate)
{
Instructor instructor = new Instructor();
instructor.PersonID = personID;
instructor.LastName = lastName;
instructor.FirstMidName = firstMidName;
instructor.HireDate = hireDate;
return instructor;
}
#endregion
#region プリミティブ プロパティ
/// <summary>
/// 使用できるメタデータ ドキュメントはありません。
/// </summary>
[EdmScalarPropertyAttribute(EntityKeyProperty=false, IsNullable=false)]
[DataMemberAttribute()]
public global::System.DateTime HireDate
{
get
{
return _HireDate;
}
set
{
OnHireDateChanging(value);
ReportPropertyChanging("HireDate");
_HireDate = StructuralObject.SetValidValue(value);
ReportPropertyChanged("HireDate");
OnHireDateChanged();
}
}
private global::System.DateTime _HireDate;
partial void OnHireDateChanging(global::System.DateTime value);
partial void OnHireDateChanged();
#endregion
}
/// <summary>
/// 使用できるメタデータ ドキュメントはありません。
/// </summary>
[EdmEntityTypeAttribute(NamespaceName="SchoolModel", Name="InstructorName")]
[Serializable()]
[DataContractAttribute(IsReference=true)]
public partial class InstructorName : EntityObject
{
#region ファクトリ メソッド
/// <summary>
/// 新しい InstructorName オブジェクトを作成します。
/// </summary>
/// <param name="fullName">FullName プロパティの初期値。</param>
/// <param name="personID">PersonID プロパティの初期値。</param>
public static InstructorName CreateInstructorName(global::System.String fullName, global::System.Int32 personID)
{
InstructorName instructorName = new InstructorName();
instructorName.FullName = fullName;
instructorName.PersonID = personID;
return instructorName;
}
#endregion
#region プリミティブ プロパティ
/// <summary>
/// 使用できるメタデータ ドキュメントはありません。
/// </summary>
[EdmScalarPropertyAttribute(EntityKeyProperty=true, IsNullable=false)]
[DataMemberAttribute()]
public global::System.String FullName
{
get
{
return _FullName;
}
set
{
if (_FullName != value)
{
OnFullNameChanging(value);
ReportPropertyChanging("FullName");
_FullName = StructuralObject.SetValidValue(value, false);
ReportPropertyChanged("FullName");
OnFullNameChanged();
}
}
}
private global::System.String _FullName;
partial void OnFullNameChanging(global::System.String value);
partial void OnFullNameChanged();
/// <summary>
/// 使用できるメタデータ ドキュメントはありません。
/// </summary>
[EdmScalarPropertyAttribute(EntityKeyProperty=true, IsNullable=false)]
[DataMemberAttribute()]
public global::System.Int32 PersonID
{
get
{
return _PersonID;
}
set
{
if (_PersonID != value)
{
OnPersonIDChanging(value);
ReportPropertyChanging("PersonID");
_PersonID = StructuralObject.SetValidValue(value);
ReportPropertyChanged("PersonID");
OnPersonIDChanged();
}
}
}
private global::System.Int32 _PersonID;
partial void OnPersonIDChanging(global::System.Int32 value);
partial void OnPersonIDChanged();
#endregion
}
/// <summary>
/// 使用できるメタデータ ドキュメントはありません。
/// </summary>
[EdmEntityTypeAttribute(NamespaceName="SchoolModel", Name="OfficeAssignment")]
[Serializable()]
[DataContractAttribute(IsReference=true)]
public partial class OfficeAssignment : EntityObject
{
#region ファクトリ メソッド
/// <summary>
/// 新しい OfficeAssignment オブジェクトを作成します。
/// </summary>
/// <param name="instructorID">InstructorID プロパティの初期値。</param>
/// <param name="location">Location プロパティの初期値。</param>
/// <param name="timestamp">Timestamp プロパティの初期値。</param>
public static OfficeAssignment CreateOfficeAssignment(global::System.Int32 instructorID, global::System.String location, global::System.Byte[] timestamp)
{
OfficeAssignment officeAssignment = new OfficeAssignment();
officeAssignment.InstructorID = instructorID;
officeAssignment.Location = location;
officeAssignment.Timestamp = timestamp;
return officeAssignment;
}
#endregion
#region プリミティブ プロパティ
/// <summary>
/// 使用できるメタデータ ドキュメントはありません。
/// </summary>
[EdmScalarPropertyAttribute(EntityKeyProperty=true, IsNullable=false)]
[DataMemberAttribute()]
public global::System.Int32 InstructorID
{
get
{
return _InstructorID;
}
set
{
if (_InstructorID != value)
{
OnInstructorIDChanging(value);
ReportPropertyChanging("InstructorID");
_InstructorID = StructuralObject.SetValidValue(value);
ReportPropertyChanged("InstructorID");
OnInstructorIDChanged();
}
}
}
private global::System.Int32 _InstructorID;
partial void OnInstructorIDChanging(global::System.Int32 value);
partial void OnInstructorIDChanged();
/// <summary>
/// 使用できるメタデータ ドキュメントはありません。
/// </summary>
[EdmScalarPropertyAttribute(EntityKeyProperty=false, IsNullable=false)]
[DataMemberAttribute()]
public global::System.String Location
{
get
{
return _Location;
}
set
{
OnLocationChanging(value);
ReportPropertyChanging("Location");
_Location = StructuralObject.SetValidValue(value, false);
ReportPropertyChanged("Location");
OnLocationChanged();
}
}
private global::System.String _Location;
partial void OnLocationChanging(global::System.String value);
partial void OnLocationChanged();
/// <summary>
/// 使用できるメタデータ ドキュメントはありません。
/// </summary>
[EdmScalarPropertyAttribute(EntityKeyProperty=false, IsNullable=false)]
[DataMemberAttribute()]
public global::System.Byte[] Timestamp
{
get
{
return StructuralObject.GetValidValue(_Timestamp);
}
set
{
OnTimestampChanging(value);
ReportPropertyChanging("Timestamp");
_Timestamp = StructuralObject.SetValidValue(value, true);
ReportPropertyChanged("Timestamp");
OnTimestampChanged();
}
}
private global::System.Byte[] _Timestamp;
partial void OnTimestampChanging(global::System.Byte[] value);
partial void OnTimestampChanged();
#endregion
#region ナビゲーション プロパティ
/// <summary>
/// 使用できるメタデータ ドキュメントはありません。
/// </summary>
[XmlIgnoreAttribute()]
[SoapIgnoreAttribute()]
[DataMemberAttribute()]
[EdmRelationshipNavigationPropertyAttribute("SchoolModel", "FK_OfficeAssignment_Person", "Person")]
public Person Person
{
get
{
return ((IEntityWithRelationships)this).RelationshipManager.GetRelatedReference<Person>("SchoolModel.FK_OfficeAssignment_Person", "Person").Value;
}
set
{
((IEntityWithRelationships)this).RelationshipManager.GetRelatedReference<Person>("SchoolModel.FK_OfficeAssignment_Person", "Person").Value = value;
}
}
/// <summary>
/// 使用できるメタデータ ドキュメントはありません。
/// </summary>
[BrowsableAttribute(false)]
[DataMemberAttribute()]
public EntityReference<Person> PersonReference
{
get
{
return ((IEntityWithRelationships)this).RelationshipManager.GetRelatedReference<Person>("SchoolModel.FK_OfficeAssignment_Person", "Person");
}
set
{
if ((value != null))
{
((IEntityWithRelationships)this).RelationshipManager.InitializeRelatedReference<Person>("SchoolModel.FK_OfficeAssignment_Person", "Person", value);
}
}
}
#endregion
}
/// <summary>
/// 使用できるメタデータ ドキュメントはありません。
/// </summary>
[EdmEntityTypeAttribute(NamespaceName="SchoolModel", Name="OnlineCourse")]
[Serializable()]
[DataContractAttribute(IsReference=true)]
public partial class OnlineCourse : EntityObject
{
#region ファクトリ メソッド
/// <summary>
/// 新しい OnlineCourse オブジェクトを作成します。
/// </summary>
/// <param name="courseID">CourseID プロパティの初期値。</param>
/// <param name="uRL">URL プロパティの初期値。</param>
public static OnlineCourse CreateOnlineCourse(global::System.Int32 courseID, global::System.String uRL)
{
OnlineCourse onlineCourse = new OnlineCourse();
onlineCourse.CourseID = courseID;
onlineCourse.URL = uRL;
return onlineCourse;
}
#endregion
#region プリミティブ プロパティ
/// <summary>
/// 使用できるメタデータ ドキュメントはありません。
/// </summary>
[EdmScalarPropertyAttribute(EntityKeyProperty=true, IsNullable=false)]
[DataMemberAttribute()]
public global::System.Int32 CourseID
{
get
{
return _CourseID;
}
set
{
if (_CourseID != value)
{
OnCourseIDChanging(value);
ReportPropertyChanging("CourseID");
_CourseID = StructuralObject.SetValidValue(value);
ReportPropertyChanged("CourseID");
OnCourseIDChanged();
}
}
}
private global::System.Int32 _CourseID;
partial void OnCourseIDChanging(global::System.Int32 value);
partial void OnCourseIDChanged();
/// <summary>
/// 使用できるメタデータ ドキュメントはありません。
/// </summary>
[EdmScalarPropertyAttribute(EntityKeyProperty=false, IsNullable=false)]
[DataMemberAttribute()]
public global::System.String URL
{
get
{
return _URL;
}
set
{
OnURLChanging(value);
ReportPropertyChanging("URL");
_URL = StructuralObject.SetValidValue(value, false);
ReportPropertyChanged("URL");
OnURLChanged();
}
}
private global::System.String _URL;
partial void OnURLChanging(global::System.String value);
partial void OnURLChanged();
#endregion
#region ナビゲーション プロパティ
/// <summary>
/// 使用できるメタデータ ドキュメントはありません。
/// </summary>
[XmlIgnoreAttribute()]
[SoapIgnoreAttribute()]
[DataMemberAttribute()]
[EdmRelationshipNavigationPropertyAttribute("SchoolModel", "FK_OnlineCourse_Course", "Course")]
public Course Course
{
get
{
return ((IEntityWithRelationships)this).RelationshipManager.GetRelatedReference<Course>("SchoolModel.FK_OnlineCourse_Course", "Course").Value;
}
set
{
((IEntityWithRelationships)this).RelationshipManager.GetRelatedReference<Course>("SchoolModel.FK_OnlineCourse_Course", "Course").Value = value;
}
}
/// <summary>
/// 使用できるメタデータ ドキュメントはありません。
/// </summary>
[BrowsableAttribute(false)]
[DataMemberAttribute()]
public EntityReference<Course> CourseReference
{
get
{
return ((IEntityWithRelationships)this).RelationshipManager.GetRelatedReference<Course>("SchoolModel.FK_OnlineCourse_Course", "Course");
}
set
{
if ((value != null))
{
((IEntityWithRelationships)this).RelationshipManager.InitializeRelatedReference<Course>("SchoolModel.FK_OnlineCourse_Course", "Course", value);
}
}
}
#endregion
}
/// <summary>
/// 使用できるメタデータ ドキュメントはありません。
/// </summary>
[EdmEntityTypeAttribute(NamespaceName="SchoolModel", Name="OnsiteCourse")]
[Serializable()]
[DataContractAttribute(IsReference=true)]
public partial class OnsiteCourse : EntityObject
{
#region ファクトリ メソッド
/// <summary>
/// 新しい OnsiteCourse オブジェクトを作成します。
/// </summary>
/// <param name="courseID">CourseID プロパティの初期値。</param>
/// <param name="location">Location プロパティの初期値。</param>
/// <param name="days">Days プロパティの初期値。</param>
/// <param name="time">Time プロパティの初期値。</param>
public static OnsiteCourse CreateOnsiteCourse(global::System.Int32 courseID, global::System.String location, global::System.String days, global::System.DateTime time)
{
OnsiteCourse onsiteCourse = new OnsiteCourse();
onsiteCourse.CourseID = courseID;
onsiteCourse.Location = location;
onsiteCourse.Days = days;
onsiteCourse.Time = time;
return onsiteCourse;
}
#endregion
#region プリミティブ プロパティ
/// <summary>
/// 使用できるメタデータ ドキュメントはありません。
/// </summary>
[EdmScalarPropertyAttribute(EntityKeyProperty=true, IsNullable=false)]
[DataMemberAttribute()]
public global::System.Int32 CourseID
{
get
{
return _CourseID;
}
set
{
if (_CourseID != value)
{
OnCourseIDChanging(value);
ReportPropertyChanging("CourseID");
_CourseID = StructuralObject.SetValidValue(value);
ReportPropertyChanged("CourseID");
OnCourseIDChanged();
}
}
}
private global::System.Int32 _CourseID;
partial void OnCourseIDChanging(global::System.Int32 value);
partial void OnCourseIDChanged();
/// <summary>
/// 使用できるメタデータ ドキュメントはありません。
/// </summary>
[EdmScalarPropertyAttribute(EntityKeyProperty=false, IsNullable=false)]
[DataMemberAttribute()]
public global::System.String Location
{
get
{
return _Location;
}
set
{
OnLocationChanging(value);
ReportPropertyChanging("Location");
_Location = StructuralObject.SetValidValue(value, false);
ReportPropertyChanged("Location");
OnLocationChanged();
}
}
private global::System.String _Location;
partial void OnLocationChanging(global::System.String value);
partial void OnLocationChanged();
/// <summary>
/// 使用できるメタデータ ドキュメントはありません。
/// </summary>
[EdmScalarPropertyAttribute(EntityKeyProperty=false, IsNullable=false)]
[DataMemberAttribute()]
public global::System.String Days
{
get
{
return _Days;
}
set
{
OnDaysChanging(value);
ReportPropertyChanging("Days");
_Days = StructuralObject.SetValidValue(value, false);
ReportPropertyChanged("Days");
OnDaysChanged();
}
}
private global::System.String _Days;
partial void OnDaysChanging(global::System.String value);
partial void OnDaysChanged();
/// <summary>
/// 使用できるメタデータ ドキュメントはありません。
/// </summary>
[EdmScalarPropertyAttribute(EntityKeyProperty=false, IsNullable=false)]
[DataMemberAttribute()]
public global::System.DateTime Time
{
get
{
return _Time;
}
set
{
OnTimeChanging(value);
ReportPropertyChanging("Time");
_Time = StructuralObject.SetValidValue(value);
ReportPropertyChanged("Time");
OnTimeChanged();
}
}
private global::System.DateTime _Time;
partial void OnTimeChanging(global::System.DateTime value);
partial void OnTimeChanged();
#endregion
#region ナビゲーション プロパティ
/// <summary>
/// 使用できるメタデータ ドキュメントはありません。
/// </summary>
[XmlIgnoreAttribute()]
[SoapIgnoreAttribute()]
[DataMemberAttribute()]
[EdmRelationshipNavigationPropertyAttribute("SchoolModel", "FK_OnsiteCourse_Course", "Course")]
public Course Course
{
get
{
return ((IEntityWithRelationships)this).RelationshipManager.GetRelatedReference<Course>("SchoolModel.FK_OnsiteCourse_Course", "Course").Value;
}
set
{
((IEntityWithRelationships)this).RelationshipManager.GetRelatedReference<Course>("SchoolModel.FK_OnsiteCourse_Course", "Course").Value = value;
}
}
/// <summary>
/// 使用できるメタデータ ドキュメントはありません。
/// </summary>
[BrowsableAttribute(false)]
[DataMemberAttribute()]
public EntityReference<Course> CourseReference
{
get
{
return ((IEntityWithRelationships)this).RelationshipManager.GetRelatedReference<Course>("SchoolModel.FK_OnsiteCourse_Course", "Course");
}
set
{
if ((value != null))
{
((IEntityWithRelationships)this).RelationshipManager.InitializeRelatedReference<Course>("SchoolModel.FK_OnsiteCourse_Course", "Course", value);
}
}
}
#endregion
}
/// <summary>
/// 使用できるメタデータ ドキュメントはありません。
/// </summary>
[EdmEntityTypeAttribute(NamespaceName="SchoolModel", Name="Person")]
[Serializable()]
[DataContractAttribute(IsReference=true)]
[KnownTypeAttribute(typeof(Student))]
[KnownTypeAttribute(typeof(Instructor))]
public partial class Person : EntityObject
{
#region ファクトリ メソッド
/// <summary>
/// 新しい Person オブジェクトを作成します。
/// </summary>
/// <param name="personID">PersonID プロパティの初期値。</param>
/// <param name="lastName">LastName プロパティの初期値。</param>
/// <param name="firstMidName">FirstMidName プロパティの初期値。</param>
public static Person CreatePerson(global::System.Int32 personID, global::System.String lastName, global::System.String firstMidName)
{
Person person = new Person();
person.PersonID = personID;
person.LastName = lastName;
person.FirstMidName = firstMidName;
return person;
}
#endregion
#region プリミティブ プロパティ
/// <summary>
/// 使用できるメタデータ ドキュメントはありません。
/// </summary>
[EdmScalarPropertyAttribute(EntityKeyProperty=true, IsNullable=false)]
[DataMemberAttribute()]
public global::System.Int32 PersonID
{
get
{
return _PersonID;
}
set
{
if (_PersonID != value)
{
OnPersonIDChanging(value);
ReportPropertyChanging("PersonID");
_PersonID = StructuralObject.SetValidValue(value);
ReportPropertyChanged("PersonID");
OnPersonIDChanged();
}
}
}
private global::System.Int32 _PersonID;
partial void OnPersonIDChanging(global::System.Int32 value);
partial void OnPersonIDChanged();
/// <summary>
/// 使用できるメタデータ ドキュメントはありません。
/// </summary>
[EdmScalarPropertyAttribute(EntityKeyProperty=false, IsNullable=false)]
[DataMemberAttribute()]
public global::System.String LastName
{
get
{
return _LastName;
}
set
{
OnLastNameChanging(value);
ReportPropertyChanging("LastName");
_LastName = StructuralObject.SetValidValue(value, false);
ReportPropertyChanged("LastName");
OnLastNameChanged();
}
}
private global::System.String _LastName;
partial void OnLastNameChanging(global::System.String value);
partial void OnLastNameChanged();
/// <summary>
/// 使用できるメタデータ ドキュメントはありません。
/// </summary>
[EdmScalarPropertyAttribute(EntityKeyProperty=false, IsNullable=false)]
[DataMemberAttribute()]
public global::System.String FirstMidName
{
get
{
return _FirstMidName;
}
set
{
OnFirstMidNameChanging(value);
ReportPropertyChanging("FirstMidName");
_FirstMidName = StructuralObject.SetValidValue(value, false);
ReportPropertyChanged("FirstMidName");
OnFirstMidNameChanged();
}
}
private global::System.String _FirstMidName;
partial void OnFirstMidNameChanging(global::System.String value);
partial void OnFirstMidNameChanged();
#endregion
#region ナビゲーション プロパティ
/// <summary>
/// 使用できるメタデータ ドキュメントはありません。
/// </summary>
[XmlIgnoreAttribute()]
[SoapIgnoreAttribute()]
[DataMemberAttribute()]
[EdmRelationshipNavigationPropertyAttribute("SchoolModel", "FK_Department_Person", "Department")]
public EntityCollection<Department> Departments
{
get
{
return ((IEntityWithRelationships)this).RelationshipManager.GetRelatedCollection<Department>("SchoolModel.FK_Department_Person", "Department");
}
set
{
if ((value != null))
{
((IEntityWithRelationships)this).RelationshipManager.InitializeRelatedCollection<Department>("SchoolModel.FK_Department_Person", "Department", value);
}
}
}
/// <summary>
/// 使用できるメタデータ ドキュメントはありません。
/// </summary>
[XmlIgnoreAttribute()]
[SoapIgnoreAttribute()]
[DataMemberAttribute()]
[EdmRelationshipNavigationPropertyAttribute("SchoolModel", "FK_OfficeAssignment_Person", "OfficeAssignment")]
public OfficeAssignment OfficeAssignment
{
get
{
return ((IEntityWithRelationships)this).RelationshipManager.GetRelatedReference<OfficeAssignment>("SchoolModel.FK_OfficeAssignment_Person", "OfficeAssignment").Value;
}
set
{
((IEntityWithRelationships)this).RelationshipManager.GetRelatedReference<OfficeAssignment>("SchoolModel.FK_OfficeAssignment_Person", "OfficeAssignment").Value = value;
}
}
/// <summary>
/// 使用できるメタデータ ドキュメントはありません。
/// </summary>
[BrowsableAttribute(false)]
[DataMemberAttribute()]
public EntityReference<OfficeAssignment> OfficeAssignmentReference
{
get
{
return ((IEntityWithRelationships)this).RelationshipManager.GetRelatedReference<OfficeAssignment>("SchoolModel.FK_OfficeAssignment_Person", "OfficeAssignment");
}
set
{
if ((value != null))
{
((IEntityWithRelationships)this).RelationshipManager.InitializeRelatedReference<OfficeAssignment>("SchoolModel.FK_OfficeAssignment_Person", "OfficeAssignment", value);
}
}
}
/// <summary>
/// 使用できるメタデータ ドキュメントはありません。
/// </summary>
[XmlIgnoreAttribute()]
[SoapIgnoreAttribute()]
[DataMemberAttribute()]
[EdmRelationshipNavigationPropertyAttribute("SchoolModel", "FK_StudentGrade_Student", "StudentGrade")]
public EntityCollection<StudentGrade> StudentGrades
{
get
{
return ((IEntityWithRelationships)this).RelationshipManager.GetRelatedCollection<StudentGrade>("SchoolModel.FK_StudentGrade_Student", "StudentGrade");
}
set
{
if ((value != null))
{
((IEntityWithRelationships)this).RelationshipManager.InitializeRelatedCollection<StudentGrade>("SchoolModel.FK_StudentGrade_Student", "StudentGrade", value);
}
}
}
/// <summary>
/// 使用できるメタデータ ドキュメントはありません。
/// </summary>
[XmlIgnoreAttribute()]
[SoapIgnoreAttribute()]
[DataMemberAttribute()]
[EdmRelationshipNavigationPropertyAttribute("SchoolModel", "CourseInstructor", "Course")]
public EntityCollection<Course> Courses
{
get
{
return ((IEntityWithRelationships)this).RelationshipManager.GetRelatedCollection<Course>("SchoolModel.CourseInstructor", "Course");
}
set
{
if ((value != null))
{
((IEntityWithRelationships)this).RelationshipManager.InitializeRelatedCollection<Course>("SchoolModel.CourseInstructor", "Course", value);
}
}
}
#endregion
}
/// <summary>
/// 使用できるメタデータ ドキュメントはありません。
/// </summary>
[EdmEntityTypeAttribute(NamespaceName="SchoolModel", Name="Student")]
[Serializable()]
[DataContractAttribute(IsReference=true)]
public partial class Student : Person
{
#region ファクトリ メソッド
/// <summary>
/// 新しい Student オブジェクトを作成します。
/// </summary>
/// <param name="personID">PersonID プロパティの初期値。</param>
/// <param name="lastName">LastName プロパティの初期値。</param>
/// <param name="firstMidName">FirstMidName プロパティの初期値。</param>
/// <param name="enrollmentDate">EnrollmentDate プロパティの初期値。</param>
public static Student CreateStudent(global::System.Int32 personID, global::System.String lastName, global::System.String firstMidName, global::System.DateTime enrollmentDate)
{
Student student = new Student();
student.PersonID = personID;
student.LastName = lastName;
student.FirstMidName = firstMidName;
student.EnrollmentDate = enrollmentDate;
return student;
}
#endregion
#region プリミティブ プロパティ
/// <summary>
/// 使用できるメタデータ ドキュメントはありません。
/// </summary>
[EdmScalarPropertyAttribute(EntityKeyProperty=false, IsNullable=false)]
[DataMemberAttribute()]
public global::System.DateTime EnrollmentDate
{
get
{
return _EnrollmentDate;
}
set
{
OnEnrollmentDateChanging(value);
ReportPropertyChanging("EnrollmentDate");
_EnrollmentDate = StructuralObject.SetValidValue(value);
ReportPropertyChanged("EnrollmentDate");
OnEnrollmentDateChanged();
}
}
private global::System.DateTime _EnrollmentDate;
partial void OnEnrollmentDateChanging(global::System.DateTime value);
partial void OnEnrollmentDateChanged();
#endregion
}
/// <summary>
/// 使用できるメタデータ ドキュメントはありません。
/// </summary>
[EdmEntityTypeAttribute(NamespaceName="SchoolModel", Name="StudentGrade")]
[Serializable()]
[DataContractAttribute(IsReference=true)]
public partial class StudentGrade : EntityObject
{
#region ファクトリ メソッド
/// <summary>
/// 新しい StudentGrade オブジェクトを作成します。
/// </summary>
/// <param name="enrollmentID">EnrollmentID プロパティの初期値。</param>
/// <param name="courseID">CourseID プロパティの初期値。</param>
/// <param name="studentID">StudentID プロパティの初期値。</param>
public static StudentGrade CreateStudentGrade(global::System.Int32 enrollmentID, global::System.Int32 courseID, global::System.Int32 studentID)
{
StudentGrade studentGrade = new StudentGrade();
studentGrade.EnrollmentID = enrollmentID;
studentGrade.CourseID = courseID;
studentGrade.StudentID = studentID;
return studentGrade;
}
#endregion
#region プリミティブ プロパティ
/// <summary>
/// 使用できるメタデータ ドキュメントはありません。
/// </summary>
[EdmScalarPropertyAttribute(EntityKeyProperty=true, IsNullable=false)]
[DataMemberAttribute()]
public global::System.Int32 EnrollmentID
{
get
{
return _EnrollmentID;
}
set
{
if (_EnrollmentID != value)
{
OnEnrollmentIDChanging(value);
ReportPropertyChanging("EnrollmentID");
_EnrollmentID = StructuralObject.SetValidValue(value);
ReportPropertyChanged("EnrollmentID");
OnEnrollmentIDChanged();
}
}
}
private global::System.Int32 _EnrollmentID;
partial void OnEnrollmentIDChanging(global::System.Int32 value);
partial void OnEnrollmentIDChanged();
/// <summary>
/// 使用できるメタデータ ドキュメントはありません。
/// </summary>
[EdmScalarPropertyAttribute(EntityKeyProperty=false, IsNullable=false)]
[DataMemberAttribute()]
public global::System.Int32 CourseID
{
get
{
return _CourseID;
}
set
{
OnCourseIDChanging(value);
ReportPropertyChanging("CourseID");
_CourseID = StructuralObject.SetValidValue(value);
ReportPropertyChanged("CourseID");
OnCourseIDChanged();
}
}
private global::System.Int32 _CourseID;
partial void OnCourseIDChanging(global::System.Int32 value);
partial void OnCourseIDChanged();
/// <summary>
/// 使用できるメタデータ ドキュメントはありません。
/// </summary>
[EdmScalarPropertyAttribute(EntityKeyProperty=false, IsNullable=false)]
[DataMemberAttribute()]
public global::System.Int32 StudentID
{
get
{
return _StudentID;
}
set
{
OnStudentIDChanging(value);
ReportPropertyChanging("StudentID");
_StudentID = StructuralObject.SetValidValue(value);
ReportPropertyChanged("StudentID");
OnStudentIDChanged();
}
}
private global::System.Int32 _StudentID;
partial void OnStudentIDChanging(global::System.Int32 value);
partial void OnStudentIDChanged();
/// <summary>
/// 使用できるメタデータ ドキュメントはありません。
/// </summary>
[EdmScalarPropertyAttribute(EntityKeyProperty=false, IsNullable=true)]
[DataMemberAttribute()]
public Nullable<global::System.Decimal> Grade
{
get
{
return _Grade;
}
set
{
OnGradeChanging(value);
ReportPropertyChanging("Grade");
_Grade = StructuralObject.SetValidValue(value);
ReportPropertyChanged("Grade");
OnGradeChanged();
}
}
private Nullable<global::System.Decimal> _Grade;
partial void OnGradeChanging(Nullable<global::System.Decimal> value);
partial void OnGradeChanged();
#endregion
#region ナビゲーション プロパティ
/// <summary>
/// 使用できるメタデータ ドキュメントはありません。
/// </summary>
[XmlIgnoreAttribute()]
[SoapIgnoreAttribute()]
[DataMemberAttribute()]
[EdmRelationshipNavigationPropertyAttribute("SchoolModel", "FK_StudentGrade_Course", "Course")]
public Course Course
{
get
{
return ((IEntityWithRelationships)this).RelationshipManager.GetRelatedReference<Course>("SchoolModel.FK_StudentGrade_Course", "Course").Value;
}
set
{
((IEntityWithRelationships)this).RelationshipManager.GetRelatedReference<Course>("SchoolModel.FK_StudentGrade_Course", "Course").Value = value;
}
}
/// <summary>
/// 使用できるメタデータ ドキュメントはありません。
/// </summary>
[BrowsableAttribute(false)]
[DataMemberAttribute()]
public EntityReference<Course> CourseReference
{
get
{
return ((IEntityWithRelationships)this).RelationshipManager.GetRelatedReference<Course>("SchoolModel.FK_StudentGrade_Course", "Course");
}
set
{
if ((value != null))
{
((IEntityWithRelationships)this).RelationshipManager.InitializeRelatedReference<Course>("SchoolModel.FK_StudentGrade_Course", "Course", value);
}
}
}
/// <summary>
/// 使用できるメタデータ ドキュメントはありません。
/// </summary>
[XmlIgnoreAttribute()]
[SoapIgnoreAttribute()]
[DataMemberAttribute()]
[EdmRelationshipNavigationPropertyAttribute("SchoolModel", "FK_StudentGrade_Student", "Person")]
public Person Person
{
get
{
return ((IEntityWithRelationships)this).RelationshipManager.GetRelatedReference<Person>("SchoolModel.FK_StudentGrade_Student", "Person").Value;
}
set
{
((IEntityWithRelationships)this).RelationshipManager.GetRelatedReference<Person>("SchoolModel.FK_StudentGrade_Student", "Person").Value = value;
}
}
/// <summary>
/// 使用できるメタデータ ドキュメントはありません。
/// </summary>
[BrowsableAttribute(false)]
[DataMemberAttribute()]
public EntityReference<Person> PersonReference
{
get
{
return ((IEntityWithRelationships)this).RelationshipManager.GetRelatedReference<Person>("SchoolModel.FK_StudentGrade_Student", "Person");
}
set
{
if ((value != null))
{
((IEntityWithRelationships)this).RelationshipManager.InitializeRelatedReference<Person>("SchoolModel.FK_StudentGrade_Student", "Person", value);
}
}
}
#endregion
}
#endregion
}
Raw
SchoolModel.edmx
<?xml version="1.0" encoding="utf-8"?>
<edmx:Edmx Version="2.0" xmlns:edmx="http://schemas.microsoft.com/ado/2008/10/edmx">
<!-- EF Runtime content -->
<edmx:Runtime>
<!-- SSDL content -->
<edmx:StorageModels>
<Schema Namespace="SchoolModel.Store" Alias="Self" Provider="System.Data.SqlClient" ProviderManifestToken="2008" xmlns:store="http://schemas.microsoft.com/ado/2007/12/edm/EntityStoreSchemaGenerator" xmlns="http://schemas.microsoft.com/ado/2009/02/edm/ssdl">
<EntityContainer Name="SchoolModelStoreContainer">
<EntitySet Name="Course" EntityType="SchoolModel.Store.Course" store:Type="Tables" Schema="dbo" />
<EntitySet Name="CourseInstructor" EntityType="SchoolModel.Store.CourseInstructor" store:Type="Tables" Schema="dbo" />
<EntitySet Name="Department" EntityType="SchoolModel.Store.Department" store:Type="Tables" Schema="dbo" />
<EntitySet Name="OfficeAssignment" EntityType="SchoolModel.Store.OfficeAssignment" store:Type="Tables" Schema="dbo" />
<EntitySet Name="OnlineCourse" EntityType="SchoolModel.Store.OnlineCourse" store:Type="Tables" Schema="dbo" />
<EntitySet Name="OnsiteCourse" EntityType="SchoolModel.Store.OnsiteCourse" store:Type="Tables" Schema="dbo" />
<EntitySet Name="Person" EntityType="SchoolModel.Store.Person" store:Type="Tables" Schema="dbo" />
<EntitySet Name="StudentGrade" EntityType="SchoolModel.Store.StudentGrade" store:Type="Tables" Schema="dbo" />
<EntitySet Name="vInstructorName" EntityType="SchoolModel.Store.vInstructorName" store:Type="Views" store:Schema="dbo" store:Name="vInstructorName">
<DefiningQuery>SELECT
[vInstructorName].[FullName] AS [FullName],
[vInstructorName].[PersonID] AS [PersonID]
FROM [dbo].[vInstructorName] AS [vInstructorName]</DefiningQuery>
</EntitySet>
<AssociationSet Name="FK_Course_Department" Association="SchoolModel.Store.FK_Course_Department">
<End Role="Department" EntitySet="Department" />
<End Role="Course" EntitySet="Course" />
</AssociationSet>
<AssociationSet Name="FK_CourseInstructor_Course" Association="SchoolModel.Store.FK_CourseInstructor_Course">
<End Role="Course" EntitySet="Course" />
<End Role="CourseInstructor" EntitySet="CourseInstructor" />
</AssociationSet>
<AssociationSet Name="FK_CourseInstructor_Person" Association="SchoolModel.Store.FK_CourseInstructor_Person">
<End Role="Person" EntitySet="Person" />
<End Role="CourseInstructor" EntitySet="CourseInstructor" />
</AssociationSet>
<AssociationSet Name="FK_Department_Person" Association="SchoolModel.Store.FK_Department_Person">
<End Role="Person" EntitySet="Person" />
<End Role="Department" EntitySet="Department" />
</AssociationSet>
<AssociationSet Name="FK_OfficeAssignment_Person" Association="SchoolModel.Store.FK_OfficeAssignment_Person">
<End Role="Person" EntitySet="Person" />
<End Role="OfficeAssignment" EntitySet="OfficeAssignment" />
</AssociationSet>
<AssociationSet Name="FK_OnlineCourse_Course" Association="SchoolModel.Store.FK_OnlineCourse_Course">
<End Role="Course" EntitySet="Course" />
<End Role="OnlineCourse" EntitySet="OnlineCourse" />
</AssociationSet>
<AssociationSet Name="FK_OnsiteCourse_Course" Association="SchoolModel.Store.FK_OnsiteCourse_Course">
<End Role="Course" EntitySet="Course" />
<End Role="OnsiteCourse" EntitySet="OnsiteCourse" />
</AssociationSet>
<AssociationSet Name="FK_StudentGrade_Course" Association="SchoolModel.Store.FK_StudentGrade_Course">
<End Role="Course" EntitySet="Course" />
<End Role="StudentGrade" EntitySet="StudentGrade" />
</AssociationSet>
<AssociationSet Name="FK_StudentGrade_Student" Association="SchoolModel.Store.FK_StudentGrade_Student">
<End Role="Person" EntitySet="Person" />
<End Role="StudentGrade" EntitySet="StudentGrade" />
</AssociationSet>
</EntityContainer>
<EntityType Name="Course">
<Key>
<PropertyRef Name="CourseID" />
</Key>
<Property Name="CourseID" Type="int" Nullable="false" />
<Property Name="Title" Type="nvarchar" Nullable="false" MaxLength="100" />
<Property Name="Credits" Type="int" Nullable="false" />
<Property Name="DepartmentID" Type="int" Nullable="false" />
</EntityType>
<EntityType Name="CourseInstructor">
<Key>
<PropertyRef Name="CourseID" />
<PropertyRef Name="PersonID" />
</Key>
<Property Name="CourseID" Type="int" Nullable="false" />
<Property Name="PersonID" Type="int" Nullable="false" />
</EntityType>
<EntityType Name="Department">
<Key>
<PropertyRef Name="DepartmentID" />
</Key>
<Property Name="DepartmentID" Type="int" Nullable="false" />
<Property Name="Name" Type="nvarchar" Nullable="false" MaxLength="50" />
<Property Name="Budget" Type="money" Nullable="false" />
<Property Name="StartDate" Type="datetime" Nullable="false" />
<Property Name="Administrator" Type="int" />
</EntityType>
<EntityType Name="OfficeAssignment">
<Key>
<PropertyRef Name="InstructorID" />
</Key>
<Property Name="InstructorID" Type="int" Nullable="false" />
<Property Name="Location" Type="nvarchar" Nullable="false" MaxLength="50" />
<Property Name="Timestamp" Type="timestamp" Nullable="false" StoreGeneratedPattern="Computed" />
</EntityType>
<EntityType Name="OnlineCourse">
<Key>
<PropertyRef Name="CourseID" />
</Key>
<Property Name="CourseID" Type="int" Nullable="false" />
<Property Name="URL" Type="nvarchar" Nullable="false" MaxLength="100" />
</EntityType>
<EntityType Name="OnsiteCourse">
<Key>
<PropertyRef Name="CourseID" />
</Key>
<Property Name="CourseID" Type="int" Nullable="false" />
<Property Name="Location" Type="nvarchar" Nullable="false" MaxLength="50" />
<Property Name="Days" Type="nvarchar" Nullable="false" MaxLength="50" />
<Property Name="Time" Type="smalldatetime" Nullable="false" />
</EntityType>
<EntityType Name="Person">
<Key>
<PropertyRef Name="PersonID" />
</Key>
<Property Name="PersonID" Type="int" Nullable="false" StoreGeneratedPattern="Identity" />
<Property Name="LastName" Type="nvarchar" Nullable="false" MaxLength="50" />
<Property Name="FirstName" Type="nvarchar" Nullable="false" MaxLength="50" />
<Property Name="HireDate" Type="datetime" />
<Property Name="EnrollmentDate" Type="datetime" />
</EntityType>
<EntityType Name="StudentGrade">
<Key>
<PropertyRef Name="EnrollmentID" />
</Key>
<Property Name="EnrollmentID" Type="int" Nullable="false" StoreGeneratedPattern="Identity" />
<Property Name="CourseID" Type="int" Nullable="false" />
<Property Name="StudentID" Type="int" Nullable="false" />
<Property Name="Grade" Type="decimal" Precision="3" Scale="2" />
</EntityType>
<!--生成中に見つかったエラー:
警告 6002: テーブル/ビュー 'C:\GITREPOS\ASP.NET-WEBFORMS-EF-TUTORIALS\CONTOSOUNIVERSITY\APP_DATA\SCHOOL.MDF.dbo.vInstructorName' には主キーが定義されていません。主キーは推論され、定義は読み取り専用のテーブル/ビューとして作成されました。
-->
<EntityType Name="vInstructorName">
<Key>
<PropertyRef Name="FullName" />
<PropertyRef Name="PersonID" />
</Key>
<Property Name="FullName" Type="nvarchar" Nullable="false" MaxLength="101" />
<Property Name="PersonID" Type="int" Nullable="false" StoreGeneratedPattern="Identity" />
</EntityType>
<Association Name="FK_Course_Department">
<End Role="Department" Type="SchoolModel.Store.Department" Multiplicity="1" />
<End Role="Course" Type="SchoolModel.Store.Course" Multiplicity="*" />
<ReferentialConstraint>
<Principal Role="Department">
<PropertyRef Name="DepartmentID" />
</Principal>
<Dependent Role="Course">
<PropertyRef Name="DepartmentID" />
</Dependent>
</ReferentialConstraint>
</Association>
<Association Name="FK_CourseInstructor_Course">
<End Role="Course" Type="SchoolModel.Store.Course" Multiplicity="1" />
<End Role="CourseInstructor" Type="SchoolModel.Store.CourseInstructor" Multiplicity="*" />
<ReferentialConstraint>
<Principal Role="Course">
<PropertyRef Name="CourseID" />
</Principal>
<Dependent Role="CourseInstructor">
<PropertyRef Name="CourseID" />
</Dependent>
</ReferentialConstraint>
</Association>
<Association Name="FK_CourseInstructor_Person">
<End Role="Person" Type="SchoolModel.Store.Person" Multiplicity="1" />
<End Role="CourseInstructor" Type="SchoolModel.Store.CourseInstructor" Multiplicity="*" />
<ReferentialConstraint>
<Principal Role="Person">
<PropertyRef Name="PersonID" />
</Principal>
<Dependent Role="CourseInstructor">
<PropertyRef Name="PersonID" />
</Dependent>
</ReferentialConstraint>
</Association>
<Association Name="FK_Department_Person">
<End Role="Person" Type="SchoolModel.Store.Person" Multiplicity="0..1" />
<End Role="Department" Type="SchoolModel.Store.Department" Multiplicity="*" />
<ReferentialConstraint>
<Principal Role="Person">
<PropertyRef Name="PersonID" />
</Principal>
<Dependent Role="Department">
<PropertyRef Name="Administrator" />
</Dependent>
</ReferentialConstraint>
</Association>
<Association Name="FK_OfficeAssignment_Person">
<End Role="Person" Type="SchoolModel.Store.Person" Multiplicity="1" />
<End Role="OfficeAssignment" Type="SchoolModel.Store.OfficeAssignment" Multiplicity="0..1" />
<ReferentialConstraint>
<Principal Role="Person">
<PropertyRef Name="PersonID" />
</Principal>
<Dependent Role="OfficeAssignment">
<PropertyRef Name="InstructorID" />
</Dependent>
</ReferentialConstraint>
</Association>
<Association Name="FK_OnlineCourse_Course">
<End Role="Course" Type="SchoolModel.Store.Course" Multiplicity="1" />
<End Role="OnlineCourse" Type="SchoolModel.Store.OnlineCourse" Multiplicity="0..1" />
<ReferentialConstraint>
<Principal Role="Course">
<PropertyRef Name="CourseID" />
</Principal>
<Dependent Role="OnlineCourse">
<PropertyRef Name="CourseID" />
</Dependent>
</ReferentialConstraint>
</Association>
<Association Name="FK_OnsiteCourse_Course">
<End Role="Course" Type="SchoolModel.Store.Course" Multiplicity="1" />
<End Role="OnsiteCourse" Type="SchoolModel.Store.OnsiteCourse" Multiplicity="0..1" />
<ReferentialConstraint>
<Principal Role="Course">
<PropertyRef Name="CourseID" />
</Principal>
<Dependent Role="OnsiteCourse">
<PropertyRef Name="CourseID" />
</Dependent>
</ReferentialConstraint>
</Association>
<Association Name="FK_StudentGrade_Course">
<End Role="Course" Type="SchoolModel.Store.Course" Multiplicity="1" />
<End Role="StudentGrade" Type="SchoolModel.Store.StudentGrade" Multiplicity="*" />
<ReferentialConstraint>
<Principal Role="Course">
<PropertyRef Name="CourseID" />
</Principal>
<Dependent Role="StudentGrade">
<PropertyRef Name="CourseID" />
</Dependent>
</ReferentialConstraint>
</Association>
<Association Name="FK_StudentGrade_Student">
<End Role="Person" Type="SchoolModel.Store.Person" Multiplicity="1">
<OnDelete Action="Cascade" />
</End>
<End Role="StudentGrade" Type="SchoolModel.Store.StudentGrade" Multiplicity="*" />
<ReferentialConstraint>
<Principal Role="Person">
<PropertyRef Name="PersonID" />
</Principal>
<Dependent Role="StudentGrade">
<PropertyRef Name="StudentID" />
</Dependent>
</ReferentialConstraint>
</Association>
<Function Name="DeletePerson" Aggregate="false" BuiltIn="false" NiladicFunction="false" IsComposable="false" ParameterTypeSemantics="AllowImplicitConversion" Schema="dbo">
<Parameter Name="PersonID" Type="int" Mode="In" />
</Function>
<Function Name="GetCourses" Aggregate="false" BuiltIn="false" NiladicFunction="false" IsComposable="false" ParameterTypeSemantics="AllowImplicitConversion" Schema="dbo" />
<Function Name="GetDepartmentName" Aggregate="false" BuiltIn="false" NiladicFunction="false" IsComposable="false" ParameterTypeSemantics="AllowImplicitConversion" Schema="dbo">
<Parameter Name="ID" Type="int" Mode="In" />
<Parameter Name="Name" Type="nvarchar" Mode="InOut" />
</Function>
<Function Name="GetStudentGrades" Aggregate="false" BuiltIn="false" NiladicFunction="false" IsComposable="false" ParameterTypeSemantics="AllowImplicitConversion" Schema="dbo">
<Parameter Name="StudentID" Type="int" Mode="In" />
</Function>
<Function Name="InsertInstructor" Aggregate="false" BuiltIn="false" NiladicFunction="false" IsComposable="false" ParameterTypeSemantics="AllowImplicitConversion" Schema="dbo">
<Parameter Name="LastName" Type="nvarchar" Mode="In" />
<Parameter Name="FirstName" Type="nvarchar" Mode="In" />
<Parameter Name="HireDate" Type="datetime" Mode="In" />
</Function>
<Function Name="InsertPerson" Aggregate="false" BuiltIn="false" NiladicFunction="false" IsComposable="false" ParameterTypeSemantics="AllowImplicitConversion" Schema="dbo">
<Parameter Name="LastName" Type="nvarchar" Mode="In" />
<Parameter Name="FirstName" Type="nvarchar" Mode="In" />
<Parameter Name="HireDate" Type="datetime" Mode="In" />
<Parameter Name="EnrollmentDate" Type="datetime" Mode="In" />
</Function>
<Function Name="InsertStudent" Aggregate="false" BuiltIn="false" NiladicFunction="false" IsComposable="false" ParameterTypeSemantics="AllowImplicitConversion" Schema="dbo">
<Parameter Name="LastName" Type="nvarchar" Mode="In" />
<Parameter Name="FirstName" Type="nvarchar" Mode="In" />
<Parameter Name="EnrollmentDate" Type="datetime" Mode="In" />
</Function>
<Function Name="UpdateInstructor" Aggregate="false" BuiltIn="false" NiladicFunction="false" IsComposable="false" ParameterTypeSemantics="AllowImplicitConversion" Schema="dbo">
<Parameter Name="PersonID" Type="int" Mode="In" />
<Parameter Name="LastName" Type="nvarchar" Mode="In" />
<Parameter Name="FirstName" Type="nvarchar" Mode="In" />
<Parameter Name="HireDate" Type="datetime" Mode="In" />
</Function>
<Function Name="UpdatePerson" Aggregate="false" BuiltIn="false" NiladicFunction="false" IsComposable="false" ParameterTypeSemantics="AllowImplicitConversion" Schema="dbo">
<Parameter Name="PersonID" Type="int" Mode="In" />
<Parameter Name="LastName" Type="nvarchar" Mode="In" />
<Parameter Name="FirstName" Type="nvarchar" Mode="In" />
<Parameter Name="HireDate" Type="datetime" Mode="In" />
<Parameter Name="EnrollmentDate" Type="datetime" Mode="In" />
</Function>
<Function Name="UpdateStudent" Aggregate="false" BuiltIn="false" NiladicFunction="false" IsComposable="false" ParameterTypeSemantics="AllowImplicitConversion" Schema="dbo">
<Parameter Name="PersonID" Type="int" Mode="In" />
<Parameter Name="LastName" Type="nvarchar" Mode="In" />
<Parameter Name="FirstName" Type="nvarchar" Mode="In" />
<Parameter Name="EnrollmentDate" Type="datetime" Mode="In" />
</Function>
</Schema></edmx:StorageModels>
<!-- CSDL content -->
<edmx:ConceptualModels>
<Schema Namespace="SchoolModel" Alias="Self" xmlns:annotation="http://schemas.microsoft.com/ado/2009/02/edm/annotation" xmlns="http://schemas.microsoft.com/ado/2008/09/edm">
<EntityContainer Name="SchoolEntities" annotation:LazyLoadingEnabled="true">
<EntitySet Name="Courses" EntityType="SchoolModel.Course" />
<EntitySet Name="Departments" EntityType="SchoolModel.Department" />
<EntitySet Name="OfficeAssignments" EntityType="SchoolModel.OfficeAssignment" />
<EntitySet Name="OnlineCourses" EntityType="SchoolModel.OnlineCourse" />
<EntitySet Name="OnsiteCourses" EntityType="SchoolModel.OnsiteCourse" />
<EntitySet Name="People" EntityType="SchoolModel.Person" />
<EntitySet Name="StudentGrades" EntityType="SchoolModel.StudentGrade" />
<EntitySet Name="InstructorNames" EntityType="SchoolModel.InstructorName" />
<AssociationSet Name="FK_Course_Department" Association="SchoolModel.FK_Course_Department">
<End Role="Department" EntitySet="Departments" />
<End Role="Course" EntitySet="Courses" />
</AssociationSet>
<AssociationSet Name="FK_OnlineCourse_Course" Association="SchoolModel.FK_OnlineCourse_Course">
<End Role="Course" EntitySet="Courses" />
<End Role="OnlineCourse" EntitySet="OnlineCourses" />
</AssociationSet>
<AssociationSet Name="FK_OnsiteCourse_Course" Association="SchoolModel.FK_OnsiteCourse_Course">
<End Role="Course" EntitySet="Courses" />
<End Role="OnsiteCourse" EntitySet="OnsiteCourses" />
</AssociationSet>
<AssociationSet Name="FK_StudentGrade_Course" Association="SchoolModel.FK_StudentGrade_Course">
<End Role="Course" EntitySet="Courses" />
<End Role="StudentGrade" EntitySet="StudentGrades" />
</AssociationSet>
<AssociationSet Name="FK_Department_Person" Association="SchoolModel.FK_Department_Person">
<End Role="Person" EntitySet="People" />
<End Role="Department" EntitySet="Departments" />
</AssociationSet>
<AssociationSet Name="FK_OfficeAssignment_Person" Association="SchoolModel.FK_OfficeAssignment_Person">
<End Role="Person" EntitySet="People" />
<End Role="OfficeAssignment" EntitySet="OfficeAssignments" />
</AssociationSet>
<AssociationSet Name="FK_StudentGrade_Student" Association="SchoolModel.FK_StudentGrade_Student">
<End Role="Person" EntitySet="People" />
<End Role="StudentGrade" EntitySet="StudentGrades" />
</AssociationSet>
<AssociationSet Name="CourseInstructor" Association="SchoolModel.CourseInstructor">
<End Role="Course" EntitySet="Courses" />
<End Role="Person" EntitySet="People" />
</AssociationSet>
<FunctionImport Name="GetCourses" EntitySet="Courses" ReturnType="Collection(SchoolModel.Course)" />
</EntityContainer>
<EntityType Name="Course">
<Key>
<PropertyRef Name="CourseID" />
</Key>
<Property Name="CourseID" Type="Int32" Nullable="false" />
<Property Name="Title" Type="String" Nullable="false" MaxLength="100" Unicode="true" FixedLength="false" />
<Property Name="Credits" Type="Int32" Nullable="false" />
<Property Name="DepartmentID" Type="Int32" Nullable="false" />
<NavigationProperty Name="Department" Relationship="SchoolModel.FK_Course_Department" FromRole="Course" ToRole="Department" />
<NavigationProperty Name="OnlineCourse" Relationship="SchoolModel.FK_OnlineCourse_Course" FromRole="Course" ToRole="OnlineCourse" />
<NavigationProperty Name="OnsiteCourse" Relationship="SchoolModel.FK_OnsiteCourse_Course" FromRole="Course" ToRole="OnsiteCourse" />
<NavigationProperty Name="StudentGrades" Relationship="SchoolModel.FK_StudentGrade_Course" FromRole="Course" ToRole="StudentGrade" />
<NavigationProperty Name="People" Relationship="SchoolModel.CourseInstructor" FromRole="Course" ToRole="Person" />
</EntityType>
<EntityType Name="Department">
<Key>
<PropertyRef Name="DepartmentID" />
</Key>
<Property Name="DepartmentID" Type="Int32" Nullable="false" />
<Property Name="Name" Type="String" Nullable="false" MaxLength="50" Unicode="true" FixedLength="false" />
<Property Name="Budget" Type="Decimal" Nullable="false" Precision="19" Scale="4" />
<Property Name="StartDate" Type="DateTime" Nullable="false" />
<Property Name="Administrator" Type="Int32" />
<NavigationProperty Name="Courses" Relationship="SchoolModel.FK_Course_Department" FromRole="Department" ToRole="Course" />
<NavigationProperty Name="Person" Relationship="SchoolModel.FK_Department_Person" FromRole="Department" ToRole="Person" />
</EntityType>
<EntityType Name="OfficeAssignment">
<Key>
<PropertyRef Name="InstructorID" />
</Key>
<Property Name="InstructorID" Type="Int32" Nullable="false" />
<Property Name="Location" Type="String" Nullable="false" MaxLength="50" Unicode="true" FixedLength="false" />
<Property Name="Timestamp" Type="Binary" Nullable="false" MaxLength="8" FixedLength="true" annotation:StoreGeneratedPattern="Computed" />
<NavigationProperty Name="Person" Relationship="SchoolModel.FK_OfficeAssignment_Person" FromRole="OfficeAssignment" ToRole="Person" />
</EntityType>
<EntityType Name="OnlineCourse">
<Key>
<PropertyRef Name="CourseID" />
</Key>
<Property Name="CourseID" Type="Int32" Nullable="false" />
<Property Name="URL" Type="String" Nullable="false" MaxLength="100" Unicode="true" FixedLength="false" />
<NavigationProperty Name="Course" Relationship="SchoolModel.FK_OnlineCourse_Course" FromRole="OnlineCourse" ToRole="Course" />
</EntityType>
<EntityType Name="OnsiteCourse">
<Key>
<PropertyRef Name="CourseID" />
</Key>
<Property Name="CourseID" Type="Int32" Nullable="false" />
<Property Name="Location" Type="String" Nullable="false" MaxLength="50" Unicode="true" FixedLength="false" />
<Property Name="Days" Type="String" Nullable="false" MaxLength="50" Unicode="true" FixedLength="false" />
<Property Name="Time" Type="DateTime" Nullable="false" />
<NavigationProperty Name="Course" Relationship="SchoolModel.FK_OnsiteCourse_Course" FromRole="OnsiteCourse" ToRole="Course" />
</EntityType>
<EntityType Name="Person">
<Key>
<PropertyRef Name="PersonID" />
</Key>
<Property Name="PersonID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
<Property Name="LastName" Type="String" Nullable="false" MaxLength="50" Unicode="true" FixedLength="false" />
<Property Name="FirstMidName" Type="String" Nullable="false" MaxLength="50" Unicode="true" FixedLength="false" />
<NavigationProperty Name="Departments" Relationship="SchoolModel.FK_Department_Person" FromRole="Person" ToRole="Department" />
<NavigationProperty Name="OfficeAssignment" Relationship="SchoolModel.FK_OfficeAssignment_Person" FromRole="Person" ToRole="OfficeAssignment" />
<NavigationProperty Name="StudentGrades" Relationship="SchoolModel.FK_StudentGrade_Student" FromRole="Person" ToRole="StudentGrade" />
<NavigationProperty Name="Courses" Relationship="SchoolModel.CourseInstructor" FromRole="Person" ToRole="Course" />
</EntityType>
<EntityType Name="StudentGrade">
<Key>
<PropertyRef Name="EnrollmentID" />
</Key>
<Property Name="EnrollmentID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
<Property Name="CourseID" Type="Int32" Nullable="false" />
<Property Name="StudentID" Type="Int32" Nullable="false" />
<Property Name="Grade" Type="Decimal" Precision="3" Scale="2" />
<NavigationProperty Name="Course" Relationship="SchoolModel.FK_StudentGrade_Course" FromRole="StudentGrade" ToRole="Course" />
<NavigationProperty Name="Person" Relationship="SchoolModel.FK_StudentGrade_Student" FromRole="StudentGrade" ToRole="Person" />
</EntityType>
<EntityType Name="InstructorName">
<Key>
<PropertyRef Name="FullName" />
<PropertyRef Name="PersonID" />
</Key>
<Property Name="FullName" Type="String" Nullable="false" MaxLength="101" Unicode="true" FixedLength="false" />
<Property Name="PersonID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
</EntityType>
<Association Name="FK_Course_Department">
<End Role="Department" Type="SchoolModel.Department" Multiplicity="1" />
<End Role="Course" Type="SchoolModel.Course" Multiplicity="*" />
<ReferentialConstraint>
<Principal Role="Department">
<PropertyRef Name="DepartmentID" />
</Principal>
<Dependent Role="Course">
<PropertyRef Name="DepartmentID" />
</Dependent>
</ReferentialConstraint>
</Association>
<Association Name="FK_OnlineCourse_Course">
<End Role="Course" Type="SchoolModel.Course" Multiplicity="1" />
<End Role="OnlineCourse" Type="SchoolModel.OnlineCourse" Multiplicity="0..1" />
<ReferentialConstraint>
<Principal Role="Course">
<PropertyRef Name="CourseID" />
</Principal>
<Dependent Role="OnlineCourse">
<PropertyRef Name="CourseID" />
</Dependent>
</ReferentialConstraint>
</Association>
<Association Name="FK_OnsiteCourse_Course">
<End Role="Course" Type="SchoolModel.Course" Multiplicity="1" />
<End Role="OnsiteCourse" Type="SchoolModel.OnsiteCourse" Multiplicity="0..1" />
<ReferentialConstraint>
<Principal Role="Course">
<PropertyRef Name="CourseID" />
</Principal>
<Dependent Role="OnsiteCourse">
<PropertyRef Name="CourseID" />
</Dependent>
</ReferentialConstraint>
</Association>
<Association Name="FK_StudentGrade_Course">
<End Role="Course" Type="SchoolModel.Course" Multiplicity="1" />
<End Role="StudentGrade" Type="SchoolModel.StudentGrade" Multiplicity="*" />
<ReferentialConstraint>
<Principal Role="Course">
<PropertyRef Name="CourseID" />
</Principal>
<Dependent Role="StudentGrade">
<PropertyRef Name="CourseID" />
</Dependent>
</ReferentialConstraint>
</Association>
<Association Name="FK_Department_Person">
<End Role="Person" Type="SchoolModel.Person" Multiplicity="0..1" />
<End Role="Department" Type="SchoolModel.Department" Multiplicity="*" />
<ReferentialConstraint>
<Principal Role="Person">
<PropertyRef Name="PersonID" />
</Principal>
<Dependent Role="Department">
<PropertyRef Name="Administrator" />
</Dependent>
</ReferentialConstraint>
</Association>
<Association Name="FK_OfficeAssignment_Person">
<End Role="Person" Type="SchoolModel.Person" Multiplicity="1" />
<End Role="OfficeAssignment" Type="SchoolModel.OfficeAssignment" Multiplicity="0..1" />
<ReferentialConstraint>
<Principal Role="Person">
<PropertyRef Name="PersonID" />
</Principal>
<Dependent Role="OfficeAssignment">
<PropertyRef Name="InstructorID" />
</Dependent>
</ReferentialConstraint>
</Association>
<Association Name="FK_StudentGrade_Student">
<End Role="Person" Type="SchoolModel.Person" Multiplicity="1">
<OnDelete Action="Cascade" />
</End>
<End Role="StudentGrade" Type="SchoolModel.StudentGrade" Multiplicity="*" />
<ReferentialConstraint>
<Principal Role="Person">
<PropertyRef Name="PersonID" />
</Principal>
<Dependent Role="StudentGrade">
<PropertyRef Name="StudentID" />
</Dependent>
</ReferentialConstraint>
</Association>
<Association Name="CourseInstructor">
<End Role="Course" Type="SchoolModel.Course" Multiplicity="*" />
<End Role="Person" Type="SchoolModel.Person" Multiplicity="*" />
</Association>
<EntityType Name="Student" BaseType="SchoolModel.Person" >
<Property Type="DateTime" Name="EnrollmentDate" Nullable="false" />
</EntityType>
<EntityType Name="Instructor" BaseType="SchoolModel.Person" >
<Property Type="DateTime" Name="HireDate" Nullable="false" />
</EntityType>
</Schema>
</edmx:ConceptualModels>
<!-- C-S mapping content -->
<edmx:Mappings>
<Mapping Space="C-S" xmlns="http://schemas.microsoft.com/ado/2008/09/mapping/cs">
<EntityContainerMapping StorageEntityContainer="SchoolModelStoreContainer" CdmEntityContainer="SchoolEntities">
<EntitySetMapping Name="Courses"><EntityTypeMapping TypeName="SchoolModel.Course"><MappingFragment StoreEntitySet="Course">
<ScalarProperty Name="CourseID" ColumnName="CourseID" />
<ScalarProperty Name="Title" ColumnName="Title" />
<ScalarProperty Name="Credits" ColumnName="Credits" />
<ScalarProperty Name="DepartmentID" ColumnName="DepartmentID" />
</MappingFragment></EntityTypeMapping></EntitySetMapping>
<EntitySetMapping Name="Departments"><EntityTypeMapping TypeName="SchoolModel.Department"><MappingFragment StoreEntitySet="Department">
<ScalarProperty Name="DepartmentID" ColumnName="DepartmentID" />
<ScalarProperty Name="Name" ColumnName="Name" />
<ScalarProperty Name="Budget" ColumnName="Budget" />
<ScalarProperty Name="StartDate" ColumnName="StartDate" />
<ScalarProperty Name="Administrator" ColumnName="Administrator" />
</MappingFragment></EntityTypeMapping></EntitySetMapping>
<EntitySetMapping Name="OfficeAssignments"><EntityTypeMapping TypeName="SchoolModel.OfficeAssignment"><MappingFragment StoreEntitySet="OfficeAssignment">
<ScalarProperty Name="InstructorID" ColumnName="InstructorID" />
<ScalarProperty Name="Location" ColumnName="Location" />
<ScalarProperty Name="Timestamp" ColumnName="Timestamp" />
</MappingFragment></EntityTypeMapping></EntitySetMapping>
<EntitySetMapping Name="OnlineCourses"><EntityTypeMapping TypeName="SchoolModel.OnlineCourse"><MappingFragment StoreEntitySet="OnlineCourse">
<ScalarProperty Name="CourseID" ColumnName="CourseID" />
<ScalarProperty Name="URL" ColumnName="URL" />
</MappingFragment></EntityTypeMapping></EntitySetMapping>
<EntitySetMapping Name="OnsiteCourses"><EntityTypeMapping TypeName="SchoolModel.OnsiteCourse"><MappingFragment StoreEntitySet="OnsiteCourse">
<ScalarProperty Name="CourseID" ColumnName="CourseID" />
<ScalarProperty Name="Location" ColumnName="Location" />
<ScalarProperty Name="Days" ColumnName="Days" />
<ScalarProperty Name="Time" ColumnName="Time" />
</MappingFragment></EntityTypeMapping></EntitySetMapping>
<EntitySetMapping Name="StudentGrades"><EntityTypeMapping TypeName="SchoolModel.StudentGrade"><MappingFragment StoreEntitySet="StudentGrade">
<ScalarProperty Name="EnrollmentID" ColumnName="EnrollmentID" />
<ScalarProperty Name="CourseID" ColumnName="CourseID" />
<ScalarProperty Name="StudentID" ColumnName="StudentID" />
<ScalarProperty Name="Grade" ColumnName="Grade" />
</MappingFragment></EntityTypeMapping></EntitySetMapping>
<EntitySetMapping Name="InstructorNames"><EntityTypeMapping TypeName="SchoolModel.InstructorName"><MappingFragment StoreEntitySet="vInstructorName">
<ScalarProperty Name="FullName" ColumnName="FullName" />
<ScalarProperty Name="PersonID" ColumnName="PersonID" />
</MappingFragment></EntityTypeMapping></EntitySetMapping>
<AssociationSetMapping Name="CourseInstructor" TypeName="SchoolModel.CourseInstructor" StoreEntitySet="CourseInstructor">
<EndProperty Name="Course">
<ScalarProperty Name="CourseID" ColumnName="CourseID" />
</EndProperty>
<EndProperty Name="Person">
<ScalarProperty Name="PersonID" ColumnName="PersonID" />
</EndProperty>
</AssociationSetMapping>
<EntitySetMapping Name="People">
<EntityTypeMapping TypeName="IsTypeOf(SchoolModel.Person)">
<MappingFragment StoreEntitySet="Person">
<ScalarProperty Name="FirstMidName" ColumnName="FirstName" />
<ScalarProperty Name="LastName" ColumnName="LastName" />
<ScalarProperty Name="PersonID" ColumnName="PersonID" />
</MappingFragment>
</EntityTypeMapping>
<EntityTypeMapping TypeName="IsTypeOf(SchoolModel.Student)">
<MappingFragment StoreEntitySet="Person">
<ScalarProperty Name="PersonID" ColumnName="PersonID" />
<ScalarProperty Name="EnrollmentDate" ColumnName="EnrollmentDate" />
<Condition ColumnName="EnrollmentDate" IsNull="false" />
</MappingFragment>
</EntityTypeMapping>
<EntityTypeMapping TypeName="IsTypeOf(SchoolModel.Instructor)">
<MappingFragment StoreEntitySet="Person">
<ScalarProperty Name="PersonID" ColumnName="PersonID" />
<ScalarProperty Name="HireDate" ColumnName="HireDate" />
<Condition ColumnName="HireDate" IsNull="false" />
</MappingFragment>
</EntityTypeMapping>
</EntitySetMapping>
<FunctionImportMapping FunctionImportName="GetCourses" FunctionName="SchoolModel.Store.GetCourses" />
</EntityContainerMapping>
</Mapping>
</edmx:Mappings>
</edmx:Runtime>
<!-- EF Designer content (DO NOT EDIT MANUALLY BELOW HERE) -->
<Designer xmlns="http://schemas.microsoft.com/ado/2008/10/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" />
</DesignerInfoPropertySet>
</Options>
<!-- Diagram content (shape and connector positions) -->
<Diagrams>
<Diagram Name="SchoolModel">
<EntityTypeShape EntityType="SchoolModel.Course" Width="1.5" PointX="0.75" PointY="6.875" Height="3.0043749999999996" IsExpanded="true" />
<EntityTypeShape EntityType="SchoolModel.Department" Width="1.5" PointX="5.25" PointY="8.5" Height="2.5772916666666674" IsExpanded="true" />
<EntityTypeShape EntityType="SchoolModel.OfficeAssignment" Width="1.5" PointX="5.25" PointY="11.75" Height="1.9366666666666674" IsExpanded="true" />
<EntityTypeShape EntityType="SchoolModel.OnlineCourse" Width="1.5" PointX="3" PointY="3.125" Height="1.7231249999999996" IsExpanded="true" />
<EntityTypeShape EntityType="SchoolModel.OnsiteCourse" Width="1.5" PointX="3" PointY="5.5" Height="2.1502083333333335" IsExpanded="true" />
<EntityTypeShape EntityType="SchoolModel.Person" Width="1.5" PointX="3" PointY="9.625" Height="2.5772916666666656" IsExpanded="true" />
<EntityTypeShape EntityType="SchoolModel.StudentGrade" Width="1.5" PointX="8.25" PointY="8.5" Height="2.3637499999999996" IsExpanded="true" />
<EntityTypeShape EntityType="SchoolModel.InstructorName" Width="1.5" PointX="0.75" PointY="0.75" Height="1.5095833333333317" IsExpanded="true" />
<AssociationConnector Association="SchoolModel.FK_Course_Department" ManuallyRouted="false">
<ConnectorPoint PointX="5.25" PointY="9.03125" />
<ConnectorPoint PointX="3.8333333333333335" PointY="9.03125" />
<ConnectorPoint PointX="3.6666666666666665" PointY="9.03125" />
<ConnectorPoint PointX="2.25" PointY="9.03125" />
</AssociationConnector>
<AssociationConnector Association="SchoolModel.FK_OnlineCourse_Course" ManuallyRouted="false">
<ConnectorPoint PointX="1.5" PointY="6.875" />
<ConnectorPoint PointX="1.5" PointY="3.9865625" />
<ConnectorPoint PointX="3" PointY="3.9865625" />
</AssociationConnector>
<AssociationConnector Association="SchoolModel.FK_OnsiteCourse_Course" ManuallyRouted="false">
<ConnectorPoint PointX="2.25" PointY="7.2626041666666667" />
<ConnectorPoint PointX="3" PointY="7.2626041666666667" />
</AssociationConnector>
<AssociationConnector Association="SchoolModel.FK_StudentGrade_Course" ManuallyRouted="false">
<ConnectorPoint PointX="2.25" PointY="8.1347916666666649" />
<ConnectorPoint PointX="7.666666666666667" PointY="8.1347916666666649" />
<ConnectorPoint PointX="7.833333333333333" PointY="8.1347916666666649" />
<ConnectorPoint PointX="9.15625" PointY="8.1347916666666649" />
<ConnectorPoint PointX="9.15625" PointY="8.5" />
</AssociationConnector>
<AssociationConnector Association="SchoolModel.FK_Department_Person" ManuallyRouted="false">
<ConnectorPoint PointX="4.5" PointY="10.351145833333334" />
<ConnectorPoint PointX="5.25" PointY="10.351145833333334" />
</AssociationConnector>
<AssociationConnector Association="SchoolModel.FK_OfficeAssignment_Person" ManuallyRouted="false">
<ConnectorPoint PointX="4.5" PointY="11.976145833333334" />
<ConnectorPoint PointX="5.25" PointY="11.976145833333334" />
</AssociationConnector>
<AssociationConnector Association="SchoolModel.FK_StudentGrade_Student" ManuallyRouted="false">
<ConnectorPoint PointX="4.5" PointY="11.413645833333334" />
<ConnectorPoint PointX="9" PointY="11.413645833333334" />
<ConnectorPoint PointX="9" PointY="10.86375" />
</AssociationConnector>
<AssociationConnector Association="SchoolModel.CourseInstructor" ManuallyRouted="false">
<ConnectorPoint PointX="1.5" PointY="9.879375" />
<ConnectorPoint PointX="1.5" PointY="11.040833833333334" />
<ConnectorPoint PointX="3" PointY="11.040833833333334" />
</AssociationConnector>
<EntityTypeShape EntityType="SchoolModel.Student" Width="1.5" PointX="4.875" PointY="6.75" Height="1.2960416666666657" />
<InheritanceConnector EntityType="SchoolModel.Student" >
<ConnectorPoint PointX="3.75" PointY="9.625" />
<ConnectorPoint PointX="3.75" PointY="8.2860416666666659" />
<ConnectorPoint PointX="5.625" PointY="8.2860416666666659" />
<ConnectorPoint PointX="5.625" PointY="8.0460416666666656" />
</InheritanceConnector>
<EntityTypeShape EntityType="SchoolModel.Instructor" Width="1.5" PointX="7" PointY="6.875" Height="1.0824999999999996" />
<InheritanceConnector EntityType="SchoolModel.Instructor" >
<ConnectorPoint PointX="3.75" PointY="9.625" />
<ConnectorPoint PointX="3.75" PointY="8.375" />
<ConnectorPoint PointX="7.75" PointY="8.375" />
<ConnectorPoint PointX="7.75" PointY="7.9575" />
</InheritanceConnector>
</Diagram>
</Diagrams>
</Designer>
</edmx:Edmx>
Raw
SchoolRepository.cs
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Configuration;
using System.Data.Objects;
namespace ContosoUniversity.DAL
{
public class SchoolRepository : IDisposable, ISchoolRepository
{
private SchoolEntities context = new SchoolEntities(ConfigurationManager.ConnectionStrings["SchoolEntities"].ConnectionString);
public IEnumerable<Department> GetDepartments()
{
return context.Departments.Include("Person").ToList();
}
private bool disposedValue = false;
protected virtual void Dispose(bool disposing)
{
if (!this.disposedValue)
{
if (disposing)
{
context.Dispose();
}
}
this.disposedValue = true;
}
public void Dispose()
{
Dispose(true);
GC.SuppressFinalize(this);
}
public IEnumerable<InstructorName> GetInstructorNames()
{
return context.InstructorNames.OrderBy("it.FullName").ToList();
}
public void InsertDepartment(Department department)
{
department.DepartmentID = GenerateDepartmentID();
context.Departments.AddObject(department);
context.SaveChanges();
}
public void DeleteDepartment(Department department)
{
context.Departments.Attach(department);
context.Departments.DeleteObject(department);
context.SaveChanges();
}
private Int32 GenerateDepartmentID()
{
Int32 maxDepartmentID = 0;
var department = (from d in GetDepartments()
orderby d.DepartmentID descending
select d).FirstOrDefault();
if (department != null)
{
maxDepartmentID = department.DepartmentID + 1;
}
return maxDepartmentID;
}
public void UpdateDepartment(Department department, Department origDepartment)
{
context.Departments.Attach(origDepartment);
context.ApplyCurrentValues("Departments", department);
context.SaveChanges();
}
public IEnumerable<Department> GetDepartmentsByAdministrator(int administrator)
{
var departments = context.Departments.Include("Person");
departments.MergeOption = MergeOption.NoTracking;
var filterdDepartments = departments.Where(x => x.Administrator == administrator);
return filterdDepartments.ToArray();
}
}
}
Raw
Student.cs
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.ComponentModel.DataAnnotations;
namespace ContosoUniversity.DAL
{
/// <summary>
/// Student の概要の説明です
/// </summary>
[MetadataType(typeof(StudentMetaData))]
public partial class Student
{
public Student()
{
}
}
public class StudentMetaData
{
[DisplayFormat(DataFormatString = "{0:d}", ApplyFormatInEditMode = true)]
public DateTime EnrollmentDate { get; set; }
[StringLength(25, ErrorMessage = "First name must be 25 characters or less in length.")]
[Required(ErrorMessage = "First name is required.")]
public String FirstMidName { get; set; }
[StringLength(25, ErrorMessage = "Last name must be 25 characters or less in length.")]
[Required(ErrorMessage = "Last name is required.")]
public String LastName { get; set; }
}
}
Raw
Web.config
<?xml version="1.0"?>
<configuration>
<location path="Register.aspx">
<system.web>
<authorization>
<allow users="*"/>
</authorization>
</system.web>
</location>
<system.web>
<authorization>
<deny users="?"/>
</authorization>
</system.web>
</configuration>
Raw
README
View raw

(Sorry about that, but we can’t show files that are this big right now.)

Raw
Courses.aspx
View raw

(Sorry about that, but we can’t show files that are this big right now.)

Raw
Courses.aspx.cs
View raw

(Sorry about that, but we can’t show files that are this big right now.)

Raw
CoursesAdd.aspx
View raw

(Sorry about that, but we can’t show files that are this big right now.)

Raw
CoursesAdd.aspx.cs
View raw

(Sorry about that, but we can’t show files that are this big right now.)

Raw
Default.aspx
View raw

(Sorry about that, but we can’t show files that are this big right now.)

Raw
Default.aspx.cs
View raw

(Sorry about that, but we can’t show files that are this big right now.)

Raw
Departments.aspx
View raw

(Sorry about that, but we can’t show files that are this big right now.)

Raw
Departments.aspx.cs
View raw

(Sorry about that, but we can’t show files that are this big right now.)

Raw
DepartmentsAdd.aspx
View raw

(Sorry about that, but we can’t show files that are this big right now.)

Raw
DepartmentsAdd.aspx.cs
View raw

(Sorry about that, but we can’t show files that are this big right now.)

Raw
Global.asax
View raw

(Sorry about that, but we can’t show files that are this big right now.)

Raw
Instructors.aspx
View raw

(Sorry about that, but we can’t show files that are this big right now.)

Raw
Instructors.aspx.cs
View raw

(Sorry about that, but we can’t show files that are this big right now.)

Raw
InstructorsCourses.aspx
View raw

(Sorry about that, but we can’t show files that are this big right now.)

Raw
InstructorsCourses.aspx.cs
View raw

(Sorry about that, but we can’t show files that are this big right now.)

Raw
jquery-1.4.1-vsdoc.js
View raw

(Sorry about that, but we can’t show files that are this big right now.)

Raw
jquery-1.4.1.js
View raw

(Sorry about that, but we can’t show files that are this big right now.)

Raw
jquery-1.4.1.min.js
View raw

(Sorry about that, but we can’t show files that are this big right now.)

Raw
Local.testsettings
View raw

(Sorry about that, but we can’t show files that are this big right now.)

Raw
School.mdf
This file has been truncated, but you can view the full file.
View raw
Raw
School_log.ldf
View raw

(Sorry about that, but we can’t show files that are this big right now.)

Raw
Site.css
View raw

(Sorry about that, but we can’t show files that are this big right now.)

Raw
Site.master
View raw

(Sorry about that, but we can’t show files that are this big right now.)

Raw
Site.master.cs
View raw

(Sorry about that, but we can’t show files that are this big right now.)

Raw
Students.aspx
View raw

(Sorry about that, but we can’t show files that are this big right now.)

Raw
Students.aspx.cs
View raw

(Sorry about that, but we can’t show files that are this big right now.)

Raw
StudentsAdd.aspx
View raw

(Sorry about that, but we can’t show files that are this big right now.)

Raw
StudentsAdd.aspx.cs
View raw

(Sorry about that, but we can’t show files that are this big right now.)

Raw
TraceAndTestImpact.testsettings
View raw

(Sorry about that, but we can’t show files that are this big right now.)

Raw
vwd.webinfo
View raw

(Sorry about that, but we can’t show files that are this big right now.)

Raw
Web.config
View raw

(Sorry about that, but we can’t show files that are this big right now.)

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment