<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="DSLIB" targetNamespace="http://tempuri.org/DSLIB.xsd" xmlns:mstns="http://tempuri.org/DSLIB.xsd" xmlns="http://tempuri.org/DSLIB.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="LibdbConnectionString" ConnectionStringObject="" IsAppSettingsProperty="True" Modifier="Assembly" Name="LibdbConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.Library.Properties.Settings.GlobalReference.Default.LibdbConnectionString" Provider="System.Data.SqlClient">
          </Connection>
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="bookTableAdapter" GeneratorDataComponentClassName="bookTableAdapter" Name="book" UserDataComponentName="bookTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="LibdbConnectionString (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 [dbo].[book] WHERE (([bid] = @Original_bid) AND ((@IsNull_catid_fk = 1 AND [catid_fk] IS NULL) OR ([catid_fk] = @Original_catid_fk)) AND ((@IsNull_pid_fk = 1 AND [pid_fk] IS NULL) OR ([pid_fk] = @Original_pid_fk)) AND ((@IsNull_bname = 1 AND [bname] IS NULL) OR ([bname] = @Original_bname)) AND ((@IsNull_bauthor = 1 AND [bauthor] IS NULL) OR ([bauthor] = @Original_bauthor)) AND ((@IsNull_byear = 1 AND [byear] IS NULL) OR ([byear] = @Original_byear)) AND ((@IsNull_blangisfarsi = 1 AND [blangisfarsi] IS NULL) OR ([blangisfarsi] = @Original_blangisfarsi)) AND ((@IsNull_btranslator = 1 AND [btranslator] IS NULL) OR ([btranslator] = @Original_btranslator)) AND ((@IsNull_bisbn = 1 AND [bisbn] IS NULL) OR ([bisbn] = @Original_bisbn)) AND ((@IsNull_bcount = 1 AND [bcount] IS NULL) OR ([bcount] = @Original_bcount)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_bid" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="bid" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_catid_fk" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="catid_fk" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_catid_fk" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="catid_fk" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_pid_fk" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="pid_fk" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_pid_fk" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="pid_fk" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_bname" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="bname" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_bname" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="bname" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_bauthor" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="bauthor" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_bauthor" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="bauthor" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_byear" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="byear" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_byear" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="byear" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_blangisfarsi" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="blangisfarsi" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_blangisfarsi" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="blangisfarsi" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_btranslator" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="btranslator" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_btranslator" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="btranslator" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_bisbn" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="bisbn" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_bisbn" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="bisbn" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_bcount" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="bcount" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_bcount" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="bcount" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>INSERT INTO [dbo].[book] ([bid], [catid_fk], [pid_fk], [bname], [bauthor], [byear], [blangisfarsi], [btranslator], [bisbn], [bcount]) VALUES (@bid, @catid_fk, @pid_fk, @bname, @bauthor, @byear, @blangisfarsi, @btranslator, @bisbn, @bcount);
SELECT bid, catid_fk, pid_fk, bname, bauthor, byear, blangisfarsi, btranslator, bisbn, bcount FROM book WHERE (bid = @bid)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@bid" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="bid" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@catid_fk" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="catid_fk" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@pid_fk" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="pid_fk" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@bname" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="bname" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@bauthor" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="bauthor" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@byear" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="byear" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@blangisfarsi" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="blangisfarsi" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@btranslator" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="btranslator" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@bisbn" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="bisbn" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@bcount" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="bcount" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>SELECT bid, catid_fk, pid_fk, bname, bauthor, byear, blangisfarsi, btranslator, bisbn, bcount FROM dbo.book</CommandText>
                    <Parameters>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>UPDATE [dbo].[book] SET [bid] = @bid, [catid_fk] = @catid_fk, [pid_fk] = @pid_fk, [bname] = @bname, [bauthor] = @bauthor, [byear] = @byear, [blangisfarsi] = @blangisfarsi, [btranslator] = @btranslator, [bisbn] = @bisbn, [bcount] = @bcount WHERE (([bid] = @Original_bid) AND ((@IsNull_catid_fk = 1 AND [catid_fk] IS NULL) OR ([catid_fk] = @Original_catid_fk)) AND ((@IsNull_pid_fk = 1 AND [pid_fk] IS NULL) OR ([pid_fk] = @Original_pid_fk)) AND ((@IsNull_bname = 1 AND [bname] IS NULL) OR ([bname] = @Original_bname)) AND ((@IsNull_bauthor = 1 AND [bauthor] IS NULL) OR ([bauthor] = @Original_bauthor)) AND ((@IsNull_byear = 1 AND [byear] IS NULL) OR ([byear] = @Original_byear)) AND ((@IsNull_blangisfarsi = 1 AND [blangisfarsi] IS NULL) OR ([blangisfarsi] = @Original_blangisfarsi)) AND ((@IsNull_btranslator = 1 AND [btranslator] IS NULL) OR ([btranslator] = @Original_btranslator)) AND ((@IsNull_bisbn = 1 AND [bisbn] IS NULL) OR ([bisbn] = @Original_bisbn)) AND ((@IsNull_bcount = 1 AND [bcount] IS NULL) OR ([bcount] = @Original_bcount)));
SELECT bid, catid_fk, pid_fk, bname, bauthor, byear, blangisfarsi, btranslator, bisbn, bcount FROM book WHERE (bid = @bid)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@bid" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="bid" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@catid_fk" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="catid_fk" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@pid_fk" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="pid_fk" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@bname" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="bname" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@bauthor" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="bauthor" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@byear" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="byear" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@blangisfarsi" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="blangisfarsi" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@btranslator" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="btranslator" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@bisbn" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="bisbn" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@bcount" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="bcount" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_bid" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="bid" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_catid_fk" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="catid_fk" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_catid_fk" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="catid_fk" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_pid_fk" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="pid_fk" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_pid_fk" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="pid_fk" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_bname" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="bname" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_bname" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="bname" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_bauthor" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="bauthor" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_bauthor" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="bauthor" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_byear" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="byear" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_byear" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="byear" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_blangisfarsi" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="blangisfarsi" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_blangisfarsi" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="blangisfarsi" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_btranslator" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="btranslator" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_btranslator" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="btranslator" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_bisbn" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="bisbn" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_bisbn" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="bisbn" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_bcount" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="bcount" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_bcount" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="bcount" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="bid" DataSetColumn="bid" />
              <Mapping SourceColumn="catid_fk" DataSetColumn="catid_fk" />
              <Mapping SourceColumn="pid_fk" DataSetColumn="pid_fk" />
              <Mapping SourceColumn="bname" DataSetColumn="bname" />
              <Mapping SourceColumn="bauthor" DataSetColumn="bauthor" />
              <Mapping SourceColumn="byear" DataSetColumn="byear" />
              <Mapping SourceColumn="blangisfarsi" DataSetColumn="blangisfarsi" />
              <Mapping SourceColumn="btranslator" DataSetColumn="btranslator" />
              <Mapping SourceColumn="bisbn" DataSetColumn="bisbn" />
              <Mapping SourceColumn="bcount" DataSetColumn="bcount" />
            </Mappings>
            <Sources>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="BorrowTableAdapter" GeneratorDataComponentClassName="BorrowTableAdapter" Name="Borrow" UserDataComponentName="BorrowTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="LibdbConnectionString (Settings)" DbObjectName="dbo.Borrow" 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 [dbo].[Borrow] WHERE (([brid] = @Original_brid) AND ((@IsNull_mid_fk = 1 AND [mid_fk] IS NULL) OR ([mid_fk] = @Original_mid_fk)) AND ((@IsNull_bid_fk = 1 AND [bid_fk] IS NULL) OR ([bid_fk] = @Original_bid_fk)) AND ((@IsNull_uid_fk = 1 AND [uid_fk] IS NULL) OR ([uid_fk] = @Original_uid_fk)) AND ([brdate] = @Original_brdate) AND ((@IsNull_brreturneddate = 1 AND [brreturneddate] IS NULL) OR ([brreturneddate] = @Original_brreturneddate)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_brid" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="brid" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_mid_fk" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="mid_fk" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_mid_fk" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="mid_fk" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_bid_fk" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="bid_fk" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_bid_fk" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="bid_fk" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_uid_fk" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="uid_fk" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_uid_fk" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="uid_fk" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_brdate" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="brdate" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_brreturneddate" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="brreturneddate" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_brreturneddate" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="brreturneddate" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>INSERT INTO [dbo].[Borrow] ([mid_fk], [bid_fk], [uid_fk], [brdate], [brreturneddate]) VALUES (@mid_fk, @bid_fk, @uid_fk, @brdate, @brreturneddate);
SELECT brid, mid_fk, bid_fk, uid_fk, brdate, brreturneddate FROM Borrow WHERE (brid = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@mid_fk" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="mid_fk" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@bid_fk" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="bid_fk" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@uid_fk" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="uid_fk" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@brdate" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="brdate" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@brreturneddate" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="brreturneddate" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>SELECT brid, mid_fk, bid_fk, uid_fk, brdate, brreturneddate FROM dbo.Borrow</CommandText>
                    <Parameters>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>UPDATE [dbo].[Borrow] SET [mid_fk] = @mid_fk, [bid_fk] = @bid_fk, [uid_fk] = @uid_fk, [brdate] = @brdate, [brreturneddate] = @brreturneddate WHERE (([brid] = @Original_brid) AND ((@IsNull_mid_fk = 1 AND [mid_fk] IS NULL) OR ([mid_fk] = @Original_mid_fk)) AND ((@IsNull_bid_fk = 1 AND [bid_fk] IS NULL) OR ([bid_fk] = @Original_bid_fk)) AND ((@IsNull_uid_fk = 1 AND [uid_fk] IS NULL) OR ([uid_fk] = @Original_uid_fk)) AND ([brdate] = @Original_brdate) AND ((@IsNull_brreturneddate = 1 AND [brreturneddate] IS NULL) OR ([brreturneddate] = @Original_brreturneddate)));
SELECT brid, mid_fk, bid_fk, uid_fk, brdate, brreturneddate FROM Borrow WHERE (brid = @brid)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@mid_fk" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="mid_fk" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@bid_fk" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="bid_fk" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@uid_fk" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="uid_fk" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@brdate" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="brdate" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@brreturneddate" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="brreturneddate" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_brid" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="brid" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_mid_fk" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="mid_fk" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_mid_fk" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="mid_fk" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_bid_fk" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="bid_fk" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_bid_fk" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="bid_fk" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_uid_fk" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="uid_fk" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_uid_fk" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="uid_fk" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_brdate" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="brdate" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_brreturneddate" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="brreturneddate" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_brreturneddate" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="brreturneddate" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="brid" ColumnName="brid" DataSourceName="[C:\LIBRARY 2 10 1386\LIBRARY\LIBDB.MDF].dbo.Borrow" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@brid" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="brid" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="brid" DataSetColumn="brid" />
              <Mapping SourceColumn="mid_fk" DataSetColumn="mid_fk" />
              <Mapping SourceColumn="bid_fk" DataSetColumn="bid_fk" />
              <Mapping SourceColumn="uid_fk" DataSetColumn="uid_fk" />
              <Mapping SourceColumn="brdate" DataSetColumn="brdate" />
              <Mapping SourceColumn="brreturneddate" DataSetColumn="brreturneddate" />
            </Mappings>
            <Sources>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="CategoryTableAdapter" GeneratorDataComponentClassName="CategoryTableAdapter" Name="Category" UserDataComponentName="CategoryTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="LibdbConnectionString (Settings)" DbObjectName="dbo.Category" 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 [dbo].[Category] WHERE (([catid] = @Original_catid) AND ((@IsNull_catname = 1 AND [catname] IS NULL) OR ([catname] = @Original_catname)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_catid" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="catid" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_catname" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="catname" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_catname" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="catname" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>INSERT INTO [dbo].[Category] ([catname]) VALUES (@catname);
SELECT catid, catname FROM Category WHERE (catid = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@catname" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="catname" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>SELECT catid, catname FROM dbo.Category</CommandText>
                    <Parameters>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>UPDATE [dbo].[Category] SET [catname] = @catname WHERE (([catid] = @Original_catid) AND ((@IsNull_catname = 1 AND [catname] IS NULL) OR ([catname] = @Original_catname)));
SELECT catid, catname FROM Category WHERE (catid = @catid)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@catname" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="catname" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_catid" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="catid" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_catname" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="catname" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_catname" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="catname" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="catid" ColumnName="catid" DataSourceName="[C:\LIBRARY 2 10 1386\LIBRARY\LIBDB.MDF].dbo.Category" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@catid" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="catid" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="catid" DataSetColumn="catid" />
              <Mapping SourceColumn="catname" DataSetColumn="catname" />
            </Mappings>
            <Sources>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="MemberTableAdapter" GeneratorDataComponentClassName="MemberTableAdapter" Name="Member" UserDataComponentName="MemberTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="LibdbConnectionString (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 [dbo].[Member] WHERE (([mid] = @Original_mid) AND ((@IsNull_mname = 1 AND [mname] IS NULL) OR ([mname] = @Original_mname)) AND ((@IsNull_mfamily = 1 AND [mfamily] IS NULL) OR ([mfamily] = @Original_mfamily)) AND ((@IsNull_mtell = 1 AND [mtell] IS NULL) OR ([mtell] = @Original_mtell)) AND ((@IsNull_maddress = 1 AND [maddress] IS NULL) OR ([maddress] = @Original_maddress)) AND ((@IsNull_mdegree = 1 AND [mdegree] IS NULL) OR ([mdegree] = @Original_mdegree)) AND ((@IsNull_mbirthyear = 1 AND [mbirthyear] IS NULL) OR ([mbirthyear] = @Original_mbirthyear)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_mid" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="mid" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_mname" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="mname" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_mname" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="mname" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_mfamily" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="mfamily" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_mfamily" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="mfamily" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_mtell" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="mtell" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_mtell" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="mtell" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_maddress" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="maddress" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_maddress" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="maddress" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_mdegree" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="mdegree" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_mdegree" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="mdegree" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_mbirthyear" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="mbirthyear" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_mbirthyear" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="mbirthyear" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>INSERT INTO [dbo].[Member] ([mname], [mfamily], [mtell], [maddress], [mpicture], [mdegree], [mbirthyear]) VALUES (@mname, @mfamily, @mtell, @maddress, @mpicture, @mdegree, @mbirthyear);
SELECT mid, mname, mfamily, mtell, maddress, mpicture, mdegree, mbirthyear FROM Member WHERE (mid = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@mname" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="mname" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@mfamily" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="mfamily" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@mtell" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="mtell" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@maddress" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="maddress" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Binary" Direction="Input" ParameterName="@mpicture" Precision="0" ProviderType="Image" Scale="0" Size="0" SourceColumn="mpicture" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@mdegree" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="mdegree" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@mbirthyear" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="mbirthyear" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>SELECT mid, mname, mfamily, mtell, maddress, mpicture, mdegree, mbirthyear FROM dbo.Member</CommandText>
                    <Parameters>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>UPDATE [dbo].[Member] SET [mname] = @mname, [mfamily] = @mfamily, [mtell] = @mtell, [maddress] = @maddress, [mpicture] = @mpicture, [mdegree] = @mdegree, [mbirthyear] = @mbirthyear WHERE (([mid] = @Original_mid) AND ((@IsNull_mname = 1 AND [mname] IS NULL) OR ([mname] = @Original_mname)) AND ((@IsNull_mfamily = 1 AND [mfamily] IS NULL) OR ([mfamily] = @Original_mfamily)) AND ((@IsNull_mtell = 1 AND [mtell] IS NULL) OR ([mtell] = @Original_mtell)) AND ((@IsNull_maddress = 1 AND [maddress] IS NULL) OR ([maddress] = @Original_maddress)) AND ((@IsNull_mdegree = 1 AND [mdegree] IS NULL) OR ([mdegree] = @Original_mdegree)) AND ((@IsNull_mbirthyear = 1 AND [mbirthyear] IS NULL) OR ([mbirthyear] = @Original_mbirthyear)));
SELECT mid, mname, mfamily, mtell, maddress, mpicture, mdegree, mbirthyear FROM Member WHERE (mid = @mid)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@mname" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="mname" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@mfamily" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="mfamily" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@mtell" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="mtell" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@maddress" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="maddress" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Binary" Direction="Input" ParameterName="@mpicture" Precision="0" ProviderType="Image" Scale="0" Size="0" SourceColumn="mpicture" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@mdegree" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="mdegree" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@mbirthyear" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="mbirthyear" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_mid" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="mid" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_mname" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="mname" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_mname" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="mname" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_mfamily" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="mfamily" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_mfamily" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="mfamily" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_mtell" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="mtell" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_mtell" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="mtell" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_maddress" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="maddress" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_maddress" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="maddress" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_mdegree" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="mdegree" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_mdegree" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="mdegree" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_mbirthyear" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="mbirthyear" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_mbirthyear" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="mbirthyear" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="mid" ColumnName="mid" DataSourceName="[C:\LIBRARY 2 10 1386\LIBRARY\LIBDB.MDF].dbo.Member" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@mid" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="mid" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="mid" DataSetColumn="mid" />
              <Mapping SourceColumn="mname" DataSetColumn="mname" />
              <Mapping SourceColumn="mfamily" DataSetColumn="mfamily" />
              <Mapping SourceColumn="mtell" DataSetColumn="mtell" />
              <Mapping SourceColumn="maddress" DataSetColumn="maddress" />
              <Mapping SourceColumn="mpicture" DataSetColumn="mpicture" />
              <Mapping SourceColumn="mdegree" DataSetColumn="mdegree" />
              <Mapping SourceColumn="mbirthyear" DataSetColumn="mbirthyear" />
            </Mappings>
            <Sources>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="publisherTableAdapter" GeneratorDataComponentClassName="publisherTableAdapter" Name="publisher" UserDataComponentName="publisherTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="LibdbConnectionString (Settings)" DbObjectName="dbo.publisher" 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 [dbo].[publisher] WHERE (([pid] = @Original_pid) AND ((@IsNull_pname = 1 AND [pname] IS NULL) OR ([pname] = @Original_pname)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_pid" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="pid" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_pname" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="pname" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_pname" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="pname" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>INSERT INTO [dbo].[publisher] ([pname]) VALUES (@pname);
SELECT pid, pname FROM publisher WHERE (pid = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@pname" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="pname" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>SELECT pid, pname FROM dbo.publisher</CommandText>
                    <Parameters>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>UPDATE [dbo].[publisher] SET [pname] = @pname WHERE (([pid] = @Original_pid) AND ((@IsNull_pname = 1 AND [pname] IS NULL) OR ([pname] = @Original_pname)));
SELECT pid, pname FROM publisher WHERE (pid = @pid)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@pname" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="pname" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_pid" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="pid" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_pname" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="pname" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_pname" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="pname" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="pid" ColumnName="pid" DataSourceName="[C:\LIBRARY 2 10 1386\LIBRARY\LIBDB.MDF].dbo.publisher" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@pid" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="pid" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="pid" DataSetColumn="pid" />
              <Mapping SourceColumn="pname" DataSetColumn="pname" />
            </Mappings>
            <Sources>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="usersTableAdapter" GeneratorDataComponentClassName="usersTableAdapter" Name="users" UserDataComponentName="usersTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="LibdbConnectionString (Settings)" DbObjectName="dbo.users" 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 [dbo].[users] WHERE (([uid] = @Original_uid) AND ((@IsNull_uusername = 1 AND [uusername] IS NULL) OR ([uusername] = @Original_uusername)) AND ((@IsNull_upassword = 1 AND [upassword] IS NULL) OR ([upassword] = @Original_upassword)) AND ((@IsNull_uname = 1 AND [uname] IS NULL) OR ([uname] = @Original_uname)) AND ((@IsNull_ufamily = 1 AND [ufamily] IS NULL) OR ([ufamily] = @Original_ufamily)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_uid" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="uid" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_uusername" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="uusername" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_uusername" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="uusername" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_upassword" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="upassword" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_upassword" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="upassword" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_uname" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="uname" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_uname" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="uname" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ufamily" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ufamily" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ufamily" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ufamily" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>INSERT INTO [dbo].[users] ([uusername], [upassword], [uname], [ufamily]) VALUES (@uusername, @upassword, @uname, @ufamily);
SELECT uid, uusername, upassword, uname, ufamily FROM users WHERE (uid = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@uusername" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="uusername" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@upassword" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="upassword" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@uname" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="uname" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ufamily" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ufamily" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>SELECT uid, uusername, upassword, uname, ufamily FROM dbo.users</CommandText>
                    <Parameters>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>UPDATE [dbo].[users] SET [uusername] = @uusername, [upassword] = @upassword, [uname] = @uname, [ufamily] = @ufamily WHERE (([uid] = @Original_uid) AND ((@IsNull_uusername = 1 AND [uusername] IS NULL) OR ([uusername] = @Original_uusername)) AND ((@IsNull_upassword = 1 AND [upassword] IS NULL) OR ([upassword] = @Original_upassword)) AND ((@IsNull_uname = 1 AND [uname] IS NULL) OR ([uname] = @Original_uname)) AND ((@IsNull_ufamily = 1 AND [ufamily] IS NULL) OR ([ufamily] = @Original_ufamily)));
SELECT uid, uusername, upassword, uname, ufamily FROM users WHERE (uid = @uid)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@uusername" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="uusername" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@upassword" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="upassword" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@uname" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="uname" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ufamily" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ufamily" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_uid" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="uid" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_uusername" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="uusername" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_uusername" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="uusername" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_upassword" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="upassword" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_upassword" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="upassword" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_uname" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="uname" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_uname" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="uname" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ufamily" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ufamily" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ufamily" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ufamily" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="uid" ColumnName="uid" DataSourceName="[C:\LIBRARY 2 10 1386\LIBRARY\LIBDB.MDF].dbo.users" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@uid" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="uid" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="uid" DataSetColumn="uid" />
              <Mapping SourceColumn="uusername" DataSetColumn="uusername" />
              <Mapping SourceColumn="upassword" DataSetColumn="upassword" />
              <Mapping SourceColumn="uname" DataSetColumn="uname" />
              <Mapping SourceColumn="ufamily" DataSetColumn="ufamily" />
            </Mappings>
            <Sources>
            </Sources>
          </TableAdapter>
        </Tables>
        <Sources>
        </Sources>
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="DSLIB" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:Generator_UserDSName="DSLIB" msprop:Generator_DataSetName="DSLIB">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="book" msprop:Generator_UserTableName="book" msprop:Generator_RowDeletedName="bookRowDeleted" msprop:Generator_TableClassName="bookDataTable" msprop:Generator_RowChangedName="bookRowChanged" msprop:Generator_RowClassName="bookRow" msprop:Generator_RowChangingName="bookRowChanging" msprop:Generator_RowEvArgName="bookRowChangeEvent" msprop:Generator_RowEvHandlerName="bookRowChangeEventHandler" msprop:Generator_TablePropName="book" msprop:Generator_TableVarName="tablebook" msprop:Generator_RowDeletingName="bookRowDeleting">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="bid" msprop:Generator_UserColumnName="bid" msprop:Generator_ColumnPropNameInRow="bid" msprop:Generator_ColumnVarNameInTable="columnbid" msprop:Generator_ColumnPropNameInTable="bidColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="catid_fk" msprop:Generator_UserColumnName="catid_fk" msprop:Generator_ColumnPropNameInRow="catid_fk" msprop:Generator_ColumnVarNameInTable="columncatid_fk" msprop:Generator_ColumnPropNameInTable="catid_fkColumn" type="xs:int" minOccurs="0" />
              <xs:element name="pid_fk" msprop:Generator_UserColumnName="pid_fk" msprop:Generator_ColumnPropNameInRow="pid_fk" msprop:Generator_ColumnVarNameInTable="columnpid_fk" msprop:Generator_ColumnPropNameInTable="pid_fkColumn" type="xs:int" minOccurs="0" />
              <xs:element name="bname" msprop:Generator_UserColumnName="bname" msprop:Generator_ColumnPropNameInRow="bname" msprop:Generator_ColumnVarNameInTable="columnbname" msprop:Generator_ColumnPropNameInTable="bnameColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="bauthor" msprop:Generator_UserColumnName="bauthor" msprop:Generator_ColumnPropNameInRow="bauthor" msprop:Generator_ColumnVarNameInTable="columnbauthor" msprop:Generator_ColumnPropNameInTable="bauthorColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="byear" msprop:Generator_UserColumnName="byear" msprop:Generator_ColumnPropNameInRow="byear" msprop:Generator_ColumnVarNameInTable="columnbyear" msprop:Generator_ColumnPropNameInTable="byearColumn" type="xs:int" minOccurs="0" />
              <xs:element name="blangisfarsi" msprop:Generator_UserColumnName="blangisfarsi" msprop:Generator_ColumnPropNameInRow="blangisfarsi" msprop:Generator_ColumnVarNameInTable="columnblangisfarsi" msprop:Generator_ColumnPropNameInTable="blangisfarsiColumn" type="xs:boolean" minOccurs="0" />
              <xs:element name="btranslator" msprop:Generator_UserColumnName="btranslator" msprop:Generator_ColumnPropNameInRow="btranslator" msprop:Generator_ColumnVarNameInTable="columnbtranslator" msprop:Generator_ColumnPropNameInTable="btranslatorColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="bisbn" msprop:Generator_UserColumnName="bisbn" msprop:Generator_ColumnPropNameInRow="bisbn" msprop:Generator_ColumnVarNameInTable="columnbisbn" msprop:Generator_ColumnPropNameInTable="bisbnColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="bcount" msprop:Generator_UserColumnName="bcount" msprop:Generator_ColumnPropNameInRow="bcount" msprop:Generator_ColumnVarNameInTable="columnbcount" msprop:Generator_ColumnPropNameInTable="bcountColumn" 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="Borrow" msprop:Generator_UserTableName="Borrow" msprop:Generator_RowDeletedName="BorrowRowDeleted" msprop:Generator_TableClassName="BorrowDataTable" msprop:Generator_RowChangedName="BorrowRowChanged" msprop:Generator_RowClassName="BorrowRow" msprop:Generator_RowChangingName="BorrowRowChanging" msprop:Generator_RowEvArgName="BorrowRowChangeEvent" msprop:Generator_RowEvHandlerName="BorrowRowChangeEventHandler" msprop:Generator_TablePropName="Borrow" msprop:Generator_TableVarName="tableBorrow" msprop:Generator_RowDeletingName="BorrowRowDeleting">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="brid" msdata:ReadOnly="true" msdata:AutoIncrement="true" msprop:Generator_UserColumnName="brid" msprop:Generator_ColumnPropNameInRow="brid" msprop:Generator_ColumnVarNameInTable="columnbrid" msprop:Generator_ColumnPropNameInTable="bridColumn" type="xs:int" />
              <xs:element name="mid_fk" msprop:Generator_UserColumnName="mid_fk" msprop:Generator_ColumnPropNameInRow="mid_fk" msprop:Generator_ColumnVarNameInTable="columnmid_fk" msprop:Generator_ColumnPropNameInTable="mid_fkColumn" type="xs:int" minOccurs="0" />
              <xs:element name="bid_fk" msprop:Generator_UserColumnName="bid_fk" msprop:Generator_ColumnPropNameInRow="bid_fk" msprop:Generator_ColumnVarNameInTable="columnbid_fk" msprop:Generator_ColumnPropNameInTable="bid_fkColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="uid_fk" msprop:Generator_UserColumnName="uid_fk" msprop:Generator_ColumnPropNameInRow="uid_fk" msprop:Generator_ColumnVarNameInTable="columnuid_fk" msprop:Generator_ColumnPropNameInTable="uid_fkColumn" type="xs:int" minOccurs="0" />
              <xs:element name="brdate" msprop:Generator_UserColumnName="brdate" msprop:Generator_ColumnPropNameInRow="brdate" msprop:Generator_ColumnVarNameInTable="columnbrdate" msprop:Generator_ColumnPropNameInTable="brdateColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="brreturneddate" msprop:Generator_UserColumnName="brreturneddate" msprop:Generator_ColumnPropNameInRow="brreturneddate" msprop:Generator_ColumnVarNameInTable="columnbrreturneddate" msprop:Generator_ColumnPropNameInTable="brreturneddateColumn" 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="Category" msprop:Generator_UserTableName="Category" msprop:Generator_RowDeletedName="CategoryRowDeleted" msprop:Generator_TableClassName="CategoryDataTable" msprop:Generator_RowChangedName="CategoryRowChanged" msprop:Generator_RowClassName="CategoryRow" msprop:Generator_RowChangingName="CategoryRowChanging" msprop:Generator_RowEvArgName="CategoryRowChangeEvent" msprop:Generator_RowEvHandlerName="CategoryRowChangeEventHandler" msprop:Generator_TablePropName="Category" msprop:Generator_TableVarName="tableCategory" msprop:Generator_RowDeletingName="CategoryRowDeleting">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="catid" msdata:ReadOnly="true" msdata:AutoIncrement="true" msprop:Generator_UserColumnName="catid" msprop:Generator_ColumnPropNameInRow="catid" msprop:Generator_ColumnVarNameInTable="columncatid" msprop:Generator_ColumnPropNameInTable="catidColumn" type="xs:int" />
              <xs:element name="catname" msprop:Generator_UserColumnName="catname" msprop:Generator_ColumnPropNameInRow="catname" msprop:Generator_ColumnVarNameInTable="columncatname" msprop:Generator_ColumnPropNameInTable="catnameColumn" 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="Member" msprop:Generator_UserTableName="Member" msprop:Generator_RowDeletedName="MemberRowDeleted" msprop:Generator_TableClassName="MemberDataTable" msprop:Generator_RowChangedName="MemberRowChanged" msprop:Generator_RowClassName="MemberRow" msprop:Generator_RowChangingName="MemberRowChanging" msprop:Generator_RowEvArgName="MemberRowChangeEvent" msprop:Generator_RowEvHandlerName="MemberRowChangeEventHandler" msprop:Generator_TablePropName="Member" msprop:Generator_TableVarName="tableMember" msprop:Generator_RowDeletingName="MemberRowDeleting">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="mid" msdata:ReadOnly="true" msdata:AutoIncrement="true" msprop:Generator_UserColumnName="mid" msprop:Generator_ColumnPropNameInRow="mid" msprop:Generator_ColumnVarNameInTable="columnmid" msprop:Generator_ColumnPropNameInTable="midColumn" type="xs:int" />
              <xs:element name="mname" msprop:Generator_UserColumnName="mname" msprop:Generator_ColumnPropNameInRow="mname" msprop:Generator_ColumnVarNameInTable="columnmname" msprop:Generator_ColumnPropNameInTable="mnameColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="mfamily" msprop:Generator_UserColumnName="mfamily" msprop:Generator_ColumnPropNameInRow="mfamily" msprop:Generator_ColumnVarNameInTable="columnmfamily" msprop:Generator_ColumnPropNameInTable="mfamilyColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="mtell" msprop:Generator_UserColumnName="mtell" msprop:Generator_ColumnPropNameInRow="mtell" msprop:Generator_ColumnVarNameInTable="columnmtell" msprop:Generator_ColumnPropNameInTable="mtellColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="maddress" msprop:Generator_UserColumnName="maddress" msprop:Generator_ColumnPropNameInRow="maddress" msprop:Generator_ColumnVarNameInTable="columnmaddress" msprop:Generator_ColumnPropNameInTable="maddressColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="500" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="mpicture" msprop:Generator_UserColumnName="mpicture" msprop:Generator_ColumnPropNameInRow="mpicture" msprop:Generator_ColumnVarNameInTable="columnmpicture" msprop:Generator_ColumnPropNameInTable="mpictureColumn" type="xs:base64Binary" minOccurs="0" />
              <xs:element name="mdegree" msprop:Generator_UserColumnName="mdegree" msprop:Generator_ColumnPropNameInRow="mdegree" msprop:Generator_ColumnVarNameInTable="columnmdegree" msprop:Generator_ColumnPropNameInTable="mdegreeColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="mbirthyear" msprop:Generator_UserColumnName="mbirthyear" msprop:Generator_ColumnPropNameInRow="mbirthyear" msprop:Generator_ColumnVarNameInTable="columnmbirthyear" msprop:Generator_ColumnPropNameInTable="mbirthyearColumn" type="xs:int" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="publisher" msprop:Generator_UserTableName="publisher" msprop:Generator_RowDeletedName="publisherRowDeleted" msprop:Generator_TableClassName="publisherDataTable" msprop:Generator_RowChangedName="publisherRowChanged" msprop:Generator_RowClassName="publisherRow" msprop:Generator_RowChangingName="publisherRowChanging" msprop:Generator_RowEvArgName="publisherRowChangeEvent" msprop:Generator_RowEvHandlerName="publisherRowChangeEventHandler" msprop:Generator_TablePropName="publisher" msprop:Generator_TableVarName="tablepublisher" msprop:Generator_RowDeletingName="publisherRowDeleting">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="pid" msdata:ReadOnly="true" msdata:AutoIncrement="true" msprop:Generator_UserColumnName="pid" msprop:Generator_ColumnPropNameInRow="pid" msprop:Generator_ColumnVarNameInTable="columnpid" msprop:Generator_ColumnPropNameInTable="pidColumn" type="xs:int" />
              <xs:element name="pname" msprop:Generator_UserColumnName="pname" msprop:Generator_ColumnPropNameInRow="pname" msprop:Generator_ColumnVarNameInTable="columnpname" msprop:Generator_ColumnPropNameInTable="pnameColumn" 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="users" msprop:Generator_UserTableName="users" msprop:Generator_RowDeletedName="usersRowDeleted" msprop:Generator_TableClassName="usersDataTable" msprop:Generator_RowChangedName="usersRowChanged" msprop:Generator_RowClassName="usersRow" msprop:Generator_RowChangingName="usersRowChanging" msprop:Generator_RowEvArgName="usersRowChangeEvent" msprop:Generator_RowEvHandlerName="usersRowChangeEventHandler" msprop:Generator_TablePropName="users" msprop:Generator_TableVarName="tableusers" msprop:Generator_RowDeletingName="usersRowDeleting">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="uid" msdata:ReadOnly="true" msdata:AutoIncrement="true" msprop:Generator_UserColumnName="uid" msprop:Generator_ColumnPropNameInRow="uid" msprop:Generator_ColumnVarNameInTable="columnuid" msprop:Generator_ColumnPropNameInTable="uidColumn" type="xs:int" />
              <xs:element name="uusername" msprop:Generator_UserColumnName="uusername" msprop:Generator_ColumnPropNameInRow="uusername" msprop:Generator_ColumnVarNameInTable="columnuusername" msprop:Generator_ColumnPropNameInTable="uusernameColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="upassword" msprop:Generator_UserColumnName="upassword" msprop:Generator_ColumnPropNameInRow="upassword" msprop:Generator_ColumnVarNameInTable="columnupassword" msprop:Generator_ColumnPropNameInTable="upasswordColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="uname" msprop:Generator_UserColumnName="uname" msprop:Generator_ColumnPropNameInRow="uname" msprop:Generator_ColumnVarNameInTable="columnuname" msprop:Generator_ColumnPropNameInTable="unameColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ufamily" msprop:Generator_UserColumnName="ufamily" msprop:Generator_ColumnPropNameInRow="ufamily" msprop:Generator_ColumnVarNameInTable="columnufamily" msprop:Generator_ColumnPropNameInTable="ufamilyColumn" 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:book" />
      <xs:field xpath="mstns:bid" />
    </xs:unique>
    <xs:unique name="Borrow_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Borrow" />
      <xs:field xpath="mstns:brid" />
    </xs:unique>
    <xs:unique name="Category_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Category" />
      <xs:field xpath="mstns:catid" />
    </xs:unique>
    <xs:unique name="Member_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Member" />
      <xs:field xpath="mstns:mid" />
    </xs:unique>
    <xs:unique name="publisher_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:publisher" />
      <xs:field xpath="mstns:pid" />
    </xs:unique>
    <xs:unique name="users_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:users" />
      <xs:field xpath="mstns:uid" />
    </xs:unique>
  </xs:element>
</xs:schema>