clrds.xsd

< SQL Server2005程序设计>

<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="CLRDS" targetNamespace="http://tempuri.org/CLRDS.xsd" xmlns:mstns="http://tempuri.org/CLRDS.xsd" xmlns="http://tempuri.org/CLRDS.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="AdventureWorksConnectionString" ConnectionStringObject="" IsAppSettingsProperty="True" Modifier="Assembly" Name="AdventureWorksConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.Chapter08.Properties.Settings.GlobalReference.Default.AdventureWorksConnectionString" Provider="System.Data.SqlClient">
          </Connection>
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="spContactsTableAdapter" GeneratorDataComponentClassName="spContactsTableAdapter" Name="spContacts" UserDataComponentName="spContactsTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="AdventureWorksConnectionString (Settings)" DbObjectName="AdventureWorks.dbo.spContacts" DbObjectType="StoredProcedure" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="False" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="False" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="False">
                    <CommandText>spContacts</CommandText>
                    <Parameters>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ContactID" DataSetColumn="ContactID" />
              <Mapping SourceColumn="NameStyle" DataSetColumn="NameStyle" />
              <Mapping SourceColumn="Title" DataSetColumn="Title" />
              <Mapping SourceColumn="FirstName" DataSetColumn="FirstName" />
              <Mapping SourceColumn="MiddleName" DataSetColumn="MiddleName" />
              <Mapping SourceColumn="LastName" DataSetColumn="LastName" />
              <Mapping SourceColumn="Suffix" DataSetColumn="Suffix" />
              <Mapping SourceColumn="EmailAddress" DataSetColumn="EmailAddress" />
              <Mapping SourceColumn="EmailPromotion" DataSetColumn="EmailPromotion" />
              <Mapping SourceColumn="Phone" DataSetColumn="Phone" />
              <Mapping SourceColumn="PasswordHash" DataSetColumn="PasswordHash" />
              <Mapping SourceColumn="PasswordSalt" DataSetColumn="PasswordSalt" />
              <Mapping SourceColumn="AdditionalContactInfo" DataSetColumn="AdditionalContactInfo" />
              <Mapping SourceColumn="rowguid" DataSetColumn="rowguid" />
              <Mapping SourceColumn="ModifiedDate" DataSetColumn="ModifiedDate" />
            </Mappings>
            <Sources>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="tblAggregateTestTableAdapter" GeneratorDataComponentClassName="tblAggregateTestTableAdapter" Name="tblAggregateTest" UserDataComponentName="tblAggregateTestTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="AdventureWorksConnectionString (Settings)" DbObjectName="AdventureWorks.dbo.tblAggregateTest" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="False" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="False" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="True">
                    <CommandText>SELECT OrderId, SUM(ItemsOrdered) AS SUM, dbo.BakersDozen(ItemsOrdered) AS BakersDozen FROM tblAggregateTest GROUP BY OrderId</CommandText>
                    <Parameters>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="OrderId" DataSetColumn="OrderId" />
              <Mapping SourceColumn="SUM" DataSetColumn="SUM" />
              <Mapping SourceColumn="BakersDozen" DataSetColumn="BakersDozen" />
            </Mappings>
            <Sources>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="tblPointTableAdapter" GeneratorDataComponentClassName="tblPointTableAdapter" Name="tblPoint" UserDataComponentName="tblPointTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="AdventureWorksConnectionString (Settings)" DbObjectName="AdventureWorks.dbo.tblPoint" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="False" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="False" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>SELECT ID, CONVERT (nvarchar, ThePoint) AS ThePoint FROM tblPoint</CommandText>
                    <Parameters>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
            </Mappings>
            <Sources>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="fnPortfolioTableTableAdapter" GeneratorDataComponentClassName="fnPortfolioTableTableAdapter" Name="fnPortfolioTable" UserDataComponentName="fnPortfolioTableTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="AdventureWorksConnectionString (Settings)" DbObjectName="AdventureWorks.dbo.fnPortfolioTable" DbObjectType="Function" 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">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="True">
                    <CommandText>SELECT TickerSymbol, Value FROM dbo.fnPortfolioTable(@TickersPacked)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="TickersPacked" ColumnName="" DataSourceName="" DataTypeServer="nvarchar(8000)" DbType="String" Direction="Input" ParameterName="@TickersPacked" Precision="0" Scale="0" Size="50" SourceColumn="" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="TickerSymbol" DataSetColumn="TickerSymbol" />
              <Mapping SourceColumn="Value" DataSetColumn="Value" />
            </Mappings>
            <Sources>
            </Sources>
          </TableAdapter>
        </Tables>
        <Sources>
        </Sources>
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="CLRDS" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:Generator_UserDSName="CLRDS" msprop:Generator_DataSetName="CLRDS">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="spContacts" msprop:Generator_UserTableName="spContacts" msprop:Generator_RowDeletedName="spContactsRowDeleted" msprop:Generator_RowChangedName="spContactsRowChanged" msprop:Generator_RowClassName="spContactsRow" msprop:Generator_RowChangingName="spContactsRowChanging" msprop:Generator_RowEvArgName="spContactsRowChangeEvent" msprop:Generator_RowEvHandlerName="spContactsRowChangeEventHandler" msprop:Generator_TableClassName="spContactsDataTable" msprop:Generator_TableVarName="tablespContacts" msprop:Generator_RowDeletingName="spContactsRowDeleting" msprop:Generator_TablePropName="spContacts">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ContactID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msprop:Generator_UserColumnName="ContactID" msprop:Generator_ColumnVarNameInTable="columnContactID" msprop:Generator_ColumnPropNameInRow="ContactID" msprop:Generator_ColumnPropNameInTable="ContactIDColumn" type="xs:int" />
              <xs:element name="NameStyle" msprop:Generator_UserColumnName="NameStyle" msprop:Generator_ColumnVarNameInTable="columnNameStyle" msprop:Generator_ColumnPropNameInRow="NameStyle" msprop:Generator_ColumnPropNameInTable="NameStyleColumn" type="xs:boolean" />
              <xs:element name="Title" msprop:Generator_UserColumnName="Title" msprop:Generator_ColumnVarNameInTable="columnTitle" msprop:Generator_ColumnPropNameInRow="Title" msprop:Generator_ColumnPropNameInTable="TitleColumn" minOccurs="0">