Class EndpointsSchema.ServiceBrokerEndpoint
- Namespace
- LinqToDB.Tools.DataProvider.SqlServer.Schemas
- Assembly
- linq2db.Tools.dll
sys.service_broker_endpoints (Transact-SQL)
Applies to: √ SQL Server (all supported versions)
This catalog view contains one row for the Service Broker endpoint. For every row in this view, there is a corresponding row with the same endpoint_id in the sys.tcp_endpoints view that contains the TCP configuration metadata. TCP is the only allowed protocol for Service Broker.
[Table(Schema = "sys", Name = "service_broker_endpoints", IsView = true)]
public class EndpointsSchema.ServiceBrokerEndpoint- Inheritance
-
EndpointsSchema.ServiceBrokerEndpoint
- Extension Methods
Properties
CertificateID
ID of certificate used for authentication, if any.
0 = Windows Authentication is being used.
[Column("certificate_id")]
[NotNull]
public int CertificateID { get; set; }Property Value
ConnectionAuth
The type of connection authentication required for connections to this endpoint, one of:
1 - NTLM
2 - KERBEROS
3 - NEGOTIATE
4 - CERTIFICATE
5 - NTLM, CERTIFICATE
6 - KERBEROS, CERTIFICATE
7 - NEGOTIATE, CERTIFICATE
8 - CERTIFICATE, NTLM
9 - CERTIFICATE, KERBEROS
10 - CERTIFICATE, NEGOTIATE
Not NULLABLE.
[Column("connection_auth")]
[NotNull]
public byte ConnectionAuth { get; set; }Property Value
ConnectionAuthDesc
Description of the type of connection authentication required for connections to this endpoint, one of:
NTLM
KERBEROS
NEGOTIATE
CERTIFICATE
NTLM, CERTIFICATE
KERBEROS, CERTIFICATE
NEGOTIATE, CERTIFICATE
CERTIFICATE, NTLM
CERTIFICATE, KERBEROS
CERTIFICATE, NEGOTIATE
NULLABLE.
[Column("connection_auth_desc")]
[Nullable]
public string? ConnectionAuthDesc { get; set; }Property Value
EncryptionAlgorithm
Encryption algorithm. The following are the possible values with their descriptions and corresponding DDL options.
0 : NONE. Corresponding DDL option: Disabled.
1 : RC4. Corresponding DDL option: {Required | Required algorithm RC4}.
2 : AES. Corresponding DDL option: Required Algorithm AES.
3 : NONE, RC4. Corresponding DDL option: {Supported | Supported Algorithm RC4}.
4 : NONE, AES. Corresponding DDL option: Supported Algorithm AES.
5 : RC4, AES. Corresponding DDL option: Required Algorithm RC4 AES.
6 : AES, RC4. Corresponding DDL option: Required Algorithm AES RC4.
7 : NONE, RC4, AES. Corresponding DDL option: Supported Algorithm RC4 AES.
8 : NONE, AES, RC4. Corresponding DDL option: Supported Algorithm AES RC4.
Not NULLABLE.
[Column("encryption_algorithm")]
[NotNull]
public byte EncryptionAlgorithm { get; set; }Property Value
EncryptionAlgorithmDesc
Encryption algorithm description. The possible values and their corresponding DDL options are listed below:
NONE : Disabled
RC4 : {Required | Required Algorithm RC4}
AES : Required Algorithm AES
NONE, RC4 : {Supported | Supported Algorithm RC4}
NONE, AES : Supported Algorithm AES
RC4, AES : Required Algorithm RC4 AES
AES, RC4 : Required Algorithm AES RC4
NONE, RC4, AES : Supported Algorithm RC4 AES
NONE, AES, RC4 : Supported Algorithm AES RC4
NULLABLE.
[Column("encryption_algorithm_desc")]
[Nullable]
public string? EncryptionAlgorithmDesc { get; set; }Property Value
EndpointID
ID of the endpoint. Is unique within the server. An endpoint with an ID less then 65536 is a system endpoint. Is not nullable.
[Column("endpoint_id")]
[NotNull]
public int EndpointID { get; set; }Property Value
IsAdminEndpoint
Indicates whether the endpoint is for administrative use.
0 = Nonadministrative endpoint.
1 = Endpoint is an administrative endpoint.
Is not nullable.
[Column("is_admin_endpoint")]
[NotNull]
public bool IsAdminEndpoint { get; set; }Property Value
IsMessageForwardingEnabled
Does endpoint support message forwarding. This is initially set to 0 (disabled). Not NULLABLE.
[Column("is_message_forwarding_enabled")]
[NotNull]
public bool IsMessageForwardingEnabled { get; set; }Property Value
MessageForwardingSize
The maximum number of megabytes of tempdb space allowed to be used for messages being forwarded. This is initially set to 10. Not NULLABLE.
[Column("message_forwarding_size")]
[NotNull]
public int MessageForwardingSize { get; set; }Property Value
Name
Name of the endpoint. Is unique within the server. Is not nullable.
[Column("name")]
[NotNull]
public string Name { get; set; }Property Value
PrincipalID
ID of the server principal that created and owns this endpoint. Is nullable.
[Column("principal_id")]
[Nullable]
public int? PrincipalID { get; set; }Property Value
- int?
Protocol
Endpoint protocol.
1 = HTTP
2 = TCP
3 = Name pipes
4 = Shared memory
5 = Virtual Interface Adapter (VIA)
Is not nullable.
[Column("protocol")]
[NotNull]
public byte Protocol { get; set; }Property Value
ProtocolDesc
Description of the endpoint protocol. NULLABLE. One of the following values:
HTTP
TCP
NAMED_PIPES
SHARED_MEMORY
VIA Note: The VIA protocol is deprecated. This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.
[Column("protocol_desc")]
[Nullable]
public string? ProtocolDesc { get; set; }Property Value
State
The endpoint state.
0 = STARTED, listening and processing requests.
1 = STOPPED, listening, but not processing requests.
2 = DISABLED, not listening.
The default state is 1. Is nullable.
[Column("state")]
[Nullable]
public byte? State { get; set; }Property Value
- byte?
StateDesc
Description of the endpoint state.
STARTED = Listening and processing requests.
STOPPED = Listening, but not processing requests.
DISABLED = Not listening.
The default state is STOPPED.
Is nullable.
[Column("state_desc")]
[Nullable]
public string? StateDesc { get; set; }Property Value
TypeColumn
Endpoint payload type.
1 = SOAP
2 = TSQL
3 = SERVICE_BROKER
4 = DATABASE_MIRRORING
Is not nullable.
[Column("type")]
[NotNull]
public byte TypeColumn { get; set; }Property Value
TypeDesc
Description of the endpoint payload type. Is nullable. One of the following values:
SOAP
TSQL
SERVICE_BROKER
DATABASE_MIRRORING
[Column("type_desc")]
[Nullable]
public string? TypeDesc { get; set; }