Class ServiceBrokerSchema.ConversationEndpoint
- Namespace
- LinqToDB.Tools.DataProvider.SqlServer.Schemas
- Assembly
- linq2db.Tools.dll
sys.conversation_endpoints (Transact-SQL)
Applies to: √ SQL Server (all supported versions)
Each side of a Service Broker conversation is represented by a conversation endpoint. This catalog view contains a row per conversation endpoint in the database.
[Table(Schema = "sys", Name = "conversation_endpoints", IsView = true)]
public class ServiceBrokerSchema.ConversationEndpoint- Inheritance
-
ServiceBrokerSchema.ConversationEndpoint
- Extension Methods
Properties
ConversationGroupID
Identifier for the conversation group this conversation belongs to. Not NULLABLE.
[Column("conversation_group_id")]
[NotNull]
public Guid ConversationGroupID { get; set; }Property Value
ConversationHandle
Identifier for this conversation endpoint. Not NULLABLE.
[Column("conversation_handle")]
[NotNull]
public Guid ConversationHandle { get; set; }Property Value
ConversationID
Identifier for the conversation. This identifier is shared by both participants in the conversation. This together with the is_initiator column is unique within the database. Not NULLABLE.
[Column("conversation_id")]
[NotNull]
public Guid ConversationID { get; set; }Property Value
DialogTimer
The time at which the conversation timer for this dialog sends a DialogTimer message. Not NULLABLE.
[Column("dialog_timer")]
[NotNull]
public DateTime DialogTimer { get; set; }Property Value
EndDialogSequence
The sequence number of the End Dialog message. Not NULLABLE.
[Column("end_dialog_sequence")]
[NotNull]
public long EndDialogSequence { get; set; }Property Value
FarBrokerInstance
The broker instance for the remote side of the conversation. NULLABLE.
[Column("far_broker_instance")]
[Nullable]
public string? FarBrokerInstance { get; set; }Property Value
FarPrincipalID
Identifier of the user whose certificate is used by the remote side of the dialog. Not NULLABLE.
[Column("far_principal_id")]
[NotNull]
public int FarPrincipalID { get; set; }Property Value
FarService
Name of the service on the remote side of conversation. Not NULLABLE.
[Column("far_service")]
[NotNull]
public string FarService { get; set; }Property Value
FirstOutOfOrderSequence
The sequence number of the first message in the out of order messages for this dialog. Not NULLABLE.
[Column("first_out_of_order_sequence")]
[NotNull]
public long FirstOutOfOrderSequence { get; set; }Property Value
InboundSessionKeyIdentifier
Identifier for inbound encryption key for this dialog. Not NULLABLE.
[Column("inbound_session_key_identifier")]
[NotNull]
public Guid InboundSessionKeyIdentifier { get; set; }Property Value
IsInitiator
Whether this endpoint is the initiator or the target of the conversation. Not NULLABLE.
1 = Initiator
0 = Target
[Column("is_initiator")]
[NotNull]
public byte IsInitiator { get; set; }Property Value
IsSystem
1 if this is a system dialog. Not NULLABLE.
[Column("is_system")]
[NotNull]
public bool IsSystem { get; set; }Property Value
LastOutOfOrderFrag
Sequence number of the last message in the out of order fragments for this dialog. Not NULLABLE.
[Column("last_out_of_order_frag")]
[NotNull]
public int LastOutOfOrderFrag { get; set; }Property Value
LastOutOfOrderSequence
The sequence number of the last message in the out of order messages for this dialog. Not NULLABLE.
[Column("last_out_of_order_sequence")]
[NotNull]
public long LastOutOfOrderSequence { get; set; }Property Value
LastSendTranID
Internal transaction ID of last transaction to send a message. Not NULLABLE.
[Column("last_send_tran_id")]
[NotNull]
public byte[] LastSendTranID { get; set; }Property Value
- byte[]
Lifetime
Expiration date/time for this conversation. Not NULLABLE.
[Column("lifetime")]
[NotNull]
public DateTime Lifetime { get; set; }Property Value
OutboundSessionKeyIdentifier
Identifier for outbound encryption key for this dialog. Not NULLABLE.
[Column("outbound_session_key_identifier")]
[NotNull]
public Guid OutboundSessionKeyIdentifier { get; set; }Property Value
PrincipalID
Identifier of the principal whose certificate is used by the local side of the dialog. Not NULLABLE.
[Column("principal_id")]
[NotNull]
public int PrincipalID { get; set; }Property Value
Priority
The conversation priority that is assigned to this conversation endpoint. Not NULLABLE.
[Column("priority")]
[NotNull]
public byte Priority { get; set; }Property Value
ReceiveSequence
Next message number expected in message receive sequence. Not NULLABLE.
[Column("receive_sequence")]
[NotNull]
public long ReceiveSequence { get; set; }Property Value
ReceiveSequenceFrag
Next message fragment number expected in message receive sequence. Not NULLABLE.
[Column("receive_sequence_frag")]
[NotNull]
public int ReceiveSequenceFrag { get; set; }Property Value
SecurityTimestamp
Time at the local session key was created. Not NULLABLE.
[Column("security_timestamp")]
[NotNull]
public DateTime SecurityTimestamp { get; set; }Property Value
SendSequence
Next message number in the send sequence. Not NULLABLE.
[Column("send_sequence")]
[NotNull]
public long SendSequence { get; set; }Property Value
ServiceContractID
Identifier of the contract for this conversation. Not NULLABLE.
[Column("service_contract_id")]
[NotNull]
public int ServiceContractID { get; set; }Property Value
ServiceID
Identifier for the service for this side of the conversation. Not NULLABLE.
[Column("service_id")]
[NotNull]
public int ServiceID { get; set; }Property Value
State
The current state of the conversation. Not NULLABLE. One of:
SO Started outbound. SQL Server processed a BEGIN CONVERSATION for this conversation, but no messages have yet been sent.
SI Started inbound. Another instance started a new conversation with SQL Server, but SQL Server has not yet completely received the first message. SQL Server may create the conversation in this state if the first message is fragmented or SQL Server receives messages out of order. However, SQL Server might create the conversation in the CO (conversing) state if the first transmission received for the conversation contains the entire first message.
CO Conversing. The conversation is established, and both sides of the conversation may send messages. Most of the communication for a typical service takes place when the conversation is in this state.
DI Disconnected inbound. The remote side of the conversation has issued an END CONVERSATION. The conversation remains in this state until the local side of the conversation issues an END CONVERSATION. An application might still receive messages for the conversation. Because the remote side of the conversation has ended the conversation, an application cannot send messages on this conversation. When an application issues an END CONVERSATION, the conversation moves to the CD (Closed) state.
DO Disconnected outbound. The local side of the conversation has issued an END CONVERSATION. The conversation remains in this state until the remote side of the conversation acknowledges the END CONVERSATION. An application cannot send or receive messages for the conversation. When the remote side of the conversation acknowledges the END CONVERSATION, the conversation moves to the CD (Closed) state.
ER Error. An error has occurred on this endpoint. The error message is placed in the application queue. If the application queue is empty, this indicates that the application already consumed the error message.
CD Closed. The conversation endpoint is no longer in use.
[Column("state")]
[NotNull]
public string State { get; set; }Property Value
StateDesc
Description of endpoint conversation state. This column is NULLABLE. One of:
STARTED_OUTBOUND
STARTED_INBOUND
CONVERSING
DISCONNECTED_INBOUND
DISCONNECTED_OUTBOUND
CLOSED
ERROR
[Column("state_desc")]
[Nullable]
public string? StateDesc { get; set; }Property Value
SystemSequence
The sequence number of the last system message for this dialog. Not NULLABLE.
[Column("system_sequence")]
[NotNull]
public long SystemSequence { get; set; }