categories.xsd

classfinalcs.rar .net 压缩包解压时不能有密码。

<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="CategoriesDataComponent" targetNamespace="uri:AspNet:StarterKits:Classifieds:Data" xmlns:mstns="uri:AspNet:StarterKits:Classifieds:Data" xmlns="uri:AspNet:StarterKits:Classifieds:Data" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" 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="Web.config" AppSettingsPropertyName="classifiedsConnection" ConnectionStringObject="" IsAppSettingsProperty="True" Modifier="Assembly" Name="classifiedsConnection (Web.config)" ParameterPrefix="@" PropertyReference="AppConfig.System.Configuration.ConfigurationManager.0.ConnectionStrings.classifiedsConnection.ConnectionString" Provider="System.Data.SqlClient">
					</Connection>
				</Connections>
				<Tables>
					<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="CategoriesDataAdapter" Name="Categories">
						<MainSource>
							<DbSource ConnectionRef="classifiedsConnection (Web.config)" DbObjectName="classifieds.GetCategoryById" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="True" GetMethodModifier="Public" GetMethodName="GetCategoryById" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True">
								<DeleteCommand>
									<DbCommand CommandType="StoredProcedure" ModifiedByUser="False">
										<CommandText>RemoveCategory</CommandText>
										<Parameters>
											<Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
											</Parameter>
											<Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Id" Precision="10" Scale="0" Size="4" SourceColumn="Id" SourceColumnNullMapping="False" SourceVersion="Current">
											</Parameter>
										</Parameters>
									</DbCommand>
								</DeleteCommand>
								<InsertCommand>
									<DbCommand CommandType="StoredProcedure" ModifiedByUser="False">
										<CommandText>InsertCategory</CommandText>
										<Parameters>
											<Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
											</Parameter>
											<Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ParentCategoryId" Precision="10" Scale="0" Size="4" SourceColumn="ParentCategoryId" SourceColumnNullMapping="False" SourceVersion="Current">
											</Parameter>
											<Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Name" Precision="0" Scale="0" Size="50" SourceColumn="Name" SourceColumnNullMapping="False" SourceVersion="Current">
											</Parameter>
										</Parameters>
									</DbCommand>
								</InsertCommand>
								<SelectCommand>
									<DbCommand CommandType="StoredProcedure" ModifiedByUser="False">
										<CommandText>GetCategoryById</CommandText>
										<Parameters>
											<Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
											</Parameter>
											<Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Id" Precision="10" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
											</Parameter>
										</Parameters>
									</DbCommand>
								</SelectCommand>
								<UpdateCommand>
									<DbCommand CommandType="StoredProcedure" ModifiedByUser="False">
										<CommandText>UpdateCategory</CommandText>
										<Parameters>
											<Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
											</Parameter>
											<Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Id" Precision="10" Scale="0" Size="4" SourceColumn="Id" SourceColumnNullMapping="False" SourceVersion="Current">
											</Parameter>
											<Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ParentCategoryId" Precision="10" Scale="0" Size="4" SourceColumn="ParentCategoryId" SourceColumnNullMapping="False" SourceVersion="Current">
											</Parameter>
											<Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Name" Precision="0" Scale="0" Size="50" SourceColumn="Name" SourceColumnNullMapping="False" SourceVersion="Current">
											</Parameter>
											<Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@NumActiveAds" Precision="10" Scale="0" Size="4" SourceColumn="NumActiveAds" SourceColumnNullMapping="False" SourceVersion="Current">
											</Parameter>
										</Parameters>
									</DbCommand>
								</UpdateCommand>
							</DbSource>
						</MainSource>
						<Mappings>
							<Mapping SourceColumn="Id" DataSetColumn="Id" />
							<Mapping SourceColumn="ParentCategoryId" DataSetColumn="ParentCategoryId" />
							<Mapping SourceColumn="Name" DataSetColumn="Name" />
							<Mapping SourceColumn="NumActiveAds" DataSetColumn="NumActiveAds" />
						</Mappings>
						<Sources>
							<DbSource ConnectionRef="classifiedsConnection (Web.config)" DbObjectName="classifieds.GetCategoriesByParentId" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="True" GetMethodModifier="Public" GetMethodName="GetCategoriesByParentId" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True">
								<SelectCommand>
									<DbCommand CommandType="StoredProcedure" ModifiedByUser="True">
										<CommandText>GetCategoriesByParentId</CommandText>
										<Parameters>
											<Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
											</Parameter>
											<Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ParentCategoryId" Precision="10" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
											</Parameter>
										</Parameters>
									</DbCommand>
								</SelectCommand>
							</DbSource>
							<DbSource ConnectionRef="classifiedsConnection (Web.config)" DbObjectName="classifieds.GetParentCategoriesById" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="True" GetMethodModifier="Public" GetMethodName="GetParentCategoriesById" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True">
								<SelectCommand>
									<DbCommand CommandType="StoredProcedure" ModifiedByUser="False">
										<CommandText>GetParentCategoriesById</CommandText>
										<Parameters>
											<Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
											</Parameter>
											<Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Id" Precision="10" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
											</Parameter>
										</Parameters>