SqlPipe SqlPipe SqlPipe SqlPipe Class

定义

允许托管存储过程在 SQL Server 数据库上进行进程内运行,以便将结果返回调用方。 Allows managed stored procedures running in-process on a SQL Server database to return results back to the caller. 此类不能被继承。 This class cannot be inherited.

public ref class SqlPipe sealed
public sealed class SqlPipe
type SqlPipe = class
Public NotInheritable Class SqlPipe
继承
SqlPipeSqlPipeSqlPipeSqlPipe

示例

下面的示例使用SqlConnectionSqlCommand来从存储过程中的数据源选择的行。The following example uses SqlConnection and SqlCommand to select rows from a data source in a stored procedure. 该示例然后使用SqlPipe执行命令,将结果发送回客户端。The example then uses a SqlPipe to execute the command and send the results back to the client.

[Microsoft.SqlServer.Server.SqlProcedure()]
public static void StoredProcExecuteCommand(int rating)
{
	// Connect through the context connection.
	using (SqlConnection connection = new SqlConnection("context connection=true"))
	{
		connection.Open();

		SqlCommand command = new SqlCommand(
			"SELECT VendorID, AccountNumber, Name FROM Purchasing.Vendor " +
			"WHERE CreditRating <= @rating", connection);
		command.Parameters.AddWithValue("@rating", rating);

		// Execute the command and send the results directly to the client.
		SqlContext.Pipe.ExecuteAndSend(command);
		
	}
}
<Microsoft.SqlServer.Server.SqlProcedure()> _
Public Shared Sub StoredProcExecuteCommand(ByVal rating As Integer)
    Dim command As SqlCommand

    ' Connect through the context connection
    Using connection As New SqlConnection("context connection=true")
        connection.Open()

        command = New SqlCommand( _
            "SELECT VendorID, AccountNumber, Name FROM Purchasing.Vendor " & _
            "WHERE CreditRating <= @rating", connection)
        command.Parameters.AddWithValue("@rating", rating)

        ' Execute the command and send the results directly to the client
        SqlContext.Pipe.ExecuteAndSend(command)
    End Using
End Sub

注解

此类的实例将提供给托管存储过程通过Pipe属性的SqlContext类。An instance of this class is made available to managed stored procedures through the Pipe property of the SqlContext class.

属性

IsSendingResults IsSendingResults IsSendingResults IsSendingResults

获取一个值,该值指示 SqlPipe 是否处于将单个结果集发送回客户端的模式。 Gets a value that indicates whether the SqlPipe is in the mode of sending single result sets back to the client. 此属性是只读的。 This property is read-only.

方法

Equals(Object) Equals(Object) Equals(Object) Equals(Object)

确定指定的对象是否等于当前对象。 Determines whether the specified object is equal to the current object.

(Inherited from Object)
ExecuteAndSend(SqlCommand) ExecuteAndSend(SqlCommand) ExecuteAndSend(SqlCommand) ExecuteAndSend(SqlCommand)

执行作为参数传递的命令,并将结果发送到客户端。 Executes the command passed as a parameter and sends the results to the client.

GetHashCode() GetHashCode() GetHashCode() GetHashCode()

作为默认哈希函数。 Serves as the default hash function.

(Inherited from Object)
GetType() GetType() GetType() GetType()

获取当前实例的 Type Gets the Type of the current instance.

(Inherited from Object)
MemberwiseClone() MemberwiseClone() MemberwiseClone() MemberwiseClone()

创建当前 Object 的浅表副本。 Creates a shallow copy of the current Object.

(Inherited from Object)
Send(SqlDataReader) Send(SqlDataReader) Send(SqlDataReader) Send(SqlDataReader)

将多行结果集直接发送到客户端或当前输出使用者。 Sends a multirow result set directly to the client or current output consumer.

Send(SqlDataRecord) Send(SqlDataRecord) Send(SqlDataRecord) Send(SqlDataRecord)

将单行结果集直接发送到客户端或当前输出使用者。 Sends a single-row result set directly to the client or current output consumer.

Send(String) Send(String) Send(String) Send(String)

将字符串消息直接发送到客户端或当前输出使用者。 Sends a string message directly to the client or current output consumer.

SendResultsEnd() SendResultsEnd() SendResultsEnd() SendResultsEnd()

标记结果集的结尾,并将 SqlPipe 实例返回到初始状态。 Marks the end of a result set, and returns the SqlPipe instance back to the initial state.

SendResultsRow(SqlDataRecord) SendResultsRow(SqlDataRecord) SendResultsRow(SqlDataRecord) SendResultsRow(SqlDataRecord)

将单行数据发送回客户端。 Sends a single row of data back to the client.

SendResultsStart(SqlDataRecord) SendResultsStart(SqlDataRecord) SendResultsStart(SqlDataRecord) SendResultsStart(SqlDataRecord)

标记要发送到客户端的结果集的开始,并使用记录参数构造描述结果集的元数据。 Marks the beginning of a result set to be sent back to the client, and uses the record parameter to construct the metadata that describes the result set.

ToString() ToString() ToString() ToString()

返回表示当前对象的字符串。 Returns a string that represents the current object.

(Inherited from Object)

适用于