Table of Contents

Class ServiceBrokerSchema.TransmissionQueue

Namespace
LinqToDB.Tools.DataProvider.SqlServer.Schemas
Assembly
linq2db.Tools.dll

sys.transmission_queue (Transact-SQL)

Applies to: √ SQL Server (all supported versions)

This catalog view contains a row for each message in the transmission queue, as shown in the following table:


See sys.transmission_queue.

[Table(Schema = "sys", Name = "transmission_queue", IsView = true)]
public class ServiceBrokerSchema.TransmissionQueue
Inheritance
ServiceBrokerSchema.TransmissionQueue
Extension Methods

Properties

ConversationHandle

Identifier for the conversation that this message belongs to. Not NULLABLE.

[Column("conversation_handle")]
[NotNull]
public Guid ConversationHandle { get; set; }

Property Value

Guid

EnqueueTime

Time at which the message entered the queue. This value uses UTC regardless of the local time zone for the instance. Not NULLABLE.

[Column("enqueue_time")]
[NotNull]
public DateTime EnqueueTime { get; set; }

Property Value

DateTime

FromServiceName

Name of the service that this message is from. NULLABLE.

[Column("from_service_name")]
[Nullable]
public string? FromServiceName { get; set; }

Property Value

string

IsConversationError

Whether this message is an error message.

0 = Not an error message.

1 = Error message.

Not NULLABLE.

[Column("is_conversation_error")]
[NotNull]
public bool IsConversationError { get; set; }

Property Value

bool

IsEndOfDialog

Whether this message is an end of conversation message. Not NULLABLE.

0 = Not an end of conversation message.

1 = End of conversation message.

Not NULLABLE.

[Column("is_end_of_dialog")]
[NotNull]
public bool IsEndOfDialog { get; set; }

Property Value

bool

MessageBody

The body of this message. NULLABLE.

[Column("message_body")]
[Nullable]
public byte[]? MessageBody { get; set; }

Property Value

byte[]

MessageSequenceNumber

Sequence number of the message. Not NULLABLE.

[Column("message_sequence_number")]
[NotNull]
public long MessageSequenceNumber { get; set; }

Property Value

long

MessageTypeName

Message type name for the message. NULLABLE.

[Column("message_type_name")]
[Nullable]
public string? MessageTypeName { get; set; }

Property Value

string

Priority

The priority level that is assigned to this message. Not NULLABLE.

[Column("priority")]
[NotNull]
public byte Priority { get; set; }

Property Value

byte

ServiceContractName

Name of the contract that the conversation for this message follows. NULLABLE.

[Column("service_contract_name")]
[Nullable]
public string? ServiceContractName { get; set; }

Property Value

string

ToBrokerInstance

Identifier of the broker that hosts the service that this message is to. NULLABLE.

[Column("to_broker_instance")]
[Nullable]
public string? ToBrokerInstance { get; set; }

Property Value

string

ToServiceName

Name of the service that this message is to. NULLABLE.

[Column("to_service_name")]
[Nullable]
public string? ToServiceName { get; set; }

Property Value

string

TransmissionStatus

The reason this message is on the queue. This is generally an error message explaining why sending the message failed. If this is blank, the message has not been sent yet. NULLABLE.

[Column("transmission_status")]
[Nullable]
public string? TransmissionStatus { get; set; }

Property Value

string