<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="libraryDataSet" targetNamespace="http://tempuri.org/libraryDataSet.xsd" xmlns:mstns="http://tempuri.org/libraryDataSet.xsd" xmlns="http://tempuri.org/libraryDataSet.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="libraryConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="libraryConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.WindowsFormsApplication5.Properties.Settings.GlobalReference.Default.libraryConnectionString" Provider="System.Data.SqlClient" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="bookTableAdapter" GeneratorDataComponentClassName="bookTableAdapter" Name="book" UserDataComponentName="bookTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="libraryConnectionString (Settings)" DbObjectName="dbo.book" 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 [book] WHERE (([isbn] = @Original_isbn) AND ((@IsNull_number = 1 AND [number] IS NULL) OR ([number] = @Original_number)) AND ((@IsNull_exist = 1 AND [exist] IS NULL) OR ([exist] = @Original_exist)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_isbn" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="isbn" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_number" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="number" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_number" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="number" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_exist" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="exist" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_exist" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="exist" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [book] ([isbn], [name], [publisher], [author], [translator], [number], [exist]) VALUES (@isbn, @name, @publisher, @author, @translator, @number, @exist);
SELECT isbn, name, publisher, author, translator, number, exist FROM book WHERE (isbn = @isbn)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@isbn" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="isbn" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@name" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@publisher" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="publisher" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@author" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="author" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@translator" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="translator" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@number" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="number" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@exist" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="exist" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT     isbn, name, publisher, author, translator, number, exist
FROM         book</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [book] SET [isbn] = @isbn, [name] = @name, [publisher] = @publisher, [author] = @author, [translator] = @translator, [number] = @number, [exist] = @exist WHERE (([isbn] = @Original_isbn) AND ((@IsNull_number = 1 AND [number] IS NULL) OR ([number] = @Original_number)) AND ((@IsNull_exist = 1 AND [exist] IS NULL) OR ([exist] = @Original_exist)));
SELECT isbn, name, publisher, author, translator, number, exist FROM book WHERE (isbn = @isbn)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@isbn" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="isbn" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@name" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@publisher" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="publisher" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@author" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="author" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@translator" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="translator" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@number" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="number" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@exist" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="exist" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_isbn" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="isbn" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_number" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="number" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_number" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="number" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_exist" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="exist" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_exist" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="exist" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="isbn" DataSetColumn="isbn" />
              <Mapping SourceColumn="name" DataSetColumn="name" />
              <Mapping SourceColumn="publisher" DataSetColumn="publisher" />
              <Mapping SourceColumn="author" DataSetColumn="author" />
              <Mapping SourceColumn="translator" DataSetColumn="translator" />
              <Mapping SourceColumn="number" DataSetColumn="number" />
              <Mapping SourceColumn="exist" DataSetColumn="exist" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="cardTableAdapter" GeneratorDataComponentClassName="cardTableAdapter" Name="card" UserDataComponentName="cardTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="libraryConnectionString (Settings)" DbObjectName="dbo.card" 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 [card] WHERE (([id] = @Original_id) AND ([isbn] = @Original_isbn) AND ([code] = @Original_code) AND ([barrowdate] = @Original_barrowdate) AND ((@IsNull_barrowback = 1 AND [barrowback] IS NULL) OR ([barrowback] = @Original_barrowback)) AND ((@IsNull_get = 1 AND [get] IS NULL) OR ([get] = @Original_get)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_id" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_isbn" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="isbn" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_code" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="code" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_barrowdate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="barrowdate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_barrowback" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="barrowback" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_barrowback" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="barrowback" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_get" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="get" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_get" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="get" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [card] ([id], [isbn], [code], [barrowdate], [barrowback], [get]) VALUES (@id, @isbn, @code, @barrowdate, @barrowback, @get);
SELECT id, isbn, code, barrowdate, barrowback, get FROM card WHERE (id = @id)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@id" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@isbn" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="isbn" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@code" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="code" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@barrowdate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="barrowdate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@barrowback" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="barrowback" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@get" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="get" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT     id, isbn, code, barrowdate, barrowback, get
FROM         card</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [card] SET [id] = @id, [isbn] = @isbn, [code] = @code, [barrowdate] = @barrowdate, [barrowback] = @barrowback, [get] = @get WHERE (([id] = @Original_id) AND ([isbn] = @Original_isbn) AND ([code] = @Original_code) AND ([barrowdate] = @Original_barrowdate) AND ((@IsNull_barrowback = 1 AND [barrowback] IS NULL) OR ([barrowback] = @Original_barrowback)) AND ((@IsNull_get = 1 AND [get] IS NULL) OR ([get] = @Original_get)));
SELECT id, isbn, code, barrowdate, barrowback, get FROM card WHERE (id = @id)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@id" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@isbn" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="isbn" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@code" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="code" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@barrowdate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="barrowdate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@barrowback" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="barrowback" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@get" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="get" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_id" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_isbn" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="isbn" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_code" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="code" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_barrowdate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="barrowdate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_barrowback" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="barrowback" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_barrowback" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="barrowback" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_get" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="get" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_get" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="get" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="id" DataSetColumn="id" />
              <Mapping SourceColumn="isbn" DataSetColumn="isbn" />
              <Mapping SourceColumn="code" DataSetColumn="code" />
              <Mapping SourceColumn="barrowdate" DataSetColumn="barrowdate" />
              <Mapping SourceColumn="barrowback" DataSetColumn="barrowback" />
              <Mapping SourceColumn="get" DataSetColumn="get" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="memberTableAdapter" GeneratorDataComponentClassName="memberTableAdapter" Name="member" UserDataComponentName="memberTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="libraryConnectionString (Settings)" DbObjectName="dbo.member" 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 [member] WHERE (([code] = @Original_code) AND ((@IsNull_tel = 1 AND [tel] IS NULL) OR ([tel] = @Original_tel)) AND ((@IsNull_membershipdate = 1 AND [membershipdate] IS NULL) OR ([membershipdate] = @Original_membershipdate)) AND ((@IsNull_membershipexpire = 1 AND [membershipexpire] IS NULL) OR ([membershipexpire] = @Original_membershipexpire)) AND ((@IsNull_barrownumber = 1 AND [barrownumber] IS NULL) OR ([barrownumber] = @Original_barrownumber)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_code" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="code" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_tel" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="tel" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_tel" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="tel" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_membershipdate" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="membershipdate" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_membershipdate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="membershipdate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_membershipexpire" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="membershipexpire" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_membershipexpire" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="membershipexpire" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_barrownumber" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="barrownumber" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_barrownumber" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="barrownumber" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [member] ([code], [fname], [lname], [address], [tel], [membershipdate], [membershipexpire], [roll], [barrownumber]) VALUES (@code, @fname, @lname, @address, @tel, @membershipdate, @membershipexpire, @roll, @barrownumber);
SELECT code, fname, lname, address, tel, membershipdate, membershipexpire, roll, barrownumber FROM member WHERE (code = @code)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@code" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="code" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@fname" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="fname" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@lname" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="lname" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@address" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="address" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@tel" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="tel" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@membershipdate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="membershipdate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@membershipexpire" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="membershipexpire" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@roll" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="roll" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@barrownumber" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="barrownumber" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT     code, fname, lname, address, tel, membershipdate, membershipexpire, roll, barrownumber
FROM         member</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [member] SET [code] = @code, [fname] = @fname, [lname] = @lname, [address] = @address, [tel] = @tel, [membershipdate] = @membershipdate, [membershipexpire] = @membershipexpire, [roll] = @roll, [barrownumber] = @barrownumber WHERE (([code] = @Original_code) AND ((@IsNull_tel = 1 AND [tel] IS NULL) OR ([tel] = @Original_tel)) AND ((@IsNull_membershipdate = 1 AND [membershipdate] IS NULL) OR ([membershipdate] = @Original_membershipdate)) AND ((@IsNull_membershipexpire = 1 AND [membershipexpire] IS NULL) OR ([membershipexpire] = @Original_membershipexpire)) AND ((@IsNull_barrownumber = 1 AND [barrownumber] IS NULL) OR ([barrownumber] = @Original_barrownumber)));
SELECT code, fname, lname, address, tel, membershipdate, membershipexpire, roll, barrownumber FROM member WHERE (code = @code)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@code" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="code" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@fname" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="fname" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@lname" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="lname" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@address" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="address" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@tel" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="tel" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@membershipdate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="membershipdate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@membershipexpire" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="membershipexpire" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@roll" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="roll" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@barrownumber" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="barrownumber" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_code" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="code" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_tel" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="tel" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_tel" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="tel" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_membershipdate" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="membershipdate" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_membershipdate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="membershipdate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_membershipexpire" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="membershipexpire" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_membershipexpire" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="membershipexpire" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_barrownumber" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="barrownumber" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_barrownumber" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="barrownumber" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="code" DataSetColumn="code" />
              <Mapping SourceColumn="fname" DataSetColumn="fname" />
              <Mapping SourceColumn="lname" DataSetColumn="lname" />
              <Mapping SourceColumn="membershipdate" DataSetColumn="membershipdate" />
              <Mapping SourceColumn="membershipexpire" DataSetColumn="membershipexpire" />
              <Mapping SourceColumn="roll" DataSetColumn="roll" />
              <Mapping SourceColumn="address" DataSetColumn="address" />
              <Mapping SourceColumn="tel" DataSetColumn="tel" />
              <Mapping SourceColumn="barrownumber" DataSetColumn="barrownumber" />
            </Mappings>
            <Sources />
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="libraryDataSet" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:Generator_UserDSName="libraryDataSet" msprop:Generator_DataSetName="libraryDataSet" msprop:EnableTableAdapterManager="True">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="book" msprop:Generator_UserTableName="book" msprop:Generator_RowDeletedName="bookRowDeleted" msprop:Generator_RowChangedName="bookRowChanged" msprop:Generator_RowClassName="bookRow" msprop:Generator_RowChangingName="bookRowChanging" msprop:Generator_RowEvArgName="bookRowChangeEvent" msprop:Generator_RowEvHandlerName="bookRowChangeEventHandler" msprop:Generator_TableClassName="bookDataTable" msprop:Generator_TableVarName="tablebook" msprop:Generator_RowDeletingName="bookRowDeleting" msprop:Generator_TablePropName="book">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="isbn" msprop:Generator_UserColumnName="isbn" msprop:Generator_ColumnVarNameInTable="columnisbn" msprop:Generator_ColumnPropNameInRow="isbn" msprop:Generator_ColumnPropNameInTable="isbnColumn" type="xs:decimal" />
              <xs:element name="name" msprop:Generator_UserColumnName="name" msprop:Generator_ColumnVarNameInTable="columnname" msprop:Generator_ColumnPropNameInRow="name" msprop:Generator_ColumnPropNameInTable="nameColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="publisher" msprop:Generator_UserColumnName="publisher" msprop:Generator_ColumnVarNameInTable="columnpublisher" msprop:Generator_ColumnPropNameInRow="publisher" msprop:Generator_ColumnPropNameInTable="publisherColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="author" msprop:Generator_UserColumnName="author" msprop:Generator_ColumnVarNameInTable="columnauthor" msprop:Generator_ColumnPropNameInRow="author" msprop:Generator_ColumnPropNameInTable="authorColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="translator" msprop:Generator_UserColumnName="translator" msprop:Generator_ColumnVarNameInTable="columntranslator" msprop:Generator_ColumnPropNameInRow="translator" msprop:Generator_ColumnPropNameInTable="translatorColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="number" msprop:Generator_UserColumnName="number" msprop:Generator_ColumnPropNameInRow="number" msprop:Generator_ColumnVarNameInTable="columnnumber" msprop:Generator_ColumnPropNameInTable="numberColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="exist" msprop:Generator_UserColumnName="exist" msprop:Generator_ColumnPropNameInRow="exist" msprop:Generator_ColumnVarNameInTable="columnexist" msprop:Generator_ColumnPropNameInTable="existColumn" type="xs:decimal" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="card" msprop:Generator_UserTableName="card" msprop:Generator_RowDeletedName="cardRowDeleted" msprop:Generator_RowChangedName="cardRowChanged" msprop:Generator_RowClassName="cardRow" msprop:Generator_RowChangingName="cardRowChanging" msprop:Generator_RowEvArgName="cardRowChangeEvent" msprop:Generator_RowEvHandlerName="cardRowChangeEventHandler" msprop:Generator_TableClassName="cardDataTable" msprop:Generator_TableVarName="tablecard" msprop:Generator_RowDeletingName="cardRowDeleting" msprop:Generator_TablePropName="card">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="id" msprop:Generator_UserColumnName="id" msprop:Generator_ColumnVarNameInTable="columnid" msprop:Generator_ColumnPropNameInRow="id" msprop:Generator_ColumnPropNameInTable="idColumn" type="xs:decimal" />
              <xs:element name="isbn" msprop:Generator_UserColumnName="isbn" msprop:Generator_ColumnVarNameInTable="columnisbn" msprop:Generator_ColumnPropNameInRow="isbn" msprop:Generator_ColumnPropNameInTable="isbnColumn" type="xs:decimal" />
              <xs:element name="code" msprop:Generator_UserColumnName="code" msprop:Generator_ColumnVarNameInTable="columncode" msprop:Generator_ColumnPropNameInRow="code" msprop:Generator_ColumnPropNameInTable="codeColumn" type="xs:decimal" />
              <xs:element name="barrowdate" msprop:Generator_UserColumnName="barrowdate" msprop:Generator_ColumnVarNameInTable="columnbarrowdate" msprop:Generator_ColumnPropNameInRow="barrowdate" msprop:Generator_ColumnPropNameInTable="barrowdateColumn" type="xs:dateTime" />
              <xs:element name="barrowback" msprop:Generator_UserColumnName="barrowback" msprop:Generator_ColumnPropNameInRow="barrowback" msprop:Generator_ColumnVarNameInTable="columnbarrowback" msprop:Generator_ColumnPropNameInTable="barrowbackColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="get" msprop:Generator_UserColumnName="get" msprop:Generator_ColumnPropNameInRow="get" msprop:Generator_ColumnVarNameInTable="columnget" msprop:Generator_ColumnPropNameInTable="getColumn" type="xs:boolean" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="member" msprop:Generator_UserTableName="member" msprop:Generator_RowDeletedName="memberRowDeleted" msprop:Generator_RowChangedName="memberRowChanged" msprop:Generator_RowClassName="memberRow" msprop:Generator_RowChangingName="memberRowChanging" msprop:Generator_RowEvArgName="memberRowChangeEvent" msprop:Generator_RowEvHandlerName="memberRowChangeEventHandler" msprop:Generator_TableClassName="memberDataTable" msprop:Generator_TableVarName="tablemember" msprop:Generator_RowDeletingName="memberRowDeleting" msprop:Generator_TablePropName="member">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="code" msprop:Generator_UserColumnName="code" msprop:Generator_ColumnVarNameInTable="columncode" msprop:Generator_ColumnPropNameInRow="code" msprop:Generator_ColumnPropNameInTable="codeColumn" type="xs:decimal" />
              <xs:element name="fname" msprop:Generator_UserColumnName="fname" msprop:Generator_ColumnVarNameInTable="columnfname" msprop:Generator_ColumnPropNameInRow="fname" msprop:Generator_ColumnPropNameInTable="fnameColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="lname" msprop:Generator_UserColumnName="lname" msprop:Generator_ColumnVarNameInTable="columnlname" msprop:Generator_ColumnPropNameInRow="lname" msprop:Generator_ColumnPropNameInTable="lnameColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="membershipdate" msprop:Generator_UserColumnName="membershipdate" msprop:Generator_ColumnVarNameInTable="columnmembershipdate" msprop:Generator_ColumnPropNameInRow="membershipdate" msprop:Generator_ColumnPropNameInTable="membershipdateColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="membershipexpire" msprop:Generator_UserColumnName="membershipexpire" msprop:Generator_ColumnVarNameInTable="columnmembershipexpire" msprop:Generator_ColumnPropNameInRow="membershipexpire" msprop:Generator_ColumnPropNameInTable="membershipexpireColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="roll" msprop:Generator_UserColumnName="roll" msprop:Generator_ColumnVarNameInTable="columnroll" msprop:Generator_ColumnPropNameInRow="roll" msprop:Generator_ColumnPropNameInTable="rollColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="address" msprop:Generator_UserColumnName="address" msprop:Generator_ColumnPropNameInRow="address" msprop:Generator_ColumnVarNameInTable="columnaddress" msprop:Generator_ColumnPropNameInTable="addressColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="tel" msprop:Generator_UserColumnName="tel" msprop:Generator_ColumnPropNameInRow="tel" msprop:Generator_ColumnVarNameInTable="columntel" msprop:Generator_ColumnPropNameInTable="telColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="barrownumber" msprop:Generator_UserColumnName="barrownumber" msprop:Generator_ColumnPropNameInRow="barrownumber" msprop:Generator_ColumnVarNameInTable="columnbarrownumber" msprop:Generator_ColumnPropNameInTable="barrownumberColumn" type="xs:decimal" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:book" />
      <xs:field xpath="mstns:isbn" />
    </xs:unique>
    <xs:unique name="card_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:card" />
      <xs:field xpath="mstns:id" />
    </xs:unique>
    <xs:unique name="member_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:member" />
      <xs:field xpath="mstns:code" />
    </xs:unique>
  </xs:element>
  <xs:annotation>
    <xs:appinfo>
      <msdata:Relationship name="FK_card_book_isbn" msdata:parent="book" msdata:child="card" msdata:parentkey="isbn" msdata:childkey="isbn" msprop:Generator_UserRelationName="FK_card_book_isbn" msprop:Generator_RelationVarName="relationFK_card_book_isbn" msprop:Generator_UserChildTable="card" msprop:Generator_UserParentTable="book" msprop:Generator_ParentPropName="bookRow" msprop:Generator_ChildPropName="GetcardRows" />
      <msdata:Relationship name="FK_card_member_code" msdata:parent="member" msdata:child="card" msdata:parentkey="code" msdata:childkey="code" msprop:Generator_UserRelationName="FK_card_member_code" msprop:Generator_RelationVarName="relationFK_card_member_code" msprop:Generator_UserChildTable="card" msprop:Generator_UserParentTable="member" msprop:Generator_ParentPropName="memberRow" msprop:Generator_ChildPropName="GetcardRows" />
    </xs:appinfo>
  </xs:annotation>
</xs:schema>