Kursach/LebedenkoWorldSkillsDataSet.xsd

<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="LebedenkoWorldSkillsDataSet" targetNamespace="http://tempuri.org/LebedenkoWorldSkillsDataSet.xsd" xmlns:mstns="http://tempuri.org/LebedenkoWorldSkillsDataSet.xsd" xmlns="http://tempuri.org/LebedenkoWorldSkillsDataSet.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">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="LebedenkoWorldSkillsConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="LebedenkoWorldSkillsConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.Lebedenko_WS_Winforms.Properties.Settings.GlobalReference.Default.LebedenkoWorldSkillsConnectionString" Provider="System.Data.SqlClient" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="DataLoginTableAdapter" GeneratorDataComponentClassName="DataLoginTableAdapter" Name="DataLogin" UserDataComponentName="DataLoginTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="LebedenkoWorldSkillsConnectionString (Settings)" DbObjectName="LebedenkoWorldSkills.dbo.DataLogin" 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=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[DataLogin] ([Login], [Password]) VALUES (@Login, @Password)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Login" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Login" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Password" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Password" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT Login, Password FROM dbo.DataLogin</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Login" DataSetColumn="Login" />
              <Mapping SourceColumn="Password" DataSetColumn="Password" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ДанныеОСтудентеTableAdapter" GeneratorDataComponentClassName="ДанныеОСтудентеTableAdapter" Name="ДанныеОСтуденте" UserDataComponentName="ДанныеОСтудентеTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="LebedenkoWorldSkillsConnectionString (Settings)" DbObjectName="LebedenkoWorldSkills.dbo.ДанныеОСтуденте" 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=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[ДанныеОСтуденте] WHERE (([Код] = @Original_Код) AND ([Имя] = @Original_Имя) AND ([Фамилия] = @Original_Фамилия) AND ([Отчество] = @Original_Отчество) AND ((@IsNull_Дата_Рождения = 1 AND [Дата_Рождения] IS NULL) OR ([Дата_Рождения] = @Original_Дата_Рождения)) AND ((@IsNull_Группа = 1 AND [Группа] IS NULL) OR ([Группа] = @Original_Группа)) AND ((@IsNull_Телефон = 1 AND [Телефон] IS NULL) OR ([Телефон] = @Original_Телефон)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Код" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Код" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Имя" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Имя" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Фамилия" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Фамилия" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Отчество" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Отчество" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Дата_Рождения" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Дата_Рождения" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Original_Дата_Рождения" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Дата_Рождения" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Группа" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Группа" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Группа" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Группа" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Телефон" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Телефон" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Телефон" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Телефон" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[ДанныеОСтуденте] ([Имя], [Фамилия], [Отчество], [Дата_Рождения], [Группа], [Телефон]) VALUES (@Имя, @Фамилия, @Отчество, @Дата_Рождения, @Группа, @Телефон);
SELECT Код, Имя, Фамилия, Отчество, Дата_Рождения, Группа, Телефон FROM ДанныеОСтуденте WHERE (Код = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Имя" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Имя" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Фамилия" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Фамилия" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Отчество" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Отчество" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Дата_Рождения" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Дата_Рождения" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Группа" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Группа" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Телефон" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Телефон" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT Код, Имя, Фамилия, Отчество, Дата_Рождения, Группа, Телефон FROM dbo.ДанныеОСтуденте</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[ДанныеОСтуденте] SET [Имя] = @Имя, [Фамилия] = @Фамилия, [Отчество] = @Отчество, [Дата_Рождения] = @Дата_Рождения, [Группа] = @Группа, [Телефон] = @Телефон WHERE (([Код] = @Original_Код) AND ([Имя] = @Original_Имя) AND ([Фамилия] = @Original_Фамилия) AND ([Отчество] = @Original_Отчество) AND ((@IsNull_Дата_Рождения = 1 AND [Дата_Рождения] IS NULL) OR ([Дата_Рождения] = @Original_Дата_Рождения)) AND ((@IsNull_Группа = 1 AND [Группа] IS NULL) OR ([Группа] = @Original_Группа)) AND ((@IsNull_Телефон = 1 AND [Телефон] IS NULL) OR ([Телефон] = @Original_Телефон)));
SELECT Код, Имя, Фамилия, Отчество, Дата_Рождения, Группа, Телефон FROM ДанныеОСтуденте WHERE (Код = @Код)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Имя" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Имя" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Фамилия" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Фамилия" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Отчество" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Отчество" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Дата_Рождения" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Дата_Рождения" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Группа" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Группа" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Телефон" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Телефон" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Код" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Код" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Имя" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Имя" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Фамилия" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Фамилия" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Отчество" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Отчество" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Дата_Рождения" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Дата_Рождения" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Original_Дата_Рождения" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Дата_Рождения" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Группа" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Группа" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Группа" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Группа" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Телефон" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Телефон" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Телефон" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Телефон" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="Код" ColumnName="Код" DataSourceName="LebedenkoWorldSkills.dbo.ДанныеОСтуденте" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@Код" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="Код" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Код" DataSetColumn="Код" />
              <Mapping SourceColumn="Имя" DataSetColumn="Имя" />
              <Mapping SourceColumn="Фамилия" DataSetColumn="Фамилия" />
              <Mapping SourceColumn="Отчество" DataSetColumn="Отчество" />
              <Mapping SourceColumn="Дата_Рождения" DataSetColumn="Дата_Рождения" />
              <Mapping SourceColumn="Группа" DataSetColumn="Группа" />
              <Mapping SourceColumn="Телефон" DataSetColumn="Телефон" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ЭкзаменTableAdapter" GeneratorDataComponentClassName="ЭкзаменTableAdapter" Name="Экзамен" UserDataComponentName="ЭкзаменTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="LebedenkoWorldSkillsConnectionString (Settings)" DbObjectName="LebedenkoWorldSkills.dbo.Экзамен" 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=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[Экзамен] WHERE (([Код] = @Original_Код) AND ((@IsNull_Наименование = 1 AND [Наименование] IS NULL) OR ([Наименование] = @Original_Наименование)) AND ((@IsNull_Дата_начала = 1 AND [Дата_начала] IS NULL) OR ([Дата_начала] = @Original_Дата_начала)) AND ((@IsNull_Дата_окончания = 1 AND [Дата_окончания] IS NULL) OR ([Дата_окончания] = @Original_Дата_окончания)) AND ((@IsNull_Оценка = 1 AND [Оценка] IS NULL) OR ([Оценка] = @Original_Оценка)) AND ((@IsNull_ID_ДанныеОСтуденте = 1 AND [ID_ДанныеОСтуденте] IS NULL) OR ([ID_ДанныеОСтуденте] = @Original_ID_ДанныеОСтуденте)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Код" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Код" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Наименование" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Наименование" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Наименование" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Наименование" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Дата_начала" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Дата_начала" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Original_Дата_начала" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Дата_начала" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Дата_окончания" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Дата_окончания" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Original_Дата_окончания" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Дата_окончания" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Оценка" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Оценка" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Оценка" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Оценка" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ID_ДанныеОСтуденте" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_ДанныеОСтуденте" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID_ДанныеОСтуденте" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_ДанныеОСтуденте" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Экзамен] ([Наименование], [Дата_начала], [Дата_окончания], [Оценка], [ID_ДанныеОСтуденте]) VALUES (@Наименование, @Дата_начала, @Дата_окончания, @Оценка, @ID_ДанныеОСтуденте);
SELECT Код, Наименование, Дата_начала, Дата_окончания, Оценка, ID_ДанныеОСтуденте FROM Экзамен WHERE (Код = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Наименование" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Наименование" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Дата_начала" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Дата_начала" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Дата_окончания" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Дата_окончания" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Оценка" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Оценка" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ID_ДанныеОСтуденте" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_ДанныеОСтуденте" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT Код, Наименование, Дата_начала, Дата_окончания, Оценка, ID_ДанныеОСтуденте FROM dbo.Экзамен</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Экзамен] SET [Наименование] = @Наименование, [Дата_начала] = @Дата_начала, [Дата_окончания] = @Дата_окончания, [Оценка] = @Оценка, [ID_ДанныеОСтуденте] = @ID_ДанныеОСтуденте WHERE (([Код] = @Original_Код) AND ((@IsNull_Наименование = 1 AND [Наименование] IS NULL) OR ([Наименование] = @Original_Наименование)) AND ((@IsNull_Дата_начала = 1 AND [Дата_начала] IS NULL) OR ([Дата_начала] = @Original_Дата_начала)) AND ((@IsNull_Дата_окончания = 1 AND [Дата_окончания] IS NULL) OR ([Дата_окончания] = @Original_Дата_окончания)) AND ((@IsNull_Оценка = 1 AND [Оценка] IS NULL) OR ([Оценка] = @Original_Оценка)) AND ((@IsNull_ID_ДанныеОСтуденте = 1 AND [ID_ДанныеОСтуденте] IS NULL) OR ([ID_ДанныеОСтуденте] = @Original_ID_ДанныеОСтуденте)));
SELECT Код, Наименование, Дата_начала, Дата_окончания, Оценка, ID_ДанныеОСтуденте FROM Экзамен WHERE (Код = @Код)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Наименование" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Наименование" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Дата_начала" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Дата_начала" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Дата_окончания" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Дата_окончания" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Оценка" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Оценка" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ID_ДанныеОСтуденте" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_ДанныеОСтуденте" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Код" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Код" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Наименование" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Наименование" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Наименование" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Наименование" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Дата_начала" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Дата_начала" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Original_Дата_начала" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Дата_начала" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Дата_окончания" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Дата_окончания" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Original_Дата_окончания" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Дата_окончания" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Оценка" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Оценка" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Оценка" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Оценка" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ID_ДанныеОСтуденте" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_ДанныеОСтуденте" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID_ДанныеОСтуденте" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_ДанныеОСтуденте" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="Код" ColumnName="Код" DataSourceName="LebedenkoWorldSkills.dbo.Экзамен" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@Код" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="Код" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Код" DataSetColumn="Код" />
              <Mapping SourceColumn="Наименование" DataSetColumn="Наименование" />
              <Mapping SourceColumn="Дата_начала" DataSetColumn="Дата_начала" />
              <Mapping SourceColumn="Дата_окончания" DataSetColumn="Дата_окончания" />
              <Mapping SourceColumn="Оценка" DataSetColumn="Оценка" />
              <Mapping SourceColumn="ID_ДанныеОСтуденте" DataSetColumn="ID_ДанныеОСтуденте" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ЭкспертыTableAdapter" GeneratorDataComponentClassName="ЭкспертыTableAdapter" Name="Эксперты" UserDataComponentName="ЭкспертыTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="LebedenkoWorldSkillsConnectionString (Settings)" DbObjectName="LebedenkoWorldSkills.dbo.Эксперты" 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=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[Эксперты] WHERE (([Код] = @Original_Код) AND ((@IsNull_Имя = 1 AND [Имя] IS NULL) OR ([Имя] = @Original_Имя)) AND ((@IsNull_Фамилия = 1 AND [Фамилия] IS NULL) OR ([Фамилия] = @Original_Фамилия)) AND ((@IsNull_Роль = 1 AND [Роль] IS NULL) OR ([Роль] = @Original_Роль)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Код" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Код" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Имя" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Имя" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Имя" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Имя" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Фамилия" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Фамилия" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Фамилия" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Фамилия" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Роль" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Роль" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Роль" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Роль" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Эксперты] ([Имя], [Фамилия], [Роль]) VALUES (@Имя, @Фамилия, @Роль);
SELECT Код, Имя, Фамилия, Роль FROM Эксперты WHERE (Код = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Имя" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Имя" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Фамилия" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Фамилия" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Роль" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Роль" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT Код, Имя, Фамилия, Роль FROM dbo.Эксперты</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Эксперты] SET [Имя] = @Имя, [Фамилия] = @Фамилия, [Роль] = @Роль WHERE (([Код] = @Original_Код) AND ((@IsNull_Имя = 1 AND [Имя] IS NULL) OR ([Имя] = @Original_Имя)) AND ((@IsNull_Фамилия = 1 AND [Фамилия] IS NULL) OR ([Фамилия] = @Original_Фамилия)) AND ((@IsNull_Роль = 1 AND [Роль] IS NULL) OR ([Роль] = @Original_Роль)));
SELECT Код, Имя, Фамилия, Роль FROM Эксперты WHERE (Код = @Код)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Имя" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Имя" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Фамилия" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Фамилия" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Роль" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Роль" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Код" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Код" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Имя" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Имя" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Имя" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Имя" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Фамилия" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Фамилия" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Фамилия" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Фамилия" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Роль" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Роль" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Роль" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Роль" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="Код" ColumnName="Код" DataSourceName="LebedenkoWorldSkills.dbo.Эксперты" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@Код" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="Код" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Код" DataSetColumn="Код" />
              <Mapping SourceColumn="Имя" DataSetColumn="Имя" />
              <Mapping SourceColumn="Фамилия" DataSetColumn="Фамилия" />
              <Mapping SourceColumn="Роль" DataSetColumn="Роль" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="View_1TableAdapter" GeneratorDataComponentClassName="View_1TableAdapter" Name="View_1" UserDataComponentName="View_1TableAdapter">
            <MainSource>
              <DbSource ConnectionRef="LebedenkoWorldSkillsConnectionString (Settings)" DbObjectName="LebedenkoWorldSkills.dbo.View_1" DbObjectType="View" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ID_ДанныеОСтуденте, Имя, Фамилия, Отчество, Наименование, Дата_начала, Дата_окончания, Оценка, Группа FROM dbo.View_1</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ID_ДанныеОСтуденте" DataSetColumn="ID_ДанныеОСтуденте" />
              <Mapping SourceColumn="Имя" DataSetColumn="Имя" />
              <Mapping SourceColumn="Фамилия" DataSetColumn="Фамилия" />
              <Mapping SourceColumn="Отчество" DataSetColumn="Отчество" />
              <Mapping SourceColumn="Наименование" DataSetColumn="Наименование" />
              <Mapping SourceColumn="Дата_начала" DataSetColumn="Дата_начала" />
              <Mapping SourceColumn="Дата_окончания" DataSetColumn="Дата_окончания" />
              <Mapping SourceColumn="Оценка" DataSetColumn="Оценка" />
              <Mapping SourceColumn="Группа" DataSetColumn="Группа" />
            </Mappings>
            <Sources />
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="LebedenkoWorldSkillsDataSet" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="True" msprop:Generator_DataSetName="LebedenkoWorldSkillsDataSet" msprop:Generator_UserDSName="LebedenkoWorldSkillsDataSet">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="DataLogin" msprop:Generator_TableClassName="DataLoginDataTable" msprop:Generator_TableVarName="tableDataLogin" msprop:Generator_TablePropName="DataLogin" msprop:Generator_RowDeletingName="DataLoginRowDeleting" msprop:Generator_RowChangingName="DataLoginRowChanging" msprop:Generator_RowEvHandlerName="DataLoginRowChangeEventHandler" msprop:Generator_RowDeletedName="DataLoginRowDeleted" msprop:Generator_UserTableName="DataLogin" msprop:Generator_RowChangedName="DataLoginRowChanged" msprop:Generator_RowEvArgName="DataLoginRowChangeEvent" msprop:Generator_RowClassName="DataLoginRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Login" msprop:Generator_ColumnVarNameInTable="columnLogin" msprop:Generator_ColumnPropNameInRow="Login" msprop:Generator_ColumnPropNameInTable="LoginColumn" msprop:Generator_UserColumnName="Login" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Password" msprop:Generator_ColumnVarNameInTable="columnPassword" msprop:Generator_ColumnPropNameInRow="Password" msprop:Generator_ColumnPropNameInTable="PasswordColumn" msprop:Generator_UserColumnName="Password" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="ДанныеОСтуденте" msprop:Generator_TableClassName="ДанныеОСтудентеDataTable" msprop:Generator_TableVarName="tableДанныеОСтуденте" msprop:Generator_TablePropName="ДанныеОСтуденте" msprop:Generator_RowDeletingName="ДанныеОСтудентеRowDeleting" msprop:Generator_RowChangingName="ДанныеОСтудентеRowChanging" msprop:Generator_RowEvHandlerName="ДанныеОСтудентеRowChangeEventHandler" msprop:Generator_RowDeletedName="ДанныеОСтудентеRowDeleted" msprop:Generator_UserTableName="ДанныеОСтуденте" msprop:Generator_RowChangedName="ДанныеОСтудентеRowChanged" msprop:Generator_RowEvArgName="ДанныеОСтудентеRowChangeEvent" msprop:Generator_RowClassName="ДанныеОСтудентеRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Код" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnКод" msprop:Generator_ColumnPropNameInRow="Код" msprop:Generator_ColumnPropNameInTable="КодColumn" msprop:Generator_UserColumnName="Код" type="xs:int" />
              <xs:element name="Имя" msprop:Generator_ColumnVarNameInTable="columnИмя" msprop:Generator_ColumnPropNameInRow="Имя" msprop:Generator_ColumnPropNameInTable="ИмяColumn" msprop:Generator_UserColumnName="Имя">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Фамилия" msprop:Generator_ColumnVarNameInTable="columnФамилия" msprop:Generator_ColumnPropNameInRow="Фамилия" msprop:Generator_ColumnPropNameInTable="ФамилияColumn" msprop:Generator_UserColumnName="Фамилия">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Отчество" msprop:Generator_ColumnVarNameInTable="columnОтчество" msprop:Generator_ColumnPropNameInRow="Отчество" msprop:Generator_ColumnPropNameInTable="ОтчествоColumn" msprop:Generator_UserColumnName="Отчество">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Дата_Рождения" msprop:Generator_ColumnVarNameInTable="columnДата_Рождения" msprop:Generator_ColumnPropNameInRow="Дата_Рождения" msprop:Generator_ColumnPropNameInTable="Дата_РожденияColumn" msprop:Generator_UserColumnName="Дата_Рождения" type="xs:dateTime" minOccurs="0" />
              <xs:element name="Группа" msprop:Generator_ColumnVarNameInTable="columnГруппа" msprop:Generator_ColumnPropNameInRow="Группа" msprop:Generator_ColumnPropNameInTable="ГруппаColumn" msprop:Generator_UserColumnName="Группа" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Телефон" msprop:Generator_ColumnVarNameInTable="columnТелефон" msprop:Generator_ColumnPropNameInRow="Телефон" msprop:Generator_ColumnPropNameInTable="ТелефонColumn" msprop:Generator_UserColumnName="Телефон" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Экзамен" msprop:Generator_TableClassName="ЭкзаменDataTable" msprop:Generator_TableVarName="tableЭкзамен" msprop:Generator_TablePropName="Экзамен" msprop:Generator_RowDeletingName="ЭкзаменRowDeleting" msprop:Generator_RowChangingName="ЭкзаменRowChanging" msprop:Generator_RowEvHandlerName="ЭкзаменRowChangeEventHandler" msprop:Generator_RowDeletedName="ЭкзаменRowDeleted" msprop:Generator_UserTableName="Экзамен" msprop:Generator_RowChangedName="ЭкзаменRowChanged" msprop:Generator_RowEvArgName="ЭкзаменRowChangeEvent" msprop:Generator_RowClassName="ЭкзаменRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Код" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnКод" msprop:Generator_ColumnPropNameInRow="Код" msprop:Generator_ColumnPropNameInTable="КодColumn" msprop:Generator_UserColumnName="Код" type="xs:int" />
              <xs:element name="Наименование" msprop:Generator_ColumnVarNameInTable="columnНаименование" msprop:Generator_ColumnPropNameInRow="Наименование" msprop:Generator_ColumnPropNameInTable="НаименованиеColumn" msprop:Generator_UserColumnName="Наименование" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Дата_начала" msprop:Generator_ColumnVarNameInTable="columnДата_начала" msprop:Generator_ColumnPropNameInRow="Дата_начала" msprop:Generator_ColumnPropNameInTable="Дата_началаColumn" msprop:Generator_UserColumnName="Дата_начала" type="xs:dateTime" minOccurs="0" />
              <xs:element name="Дата_окончания" msprop:Generator_ColumnVarNameInTable="columnДата_окончания" msprop:Generator_ColumnPropNameInRow="Дата_окончания" msprop:Generator_ColumnPropNameInTable="Дата_окончанияColumn" msprop:Generator_UserColumnName="Дата_окончания" type="xs:dateTime" minOccurs="0" />
              <xs:element name="Оценка" msprop:Generator_ColumnVarNameInTable="columnОценка" msprop:Generator_ColumnPropNameInRow="Оценка" msprop:Generator_ColumnPropNameInTable="ОценкаColumn" msprop:Generator_UserColumnName="Оценка" type="xs:int" minOccurs="0" />
              <xs:element name="ID_ДанныеОСтуденте" msprop:Generator_ColumnVarNameInTable="columnID_ДанныеОСтуденте" msprop:Generator_ColumnPropNameInRow="ID_ДанныеОСтуденте" msprop:Generator_ColumnPropNameInTable="ID_ДанныеОСтудентеColumn" msprop:Generator_UserColumnName="ID_ДанныеОСтуденте" type="xs:int" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Эксперты" msprop:Generator_TableClassName="ЭкспертыDataTable" msprop:Generator_TableVarName="tableЭксперты" msprop:Generator_TablePropName="Эксперты" msprop:Generator_RowDeletingName="ЭкспертыRowDeleting" msprop:Generator_RowChangingName="ЭкспертыRowChanging" msprop:Generator_RowEvHandlerName="ЭкспертыRowChangeEventHandler" msprop:Generator_RowDeletedName="ЭкспертыRowDeleted" msprop:Generator_UserTableName="Эксперты" msprop:Generator_RowChangedName="ЭкспертыRowChanged" msprop:Generator_RowEvArgName="ЭкспертыRowChangeEvent" msprop:Generator_RowClassName="ЭкспертыRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Код" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnКод" msprop:Generator_ColumnPropNameInRow="Код" msprop:Generator_ColumnPropNameInTable="КодColumn" msprop:Generator_UserColumnName="Код" type="xs:int" />
              <xs:element name="Имя" msprop:Generator_ColumnVarNameInTable="columnИмя" msprop:Generator_ColumnPropNameInRow="Имя" msprop:Generator_ColumnPropNameInTable="ИмяColumn" msprop:Generator_UserColumnName="Имя" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Фамилия" msprop:Generator_ColumnVarNameInTable="columnФамилия" msprop:Generator_ColumnPropNameInRow="Фамилия" msprop:Generator_ColumnPropNameInTable="ФамилияColumn" msprop:Generator_UserColumnName="Фамилия" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Роль" msprop:Generator_ColumnVarNameInTable="columnРоль" msprop:Generator_ColumnPropNameInRow="Роль" msprop:Generator_ColumnPropNameInTable="РольColumn" msprop:Generator_UserColumnName="Роль" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="View_1" msprop:Generator_TableClassName="View_1DataTable" msprop:Generator_TableVarName="tableView_1" msprop:Generator_TablePropName="View_1" msprop:Generator_RowDeletingName="View_1RowDeleting" msprop:Generator_RowChangingName="View_1RowChanging" msprop:Generator_RowEvHandlerName="View_1RowChangeEventHandler" msprop:Generator_RowDeletedName="View_1RowDeleted" msprop:Generator_UserTableName="View_1" msprop:Generator_RowChangedName="View_1RowChanged" msprop:Generator_RowEvArgName="View_1RowChangeEvent" msprop:Generator_RowClassName="View_1Row">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ID_ДанныеОСтуденте" msprop:Generator_ColumnVarNameInTable="columnID_ДанныеОСтуденте" msprop:Generator_ColumnPropNameInRow="ID_ДанныеОСтуденте" msprop:Generator_ColumnPropNameInTable="ID_ДанныеОСтудентеColumn" msprop:Generator_UserColumnName="ID_ДанныеОСтуденте" type="xs:int" minOccurs="0" />
              <xs:element name="Имя" msprop:Generator_ColumnVarNameInTable="columnИмя" msprop:Generator_ColumnPropNameInRow="Имя" msprop:Generator_ColumnPropNameInTable="ИмяColumn" msprop:Generator_UserColumnName="Имя">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Фамилия" msprop:Generator_ColumnVarNameInTable="columnФамилия" msprop:Generator_ColumnPropNameInRow="Фамилия" msprop:Generator_ColumnPropNameInTable="ФамилияColumn" msprop:Generator_UserColumnName="Фамилия">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Отчество" msprop:Generator_ColumnVarNameInTable="columnОтчество" msprop:Generator_ColumnPropNameInRow="Отчество" msprop:Generator_ColumnPropNameInTable="ОтчествоColumn" msprop:Generator_UserColumnName="Отчество">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Наименование" msprop:Generator_ColumnVarNameInTable="columnНаименование" msprop:Generator_ColumnPropNameInRow="Наименование" msprop:Generator_ColumnPropNameInTable="НаименованиеColumn" msprop:Generator_UserColumnName="Наименование" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Дата_начала" msprop:Generator_ColumnVarNameInTable="columnДата_начала" msprop:Generator_ColumnPropNameInRow="Дата_начала" msprop:Generator_ColumnPropNameInTable="Дата_началаColumn" msprop:Generator_UserColumnName="Дата_начала" type="xs:dateTime" minOccurs="0" />
              <xs:element name="Дата_окончания" msprop:Generator_ColumnVarNameInTable="columnДата_окончания" msprop:Generator_ColumnPropNameInRow="Дата_окончания" msprop:Generator_ColumnPropNameInTable="Дата_окончанияColumn" msprop:Generator_UserColumnName="Дата_окончания" type="xs:dateTime" minOccurs="0" />
              <xs:element name="Оценка" msprop:Generator_ColumnVarNameInTable="columnОценка" msprop:Generator_ColumnPropNameInRow="Оценка" msprop:Generator_ColumnPropNameInTable="ОценкаColumn" msprop:Generator_UserColumnName="Оценка" type="xs:int" minOccurs="0" />
              <xs:element name="Группа" msprop:Generator_ColumnVarNameInTable="columnГруппа" msprop:Generator_ColumnPropNameInRow="Группа" msprop:Generator_ColumnPropNameInTable="ГруппаColumn" msprop:Generator_UserColumnName="Группа" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:ДанныеОСтуденте" />
      <xs:field xpath="mstns:Код" />
    </xs:unique>
    <xs:unique name="Экзамен_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Экзамен" />
      <xs:field xpath="mstns:Код" />
    </xs:unique>
    <xs:unique name="Эксперты_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Эксперты" />
      <xs:field xpath="mstns:Код" />
    </xs:unique>
  </xs:element>
  <xs:annotation>
    <xs:appinfo>
      <msdata:Relationship name="FK_Экзамен_ДанныеОСтуденте" msdata:parent="ДанныеОСтуденте" msdata:child="Экзамен" msdata:parentkey="Код" msdata:childkey="ID_ДанныеОСтуденте" msprop:Generator_UserChildTable="Экзамен" msprop:Generator_ChildPropName="GetЭкзаменRows" msprop:Generator_UserRelationName="FK_Экзамен_ДанныеОСтуденте" msprop:Generator_ParentPropName="ДанныеОСтудентеRow" msprop:Generator_RelationVarName="relationFK_Экзамен_ДанныеОСтуденте" msprop:Generator_UserParentTable="ДанныеОСтуденте" />
    </xs:appinfo>
  </xs:annotation>
</xs:schema>