sqlclient.datasource1.commands2.config

Ｃ＃的数据层架构

<?xml version="1.0" encoding="utf-8" ?> 
<dataOperations dataSource="DataSource1" xmlns="Framework.DataAccess">
	<dataSetAdapters>
		<dataSetAdapter name="Adapter1" populateCommands="true">
			<selectCommand name="Adapter1_SelectCommand" type="Text">
				<commandText>SELECT * FROM Users WHERE Username = @Username</commandText>
				<parameters>
					<param key="Username" name="@Username" type="NVarChar" size="50" direction="Input" />
				</parameters>
			</selectCommand>
			<tableMappings>
				<tableMapping sourceTable="Table" dataSetTable="Users">
					<columnMappings>
						<columnMapping sourceColumn="Amount" dataSetColumn="DisposableMoney" />
					</columnMappings>
				</tableMapping>
			</tableMappings>
		</dataSetAdapter>	
		<dataSetAdapter name="Adapter2" populateCommands="true">
			<selectCommand name="Adapter2_SelectCommand" type="Text">
				<commandText>SELECT * FROM Users WHERE Username = @Username</commandText>
				<parameters>
					<param key="Username" name="@Username" type="NVarChar" size="50" direction="Input" />
				</parameters>
			</selectCommand>
			<updateCommand name="Adapter2_UpdateCommand" type="StoredProcedure">
				<commandText>UpdateUser</commandText>
				<parameters>
					<param key="Username" name="@Username" type="NVarChar" size="50" direction="Input" sourceColumn="Username"/>
					<param key="UserID" name="@UserID" type="Int" direction="Input" sourceColumn="UserID"/>
				</parameters>
			</updateCommand>
			<tableMappings>
				<tableMapping sourceTable="Table" dataSetTable="Users"/>
			</tableMappings>
		</dataSetAdapter>		
	</dataSetAdapters>	
</dataOperations>