1<?xml version="1.0" encoding="utf-8"?>
  2<xs:schema id="TestDatabase" targetNamespace="http://tempuri.org/TestDatabase.xsd" xmlns:mstns="http://tempuri.org/TestDatabase.xsd" xmlns="http://tempuri.org/TestDatabase.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">
  3  <xs:annotation>
  4    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
  5      <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
  6        <Connections>
  7          <Connection AppSettingsObjectName="Web.config" AppSettingsPropertyName="SqlConnectionString" ConnectionStringObject="" IsAppSettingsProperty="True" Modifier="Assembly" Name="SqlConnectionString (Web.config)" ParameterPrefix="@" PropertyReference="AppConfig.System.Configuration.ConfigurationManager.0.ConnectionStrings.SqlConnectionString.ConnectionString" Provider="System.Data.SqlClient">
  8          </Connection>
  9        </Connections>
 10        <Tables>
 11          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="TestTableAdapter" GeneratorDataComponentClassName="TestTableAdapter" Name="Test" UserDataComponentName="TestTableAdapter">
 12            <MainSource>
 13              <DbSource ConnectionRef="SqlConnectionString (Web.config)" DbObjectName="dbo.Test" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillInit" GenerateMethods="Both" GenerateShortCommands="True" GeneratorGetMethodName="GetInit" GeneratorSourceName="FillInit" GetMethodModifier="Public" GetMethodName="GetInit" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetInit" UserSourceName="FillInit">
 14                <DeleteCommand>
 15                  <DbCommand CommandType="Text" ModifiedByUser="False">
 16                    <CommandText>DELETE FROM [dbo].[Test] WHERE (([Id] = @Original_Id) AND ((@IsNull_ParentId = 1 AND [ParentId] IS NULL) OR ([ParentId] = @Original_ParentId)) AND ((@IsNull_Name = 1 AND [Name] IS NULL) OR ([Name] = @Original_Name)) AND ((@IsNull_PublishTime = 1 AND [PublishTime] IS NULL) OR ([PublishTime] = @Original_PublishTime)) AND ((@IsNull_Price = 1 AND [Price] IS NULL) OR ([Price] = @Original_Price)) AND ((@IsNull_IsGood = 1 AND [IsGood] IS NULL) OR ([IsGood] = @Original_IsGood)))</CommandText>
 17                    <Parameters>
 18                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Id" SourceColumnNullMapping="False" SourceVersion="Original">
 19                      </Parameter>
 20                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ParentId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ParentId" SourceColumnNullMapping="True" SourceVersion="Original">
 21                      </Parameter>
 22                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ParentId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ParentId" SourceColumnNullMapping="False" SourceVersion="Original">
 23                      </Parameter>
 24                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Name" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="True" SourceVersion="Original">
 25                      </Parameter>
 26                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="False" SourceVersion="Original">
 27                      </Parameter>
 28                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_PublishTime" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PublishTime" SourceColumnNullMapping="True" SourceVersion="Original">
 29                      </Parameter>
 30                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_PublishTime" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="PublishTime" SourceColumnNullMapping="False" SourceVersion="Original">
 31                      </Parameter>
 32                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Price" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Price" SourceColumnNullMapping="True" SourceVersion="Original">
 33                      </Parameter>
 34                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Original_Price" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="Price" SourceColumnNullMapping="False" SourceVersion="Original">
 35                      </Parameter>
 36                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_IsGood" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IsGood" SourceColumnNullMapping="True" SourceVersion="Original">
 37                      </Parameter>
 38                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_IsGood" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="IsGood" SourceColumnNullMapping="False" SourceVersion="Original">
 39                      </Parameter>
 40                    </Parameters>
 41                  </DbCommand>
 42                </DeleteCommand>
 43                <InsertCommand>
 44                  <DbCommand CommandType="Text" ModifiedByUser="False">
 45                    <CommandText>INSERT INTO [dbo].[Test] ([ParentId], [Name], [PublishTime], [Price], [IsGood]) VALUES (@ParentId, @Name, @PublishTime, @Price, @IsGood);
 46SELECT Id, ParentId, Name, PublishTime, Price, IsGood FROM Test WHERE (Id = SCOPE_IDENTITY())</CommandText>
 47                    <Parameters>
 48                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ParentId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ParentId" SourceColumnNullMapping="False" SourceVersion="Current">
 49                      </Parameter>
 50                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="False" SourceVersion="Current">
 51                      </Parameter>
 52                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@PublishTime" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="PublishTime" SourceColumnNullMapping="False" SourceVersion="Current">
 53                      </Parameter>
 54                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Price" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="Price" SourceColumnNullMapping="False" SourceVersion="Current">
 55                      </Parameter>
 56                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@IsGood" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="IsGood" SourceColumnNullMapping="False" SourceVersion="Current">
 57                      </Parameter>
 58                    </Parameters>
 59                  </DbCommand>
 60                </InsertCommand>
 61                <SelectCommand>
 62                  <DbCommand CommandType="Text" ModifiedByUser="False">
 63                    <CommandText>SELECT Id, ParentId, Name, PublishTime, Price, IsGood FROM dbo.Test</CommandText>
 64                    <Parameters>
 65                    </Parameters>
 66                  </DbCommand>
 67                </SelectCommand>
 68                <UpdateCommand>
 69                  <DbCommand CommandType="Text" ModifiedByUser="False">
 70                    <CommandText>UPDATE [dbo].[Test] SET [ParentId] = @ParentId, [Name] = @Name, [PublishTime] = @PublishTime, [Price] = @Price, [IsGood] = @IsGood WHERE (([Id] = @Original_Id) AND ((@IsNull_ParentId = 1 AND [ParentId] IS NULL) OR ([ParentId] = @Original_ParentId)) AND ((@IsNull_Name = 1 AND [Name] IS NULL) OR ([Name] = @Original_Name)) AND ((@IsNull_PublishTime = 1 AND [PublishTime] IS NULL) OR ([PublishTime] = @Original_PublishTime)) AND ((@IsNull_Price = 1 AND [Price] IS NULL) OR ([Price] = @Original_Price)) AND ((@IsNull_IsGood = 1 AND [IsGood] IS NULL) OR ([IsGood] = @Original_IsGood)));
 71SELECT Id, ParentId, Name, PublishTime, Price, IsGood FROM Test WHERE (Id = @Id)</CommandText>
 72                    <Parameters>
 73                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ParentId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ParentId" SourceColumnNullMapping="False" SourceVersion="Current">
 74                      </Parameter>
 75                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="False" SourceVersion="Current">
 76                      </Parameter>
 77                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@PublishTime" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="PublishTime" SourceColumnNullMapping="False" SourceVersion="Current">
 78                      </Parameter>
 79                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Price" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="Price" SourceColumnNullMapping="False" SourceVersion="Current">
 80                      </Parameter>
 81                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@IsGood" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="IsGood" SourceColumnNullMapping="False" SourceVersion="Current">
 82                      </Parameter>
 83                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Id" SourceColumnNullMapping="False" SourceVersion="Original">
 84                      </Parameter>
 85                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ParentId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ParentId" SourceColumnNullMapping="True" SourceVersion="Original">
 86                      </Parameter>
 87                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ParentId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ParentId" SourceColumnNullMapping="False" SourceVersion="Original">
 88                      </Parameter>
 89                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Name" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="True" SourceVersion="Original">
 90                      </Parameter>
 91                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="False" SourceVersion="Original">
 92                      </Parameter>
 93                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_PublishTime" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PublishTime" SourceColumnNullMapping="True" SourceVersion="Original">
 94                      </Parameter>
 95                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_PublishTime" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="PublishTime" SourceColumnNullMapping="False" SourceVersion="Original">
 96                      </Parameter>
 97                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Price" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Price" SourceColumnNullMapping="True" SourceVersion="Original">
 98                      </Parameter>
 99                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Original_Price" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="Price" SourceColumnNullMapping="False" SourceVersion="Original">
100                      </Parameter>
101                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_IsGood" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IsGood" SourceColumnNullMapping="True" SourceVersion="Original">
102                      </Parameter>
103                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_IsGood" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="IsGood" SourceColumnNullMapping="False" SourceVersion="Original">
104                      </Parameter>
105                      <Parameter AllowDbNull="False" AutogeneratedName="Id" ColumnName="Id" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@Id" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="Id" SourceColumnNullMapping="False" SourceVersion="Current">
106                      </Parameter>
107                    </Parameters>
108                  </DbCommand>
109                </UpdateCommand>
110              </DbSource>
111            </MainSource>
112            <Mappings>
113              <Mapping SourceColumn="Id" DataSetColumn="Id" />
114              <Mapping SourceColumn="ParentId" DataSetColumn="ParentId" />
115              <Mapping SourceColumn="Name" DataSetColumn="Name" />
116              <Mapping SourceColumn="PublishTime" DataSetColumn="PublishTime" />
117              <Mapping SourceColumn="Price" DataSetColumn="Price" />
118              <Mapping SourceColumn="IsGood" DataSetColumn="IsGood" />
119            </Mappings>
120            <Sources>
121              <DbSource ConnectionRef="SqlConnectionString (Web.config)" DbObjectName="[C:\DOCUMENTS AND SETTINGS\ADMINISTRATOR\妗岄潰\VS2005\WEB\APP_DATA\VS2005_TEST.MDF].dbo.sp_DeleteTest" DbObjectType="StoredProcedure" GenerateShortCommands="True" GeneratorSourceName="DeleteTest" Modifier="Public" Name="DeleteTest" QueryType="Scalar" ScalarCallRetval="System.Int32, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetDataBy" UserSourceName="DeleteTest">
122                <SelectCommand>
123                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="False">
124                    <CommandText>dbo.sp_DeleteTest</CommandText>
125                    <Parameters>
126                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
127                      </Parameter>
128                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Id" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
129                      </Parameter>
130                    </Parameters>
131                  </DbCommand>
132                </SelectCommand>
133              </DbSource>
134              <DbSource ConnectionRef="SqlConnectionString (Web.config)" DbObjectName="[C:\DOCUMENTS AND SETTINGS\ADMINISTRATOR\妗岄潰\VS2005\WEB\APP_DATA\VS2005_TEST.MDF].dbo.sp_SelectTest" DbObjectType="StoredProcedure" FillMethodModifier="Public" FillMethodName="FillTest" GenerateMethods="Both" GenerateShortCommands="True" GeneratorGetMethodName="GetTest" GeneratorSourceName="FillTest" GetMethodModifier="Public" GetMethodName="GetTest" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetTest" UserSourceName="FillTest">
135                <SelectCommand>
136                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="False">
137                    <CommandText>dbo.sp_SelectTest</CommandText>
138                    <Parameters>
139                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
140                      </Parameter>
141                    </Parameters>
142                  </DbCommand>
143                </SelectCommand>
144              </DbSource>
145              <DbSource ConnectionRef="SqlConnectionString (Web.config)" DbObjectName="[C:\DOCUMENTS AND SETTINGS\ADMINISTRATOR\妗岄潰\VS2005\WEB\APP_DATA\VS2005_TEST.MDF].dbo.sp_SelectTestById" DbObjectType="StoredProcedure" FillMethodModifier="Public" FillMethodName="FillTestById" GenerateMethods="Both" GenerateShortCommands="True" GeneratorGetMethodName="GetTestById" GeneratorSourceName="FillTestById" GetMethodModifier="Public" GetMethodName="GetTestById" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetTestById" UserSourceName="FillTestById">
146                <SelectCommand>
147                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="False">
148                    <CommandText>dbo.sp_SelectTestById</CommandText>
149                    <Parameters>
150                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
151                      </Parameter>
152                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Id" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
153                      </Parameter>
154                    </Parameters>
155                  </DbCommand>
156                </SelectCommand>
157              </DbSource>
158              <DbSource ConnectionRef="SqlConnectionString (Web.config)" DbObjectName="[C:\DOCUMENTS AND SETTINGS\ADMINISTRATOR\妗岄潰\VS2005\WEB\APP_DATA\VS2005_TEST.MDF].dbo.sp_InsertTest" DbObjectType="StoredProcedure" GenerateShortCommands="True" GeneratorSourceName="InsertTest" Modifier="Public" Name="InsertTest" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetDataBy1" UserSourceName="InsertTest">
159                <SelectCommand>
160                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="False">
161                    <CommandText>dbo.sp_InsertTest</CommandText>
162                    <Parameters>
163                      <Parameter AllowDbNull="Tru