locations.xsd

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

<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="LocationsDataComponent" 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" Modifier="AutoLayout, AnsiClass, NotPublic, Public" 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>
					<DbTable BaseClass="System.ComponentModel.Component" DataAccessorName="LocationsDataAdapter" Modifier="AutoLayout, AnsiClass, NotPublic, Public" Name="Locations" WebServiceAttribute="False">
						<MainSource>
							<DbSource ConnectionRef="classifiedsConnection (Web.config)" DbObjectName="classifieds.GetAllLocations" DbObjectType="StoredProcedure" EnableWebMethods="False" GenerateMethods="Get" GeneratePagingMethods="False" GetMethodName="GetAllLocations" Name="Fill" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.3600.0, Culture=neutral, PublicKeyToken=b77a5c561934e089">
								<DeleteCommand>
									<DbCommand CommandType="StoredProcedure" ModifiedByUser="False">
										<CommandText>RemoveLocation</CommandText>
										<Parameters>
											<Parameter AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
											</Parameter>
											<Parameter 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>InsertLocation</CommandText>
										<Parameters>
											<Parameter AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
											</Parameter>
											<Parameter 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>GetAllLocations</CommandText>
										<Parameters>
											<Parameter AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
											</Parameter>
										</Parameters>
									</DbCommand>
								</SelectCommand>
								<UpdateCommand>
									<DbCommand CommandType="StoredProcedure" ModifiedByUser="False">
										<CommandText>UpdateLocation</CommandText>
										<Parameters>
											<Parameter AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
											</Parameter>
											<Parameter AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Id" Precision="10" Scale="0" Size="4" SourceColumn="Id" SourceColumnNullMapping="False" SourceVersion="Current">
											</Parameter>
											<Parameter AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Name" Precision="0" Scale="0" Size="50" SourceColumn="Name" SourceColumnNullMapping="False" SourceVersion="Current">
											</Parameter>
										</Parameters>
									</DbCommand>
								</UpdateCommand>
							</DbSource>
						</MainSource>
						<Mappings>
							<Mapping SourceColumn="Id" DataSetColumn="Id" />
							<Mapping SourceColumn="Name" DataSetColumn="Name" />
						</Mappings>
						<Sources>
							<DbSource ConnectionRef="classifiedsConnection (Web.config)" DbObjectName="classifieds.RemoveLocation" DbObjectType="StoredProcedure" EnableWebMethods="False" MethodsParameterType="CLR" Modifier="Public" Name="RemoveLocation" ParameterList="@Id" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=2.0.3600.0, Culture=neutral, PublicKeyToken=b77a5c561934e089">
								<SelectCommand>
									<DbCommand CommandType="StoredProcedure" ModifiedByUser="False">
										<CommandText>RemoveLocation</CommandText>
										<Parameters>
											<Parameter AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
											</Parameter>
											<Parameter AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Id" Precision="10" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
											</Parameter>
										</Parameters>
									</DbCommand>
								</SelectCommand>
							</DbSource>
							<DbSource ConnectionRef="classifiedsConnection (Web.config)" DbObjectName="classifieds.InsertLocation" DbObjectType="StoredProcedure" EnableWebMethods="False" MethodsParameterType="CLR" Modifier="Public" Name="InsertLocation" ParameterList="@Name" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=2.0.3600.0, Culture=neutral, PublicKeyToken=b77a5c561934e089">
								<SelectCommand>
									<DbCommand CommandType="StoredProcedure" ModifiedByUser="False">
										<CommandText>InsertLocation</CommandText>
										<Parameters>
											<Parameter AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
											</Parameter>
											<Parameter AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Name" Precision="0" Scale="0" Size="50" SourceColumnNullMapping="False" SourceVersion="Current">
											</Parameter>
										</Parameters>
									</DbCommand>
								</SelectCommand>
							</DbSource>
						</Sources>
					</DbTable>
				</Tables>
				<Sources>
				</Sources>
			</DataSource>
		</xs:appinfo>
	</xs:annotation>
	<xs:element name="LocationsDataComponent" msdata:IsDataSet="true">
		<xs:complexType>
			<xs:choice minOccurs="0" maxOccurs="unbounded">
				<xs:element name="Locations">
					<xs:complexType>
						<xs:sequence>
							<xs:element name="Id" msdata:ReadOnly="true" msdata:AutoIncrement="true" type="xs:int" />
							<xs:element name="Name">
								<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:Locations" />
			<xs:field xpath="mstns:Id" />
		</xs:unique>
	</xs:element>
</xs:schema>