Class EndpointsSchema.Endpoint

Namespace

LinqToDB.Tools.DataProvider.SqlServer.Schemas

Assembly

linq2db.Tools.dll

sys.endpoints (Transact-SQL)

Applies to: √ SQL Server (all supported versions)

Contains one row per endpoint that is created in the system. There is always exactly one SYSTEM endpoint.

See sys.endpoints.

[Table(Schema = "sys", Name = "endpoints", IsView = true)]
public class EndpointsSchema.Endpoint

Inheritance

object

EndpointsSchema.Endpoint

Extension Methods

Map.DeepCopy<T>(T)

Properties

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

int

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

bool

Name

Name of the endpoint. Is unique within the server. Is not nullable.

[Column("name")]
[NotNull]
public string Name { get; set; }

Property Value

string

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

byte

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

string

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

string

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

byte

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; }

Property Value

string