sqlclient.datasource1.commands.config

Ｃ＃的数据层架构

<?xml version="1.0" encoding="utf-8" ?> 
<dataOperations dataSource="DataSource1" xmlns="Framework.DataAccess">
	<dataCommands>
		<dataCommand name="Command1" type="Text">
			<commandText>INSERT INTO Users(Username) VALUES('user')</commandText>
		</dataCommand>
		<dataCommand name="Command2" type="Text">
			<commandText>SELECT * FROM Users</commandText>
		</dataCommand>
		<dataCommand name="Command3" type="Text">
			<commandText>INSERT INTO Users(Username) VALUES(@Username)</commandText>
			<parameters>
				<param key="Username" name="@Username" type="NVarChar" size="50" direction="Input" />
			</parameters>
		</dataCommand>
		<dataCommand name="Command4" type="Text">
			<commandText><![CDATA[SELECT * FROM Users WHERE UserID > @UserID]]></commandText>
			<parameters>
				<param name="@UserID" type="Int" direction="Input" />
			</parameters>
		</dataCommand>
		<dataCommand name="Command5" type="Text">
			<commandText>SELECT * FROM Users WHERE Username = @Username</commandText>
			<parameters>
				<param key="Username" name="@Username" type="NVarChar" size="50" direction="Input" />
			</parameters>
		</dataCommand>
		<dataCommand name="Command6" type="Text">
			<commandText>
				INSERT INTO Users(Username) VALUES('user')
				SET @UserID = SCOPE_IDENTITY()
			</commandText>
			<parameters>
				<param key="UserID" name="@UserID" type="Int" direction="Output" />
			</parameters>
		</dataCommand>
		<dataCommand name="Command7" type="StoredProcedure">
			<commandText>InsertUser</commandText>
			<parameters>
				<param key="Username" name="@Username" type="NVarChar" size="50" direction="Input" />
				<param key="UserID" name="@UserID" type="Int" direction="Output" />
			</parameters>
		</dataCommand>
		<dataCommand name="Command13" type="StoredProcedure">
			<commandText>InsertUser</commandText>
			<parameters>
				<param key="Username" name="@Username" type="NVarChar" size="50" direction="Input" />
				<param key="UserID" name="@UserID" type="Int" direction="Output" />
			</parameters>
		</dataCommand>
		<dataCommand name="Command14" type="Text">
			<commandText><![CDATA[RAISERROR ('Raised Error', @Severity, 1)]]></commandText>
			<parameters>
				<param name="@Severity" type="Int" direction="Input" />
			</parameters>
		</dataCommand>
	</dataCommands>		
</dataOperations>