<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="BoreyDataSet" targetNamespace="http://tempuri.org/BoreyDataSet.xsd" xmlns:mstns="http://tempuri.org/BoreyDataSet.xsd" xmlns="http://tempuri.org/BoreyDataSet.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 ConnectionStringObject="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Work\Borey.mdb" IsAppSettingsProperty="False" Modifier="Assembly" Name="ACCESS.C:\Work\Borey.mdb" Provider="System.Data.OleDb">
          </Connection>
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="CustomerTableAdapter" GeneratorDataComponentClassName="CustomerTableAdapter" Name="Customer" UserDataComponentName="CustomerTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ACCESS.C:\Work\Borey.mdb" DbObjectName="Customer" 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">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>DELETE FROM `Customer` WHERE ((`CustomerId` = ?) AND ((? = 1 AND `CustomerName` IS NULL) OR (`CustomerName` = ?)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_CustomerId" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="CustomerId" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_CustomerName" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="CustomerName" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_CustomerName" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="CustomerName" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>INSERT INTO `Customer` (`CustomerName`) VALUES (?)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="CustomerName" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="CustomerName" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>SELECT CustomerId, CustomerName FROM Customer</CommandText>
                    <Parameters>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>UPDATE `Customer` SET `CustomerName` = ? WHERE ((`CustomerId` = ?) AND ((? = 1 AND `CustomerName` IS NULL) OR (`CustomerName` = ?)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="CustomerName" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="CustomerName" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_CustomerId" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="CustomerId" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_CustomerName" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="CustomerName" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_CustomerName" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="CustomerName" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="CustomerId" DataSetColumn="CustomerId" />
              <Mapping SourceColumn="CustomerName" DataSetColumn="CustomerName" />
            </Mappings>
            <Sources>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="EmploeTableAdapter" GeneratorDataComponentClassName="EmploeTableAdapter" Name="Emploe" UserDataComponentName="EmploeTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ACCESS.C:\Work\Borey.mdb" DbObjectName="Emploe" 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">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>DELETE FROM `Emploe` WHERE ((`EmploeId` = ?) AND ((? = 1 AND `Emploe` IS NULL) OR (`Emploe` = ?)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_EmploeId" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="EmploeId" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Emploe" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Emploe" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Emploe" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Emploe" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>INSERT INTO `Emploe` (`Emploe`) VALUES (?)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Emploe" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Emploe" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>SELECT EmploeId, Emploe FROM Emploe</CommandText>
                    <Parameters>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>UPDATE `Emploe` SET `Emploe` = ? WHERE ((`EmploeId` = ?) AND ((? = 1 AND `Emploe` IS NULL) OR (`Emploe` = ?)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Emploe" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Emploe" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_EmploeId" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="EmploeId" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Emploe" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Emploe" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Emploe" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Emploe" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="EmploeId" DataSetColumn="EmploeId" />
              <Mapping SourceColumn="Emploe" DataSetColumn="Emploe" />
            </Mappings>
            <Sources>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="OrdersTableAdapter" GeneratorDataComponentClassName="OrdersTableAdapter" Name="Orders" UserDataComponentName="OrdersTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ACCESS.C:\Work\Borey.mdb" DbObjectName="Orders" 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">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>DELETE FROM `Orders` WHERE ((`OrdersId` = ?) AND ((? = 1 AND `CustomerId` IS NULL) OR (`CustomerId` = ?)) AND ((? = 1 AND `EmploeId` IS NULL) OR (`EmploeId` = ?)) AND ((? = 1 AND `Date` IS NULL) OR (`Date` = ?)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_OrdersId" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="OrdersId" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_CustomerId" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="CustomerId" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_CustomerId" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="CustomerId" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_EmploeId" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="EmploeId" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_EmploeId" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="EmploeId" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Date" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Date" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="Original_Date" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Date" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>INSERT INTO `Orders` (`CustomerId`, `EmploeId`, `Date`) VALUES (?, ?, ?)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="CustomerId" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="CustomerId" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="EmploeId" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="EmploeId" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="Date" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Date" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>SELECT OrdersId, CustomerId, EmploeId, [Date] FROM Orders</CommandText>
                    <Parameters>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>UPDATE `Orders` SET `CustomerId` = ?, `EmploeId` = ?, `Date` = ? WHERE ((`OrdersId` = ?) AND ((? = 1 AND `CustomerId` IS NULL) OR (`CustomerId` = ?)) AND ((? = 1 AND `EmploeId` IS NULL) OR (`EmploeId` = ?)) AND ((? = 1 AND `Date` IS NULL) OR (`Date` = ?)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="CustomerId" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="CustomerId" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="EmploeId" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="EmploeId" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="Date" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Date" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_OrdersId" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="OrdersId" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_CustomerId" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="CustomerId" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_CustomerId" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="CustomerId" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_EmploeId" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="EmploeId" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_EmploeId" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="EmploeId" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Date" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Date" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="Original_Date" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Date" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="OrdersId" DataSetColumn="OrdersId" />
              <Mapping SourceColumn="CustomerId" DataSetColumn="CustomerId" />
              <Mapping SourceColumn="EmploeId" DataSetColumn="EmploeId" />
              <Mapping SourceColumn="Date" DataSetColumn="Date" />
            </Mappings>
            <Sources>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="OrdersDetailsTableAdapter" GeneratorDataComponentClassName="OrdersDetailsTableAdapter" Name="OrdersDetails" UserDataComponentName="OrdersDetailsTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ACCESS.C:\Work\Borey.mdb" DbObjectName="OrdersDetails" 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">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>DELETE FROM `OrdersDetails` WHERE ((`OrdersDetailsId` = ?) AND ((? = 1 AND `ProductId` IS NULL) OR (`ProductId` = ?)) AND ((? = 1 AND `Price` IS NULL) OR (`Price` = ?)) AND ((? = 1 AND `Volume` IS NULL) OR (`Volume` = ?)) AND ((? = 1 AND `OrdersId` IS NULL) OR (`OrdersId` = ?)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_OrdersDetailsId" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="OrdersDetailsId" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_ProductId" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ProductId" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_ProductId" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ProductId" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Price" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Price" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="Original_Price" Precision="0" ProviderType="Currency" Scale="0" Size="0" SourceColumn="Price" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Volume" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Volume" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_Volume" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Volume" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_OrdersId" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="OrdersId" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_OrdersId" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="OrdersId" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>INSERT INTO `OrdersDetails` (`ProductId`, `Price`, `Volume`, `OrdersId`) VALUES (?, ?, ?, ?)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="ProductId" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ProductId" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="Price" Precision="0" ProviderType="Currency" Scale="0" Size="0" SourceColumn="Price" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Volume" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Volume" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="OrdersId" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="OrdersId" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>SELECT OrdersDetailsId, ProductId, Price, Volume, OrdersId FROM OrdersDetails</CommandText>
                    <Parameters>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>UPDATE `OrdersDetails` SET `ProductId` = ?, `Price` = ?, `Volume` = ?, `OrdersId` = ? WHERE ((`OrdersDetailsId` = ?) AND ((? = 1 AND `ProductId` IS NULL) OR (`ProductId` = ?)) AND ((? = 1 AND `Price` IS NULL) OR (`Price` = ?)) AND ((? = 1 AND `Volume` IS NULL) OR (`Volume` = ?)) AND ((? = 1 AND `OrdersId` IS NULL) OR (`OrdersId` = ?)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="ProductId" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ProductId" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="Price" Precision="0" ProviderType="Currency" Scale="0" Size="0" SourceColumn="Price" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Volume" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Volume" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="OrdersId" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="OrdersId" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_OrdersDetailsId" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="OrdersDetailsId" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_ProductId" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ProductId" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_ProductId" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ProductId" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Price" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Price" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="Original_Price" Precision="0" ProviderType="Currency" Scale="0" Size="0" SourceColumn="Price" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Volume" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Volume" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_Volume" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Volume" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_OrdersId" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="OrdersId" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_OrdersId" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="OrdersId" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="OrdersDetailsId" DataSetColumn="OrdersDetailsId" />
              <Mapping SourceColumn="ProductId" DataSetColumn="ProductId" />
              <Mapping SourceColumn="Price" DataSetColumn="Price" />
              <Mapping SourceColumn="Volume" DataSetColumn="Volume" />
              <Mapping SourceColumn="OrdersId" DataSetColumn="OrdersId" />
            </Mappings>
            <Sources>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ProductTableAdapter" GeneratorDataComponentClassName="ProductTableAdapter" Name="Product" UserDataComponentName="ProductTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ACCESS.C:\Work\Borey.mdb" DbObjectName="Product" 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">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>DELETE FROM `Product` WHERE ((`ProductId` = ?) AND ((? = 1 AND `ProductName` IS NULL) OR (`ProductName` = ?)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_ProductId" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ProductId" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_ProductName" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ProductName" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_ProductName" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="ProductName" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>INSERT INTO `Product` (`ProductName`) VALUES (?)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="ProductName" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="ProductName" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>SELECT ProductId, ProductName FROM Product</CommandText>
                    <Parameters>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>UPDATE `Product` SET `ProductName` = ? WHERE ((`ProductId` = ?) AND ((? = 1 AND `ProductName` IS NULL) OR (`ProductName` = ?)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="ProductName" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="ProductName" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_ProductId" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ProductId" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_ProductName" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ProductName" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_ProductName" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="ProductName" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ProductId" DataSetColumn="ProductId" />
              <Mapping SourceColumn="ProductName" DataSetColumn="ProductName" />
            </Mappings>
            <Sources>
            </Sources>
          </TableAdapter>
        </Tables>
        <Sources>
        </Sources>
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="BoreyDataSet" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:Generator_UserDSName="BoreyDataSet" msprop:Generator_DataSetName="BoreyDataSet">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="Customer" msprop:Generator_UserTableName="Customer" msprop:Generator_RowDeletedName="CustomerRowDeleted" msprop:Generator_TableClassName="CustomerDataTable" msprop:Generator_RowChangedName="CustomerRowChanged" msprop:Generator_RowClassName="CustomerRow" msprop:Generator_RowChangingName="CustomerRowChanging" msprop:Generator_RowEvArgName="CustomerRowChangeEvent" msprop:Generator_RowEvHandlerName="CustomerRowChangeEventHandler" msprop:Generator_TablePropName="Customer" msprop:Generator_TableVarName="tableCustomer" msprop:Generator_RowDeletingName="CustomerRowDeleting">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="CustomerId" msdata:AutoIncrement="true" msprop:Generator_UserColumnName="CustomerId" msprop:Generator_ColumnPropNameInRow="CustomerId" msprop:Generator_ColumnVarNameInTable="columnCustomerId" msprop:Generator_ColumnPropNameInTable="CustomerIdColumn" type="xs:int" />
              <xs:element name="CustomerName" msprop:Generator_UserColumnName="CustomerName" msprop:Generator_ColumnPropNameInRow="CustomerName" msprop:Generator_ColumnVarNameInTable="columnCustomerName" msprop:Generator_ColumnPropNameInTable="CustomerNameColumn" 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="Emploe" msprop:Generator_UserTableName="Emploe" msprop:Generator_RowDeletedName="EmploeRowDeleted" msprop:Generator_TableClassName="EmploeDataTable" msprop:Generator_RowChangedName="EmploeRowChanged" msprop:Generator_RowClassName="EmploeRow" msprop:Generator_RowChangingName="EmploeRowChanging" msprop:Generator_RowEvArgName="EmploeRowChangeEvent" msprop:Generator_RowEvHandlerName="EmploeRowChangeEventHandler" msprop:Generator_TablePropName="Emploe" msprop:Generator_TableVarName="tableEmploe" msprop:Generator_RowDeletingName="EmploeRowDeleting">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="EmploeId" msdata:AutoIncrement="true" msprop:Generator_UserColumnName="EmploeId" msprop:Generator_ColumnPropNameInRow="EmploeId" msprop:Generator_ColumnVarNameInTable="columnEmploeId" msprop:Generator_ColumnPropNameInTable="EmploeIdColumn" type="xs:int" />
              <xs:element name="Emploe" msprop:Generator_UserColumnName="Emploe" msprop:Generator_ColumnPropNameInRow="Emploe" msprop:Generator_ColumnVarNameInTable="columnEmploe" msprop:Generator_ColumnPropNameInTable="EmploeColumn" 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="Orders" msprop:Generator_UserTableName="Orders" msprop:Generator_RowDeletedName="OrdersRowDeleted" msprop:Generator_TableClassName="OrdersDataTable" msprop:Generator_RowChangedName="OrdersRowChanged" msprop:Generator_RowClassName="OrdersRow" msprop:Generator_RowChangingName="OrdersRowChanging" msprop:Generator_RowEvArgName="OrdersRowChangeEvent" msprop:Generator_RowEvHandlerName="OrdersRowChangeEventHandler" msprop:Generator_TablePropName="Orders" msprop:Generator_TableVarName="tableOrders" msprop:Generator_RowDeletingName="OrdersRowDeleting">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="OrdersId" msdata:AutoIncrement="true" msprop:Generator_UserColumnName="OrdersId" msprop:Generator_ColumnPropNameInRow="OrdersId" msprop:Generator_ColumnVarNameInTable="columnOrdersId" msprop:Generator_ColumnPropNameInTable="OrdersIdColumn" type="xs:int" />
              <xs:element name="CustomerId" msprop:Generator_UserColumnName="CustomerId" msprop:Generator_ColumnPropNameInRow="CustomerId" msprop:Generator_ColumnVarNameInTable="columnCustomerId" msprop:Generator_ColumnPropNameInTable="CustomerIdColumn" type="xs:int" minOccurs="0" />
              <xs:element name="EmploeId" msprop:Generator_UserColumnName="EmploeId" msprop:Generator_ColumnPropNameInRow="EmploeId" msprop:Generator_ColumnVarNameInTable="columnEmploeId" msprop:Generator_ColumnPropNameInTable="EmploeIdColumn" type="xs:int" minOccurs="0" />
              <xs:element name="Date" msprop:Generator_UserColumnName="Date" msprop:Generator_ColumnPropNameInRow="Date" msprop:Generator_ColumnVarNameInTable="columnDate" msprop:Generator_ColumnPropNameInTable="DateColumn" type="xs:dateTime" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="OrdersDetails" msprop:Generator_UserTableName="OrdersDetails" msprop:Generator_RowDeletedName="OrdersDetailsRowDeleted" msprop:Generator_TableClassName="OrdersDetailsDataTable" msprop:Generator_RowChangedName="OrdersDetailsRowChanged" msprop:Generator_RowClassName="OrdersDetailsRow" msprop:Generator_RowChangingName="OrdersDetailsRowChanging" msprop:Generator_RowEvArgName="OrdersDetailsRowChangeEvent" msprop:Generator_RowEvHandlerName="OrdersDetailsRowChangeEventHandler" msprop:Generator_TablePropName="OrdersDetails" msprop:Generator_TableVarName="tableOrdersDetails" msprop:Generator_RowDeletingName="OrdersDetailsRowDeleting">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="OrdersDetailsId" msdata:AutoIncrement="true" msprop:Generator_UserColumnName="OrdersDetailsId" msprop:Generator_ColumnPropNameInRow="OrdersDetailsId" msprop:Generator_ColumnVarNameInTable="columnOrdersDetailsId" msprop:Generator_ColumnPropNameInTable="OrdersDetailsIdColumn" type="xs:int" />
              <xs:element name="ProductId" msprop:Generator_UserColumnName="ProductId" msprop:Generator_ColumnPropNameInRow="ProductId" msprop:Generator_ColumnVarNameInTable="columnProductId" msprop:Generator_ColumnPropNameInTable="ProductIdColumn" type="xs:int" minOccurs="0" />
              <xs:element name="Price" msprop:Generator_UserColumnName="Price" msprop:Generator_ColumnPropNameInRow="Price" msprop:Generator_ColumnVarNameInTable="columnPrice" msprop:Generator_ColumnPropNameInTable="PriceColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="Volume" msprop:Generator_UserColumnName="Volume" msprop:Generator_ColumnPropNameInRow="Volume" msprop:Generator_ColumnVarNameInTable="columnVolume" msprop:Generator_ColumnPropNameInTable="VolumeColumn" type="xs:int" minOccurs="0" />
              <xs:element name="OrdersId" msprop:Generator_UserColumnName="OrdersId" msprop:Generator_ColumnPropNameInRow="OrdersId" msprop:Generator_ColumnVarNameInTable="columnOrdersId" msprop:Generator_ColumnPropNameInTable="OrdersIdColumn" type="xs:int" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Product" msprop:Generator_UserTableName="Product" msprop:Generator_RowDeletedName="ProductRowDeleted" msprop:Generator_TableClassName="ProductDataTable" msprop:Generator_RowChangedName="ProductRowChanged" msprop:Generator_RowClassName="ProductRow" msprop:Generator_RowChangingName="ProductRowChanging" msprop:Generator_RowEvArgName="ProductRowChangeEvent" msprop:Generator_RowEvHandlerName="ProductRowChangeEventHandler" msprop:Generator_TablePropName="Product" msprop:Generator_TableVarName="tableProduct" msprop:Generator_RowDeletingName="ProductRowDeleting">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ProductId" msdata:AutoIncrement="true" msprop:Generator_UserColumnName="ProductId" msprop:Generator_ColumnPropNameInRow="ProductId" msprop:Generator_ColumnVarNameInTable="columnProductId" msprop:Generator_ColumnPropNameInTable="ProductIdColumn" type="xs:int" />
              <xs:element name="ProductName" msprop:Generator_UserColumnName="ProductName" msprop:Generator_ColumnPropNameInRow="ProductName" msprop:Generator_ColumnVarNameInTable="columnProductName" msprop:Generator_ColumnPropNameInTable="ProductNameColumn" 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:Customer" />
      <xs:field xpath="mstns:CustomerId" />
    </xs:unique>
    <xs:unique name="Emploe_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Emploe" />
      <xs:field xpath="mstns:EmploeId" />
    </xs:unique>
    <xs:unique name="Orders_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Orders" />
      <xs:field xpath="mstns:OrdersId" />
    </xs:unique>
    <xs:unique name="OrdersDetails_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:OrdersDetails" />
      <xs:field xpath="mstns:OrdersDetailsId" />
    </xs:unique>
    <xs:unique name="Product_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Product" />
      <xs:field xpath="mstns:ProductId" />
    </xs:unique>
  </xs:element>
  <xs:annotation>
    <xs:appinfo>
      <msdata:Relationship name="CustomerOrders" msdata:parent="Customer" msdata:child="Orders" msdata:parentkey="CustomerId" msdata:childkey="CustomerId" msprop:Generator_UserRelationName="CustomerOrders" msprop:Generator_RelationVarName="relationCustomerOrders" msprop:Generator_UserChildTable="Orders" msprop:Generator_UserParentTable="Customer" msprop:Generator_ParentPropName="CustomerRow" msprop:Generator_ChildPropName="GetOrdersRows" />
      <msdata:Relationship name="EmploeOrders" msdata:parent="Emploe" msdata:child="Orders" msdata:parentkey="EmploeId" msdata:childkey="EmploeId" msprop:Generator_UserRelationName="EmploeOrders" msprop:Generator_RelationVarName="relationEmploeOrders" msprop:Generator_UserChildTable="Orders" msprop:Generator_UserParentTable="Emploe" msprop:Generator_ParentPropName="EmploeRow" msprop:Generator_ChildPropName="GetOrdersRows" />
      <msdata:Relationship name="OrdersOrdersDetails" msdata:parent="Orders" msdata:child="OrdersDetails" msdata:parentkey="OrdersId" msdata:childkey="OrdersId" msprop:Generator_UserRelationName="OrdersOrdersDetails" msprop:Generator_RelationVarName="relationOrdersOrdersDetails" msprop:Generator_UserChildTable="OrdersDetails" msprop:Generator_UserParentTable="Orders" msprop:Generator_ParentPropName="OrdersRow" msprop:Generator_ChildPropName="GetOrdersDetailsRows" />
      <msdata:Relationship name="ProductOrdersDetails" msdata:parent="Product" msdata:child="OrdersDetails" msdata:parentkey="ProductId" msdata:childkey="ProductId" msprop:Generator_UserRelationName="ProductOrdersDetails" msprop:Generator_RelationVarName="relationProductOrdersDetails" msprop:Generator_UserChildTable="OrdersDetails" msprop:Generator_UserParentTable="Product" msprop:Generator_ParentPropName="ProductRow" msprop:Generator_ChildPropName="GetOrdersDetailsRows" />
    </xs:appinfo>
  </xs:annotation>
</xs:schema>