PageRenderTime 7ms CodeModel.GetById 21ms app.highlight 16ms RepoModel.GetById 1ms app.codeStats 0ms

/Visual Studio 2008/VBVstoExcelWorkbook/SchoolDataSet.xsd

#
XML Schema | 895 lines | 895 code | 0 blank | 0 comment | 0 complexity | e621543b46f373c07dc5bc137bf890e9 MD5 | raw file
  1<?xml version="1.0" encoding="utf-8"?>
  2<xs:schema id="SchoolDataSet" targetNamespace="http://tempuri.org/SchoolDataSet.xsd" xmlns:mstns="http://tempuri.org/SchoolDataSet.xsd" xmlns="http://tempuri.org/SchoolDataSet.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  3  <xs:annotation>
  4    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
  5      <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" GeneratorFunctionsComponentClassName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" UserFunctionsComponentName="QueriesTableAdapter" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
  6        <Connections>
  7          <Connection AppSettingsObjectName="MySettings" AppSettingsPropertyName="SchoolConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="SchoolConnectionString (MySettings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.VBVstoExcelWorkbook.MySettings.GlobalReference.Default.SchoolConnectionString" Provider="System.Data.SqlClient" />
  8        </Connections>
  9        <Tables>
 10          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="CourseTableAdapter" GeneratorDataComponentClassName="CourseTableAdapter" Name="Course" UserDataComponentName="CourseTableAdapter">
 11            <MainSource>
 12              <DbSource ConnectionRef="SchoolConnectionString (MySettings)" DbObjectName="SQLServer2005DB.dbo.Course" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
 13                <DeleteCommand>
 14                  <DbCommand CommandType="Text" ModifiedByUser="false">
 15                    <CommandText>DELETE FROM [dbo].[Course] WHERE (([CourseID] = @Original_CourseID) AND ([Title] = @Original_Title) AND ([Credits] = @Original_Credits) AND ([DepartmentID] = @Original_DepartmentID))</CommandText>
 16                    <Parameters>
 17                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_CourseID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CourseID" SourceColumnNullMapping="false" SourceVersion="Original" />
 18                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Title" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Title" SourceColumnNullMapping="false" SourceVersion="Original" />
 19                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Credits" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Credits" SourceColumnNullMapping="false" SourceVersion="Original" />
 20                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_DepartmentID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DepartmentID" SourceColumnNullMapping="false" SourceVersion="Original" />
 21                    </Parameters>
 22                  </DbCommand>
 23                </DeleteCommand>
 24                <InsertCommand>
 25                  <DbCommand CommandType="Text" ModifiedByUser="false">
 26                    <CommandText>INSERT INTO [dbo].[Course] ([CourseID], [Title], [Credits], [DepartmentID]) VALUES (@CourseID, @Title, @Credits, @DepartmentID);
 27SELECT CourseID, Title, Credits, DepartmentID FROM Course WHERE (CourseID = @CourseID)</CommandText>
 28                    <Parameters>
 29                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@CourseID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CourseID" SourceColumnNullMapping="false" SourceVersion="Current" />
 30                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Title" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Title" SourceColumnNullMapping="false" SourceVersion="Current" />
 31                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Credits" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Credits" SourceColumnNullMapping="false" SourceVersion="Current" />
 32                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@DepartmentID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DepartmentID" SourceColumnNullMapping="false" SourceVersion="Current" />
 33                    </Parameters>
 34                  </DbCommand>
 35                </InsertCommand>
 36                <SelectCommand>
 37                  <DbCommand CommandType="Text" ModifiedByUser="false">
 38                    <CommandText>SELECT CourseID, Title, Credits, DepartmentID FROM dbo.Course</CommandText>
 39                    <Parameters />
 40                  </DbCommand>
 41                </SelectCommand>
 42                <UpdateCommand>
 43                  <DbCommand CommandType="Text" ModifiedByUser="false">
 44                    <CommandText>UPDATE [dbo].[Course] SET [CourseID] = @CourseID, [Title] = @Title, [Credits] = @Credits, [DepartmentID] = @DepartmentID WHERE (([CourseID] = @Original_CourseID) AND ([Title] = @Original_Title) AND ([Credits] = @Original_Credits) AND ([DepartmentID] = @Original_DepartmentID));
 45SELECT CourseID, Title, Credits, DepartmentID FROM Course WHERE (CourseID = @CourseID)</CommandText>
 46                    <Parameters>
 47                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@CourseID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CourseID" SourceColumnNullMapping="false" SourceVersion="Current" />
 48                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Title" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Title" SourceColumnNullMapping="false" SourceVersion="Current" />
 49                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Credits" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Credits" SourceColumnNullMapping="false" SourceVersion="Current" />
 50                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@DepartmentID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DepartmentID" SourceColumnNullMapping="false" SourceVersion="Current" />
 51                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_CourseID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CourseID" SourceColumnNullMapping="false" SourceVersion="Original" />
 52                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Title" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Title" SourceColumnNullMapping="false" SourceVersion="Original" />
 53                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Credits" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Credits" SourceColumnNullMapping="false" SourceVersion="Original" />
 54                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_DepartmentID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DepartmentID" SourceColumnNullMapping="false" SourceVersion="Original" />
 55                    </Parameters>
 56                  </DbCommand>
 57                </UpdateCommand>
 58              </DbSource>
 59            </MainSource>
 60            <Mappings>
 61              <Mapping SourceColumn="CourseID" DataSetColumn="CourseID" />
 62              <Mapping SourceColumn="Title" DataSetColumn="Title" />
 63              <Mapping SourceColumn="Credits" DataSetColumn="Credits" />
 64              <Mapping SourceColumn="DepartmentID" DataSetColumn="DepartmentID" />
 65            </Mappings>
 66            <Sources />
 67          </TableAdapter>
 68          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="CourseGradeTableAdapter" GeneratorDataComponentClassName="CourseGradeTableAdapter" Name="CourseGrade" UserDataComponentName="CourseGradeTableAdapter">
 69            <MainSource>
 70              <DbSource ConnectionRef="SchoolConnectionString (MySettings)" DbObjectName="SQLServer2005DB.dbo.CourseGrade" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
 71                <DeleteCommand>
 72                  <DbCommand CommandType="Text" ModifiedByUser="false">
 73                    <CommandText>DELETE FROM [dbo].[CourseGrade] WHERE (([EnrollmentID] = @Original_EnrollmentID) AND ([CourseID] = @Original_CourseID) AND ([StudentID] = @Original_StudentID) AND ((@IsNull_Grade = 1 AND [Grade] IS NULL) OR ([Grade] = @Original_Grade)))</CommandText>
 74                    <Parameters>
 75                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_EnrollmentID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="EnrollmentID" SourceColumnNullMapping="false" SourceVersion="Original" />
 76                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_CourseID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CourseID" SourceColumnNullMapping="false" SourceVersion="Original" />
 77                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_StudentID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="StudentID" SourceColumnNullMapping="false" SourceVersion="Original" />
 78                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Grade" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Grade" SourceColumnNullMapping="true" SourceVersion="Original" />
 79                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_Grade" Precision="3" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="Grade" SourceColumnNullMapping="false" SourceVersion="Original" />
 80                    </Parameters>
 81                  </DbCommand>
 82                </DeleteCommand>
 83                <InsertCommand>
 84                  <DbCommand CommandType="Text" ModifiedByUser="false">
 85                    <CommandText>INSERT INTO [dbo].[CourseGrade] ([CourseID], [StudentID], [Grade]) VALUES (@CourseID, @StudentID, @Grade);
 86SELECT EnrollmentID, CourseID, StudentID, Grade FROM CourseGrade WHERE (EnrollmentID = SCOPE_IDENTITY())</CommandText>
 87                    <Parameters>
 88                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@CourseID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CourseID" SourceColumnNullMapping="false" SourceVersion="Current" />
 89                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@StudentID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="StudentID" SourceColumnNullMapping="false" SourceVersion="Current" />
 90                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Grade" Precision="3" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="Grade" SourceColumnNullMapping="false" SourceVersion="Current" />
 91                    </Parameters>
 92                  </DbCommand>
 93                </InsertCommand>
 94                <SelectCommand>
 95                  <DbCommand CommandType="Text" ModifiedByUser="false">
 96                    <CommandText>SELECT EnrollmentID, CourseID, StudentID, Grade FROM dbo.CourseGrade</CommandText>
 97                    <Parameters />
 98                  </DbCommand>
 99                </SelectCommand>
100                <UpdateCommand>
101                  <DbCommand CommandType="Text" ModifiedByUser="false">
102                    <CommandText>UPDATE [dbo].[CourseGrade] SET [CourseID] = @CourseID, [StudentID] = @StudentID, [Grade] = @Grade WHERE (([EnrollmentID] = @Original_EnrollmentID) AND ([CourseID] = @Original_CourseID) AND ([StudentID] = @Original_StudentID) AND ((@IsNull_Grade = 1 AND [Grade] IS NULL) OR ([Grade] = @Original_Grade)));
103SELECT EnrollmentID, CourseID, StudentID, Grade FROM CourseGrade WHERE (EnrollmentID = @EnrollmentID)</CommandText>
104                    <Parameters>
105                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@CourseID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CourseID" SourceColumnNullMapping="false" SourceVersion="Current" />
106                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@StudentID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="StudentID" SourceColumnNullMapping="false" SourceVersion="Current" />
107                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Grade" Precision="3" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="Grade" SourceColumnNullMapping="false" SourceVersion="Current" />
108                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_EnrollmentID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="EnrollmentID" SourceColumnNullMapping="false" SourceVersion="Original" />
109                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_CourseID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CourseID" SourceColumnNullMapping="false" SourceVersion="Original" />
110                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_StudentID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="StudentID" SourceColumnNullMapping="false" SourceVersion="Original" />
111                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Grade" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Grade" SourceColumnNullMapping="true" SourceVersion="Original" />
112                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_Grade" Precision="3" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="Grade" SourceColumnNullMapping="false" SourceVersion="Original" />
113                      <Parameter AllowDbNull="false" AutogeneratedName="EnrollmentID" ColumnName="EnrollmentID" DataSourceName="SQLServer2005DB.dbo.CourseGrade" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@EnrollmentID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="EnrollmentID" SourceColumnNullMapping="false" SourceVersion="Current" />
114                    </Parameters>
115                  </DbCommand>
116                </UpdateCommand>
117              </DbSource>
118            </MainSource>
119            <Mappings>
120              <Mapping SourceColumn="EnrollmentID" DataSetColumn="EnrollmentID" />
121              <Mapping SourceColumn="CourseID" DataSetColumn="CourseID" />
122              <Mapping SourceColumn="StudentID" DataSetColumn="StudentID" />
123              <Mapping SourceColumn="Grade" DataSetColumn="Grade" />
124            </Mappings>
125            <Sources />
126          </TableAdapter>
127          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="CourseInstructorTableAdapter" GeneratorDataComponentClassName="CourseInstructorTableAdapter" Name="CourseInstructor" UserDataComponentName="CourseInstructorTableAdapter">
128            <MainSource>
129              <DbSource ConnectionRef="SchoolConnectionString (MySettings)" DbObjectName="SQLServer2005DB.dbo.CourseInstructor" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
130                <DeleteCommand>
131                  <DbCommand CommandType="Text" ModifiedByUser="false">
132                    <CommandText>DELETE FROM [dbo].[CourseInstructor] WHERE (([CourseID] = @Original_CourseID) AND ([PersonID] = @Original_PersonID))</CommandText>
133                    <Parameters>
134                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_CourseID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CourseID" SourceColumnNullMapping="false" SourceVersion="Original" />
135                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_PersonID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PersonID" SourceColumnNullMapping="false" SourceVersion="Original" />
136                    </Parameters>
137                  </DbCommand>
138                </DeleteCommand>
139                <InsertCommand>
140                  <DbCommand CommandType="Text" ModifiedByUser="false">
141                    <CommandText>INSERT INTO [dbo].[CourseInstructor] ([CourseID], [PersonID]) VALUES (@CourseID, @PersonID);
142SELECT CourseID, PersonID FROM CourseInstructor WHERE (CourseID = @CourseID) AND (PersonID = @PersonID)</CommandText>
143                    <Parameters>
144                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@CourseID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CourseID" SourceColumnNullMapping="false" SourceVersion="Current" />
145                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@PersonID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PersonID" SourceColumnNullMapping="false" SourceVersion="Current" />
146                    </Parameters>
147                  </DbCommand>
148                </InsertCommand>
149                <SelectCommand>
150                  <DbCommand CommandType="Text" ModifiedByUser="false">
151                    <CommandText>SELECT CourseID, PersonID FROM dbo.CourseInstructor</CommandText>
152                    <Parameters />
153                  </DbCommand>
154                </SelectCommand>
155                <UpdateCommand>
156                  <DbCommand CommandType="Text" ModifiedByUser="false">
157                    <CommandText>UPDATE [dbo].[CourseInstructor] SET [CourseID] = @CourseID, [PersonID] = @PersonID WHERE (([CourseID] = @Original_CourseID) AND ([PersonID] = @Original_PersonID));
158SELECT CourseID, PersonID FROM CourseInstructor WHERE (CourseID = @CourseID) AND (PersonID = @PersonID)</CommandText>
159                    <Parameters>
160                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@CourseID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CourseID" SourceColumnNullMapping="false" SourceVersion="Current" />
161                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@PersonID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PersonID" SourceColumnNullMapping="false" SourceVersion="Current" />
162                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_CourseID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CourseID" SourceColumnNullMapping="false" SourceVersion="Original" />
163                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_PersonID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PersonID" SourceColumnNullMapping="false" SourceVersion="Original" />
164                    </Parameters>
165                  </DbCommand>
166                </UpdateCommand>
167              </DbSource>
168            </MainSource>
169            <Mappings>
170              <Mapping SourceColumn="CourseID" DataSetColumn="CourseID" />
171              <Mapping SourceColumn="PersonID" DataSetColumn="PersonID" />
172            </Mappings>
173            <Sources />
174          </TableAdapter>
175          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="DepartmentTableAdapter" GeneratorDataComponentClassName="DepartmentTableAdapter" Name="Department" UserDataComponentName="DepartmentTableAdapter">
176            <MainSource>
177              <DbSource ConnectionRef="SchoolConnectionString (MySettings)" DbObjectName="SQLServer2005DB.dbo.Department" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
178                <DeleteCommand>
179                  <DbCommand CommandType="Text" ModifiedByUser="false">
180                    <CommandText>DELETE FROM [dbo].[Department] WHERE (([DepartmentID] = @Original_DepartmentID) AND ([Name] = @Original_Name) AND ([Budget] = @Original_Budget) AND ([StartDate] = @Original_StartDate) AND ((@IsNull_Administrator = 1 AND [Administrator] IS NULL) OR ([Administrator] = @Original_Administrator)))</CommandText>
181                    <Parameters>
182                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_DepartmentID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DepartmentID" SourceColumnNullMapping="false" SourceVersion="Original" />
183                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Name" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Original" />
184                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Original_Budget" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="Budget" SourceColumnNullMapping="false" SourceVersion="Original" />
185                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_StartDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="StartDate" SourceColumnNullMapping="false" SourceVersion="Original" />
186                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Administrator" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Administrator" SourceColumnNullMapping="true" SourceVersion="Original" />
187                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Administrator" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Administrator" SourceColumnNullMapping="false" SourceVersion="Original" />
188                    </Parameters>
189                  </DbCommand>
190                </DeleteCommand>
191                <InsertCommand>
192                  <DbCommand CommandType="Text" ModifiedByUser="false">
193                    <CommandText>INSERT INTO [dbo].[Department] ([DepartmentID], [Name], [Budget], [StartDate], [Administrator]) VALUES (@DepartmentID, @Name, @Budget, @StartDate, @Administrator);
194SELECT DepartmentID, Name, Budget, StartDate, Administrator FROM Department WHERE (DepartmentID = @DepartmentID)</CommandText>
195                    <Parameters>
196                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@DepartmentID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DepartmentID" SourceColumnNullMapping="false" SourceVersion="Current" />
197                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Name" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Current" />
198                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Budget" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="Budget" SourceColumnNullMapping="false" SourceVersion="Current" />
199                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@StartDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="StartDate" SourceColumnNullMapping="false" SourceVersion="Current" />
200                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Administrator" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Administrator" SourceColumnNullMapping="false" SourceVersion="Current" />
201                    </Parameters>
202                  </DbCommand>
203                </InsertCommand>
204                <SelectCommand>
205                  <DbCommand CommandType="Text" ModifiedByUser="false">
206                    <CommandText>SELECT DepartmentID, Name, Budget, StartDate, Administrator FROM dbo.Department</CommandText>
207                    <Parameters />
208                  </DbCommand>
209                </SelectCommand>
210                <UpdateCommand>
211                  <DbCommand CommandType="Text" ModifiedByUser="false">
212                    <CommandText>UPDATE [dbo].[Department] SET [DepartmentID] = @DepartmentID, [Name] = @Name, [Budget] = @Budget, [StartDate] = @StartDate, [Administrator] = @Administrator WHERE (([DepartmentID] = @Original_DepartmentID) AND ([Name] = @Original_Name) AND ([Budget] = @Original_Budget) AND ([StartDate] = @Original_StartDate) AND ((@IsNull_Administrator = 1 AND [Administrator] IS NULL) OR ([Administrator] = @Original_Administrator)));
213SELECT DepartmentID, Name, Budget, StartDate, Administrator FROM Department WHERE (DepartmentID = @DepartmentID)</CommandText>
214                    <Parameters>
215                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@DepartmentID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DepartmentID" SourceColumnNullMapping="false" SourceVersion="Current" />
216                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Name" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Current" />
217                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Budget" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="Budget" SourceColumnNullMapping="false" SourceVersion="Current" />
218                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@StartDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="StartDate" SourceColumnNullMapping="false" SourceVersion="Current" />
219                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Administrator" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Administrator" SourceColumnNullMapping="false" SourceVersion="Current" />
220                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_DepartmentID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DepartmentID" SourceColumnNullMapping="false" SourceVersion="Original" />
221                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Name" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Original" />
222                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Original_Budget" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="Budget" SourceColumnNullMapping="false" SourceVersion="Original" />
223                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_StartDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="StartDate" SourceColumnNullMapping="false" SourceVersion="Original" />
224                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Administrator" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Administrator" SourceColumnNullMapping="true" SourceVersion="Original" />
225                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Administrator" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Administrator" SourceColumnNullMapping="false" SourceVersion="Original" />
226                    </Parameters>
227                  </DbCommand>
228                </UpdateCommand>
229              </DbSource>
230            </MainSource>
231            <Mappings>
232              <Mapping SourceColumn="DepartmentID" DataSetColumn="DepartmentID" />
233              <Mapping SourceColumn="Name" DataSetColumn="Name" />
234              <Mapping SourceColumn="Budget" DataSetColumn="Budget" />
235              <Mapping SourceColumn="StartDate" DataSetColumn="StartDate" />
236              <Mapping SourceColumn="Administrator" DataSetColumn="Administrator" />
237            </Mappings>
238            <Sources />
239          </TableAdapter>
240          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="OfficeAssignmentTableAdapter" GeneratorDataComponentClassName="OfficeAssignmentTableAdapter" Name="OfficeAssignment" UserDataComponentName="OfficeAssignmentTableAdapter">
241            <MainSource>
242              <DbSource ConnectionRef="SchoolConnectionString (MySettings)" DbObjectName="SQLServer2005DB.dbo.OfficeAssignment" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
243                <DeleteCommand>
244                  <DbCommand CommandType="Text" ModifiedByUser="false">
245                    <CommandText>DELETE FROM [dbo].[OfficeAssignment] WHERE (([InstructorID] = @Original_InstructorID) AND ([Timestamp] = @Original_Timestamp))</CommandText>
246                    <Parameters>
247                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_InstructorID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="InstructorID" SourceColumnNullMapping="false" SourceVersion="Original" />
248                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Binary" Direction="Input" ParameterName="@Original_Timestamp" Precision="0" ProviderType="Timestamp" Scale="0" Size="0" SourceColumn="Timestamp" SourceColumnNullMapping="false" SourceVersion="Original" />
249                    </Parameters>
250                  </DbCommand>
251                </DeleteCommand>
252                <InsertCommand>
253                  <DbCommand CommandType="Text" ModifiedByUser="false">
254                    <CommandText>INSERT INTO [dbo].[OfficeAssignment] ([InstructorID], [Location]) VALUES (@InstructorID, @Location);
255SELECT InstructorID, Location, Timestamp FROM OfficeAssignment WHERE (InstructorID = @InstructorID)</CommandText>
256                    <Parameters>
257                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@InstructorID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="InstructorID" SourceColumnNullMapping="false" SourceVersion="Current" />
258                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Location" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Location" SourceColumnNullMapping="false" SourceVersion="Current" />
259                    </Parameters>
260                  </DbCommand>
261                </InsertCommand>
262                <SelectCommand>
263                  <DbCommand CommandType="Text" ModifiedByUser="false">
264                    <CommandText>SELECT InstructorID, Location, Timestamp FROM dbo.OfficeAssignment</CommandText>
265                    <Parameters />
266                  </DbCommand>
267                </SelectCommand>
268                <UpdateCommand>
269                  <DbCommand CommandType="Text" ModifiedByUser="false">
270                    <CommandText>UPDATE [dbo].[OfficeAssignment] SET [InstructorID] = @InstructorID, [Location] = @Location WHERE (([InstructorID] = @Original_InstructorID) AND ([Timestamp] = @Original_Timestamp));
271SELECT InstructorID, Location, Timestamp FROM OfficeAssignment WHERE (InstructorID = @InstructorID)</CommandText>
272                    <Parameters>
273                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@InstructorID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="InstructorID" SourceColumnNullMapping="false" SourceVersion="Current" />
274                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Location" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Location" SourceColumnNullMapping="false" SourceVersion="Current" />
275                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_InstructorID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="InstructorID" SourceColumnNullMapping="false" SourceVersion="Original" />
276                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Binary" Direction="Input" ParameterName="@Original_Timestamp" Precision="0" ProviderType="Timestamp" Scale="0" Size="0" SourceColumn="Timestamp" SourceColumnNullMapping="false" SourceVersion="Original" />
277                    </Parameters>
278                  </DbCommand>
279                </UpdateCommand>
280              </DbSource>
281            </MainSource>
282            <Mappings>
283              <Mapping SourceColumn="InstructorID" DataSetColumn="InstructorID" />
284              <Mapping SourceColumn="Location" DataSetColumn="Location" />
285              <Mapping SourceColumn="Timestamp" DataSetColumn="Timestamp" />
286            </Mappings>
287            <Sources />
288          </TableAdapter>
289          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="OnlineCourseTableAdapter" GeneratorDataComponentClassName="OnlineCourseTableAdapter" Name="OnlineCourse" UserDataComponentName="OnlineCourseTableAdapter">
290            <MainSource>
291              <DbSource ConnectionRef="SchoolConnectionString (MySettings)" DbObjectName="SQLServer2005DB.dbo.OnlineCourse" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
292                <DeleteCommand>
293                  <DbCommand CommandType="Text" ModifiedByUser="false">
294                    <CommandText>DELETE FROM [dbo].[OnlineCourse] WHERE (([CourseID] = @Original_CourseID) AND ([URL] = @Original_URL))</CommandText>
295                    <Parameters>
296                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_CourseID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CourseID" SourceColumnNullMapping="false" SourceVersion="Original" />
297                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_URL" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="URL" SourceColumnNullMapping="false" SourceVersion="Original" />
298                    </Parameters>
299                  </DbCommand>
300                </DeleteCommand>
301                <InsertCommand>
302                  <DbCommand CommandType="Text" ModifiedByUser="false">
303                    <CommandText>INSERT INTO [dbo].[OnlineCourse] ([CourseID], [URL]) VALUES (@CourseID, @URL);
304SELECT CourseID, URL FROM OnlineCourse WHERE (CourseID = @CourseID)</CommandText>
305                    <Parameters>
306                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@CourseID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CourseID" SourceColumnNullMapping="false" SourceVersion="Current" />
307                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@URL" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="URL" SourceColumnNullMapping="false" SourceVersion="Current" />
308                    </Parameters>
309                  </DbCommand>
310                </InsertCommand>
311                <SelectCommand>
312                  <DbCommand CommandType="Text" ModifiedByUser="false">
313                    <CommandText>SELECT CourseID, URL FROM dbo.OnlineCourse</CommandText>
314                    <Parameters />
315                  </DbCommand>
316                </SelectCommand>
317                <UpdateCommand>
318                  <DbCommand CommandType="Text" ModifiedByUser="false">
319                    <CommandText>UPDATE [dbo].[OnlineCourse] SET [CourseID] = @CourseID, [URL] = @URL WHERE (([CourseID] = @Original_CourseID) AND ([URL] = @Original_URL));
320SELECT CourseID, URL FROM OnlineCourse WHERE (CourseID = @CourseID)</CommandText>
321                    <Parameters>
322                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@CourseID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CourseID" SourceColumnNullMapping="false" SourceVersion="Current" />
323                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@URL" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="URL" SourceColumnNullMapping="false" SourceVersion="Current" />
324                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_CourseID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CourseID" SourceColumnNullMapping="false" SourceVersion="Original" />
325                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_URL" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="URL" SourceColumnNullMapping="false" SourceVersion="Original" />
326                    </Parameters>
327                  </DbCommand>
328                </UpdateCommand>
329              </DbSource>
330            </MainSource>
331            <Mappings>
332              <Mapping SourceColumn="CourseID" DataSetColumn="CourseID" />
333              <Mapping SourceColumn="URL" DataSetColumn="URL" />
334            </Mappings>
335            <Sources />
336          </TableAdapter>
337          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="OnsiteCourseTableAdapter" GeneratorDataComponentClassName="OnsiteCourseTableAdapter" Name="OnsiteCourse" UserDataComponentName="OnsiteCourseTableAdapter">
338            <MainSource>
339              <DbSource ConnectionRef="SchoolConnectionString (MySettings)" DbObjectName="SQLServer2005DB.dbo.OnsiteCourse" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
340                <DeleteCommand>
341                  <DbCommand CommandType="Text" ModifiedByUser="false">
342                    <CommandText>DELETE FROM [dbo].[OnsiteCourse] WHERE (([CourseID] = @Original_CourseID) AND ([Location] = @Original_Location) AND ([Days] = @Original_Days) AND ([Time] = @Original_Time))</CommandText>
343                    <Parameters>
344                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_CourseID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CourseID" SourceColumnNullMapping="false" SourceVersion="Original" />
345                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Location" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Location" SourceColumnNullMapping="false" SourceVersion="Original" />
346                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Days" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Days" SourceColumnNullMapping="false" SourceVersion="Original" />
347                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_Time" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="Time" SourceColumnNullMapping="false" SourceVersion="Original" />
348                    </Parameters>
349                  </DbCommand>
350                </DeleteCommand>
351                <InsertCommand>
352                  <DbCommand CommandType="Text" ModifiedByUser="false">
353                    <CommandText>INSERT INTO [dbo].[OnsiteCourse] ([CourseID], [Location], [Days], [Time]) VALUES (@CourseID, @Location, @Days, @Time);
354SELECT CourseID, Location, Days, Time FROM OnsiteCourse WHERE (CourseID = @CourseID)</CommandText>
355                    <Parameters>
356                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@CourseID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CourseID" SourceColumnNullMapping="false" SourceVersion="Current" />
357                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Location" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Location" SourceColumnNullMapping="false" SourceVersion="Current" />
358                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Days" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Days" SourceColumnNullMapping="false" SourceVersion="Current" />
359                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Time" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="Time" SourceColumnNullMapping="false" SourceVersion="Current" />
360                    </Parameters>
361                  </DbCommand>
362                </InsertCommand>
363                <SelectCommand>
364                  <DbCommand CommandType="Text" ModifiedByUser="false">
365                    <CommandText>SELECT CourseID, Location, Days, Time FROM dbo.OnsiteCourse</CommandText>
366                    <Parameters />
367                  </DbCommand>
368                </SelectCommand>
369                <UpdateCommand>
370                  <DbCommand CommandType="Text" ModifiedByUser="false">
371                    <CommandText>UPDATE [dbo].[OnsiteCourse] SET [CourseID] = @CourseID, [Location] = @Location, [Days] = @Days, [Time] = @Time WHERE (([CourseID] = @Original_CourseID) AND ([Location] = @Original_Location) AND ([Days] = @Original_Days) AND ([Time] = @Original_Time));
372SELECT CourseID, Location, Days, Time FROM OnsiteCourse WHERE (CourseID = @CourseID)</CommandText>
373                    <Parameters>
374                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@CourseID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CourseID" SourceColumnNullMapping="false" SourceVersion="Current" />
375                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Location" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Location" SourceColumnNullMapping="false" SourceVersion="Current" />
376                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Days" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Days" SourceColumnNullMapping="false" SourceVersion="Current" />
377                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Time" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="Time" SourceColumnNullMapping="false" SourceVersion="Current" />
378                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_CourseID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CourseID" SourceColumnNullMapping="false" SourceVersion="Original" />
379                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Location" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Location" SourceColumnNullMapping="false" SourceVersion="Original" />
380                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Days" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Days" SourceColumnNullMapping="false" SourceVersion="Original" />
381                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_Time" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="Time" SourceColumnNullMapping="false" SourceVersion="Original" />
382                    </Parameters>
383                  </DbCommand>
384                </UpdateCommand>
385              </DbSource>
386            </MainSource>
387            <Mappings>
388              <Mapping SourceColumn="CourseID" DataSetColumn="CourseID" />
389              <Mapping SourceColumn="Location" DataSetColumn="Location" />
390              <Mapping SourceColumn="Days" DataSetColumn="Days" />
391              <Mapping SourceColumn="Time" DataSetColumn="Time" />
392            </Mappings>
393            <Sources />
394          </TableAdapter>
395          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="PersonTableAdapter" GeneratorDataComponentClassName="PersonTableAdapter" Name="Person" UserDataComponentName="PersonTableAdapter">
396            <MainSource>
397              <DbSource ConnectionRef="SchoolConnectionString (MySettings)" DbObjectName="SQLServer2005DB.dbo.Person" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
398                <DeleteCommand>
399                  <DbCommand CommandType="Text" ModifiedByUser="false">
400                    <CommandText>DELETE FROM [dbo].[Person] WHERE (([PersonID] = @Original_PersonID) AND ([LastName] = @Original_LastName) AND ([FirstName] = @Original_FirstName) AND ([PersonCategory] = @Original_PersonCategory) AND ((@IsNull_HireDate = 1 AND [HireDate] IS NULL) OR ([HireDate] = @Original_HireDate)) AND ((@IsNull_EnrollmentDate = 1 AND [EnrollmentDate] IS NULL) OR ([EnrollmentDate] = @Original_EnrollmentDate)))</CommandText>
401                    <Parameters>
402                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_PersonID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PersonID" SourceColumnNullMapping="false" SourceVersion="Original" />
403                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_LastName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="LastName" SourceColumnNullMapping="false" SourceVersion="Original" />
404                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_FirstName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="FirstName" SourceColumnNullMapping="false" SourceVersion="Original" />
405                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@Original_PersonCategory" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="PersonCategory" SourceColumnNullMapping="false" SourceVersion="Original" />
406                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_HireDate" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="HireDate" SourceColumnNullMapping="true" SourceVersion="Original" />
407                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_HireDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="HireDate" SourceColumnNullMapping="false" SourceVersion="Original" />
408                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_EnrollmentDate" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="EnrollmentDate" SourceColumnNullMapping="true" SourceVersion="Original" />
409                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_EnrollmentDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="EnrollmentDate" SourceColumnNullMapping="false" SourceVersion="Original" />
410                    </Parameters>
411                  </DbCommand>
412                </DeleteCommand>
413                <InsertCommand>
414                  <DbCommand CommandType="Text" ModifiedByUser="false">
415                    <CommandText>INSERT INTO [dbo].[Person] ([LastName], [FirstName], [PersonCategory], [HireDate], [EnrollmentDate], [Picture]) VALUES (@LastName, @FirstName, @PersonCategory, @HireDate, @EnrollmentDate, @Picture);
416SELECT PersonID, LastName, FirstName, PersonCategory, HireDate, EnrollmentDate, Picture FROM Person WHERE (PersonID = SCOPE_IDENTITY())</CommandText>
417                    <Parameters>
418                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@LastName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="LastName" SourceColumnNullMapping="false" SourceVersion="Current" />
419                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@FirstName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="FirstName" SourceColumnNullMapping="false" SourceVersion="Current" />
420                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@PersonCategory" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="PersonCategory" SourceColumnNullMapping="false" SourceVersion="Current" />
421                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@HireDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="HireDate" SourceColumnNullMapping="false" SourceVersion="Current" />
422                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@EnrollmentDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="EnrollmentDate" SourceColumnNullMapping="false" SourceVersion="Current" />
423                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Binary" Direction="Input" ParameterName="@Picture" Precision="0" ProviderType="Image" Scale="0" Size="0" SourceColumn="Picture" SourceColumnNullMapping="false" SourceVersion="Current" />
424                    </Parameters>
425                  </DbCommand>
426                </InsertCommand>
427                <SelectCommand>
428                  <DbCommand CommandType="Text" ModifiedByUser="false">
429                    <CommandText>SELECT PersonID, LastName, FirstName, PersonCategory, HireDate, EnrollmentDate, Picture FROM dbo.Person</CommandText>
430                    <Parameters />
431                  </DbCommand>
432                </SelectCommand>
433                <UpdateCommand>
434                  <DbCommand CommandType="Text" ModifiedByUser="false">
435                    <CommandText>UPDATE [dbo].[Person] SET [LastName] = @LastName, [FirstName] = @FirstName, [PersonCategory] = @PersonCategory, [HireDate] = @HireDate, [EnrollmentDate] = @EnrollmentDate, [Picture] = @Picture WHERE (([PersonID] = @Original_PersonID) AND ([LastName] = @Original_LastName) AND ([FirstName] = @Original_FirstName) AND ([PersonCategory] = @Original_PersonCategory) AND ((@IsNull_HireDate = 1 AND [HireDate] IS NULL) OR ([HireDate] = @Original_HireDate)) AND ((@IsNull_EnrollmentDate = 1 AND [EnrollmentDate] IS NULL) OR ([EnrollmentDate] = @Original_EnrollmentDate)));
436SELECT PersonID, LastName, FirstName, PersonCategory, HireDate, EnrollmentDate, Picture FROM Person WHERE (PersonID = @PersonID)</CommandText>
437                    <Parameters>
438                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@LastName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="LastName" SourceColumnNullMapping="false" SourceVersion="Current" />
439                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@FirstName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="FirstName" SourceColumnNullMapping="false" SourceVersion="Current" />
440                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@PersonCategory" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="PersonCategory" SourceColumnNullMapping="false" SourceVersion="Current" />
441                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@HireDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="HireDate" SourceColumnNullMapping="false" SourceVersion="Current" />
442                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@EnrollmentDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="EnrollmentDate" SourceColumnNullMapping="false" SourceVersion="Current" />
443                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Binary" Direction="Input" ParameterName="@Picture" Precision="0" ProviderType="Image" Scale="0" Size="0" SourceColumn="Picture" SourceColumnNullMapping="false" SourceVersion="Current" />
444                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_PersonID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PersonID" SourceColumnNullMapping="false" SourceVersion="Original" />
445                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_LastName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="LastName" SourceColumnNullMapping="false" SourceVersion="Original" />
446                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_FirstName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="FirstName" SourceColumnNullMapping="false" SourceVersion="Original" />
447                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@Original_PersonCategory" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="PersonCategory" SourceColumnNullMapping="false" SourceVersion="Original" />
448                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_HireDate" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="HireDate" SourceColumnNullMapping="true" SourceVersion="Original" />
449                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_HireDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="HireDate" SourceColumnNullMapping="false" SourceVersion="Original" />
450                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_EnrollmentDate" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="EnrollmentDate" SourceColumnNullMapping="true" SourceVersion="Original" />
451                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_EnrollmentDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="EnrollmentDate" SourceColumnNullMapping="false" SourceVersion="Original" />
452                      <Parameter AllowDbNull="false" AutogeneratedName="PersonID" ColumnName="PersonID" DataSourceName="SQLServer2005DB.dbo.Person" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@PersonID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="PersonID" SourceColumnNullMapping="false" SourceVersion="Current" />
453                    </Parameters>
454                  </DbCommand>
455                </UpdateCommand>
456              </DbSource>
457            </MainSource>
458            <Mappings>
459              <Mapping SourceColumn="PersonID" DataSetColumn="PersonID" />
460              <Mapping SourceColumn="LastName" DataSetColumn="LastName" />
461              <Mapping SourceColumn="FirstName" DataSetColumn="FirstName" />
462              <Mapping SourceColumn="PersonCategory" DataSetColumn="PersonCategory" />
463              <Mapping SourceColumn="HireDate" DataSetColumn="HireDate" />
464              <Mapping SourceColumn="EnrollmentDate" DataSetColumn="EnrollmentDate" />
465              <Mapping SourceColumn="Picture" DataSetColumn="Picture" />
466            </Mappings>
467            <Sources />
468          </TableAdapter>
469          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="GetStudentGradesTableAdapter" GeneratorDataComponentClassName="GetStudentGradesTableAdapter" Name="GetStudentGrades" UserDataComponentName="GetStudentGradesTableAdapter">
470            <MainSource>
471              <DbSource ConnectionRef="SchoolConnectionString (MySettings)" DbObjectName="SQLServer2005DB.dbo.GetStudentGrades" DbObjectType="StoredProcedure" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
472                <SelectCommand>
473                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
474                    <CommandText>dbo.GetStudentGrades</CommandText>
475                    <Parameters>
476                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
477                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@StudentID" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
478                    </Parameters>
479                  </DbCommand>
480                </SelectCommand>
481              </DbSource>
482            </MainSource>
483            <Mappings>
484              <Mapping SourceColumn="EnrollmentID" DataSetColumn="EnrollmentID" />
485              <Mapping SourceColumn="Grade" DataSetColumn="Grade" />
486            </Mappings>
487            <Sources />
488          </TableAdapter>
489          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="InsertOfficeAssignmentTableAdapter" GeneratorDataComponentClassName="InsertOfficeAssignmentTableAdapter" Name="InsertOfficeAssignment" UserDataComponentName="InsertOfficeAssignmentTableAdapter">
490            <MainSource>
491              <DbSource ConnectionRef="SchoolConnectionString (MySettings)" DbObjectName="SQLServer2005DB.dbo.InsertOfficeAssignment" DbObjectType="StoredProcedure" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
492                <SelectCommand>
493                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
494                    <CommandText>dbo.InsertOfficeAssignment</CommandText>
495                    <Parameters>
496                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
497                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@InstructorID" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
498                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Location" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
499                    </Parameters>
500                  </DbCommand>
501                </SelectCommand>
502              </DbSource>
503            </MainSource>
504            <Mappings>
505              <Mapping SourceColumn="Timestamp" DataSetColumn="Timestamp" />
506            </Mappings>
507            <Sources />
508          </TableAdapter>
509          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="InsertPersonTableAdapter" GeneratorDataComponentClassName="InsertPersonTableAdapter" Name="InsertPerson" UserDataComponentName="InsertPersonTableAdapter">
510            <MainSource>
511              <DbSource ConnectionRef="SchoolConnectionString (MySettings)" DbObjectName="SQLServer2005DB.dbo.InsertPerson" DbObjectType="StoredProcedure" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
512                <SelectCommand>
513                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
514                    <CommandText>dbo.InsertPerson</CommandText>
515                    <Parameters>
516                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
517                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@LastName" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
518                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@FirstName" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
519                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@HireDate" Precision="23" ProviderType="DateTime" Scale="3" Size="8" SourceColumnNullMapping="false" SourceVersion="Current" />
520                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@EnrollmentDate" Precision="23" ProviderType="DateTime" Scale="3" Size="8" SourceColumnNullMapping="false" SourceVersion="Current" />
521                    </Parameters>
522                  </DbCommand>
523                </SelectCommand>
524              </DbSource>
525            </MainSource>
526            <Mappings>
527              <Mapping SourceColumn="NewPersonID" DataSetColumn="NewPersonID" />
528            </Mappings>
529            <Sources />
530          </TableAdapter>
531          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="UpdateOfficeAssignmentTableAdapter" GeneratorDataComponentClassName="UpdateOfficeAssignmentTableAdapter" Name="UpdateOfficeAssignment" UserDataComponentName="UpdateOfficeAssignmentTableAdapter">
532            <MainSource>
533              <DbSource ConnectionRef="SchoolConnectionString (MySettings)" DbObjectName="SQLServer2005DB.dbo.UpdateOfficeAssignment" DbObjectType="StoredProcedure" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
534                <SelectCommand>
535                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
536                    <CommandText>dbo.UpdateOfficeAssignment</CommandText>
537                    <Parameters>
538                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
539                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@InstructorID" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
540                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Location" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
541                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Binary" Direction="Input" ParameterName="@OrigTimestamp" Precision="0" ProviderType="Timestamp" Scale="0" Size="8" SourceColumnNullMapping="false" SourceVersion="Current" />
542                    </Parameters>
543                  </DbCommand>
544                </SelectCommand>
545              </DbSource>
546            </MainSource>
547            <Mappings>
548              <Mapping SourceColumn="Timestamp" DataSetColumn="Timestamp" />
549            </Mappings>
550            <Sources />
551          </TableAdapter>
552          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="CourseListTableAdapter" GeneratorDataComponentClassName="CourseListTableAdapter" Name="CourseList" UserDataComponentName="CourseListTableAdapter">
553            <MainSource>
554              <DbSource ConnectionRef="SchoolConnectionString (MySettings)" DbObjectType="Unknown" FillMethodModifier="Public" FillMethodName="FillCourseList" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetCourseList" GeneratorSourceName="FillCourseList" GetMethodModifier="Public" GetMethodName="GetCourseList" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetCourseList" UserSourceName="FillCourseList">
555                <SelectCommand>
556                  <DbCommand CommandType="Text" ModifiedByUser="true">
557                    <CommandText>SELECT        Course.Title, Course.Credits, Department.Name AS DepartmentName, Instructors.FirstName + ' ' + Instructors.LastName AS Instructor
558FROM            CourseGrade LEFT OUTER JOIN
559                         Person AS Students ON CourseGrade.StudentID = Students.PersonID RIGHT OUTER JOIN
560                         Person AS Instructors RIGHT OUTER JOIN
561                         CourseInstructor RIGHT OUTER JOIN
562                         Course ON CourseInstructor.CourseID = Course.CourseID LEFT OUTER JOIN
563                         Department ON Course.DepartmentID = Department.DepartmentID ON Instructors.PersonID = CourseInstructor.PersonID ON 
564                         CourseGrade.CourseID = Course.CourseID
565WHERE        (Students.FirstName + ' ' + Students.LastName = @StudentName)</CommandText>
566                    <Parameters>
567                      <Parameter AllowDbNull="false" AutogeneratedName="StudentName" ColumnName="" DataSourceName="" DataTypeServer="unknown" DbType="String" Direction="Input" ParameterName="@StudentName" Precision="0" Scale="0" Size="1024" SourceColumn="" SourceColumnNullMapping="false" SourceVersion="Current" />
568                    </Parameters>
569                  </DbCommand>
570                </SelectCommand>
571              </DbSource>
572            </MainSource>
573            <Mappings>
574              <Mapping SourceColumn="Title" DataSetColumn="Title" />
575              <Mapping SourceColumn="Credits" DataSetColumn="Credits" />
576              <Mapping SourceColumn="DepartmentName" DataSetColumn="DepartmentName" />
577              <Mapping SourceColumn="Instructor" DataSetColumn="Instructor" />
578            </Mappings>
579            <Sources />
580          </TableAdapter>
581          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="StudentListTableAdapter" GeneratorDataComponentClassName="StudentListTableAdapter" Name="StudentList" UserDataComponentName="StudentListTableAdapter">
582            <MainSource>
583              <DbSource ConnectionRef="SchoolConnectionString (MySettings)" DbObjectType="Unknown" FillMethodModifier="Public" FillMethodName="FillStudentList" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetStudentList" GeneratorSourceName="FillStudentList" GetMethodModifier="Public" GetMethodName="GetStudentList" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetStudentList" UserSourceName="FillStudentList">
584                <SelectCommand>
585                  <DbCommand CommandType="Text" ModifiedByUser="true">
586                    <CommandText>SELECT        FirstName + ' ' + LastName AS StudentName
587FROM            Person
588WHERE        (HireDate IS NULL)
589ORDER BY StudentName</CommandText>
590                    <Parameters />
591                  </DbCommand>
592                </SelectCommand>
593              </DbSource>
594            </MainSource>
595            <Mappings>
596              <Mapping SourceColumn="StudentName" DataSetColumn="StudentName" />
597            </Mappings>
598            <Sources />
599          </TableAdapter>
600        </Tables>
601        <Sources>
602          <DbSource ConnectionRef="SchoolConnectionString (MySettings)" DbObjectName="SQLServer2005DB.dbo.DeleteOfficeAssignment" DbObjectType="StoredProcedure" GenerateShortCommands="true" GeneratorSourceName="DeleteOfficeAssignment" MethodsParameterType="CLR" Modifier="Public" Name="DeleteOfficeAssignment" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="DeleteOfficeAssignment">
603            <SelectCommand>
604              <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
605                <CommandText>dbo.DeleteOfficeAssignment</CommandText>
606                <Parameters>
607                  <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
608                  <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@InstructorID" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
609                </Parameters>
610              </DbCommand>
611            </SelectCommand>
612          </DbSource>
613          <DbSource ConnectionRef="SchoolConnectionString (MySettings)" DbObjectName="SQLServer2005DB.dbo.DeletePerson" DbObjectType="StoredProcedure" GenerateShortCommands="true" GeneratorSourceName="DeletePerson" MethodsParameterType="CLR" Modifier="Public" Name="DeletePerson" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy1" UserSourceName="DeletePerson">
614            <SelectCommand>
615              <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
616                <CommandText>dbo.DeletePerson</CommandText>
617                <Parameters>
618                  <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
619                  <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@PersonID" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
620                </Parameters>
621              </DbCommand>
622            </SelectCommand>
623          </DbSource>
624          <DbSource ConnectionRef="SchoolConnectionString (MySettings)" DbObjectName="SQLServer2005DB.dbo.UpdatePerson" DbObjectType="StoredProcedure" GenerateShortCommands="true" GeneratorSourceName="UpdatePerson" MethodsParameterType="CLR" Modifier="Public" Name="UpdatePerson" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy2" UserSourceName="UpdatePerson">
625            <SelectCommand>
626              <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
627                <CommandText>dbo.UpdatePerson</CommandText>
628                <Parameters>
629                  <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
630                  <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@PersonID" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
631                  <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@LastName" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
632                  <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@FirstName" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
633                  <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@HireDate" Precision="23" ProviderType="DateTime" Scale="3" Size="8" SourceColumnNullMapping="false" SourceVersion="Current" />
634                  <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@EnrollmentDate" Precision="23" ProviderType="DateTime" Scale="3" Size="8" SourceColumnNullMapping="false" SourceVersion="Current" />
635                </Parameters>
636              </DbCommand>
637            </SelectCommand>
638          </DbSource>
639        </Sources>
640      </DataSource>
641    </xs:appinfo>
642  </xs:annotation>
643  <xs:element name="SchoolDataSet" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:Generator_DataSetName="SchoolDataSet" msprop:Generator_UserDSName="SchoolDataSet" msprop:EnableTableAdapterManager="true">
644    <xs:complexType>
645      <xs:choice minOccurs="0" maxOccurs="unbounded">
646        <xs:element name="Course" msprop:Generator_UserTableName="Course" msprop:Generator_RowDeletedName="CourseRowDeleted" msprop:Generator_TableClassName="CourseDataTable" msprop:Generator_RowChangedName="CourseRowChanged" msprop:Generator_RowClassName="CourseRow" msprop:Generator_RowChangingName="CourseRowChanging" msprop:Generator_RowEvArgName="CourseRowChangeEvent" msprop:Generator_RowEvHandlerName="CourseRowChangeEventHandler" msprop:Generator_TablePropName="Course" msprop:Generator_TableVarName="tableCourse" msprop:Generator_RowDeletingName="CourseRowDeleting">
647          <xs:complexType>
648            <xs:sequence>
649              <xs:element name="CourseID" msprop:Generator_UserColumnName="CourseID" msprop:Generator_ColumnPropNameInRow="CourseID" msprop:Generator_ColumnVarNameInTable="columnCourseID" msprop:Generator_ColumnPropNameInTable="CourseIDColumn" type="xs:int" />
650              <xs:element name="Title" msprop:Generator_UserColumnName="Title" msprop:Generator_ColumnPropNameInRow="Title" msprop:Generator_ColumnVarNameInTable="columnTitle" msprop:Generator_ColumnPropNameInTable="TitleColumn">
651                <xs:simpleType>
652                  <xs:restriction base="xs:string">
653                    <xs:maxLength value="100" />
654                  </xs:restriction>
655                </xs:simpleType>
656              </xs:element>
657              <xs:element name="Credits" msprop:Generator_UserColumnName="Credits" msprop:Generator_ColumnPropNameInRow="Credits" msprop:Generator_ColumnVarNameInTable="columnCredits" msprop:Generator_ColumnPropNameInTable="CreditsColumn" type="xs:int" />
658              <xs:element name="DepartmentID" msprop:Generator_UserColumnName="DepartmentID" msprop:Generator_ColumnPropNameInRow="DepartmentID" msprop:Generator_ColumnVarNameInTable="columnDepartmentID" msprop:Generator_ColumnPropNameInTable="DepartmentIDColumn" type="xs:int" />
659            </xs:sequence>
660          </xs:complexType>
661        </xs:element>
662        <xs:element name="CourseGrade" msprop:Generator_UserTableName="CourseGrade" msprop:Generator_RowDeletedName="CourseGradeRowDeleted" msprop:Generator_TableClassName="CourseGradeDataTable" msprop:Generator_RowChangedName="CourseGradeRowChanged" msprop:Generator_RowClassName="CourseGradeRow" msprop:Generator_RowChangingName="CourseGradeRowChanging" msprop:Generator_RowEvArgName="CourseGradeRowChangeEvent" msprop:Generator_RowEvHandlerName="CourseGradeRowChangeEventHandler" msprop:Generator_TablePropName="CourseGrade" msprop:Generator_TableVarName="tableCourseGrade" msprop:Generator_RowDeletingName="CourseGradeRowDeleting">
663          <xs:complexType>
664            <xs:sequence>
665              <xs:element name="EnrollmentID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_UserColumnName="EnrollmentID" msprop:Generator_ColumnPropNameInRow="EnrollmentID" msprop:Generator_ColumnVarNameInTable="columnEnrollmentID" msprop:Generator_ColumnPropNameInTable="EnrollmentIDColumn" type="xs:int" />
666              <xs:element name="CourseID" msprop:Generator_UserColumnName="CourseID" msprop:Generator_ColumnPropNameInRow="CourseID" msprop:Generator_ColumnVarNameInTable="columnCourseID" msprop:Generator_ColumnPropNameInTable="CourseIDColumn" type="xs:int" />
667              <xs:element name="StudentID" msprop:Generator_UserColumnName="StudentID" msprop:Generator_ColumnPropNameInRow="StudentID" msprop:Generator_ColumnVarNameInTable="columnStudentID" msprop:Generator_ColumnPropNameInTable="StudentIDColumn" type="xs:int" />
668              <xs:element name="Grade" msprop:Generator_UserColumnName="Grade" msprop:Generator_ColumnPropNameInRow="Grade" msprop:Generator_ColumnVarNameInTable="columnGrade" msprop:Generator_ColumnPropNameInTable="GradeColumn" type="xs:decimal" minOccurs="0" />
669            </xs:sequence>
670          </xs:complexType>
671        </xs:element>
672        <xs:element name="CourseInstructor" msprop:Generator_UserTableName="CourseInstructor" msprop:Generator_RowDeletedName="CourseInstructorRowDeleted" msprop:Generator_TableClassName="CourseInstructorDataTable" msprop:Generator_RowChangedName="CourseInstructorRowChanged" msprop:Generator_RowClassName="CourseInstructorRow" msprop:Generator_RowChangingName="CourseInstructorRowChanging" msprop:Generator_RowEvArgName="CourseInstructorRowChangeEvent" msprop:Generator_RowEvHandlerName="CourseInstructorRowChangeEventHandler" msprop:Generator_TablePropName="CourseInstructor" msprop:Generator_TableVarName="tableCourseInstructor" msprop:Generator_RowDeletingName="CourseInstructorRowDeleting">
673          <xs:complexType>
674            <xs:sequence>
675              <xs:element name="CourseID" msprop:Generator_UserColumnName="CourseID" msprop:Generator_ColumnPropNameInRow="CourseID" msprop:Generator_ColumnVarNameInTable="columnCourseID" msprop:Generator_ColumnPropNameInTable="CourseIDColumn" type="xs:int" />
676              <xs:element name="PersonID" msprop:Generator_UserColumnName="PersonID" msprop:Generator_ColumnPropNameInRow="PersonID" msprop:Generator_ColumnVarNameInTable="columnPersonID" msprop:Generator_ColumnPropNameInTable="PersonIDColumn" type="xs:int" />
677            </xs:sequence>
678          </xs:complexType>
679        </xs:element>
680        <xs:element name="Department" msprop:Generator_UserTableName="Department" msprop:Generator_RowDeletedName="DepartmentRowDeleted" msprop:Generator_TableClassName="DepartmentDataTable" msprop:Generator_RowChangedName="DepartmentRowChanged" msprop:Generator_RowClassName="DepartmentRow" msprop:Generator_RowChangingName="DepartmentRowChanging" msprop:Generator_RowEvArgName="DepartmentRowChangeEvent" msprop:Generator_RowEvHandlerName="DepartmentRowChangeEventHandler" msprop:Generator_TablePropName="Department" msprop:Generator_TableVarName="tableDepartment" msprop:Generator_RowDeletingName="DepartmentRowDeleting">
681          <xs:complexType>
682            <xs:sequence>
683              <xs:element name="DepartmentID" msprop:Generator_UserColumnName="DepartmentID" msprop:Generator_ColumnPropNameInRow="DepartmentID" msprop:Generator_ColumnVarNameInTable="columnDepartmentID" msprop:Generator_ColumnPropNameInTable="DepartmentIDColumn" type="xs:int" />
684              <xs:element name="Name" msprop:Generator_UserColumnName="Name" msprop:Generator_ColumnPropNameInRow="Name" msprop:Generator_ColumnVarNameInTable="columnName" msprop:Generator_ColumnPropNameInTable="NameColumn">
685                <xs:simpleType>
686                  <xs:restriction base="xs:string">
687                    <xs:maxLength value="50" />
688                  </xs:restriction>
689                </xs:simpleType>
690              </xs:element>
691              <xs:element name="Budget" msprop:Generator_UserColumnName="Budget" msprop:Generator_ColumnPropNameInRow="Budget" msprop:Generator_ColumnVarNameInTable="columnBudget" msprop:Generator_ColumnPropNameInTable="BudgetColumn" type="xs:decimal" />
692              <xs:element name="StartDate" msprop:Generator_UserColumnName="StartDate" msprop:Generator_ColumnPropNameInRow="StartDate" msprop:Generator_ColumnVarNameInTable="columnStartDate" msprop:Generator_ColumnPropNameInTable="StartDateColumn" type="xs:dateTime" />
693              <xs:element name="Administrator" msprop:Generator_UserColumnName="Administrator" msprop:Generator_ColumnPropNameInRow="Administrator" msprop:Generator_ColumnVarNameInTable="columnAdministrator" msprop:Generator_ColumnPropNameInTable="AdministratorColumn" type="xs:int" minOccurs="0" />
694            </xs:sequence>
695          </xs:complexType>
696        </xs:element>
697        <xs:element name="OfficeAssignment" msprop:Generator_UserTableName="OfficeAssignment" msprop:Generator_RowDeletedName="OfficeAssignmentRowDeleted" msprop:Generator_TableClassName="OfficeAssignmentDataTable" msprop:Generator_RowChangedName="OfficeAssignmentRowChanged" msprop:Generator_RowClassName="OfficeAssignmentRow" msprop:Generator_RowChangingName="OfficeAssignmentRowChanging" msprop:Generator_RowEvArgName="OfficeAssignmentRowChangeEvent" msprop:Generator_RowEvHandlerName="OfficeAssignmentRowChangeEventHandler" msprop:Generator_TablePropName="OfficeAssignment" msprop:Generator_TableVarName="tableOfficeAssignment" msprop:Generator_RowDeletingName="OfficeAssignmentRowDeleting">
698          <xs:complexType>
699            <xs:sequence>
700              <xs:element name="InstructorID" msprop:Generator_UserColumnName="InstructorID" msprop:Generator_ColumnPropNameInRow="InstructorID" msprop:Generator_ColumnVarNameInTable="columnInstructorID" msprop:Generator_ColumnPropNameInTable="InstructorIDColumn" type="xs:int" />
701              <xs:element name="Location" msprop:Generator_UserColumnName="Location" msprop:Generator_ColumnPropNameInRow="Location" msprop:Generator_ColumnVarNameInTable="columnLocation" msprop:Generator_ColumnPropNameInTable="LocationColumn">
702                <xs:simpleType>
703                  <xs:restriction base="xs:string">
704                    <xs:maxLength value="50" />
705                  </xs:restriction>
706                </xs:simpleType>
707              </xs:element>
708              <xs:element name="Timestamp" msdata:ReadOnly="true" msprop:Generator_UserColumnName="Timestamp" msprop:Generator_ColumnPropNameInRow="Timestamp" msprop:Generator_ColumnVarNameInTable="columnTimestamp" msprop:Generator_ColumnPropNameInTable="TimestampColumn" type="xs:base64Binary" minOccurs="0" />
709            </xs:sequence>
710          </xs:complexType>
711        </xs:element>
712        <xs:element name="OnlineCourse" msprop:Generator_UserTableName="OnlineCourse" msprop:Generator_RowDeletedName="OnlineCourseRowDeleted" msprop:Generator_TableClassName="OnlineCourseDataTable" msprop:Generator_RowChangedName="OnlineCourseRowChanged" msprop:Generator_RowClassName="OnlineCourseRow" msprop:Generator_RowChangingName="OnlineCourseRowChanging" msprop:Generator_RowEvArgName="OnlineCourseRowChangeEvent" msprop:Generator_RowEvHandlerName="OnlineCourseRowChangeEventHandler" msprop:Generator_TablePropName="OnlineCourse" msprop:Generator_TableVarName="tableOnlineCourse" msprop:Generator_RowDeletingName="OnlineCourseRowDeleting">
713          <xs:complexType>
714            <xs:sequence>
715              <xs:element name="CourseID" msprop:Generator_UserColumnName="CourseID" msprop:Generator_ColumnPropNameInRow="CourseID" msprop:Generator_ColumnVarNameInTable="columnCourseID" msprop:Generator_ColumnPropNameInTable="CourseIDColumn" type="xs:int" />
716              <xs:element name="URL" msprop:Generator_UserColumnName="URL" msprop:Generator_ColumnPropNameInRow="URL" msprop:Generator_ColumnVarNameInTable="columnURL" msprop:Generator_ColumnPropNameInTable="URLColumn">
717                <xs:simpleType>
718                  <xs:restriction base="xs:string">
719                    <xs:maxLength value="100" />
720                  </xs:restriction>
721                </xs:simpleType>
722              </xs:element>
723            </xs:sequence>
724          </xs:complexType>
725        </xs:element>
726        <xs:element name="OnsiteCourse" msprop:Generator_UserTableName="OnsiteCourse" msprop:Generator_RowDeletedName="OnsiteCourseRowDeleted" msprop:Generator_TableClassName="OnsiteCourseDataTable" msprop:Generator_RowChangedName="OnsiteCourseRowChanged" msprop:Generator_RowClassName="OnsiteCourseRow" msprop:Generator_RowChangingName="OnsiteCourseRowChanging" msprop:Generator_RowEvArgName="OnsiteCourseRowChangeEvent" msprop:Generator_RowEvHandlerName="OnsiteCourseRowChangeEventHandler" msprop:Generator_TablePropName="OnsiteCourse" msprop:Generator_TableVarName="tableOnsiteCourse" msprop:Generator_RowDeletingName="OnsiteCourseRowDeleting">
727          <xs:complexType>
728            <xs:sequence>
729              <xs:element name="CourseID" msprop:Generator_UserColumnName="CourseID" msprop:Generator_ColumnPropNameInRow="CourseID" msprop:Generator_ColumnVarNameInTable="columnCourseID" msprop:Generator_ColumnPropNameInTable="CourseIDColumn" type="xs:int" />
730              <xs:element name="Location" msprop:Generator_UserColumnName="Location" msprop:Generator_ColumnPropNameInRow="Location" msprop:Generator_ColumnVarNameInTable="columnLocation" msprop:Generator_ColumnPropNameInTable="LocationColumn">
731                <xs:simpleType>
732                  <xs:restriction base="xs:string">
733                    <xs:maxLength value="50" />
734                  </xs:restriction>
735                </xs:simpleType>
736              </xs:element>
737              <xs:element name="Days" msprop:Generator_UserColumnName="Days" msprop:Generator_ColumnPropNameInRow="Days" msprop:Generator_ColumnVarNameInTable="columnDays" msprop:Generator_ColumnPropNameInTable="DaysColumn">
738                <xs:simpleType>
739                  <xs:restriction base="xs:string">
740                    <xs:maxLength value="50" />
741                  </xs:restriction>
742                </xs:simpleType>
743              </xs:element>
744              <xs:element name="Time" msprop:Generator_UserColumnName="Time" msprop:Generator_ColumnPropNameInRow="Time" msprop:Generator_ColumnVarNameInTable="columnTime" msprop:Generator_ColumnPropNameInTable="TimeColumn" type="xs:dateTime" />
745            </xs:sequence>
746          </xs:complexType>
747        </xs:element>
748        <xs:element name="Person" msprop:Generator_UserTableName="Person" msprop:Generator_RowDeletedName="PersonRowDeleted" msprop:Generator_TableClassName="PersonDataTable" msprop:Generator_RowChangedName="PersonRowChanged" msprop:Generator_RowClassName="PersonRow" msprop:Generator_RowChangingName="PersonRowChanging" msprop:Generator_RowEvArgName="PersonRowChangeEvent" msprop:Generator_RowEvHandlerName="PersonRowChangeEventHandler" msprop:Generator_TablePropName="Person" msprop:Generator_TableVarName="tablePerson" msprop:Generator_RowDeletingName="PersonRowDeleting">
749          <xs:complexType>
750            <xs:sequence>
751              <xs:element name="PersonID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_UserColumnName="PersonID" msprop:Generator_ColumnPropNameInRow="PersonID" msprop:Generator_ColumnVarNameInTable="columnPersonID" msprop:Generator_ColumnPropNameInTable="PersonIDColumn" type="xs:int" />
752              <xs:element name="LastName" msprop:Generator_UserColumnName="LastName" msprop:Generator_ColumnPropNameInRow="LastName" msprop:Generator_ColumnVarNameInTable="columnLastName" msprop:Generator_ColumnPropNameInTable="LastNameColumn">
753                <xs:simpleType>
754                  <xs:restriction base="xs:string">
755                    <xs:maxLength value="50" />
756                  </xs:restriction>
757                </xs:simpleType>
758              </xs:element>
759              <xs:element name="FirstName" msprop:Generator_UserColumnName="FirstName" msprop:Generator_ColumnPropNameInRow="FirstName" msprop:Generator_ColumnVarNameInTable="columnFirstName" msprop:Generator_ColumnPropNameInTable="FirstNameColumn">
760                <xs:simpleType>
761                  <xs:restriction base="xs:string">
762                    <xs:maxLength value="50" />
763                  </xs:restriction>
764                </xs:simpleType>
765              </xs:element>
766              <xs:element name="PersonCategory" msprop:Generator_UserColumnName="PersonCategory" msprop:Generator_ColumnPropNameInRow="PersonCategory" msprop:Generator_ColumnVarNameInTable="columnPersonCategory" msprop:Generator_ColumnPropNameInTable="PersonCategoryColumn" type="xs:short" />
767              <xs:element name="HireDate" msprop:Generator_UserColumnName="HireDate" msprop:Generator_ColumnPropNameInRow="HireDate" msprop:Generator_ColumnVarNameInTable="columnHireDate" msprop:Generator_ColumnPropNameInTable="HireDateColumn" type="xs:dateTime" minOccurs="0" />
768              <xs:element name="EnrollmentDate" msprop:Generator_UserColumnName="EnrollmentDate" msprop:Generator_ColumnPropNameInRow="EnrollmentDate" msprop:Generator_ColumnVarNameInTable="columnEnrollmentDate" msprop:Generator_ColumnPropNameInTable="EnrollmentDateColumn" type="xs:dateTime" minOccurs="0" />
769              <xs:element name="Picture" msprop:Generator_UserColumnName="Picture" msprop:Generator_ColumnPropNameInRow="Picture" msprop:Generator_ColumnVarNameInTable="columnPicture" msprop:Generator_ColumnPropNameInTable="PictureColumn" type="xs:base64Binary" minOccurs="0" />
770            </xs:sequence>
771          </xs:complexType>
772        </xs:element>
773        <xs:element name="GetStudentGrades" msprop:Generator_UserTableName="GetStudentGrades" msprop:Generator_RowDeletedName="GetStudentGradesRowDeleted" msprop:Generator_TableClassName="GetStudentGradesDataTable" msprop:Generator_RowChangedName="GetStudentGradesRowChanged" msprop:Generator_RowClassName="GetStudentGradesRow" msprop:Generator_RowChangingName="GetStudentGradesRowChanging" msprop:Generator_RowEvArgName="GetStudentGradesRowChangeEvent" msprop:Generator_RowEvHandlerName="GetStudentGradesRowChangeEventHandler" msprop:Generator_TablePropName="GetStudentGrades" msprop:Generator_TableVarName="tableGetStudentGrades" msprop:Generator_RowDeletingName="GetStudentGradesRowDeleting">
774          <xs:complexType>
775            <xs:sequence>
776              <xs:element name="EnrollmentID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msprop:Generator_UserColumnName="EnrollmentID" msprop:Generator_ColumnPropNameInRow="EnrollmentID" msprop:Generator_ColumnVarNameInTable="columnEnrollmentID" msprop:Generator_ColumnPropNameInTable="EnrollmentIDColumn" type="xs:int" />
777              <xs:element name="Grade" msprop:Generator_UserColumnName="Grade" msprop:Generator_ColumnPropNameInRow="Grade" msprop:Generator_ColumnVarNameInTable="columnGrade" msprop:Generator_ColumnPropNameInTable="GradeColumn" type="xs:decimal" minOccurs="0" />
778            </xs:sequence>
779          </xs:complexType>
780        </xs:element>
781        <xs:element name="InsertOfficeAssignment" msprop:Generator_UserTableName="InsertOfficeAssignment" msprop:Generator_RowDeletedName="InsertOfficeAssignmentRowDeleted" msprop:Generator_TableClassName="InsertOfficeAssignmentDataTable" msprop:Generator_RowChangedName="InsertOfficeAssignmentRowChanged" msprop:Generator_RowClassName="InsertOfficeAssignmentRow" msprop:Generator_RowChangingName="InsertOfficeAssignmentRowChanging" msprop:Generator_RowEvArgName="InsertOfficeAssignmentRowChangeEvent" msprop:Generator_RowEvHandlerName="InsertOfficeAssignmentRowChangeEventHandler" msprop:Generator_TablePropName="InsertOfficeAssignment" msprop:Generator_TableVarName="tableInsertOfficeAssignment" msprop:Generator_RowDeletingName="InsertOfficeAssignmentRowDeleting">
782          <xs:complexType>
783            <xs:sequence>
784              <xs:element name="Timestamp" msdata:ReadOnly="true" msprop:Generator_UserColumnName="Timestamp" msprop:Generator_ColumnPropNameInRow="Timestamp" msprop:Generator_ColumnVarNameInTable="columnTimestamp" msprop:Generator_ColumnPropNameInTable="TimestampColumn" type="xs:base64Binary" minOccurs="0" />
785            </xs:sequence>
786          </xs:complexType>
787        </xs:element>
788        <xs:element name="InsertPerson" msprop:Generator_UserTableName="InsertPerson" msprop:Generator_RowDeletedName="InsertPersonRowDeleted" msprop:Generator_TableClassName="InsertPersonDataTable" msprop:Generator_RowChangedName="InsertPersonRowChanged" msprop:Generator_RowClassName="InsertPersonRow" msprop:Generator_RowChangingName="InsertPersonRowChanging" msprop:Generator_RowEvArgName="InsertPersonRowChangeEvent" msprop:Generator_RowEvHandlerName="InsertPersonRowChangeEventHandler" msprop:Generator_TablePropName="InsertPerson" msprop:Generator_TableVarName="tableInsertPerson" msprop:Generator_RowDeletingName="InsertPersonRowDeleting">
789          <xs:complexType>
790            <xs:sequence>
791              <xs:element name="NewPersonID" msdata:ReadOnly="true" msprop:Generator_UserColumnName="NewPersonID" msprop:Generator_ColumnPropNameInRow="NewPersonID" msprop:Generator_ColumnVarNameInTable="columnNewPersonID" msprop:Generator_ColumnPropNameInTable="NewPersonIDColumn" type="xs:decimal" minOccurs="0" />
792            </xs:sequence>
793          </xs:complexType>
794        </xs:element>
795        <xs:element name="UpdateOfficeAssignment" msprop:Generator_UserTableName="UpdateOfficeAssignment" msprop:Generator_RowDeletedName="UpdateOfficeAssignmentRowDeleted" msprop:Generator_TableClassName="UpdateOfficeAssignmentDataTable" msprop:Generator_RowChangedName="UpdateOfficeAssignmentRowChanged" msprop:Generator_RowClassName="UpdateOfficeAssignmentRow" msprop:Generator_RowChangingName="UpdateOfficeAssignmentRowChanging" msprop:Generator_RowEvArgName="UpdateOfficeAssignmentRowChangeEvent" msprop:Generator_RowEvHandlerName="UpdateOfficeAssignmentRowChangeEventHandler" msprop:Generator_TablePropName="UpdateOfficeAssignment" msprop:Generator_TableVarName="tableUpdateOfficeAssignment" msprop:Generator_RowDeletingName="UpdateOfficeAssignmentRowDeleting">
796          <xs:complexType>
797            <xs:sequence>
798              <xs:element name="Timestamp" msdata:ReadOnly="true" msprop:Generator_UserColumnName="Timestamp" msprop:Generator_ColumnPropNameInRow="Timestamp" msprop:Generator_ColumnVarNameInTable="columnTimestamp" msprop:Generator_ColumnPropNameInTable="TimestampColumn" type="xs:base64Binary" minOccurs="0" />
799            </xs:sequence>
800          </xs:complexType>
801        </xs:element>
802        <xs:element name="CourseList" msprop:Generator_UserTableName="CourseList" msprop:Generator_RowDeletedName="CourseListRowDeleted" msprop:Generator_TableClassName="CourseListDataTable" msprop:Generator_RowChangedName="CourseListRowChanged" msprop:Generator_RowClassName="CourseListRow" msprop:Generator_RowChangingName="CourseListRowChanging" msprop:Generator_RowEvArgName="CourseListRowChangeEvent" msprop:Generator_RowEvHandlerName="CourseListRowChangeEventHandler" msprop:Generator_TablePropName="CourseList" msprop:Generator_TableVarName="tableCourseList" msprop:Generator_RowDeletingName="CourseListRowDeleting">
803          <xs:complexType>
804            <xs:sequence>
805              <xs:element name="Title" msprop:Generator_UserColumnName="Title" msprop:Generator_ColumnPropNameInRow="Title" msprop:Generator_ColumnVarNameInTable="columnTitle" msprop:Generator_ColumnPropNameInTable="TitleColumn">
806                <xs:simpleType>
807                  <xs:restriction base="xs:string">
808                    <xs:maxLength value="100" />
809                  </xs:restriction>
810                </xs:simpleType>
811              </xs:element>
812              <xs:element name="Credits" msprop:Generator_UserColumnName="Credits" msprop:Generator_ColumnPropNameInRow="Credits" msprop:Generator_ColumnVarNameInTable="columnCredits" msprop:Generator_ColumnPropNameInTable="CreditsColumn" type="xs:int" />
813              <xs:element name="DepartmentName" msprop:Generator_UserColumnName="DepartmentName" msprop:Generator_ColumnPropNameInRow="DepartmentName" msprop:Generator_ColumnVarNameInTable="columnDepartmentName" msprop:Generator_ColumnPropNameInTable="DepartmentNameColumn" minOccurs="0">
814                <xs:simpleType>
815                  <xs:restriction base="xs:string">
816                    <xs:maxLength value="50" />
817                  </xs:restriction>
818                </xs:simpleType>
819              </xs:element>
820              <xs:element name="Instructor" msdata:ReadOnly="true" msprop:Generator_UserColumnName="Instructor" msprop:Generator_ColumnPropNameInRow="Instructor" msprop:Generator_ColumnVarNameInTable="columnInstructor" msprop:Generator_ColumnPropNameInTable="InstructorColumn" minOccurs="0">
821                <xs:simpleType>
822                  <xs:restriction base="xs:string">
823                    <xs:maxLength value="101" />
824                  </xs:restriction>
825                </xs:simpleType>
826              </xs:element>
827            </xs:sequence>
828          </xs:complexType>
829        </xs:element>
830        <xs:element name="StudentList" msprop:Generator_UserTableName="StudentList" msprop:Generator_RowDeletedName="StudentListRowDeleted" msprop:Generator_TableClassName="StudentListDataTable" msprop:Generator_RowChangedName="StudentListRowChanged" msprop:Generator_RowClassName="StudentListRow" msprop:Generator_RowChangingName="StudentListRowChanging" msprop:Generator_RowEvArgName="StudentListRowChangeEvent" msprop:Generator_RowEvHandlerName="StudentListRowChangeEventHandler" msprop:Generator_TablePropName="StudentList" msprop:Generator_TableVarName="tableStudentList" msprop:Generator_RowDeletingName="StudentListRowDeleting">
831          <xs:complexType>
832            <xs:sequence>
833              <xs:element name="StudentName" msdata:ReadOnly="true" msprop:Generator_UserColumnName="StudentName" msprop:Generator_ColumnPropNameInRow="StudentName" msprop:Generator_ColumnVarNameInTable="columnStudentName" msprop:Generator_ColumnPropNameInTable="StudentNameColumn" minOccurs="0">
834                <xs:simpleType>
835                  <xs:restriction base="xs:string">
836                    <xs:maxLength value="101" />
837                  </xs:restriction>
838                </xs:simpleType>
839              </xs:element>
840            </xs:sequence>
841          </xs:complexType>
842        </xs:element>
843      </xs:choice>
844    </xs:complexType>
845    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
846      <xs:selector xpath=".//mstns:Course" />
847      <xs:field xpath="mstns:CourseID" />
848    </xs:unique>
849    <xs:unique name="CourseGrade_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
850      <xs:selector xpath=".//mstns:CourseGrade" />
851      <xs:field xpath="mstns:EnrollmentID" />
852    </xs:unique>
853    <xs:unique name="CourseInstructor_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
854      <xs:selector xpath=".//mstns:CourseInstructor" />
855      <xs:field xpath="mstns:CourseID" />
856      <xs:field xpath="mstns:PersonID" />
857    </xs:unique>
858    <xs:unique name="Department_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
859      <xs:selector xpath=".//mstns:Department" />
860      <xs:field xpath="mstns:DepartmentID" />
861    </xs:unique>
862    <xs:unique name="OfficeAssignment_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
863      <xs:selector xpath=".//mstns:OfficeAssignment" />
864      <xs:field xpath="mstns:InstructorID" />
865    </xs:unique>
866    <xs:unique name="OnlineCourse_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
867      <xs:selector xpath=".//mstns:OnlineCourse" />
868      <xs:field xpath="mstns:CourseID" />
869    </xs:unique>
870    <xs:unique name="OnsiteCourse_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
871      <xs:selector xpath=".//mstns:OnsiteCourse" />
872      <xs:field xpath="mstns:CourseID" />
873    </xs:unique>
874    <xs:unique name="Person_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
875      <xs:selector xpath=".//mstns:Person" />
876      <xs:field xpath="mstns:PersonID" />
877    </xs:unique>
878    <xs:unique name="GetStudentGrades_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
879      <xs:selector xpath=".//mstns:GetStudentGrades" />
880      <xs:field xpath="mstns:EnrollmentID" />
881    </xs:unique>
882  </xs:element>
883  <xs:annotation>
884    <xs:appinfo>
885      <msdata:Relationship name="FK_Course_Department" msdata:parent="Department" msdata:child="Course" msdata:parentkey="DepartmentID" msdata:childkey="DepartmentID" msprop:Generator_UserRelationName="FK_Course_Department" msprop:Generator_RelationVarName="relationFK_Course_Department" msprop:Generator_UserChildTable="Course" msprop:Generator_UserParentTable="Department" msprop:Generator_ParentPropName="DepartmentRow" msprop:Generator_ChildPropName="GetCourseRows" />
886      <msdata:Relationship name="FK_CourseGrade_Course" msdata:parent="Course" msdata:child="CourseGrade" msdata:parentkey="CourseID" msdata:childkey="CourseID" msprop:Generator_UserRelationName="FK_CourseGrade_Course" msprop:Generator_RelationVarName="relationFK_CourseGrade_Course" msprop:Generator_UserChildTable="CourseGrade" msprop:Generator_UserParentTable="Course" msprop:Generator_ParentPropName="CourseRow" msprop:Generator_ChildPropName="GetCourseGradeRows" />
887      <msdata:Relationship name="FK_CourseGrade_Student" msdata:parent="Person" msdata:child="CourseGrade" msdata:parentkey="PersonID" msdata:childkey="StudentID" msprop:Generator_UserRelationName="FK_CourseGrade_Student" msprop:Generator_RelationVarName="relationFK_CourseGrade_Student" msprop:Generator_UserChildTable="CourseGrade" msprop:Generator_UserParentTable="Person" msprop:Generator_ParentPropName="PersonRow" msprop:Generator_ChildPropName="GetCourseGradeRows" />
888      <msdata:Relationship name="FK_CourseInstructor_Course" msdata:parent="Course" msdata:child="CourseInstructor" msdata:parentkey="CourseID" msdata:childkey="CourseID" msprop:Generator_UserRelationName="FK_CourseInstructor_Course" msprop:Generator_RelationVarName="relationFK_CourseInstructor_Course" msprop:Generator_UserChildTable="CourseInstructor" msprop:Generator_UserParentTable="Course" msprop:Generator_ParentPropName="CourseRow" msprop:Generator_ChildPropName="GetCourseInstructorRows" />
889      <msdata:Relationship name="FK_CourseInstructor_Person" msdata:parent="Person" msdata:child="CourseInstructor" msdata:parentkey="PersonID" msdata:childkey="PersonID" msprop:Generator_UserRelationName="FK_CourseInstructor_Person" msprop:Generator_RelationVarName="relationFK_CourseInstructor_Person" msprop:Generator_UserChildTable="CourseInstructor" msprop:Generator_UserParentTable="Person" msprop:Generator_ParentPropName="PersonRow" msprop:Generator_ChildPropName="GetCourseInstructorRows" />
890      <msdata:Relationship name="FK_OfficeAssignment_Person" msdata:parent="Person" msdata:child="OfficeAssignment" msdata:parentkey="PersonID" msdata:childkey="InstructorID" msprop:Generator_UserRelationName="FK_OfficeAssignment_Person" msprop:Generator_RelationVarName="relationFK_OfficeAssignment_Person" msprop:Generator_UserChildTable="OfficeAssignment" msprop:Generator_UserParentTable="Person" msprop:Generator_ParentPropName="PersonRow" msprop:Generator_ChildPropName="GetOfficeAssignmentRows" />
891      <msdata:Relationship name="FK_OnlineCourse_Course" msdata:parent="Course" msdata:child="OnlineCourse" msdata:parentkey="CourseID" msdata:childkey="CourseID" msprop:Generator_UserRelationName="FK_OnlineCourse_Course" msprop:Generator_RelationVarName="relationFK_OnlineCourse_Course" msprop:Generator_UserChildTable="OnlineCourse" msprop:Generator_UserParentTable="Course" msprop:Generator_ParentPropName="CourseRow" msprop:Generator_ChildPropName="GetOnlineCourseRows" />
892      <msdata:Relationship name="FK_OnsiteCourse_Course" msdata:parent="Course" msdata:child="OnsiteCourse" msdata:parentkey="CourseID" msdata:childkey="CourseID" msprop:Generator_UserRelationName="FK_OnsiteCourse_Course" msprop:Generator_RelationVarName="relationFK_OnsiteCourse_Course" msprop:Generator_UserChildTable="OnsiteCourse" msprop:Generator_UserParentTable="Course" msprop:Generator_ParentPropName="CourseRow" msprop:Generator_ChildPropName="GetOnsiteCourseRows" />
893    </xs:appinfo>
894  </xs:annotation>
895</xs:schema>