sqlclient.datasource1.commands3.config

Ｃ＃的数据层架构

<?xml version="1.0" encoding="utf-8" ?> 
<dataOperations dataSource="DataSource1" xmlns="Framework.DataAccess">
	<dataCommands>
		<dataCommand name="SelectUsersCommand1" type="Text">
			<commandText><![CDATA[
				SELECT 
					COUNT(*) 
				FROM Users AS U1
				WHERE 1=1
				{1}
			]]></commandText>
			<replaceByParamValues>
				<replaceByParamValue paramName="@UserID" paramValue="DBNull.Value">
					<oldString>{1}</oldString>
					<newString></newString>
					<defaultString><![CDATA[AND U1.UserID < @UserID]]></defaultString>
				</replaceByParamValue>
			</replaceByParamValues>
			<parameters>
				<param name="@UserID" type="Int" direction="Input" />
			</parameters>			
		</dataCommand>
		
		<dataCommand name="SelectUsersCommand2" type="Text">
			<commandText><![CDATA[
				SELECT 
					COUNT(*)
				FROM Users AS U1
				WHERE 1=1
				AND U1.UserID < @UserID
			]]></commandText>
			<replaceByParamValues>
				<replaceByParamValue paramName="@UserID" paramValue="DBNull.Value">
					<oldString><![CDATA[AND U1.UserID < @UserID]]></oldString>
					<newString></newString>
				</replaceByParamValue>
			</replaceByParamValues>
			<parameters>
				<param name="@UserID" type="Int" direction="Input" />
			</parameters>			
		</dataCommand>
		
	</dataCommands>
</dataOperations>