Table of Contents

Class ServiceBrokerSchema.Route

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

sys.routes (Transact-SQL)

Applies to: √ SQL Server (all supported versions) √ Azure SQL Managed Instance

This catalog views contains one row per route. Service Broker uses routes to locate the network address for a service.


See sys.routes.

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

Properties

Address

Network address to which Service Broker sends messages for the remote service. NULLABLE. For SQL Managed Instance, address must be local.

[Column("address")]
[Nullable]
public string? Address { get; set; }

Property Value

string

BrokerInstance

Identifier of the broker that hosts the remote service. NULLABLE.

[Column("broker_instance")]
[Nullable]
public string? BrokerInstance { get; set; }

Property Value

string

Lifetime

The date and time when the route expires. Notice that this value does not use the local time zone. Instead, the value shows the expiration time for UTC. NULLABLE.

[Column("lifetime")]
[Nullable]
public DateTime? Lifetime { get; set; }

Property Value

DateTime?

MirrorAddress

Network address of the mirroring partner for the server specified in the address. NULLABLE.

[Column("mirror_address")]
[Nullable]
public string? MirrorAddress { get; set; }

Property Value

string

Name

Name of the route, unique within the database. Not NULLABLE.

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

Property Value

string

PrincipalID

Identifier for the database principal that owns the route. NULLABLE.

[Column("principal_id")]
[Nullable]
public int? PrincipalID { get; set; }

Property Value

int?

RemoteServiceName

Name of the remote service. NULLABLE.

[Column("remote_service_name")]
[Nullable]
public string? RemoteServiceName { get; set; }

Property Value

string

RouteID

Identifier for the route. Not NULLABLE.

[Column("route_id")]
[NotNull]
public int RouteID { get; set; }

Property Value

int