Class ServiceBrokerSchema.DataContext

Namespace

LinqToDB.Tools.DataProvider.SqlServer.Schemas

Assembly

linq2db.Tools.dll

public class ServiceBrokerSchema.DataContext

Inheritance

object

ServiceBrokerSchema.DataContext

Extension Methods

Map.DeepCopy<T>(T)

Constructors

DataContext(IDataContext)

public DataContext(IDataContext dataContext)

Parameters

dataContext IDataContext

Properties

ConversationEndpoints

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.

See sys.conversation_endpoints.

public ITable<ServiceBrokerSchema.ConversationEndpoint> ConversationEndpoints { get; }

Property Value

ITable<ServiceBrokerSchema.ConversationEndpoint>

ConversationGroups

sys.conversation_groups (Transact-SQL)

Applies to: √ SQL Server (all supported versions)

This catalog view contains a row for each conversation group.

See sys.conversation_groups.

public ITable<ServiceBrokerSchema.ConversationGroup> ConversationGroups { get; }

Property Value

ITable<ServiceBrokerSchema.ConversationGroup>

ConversationPriorities

sys.conversation_priorities (Transact-SQL)

Applies to: √ SQL Server (all supported versions)

Contains a row for each conversation priority created in the current database, as shown in the following table:

See sys.conversation_priorities.

public ITable<ServiceBrokerSchema.ConversationPriority> ConversationPriorities { get; }

Property Value

ITable<ServiceBrokerSchema.ConversationPriority>

MessageTypeXmlSchemaCollectionUsages

sys.message_type_xml_schema_collection_usages (Transact-SQL)

Applies to: √ SQL Server (all supported versions)

This catalog view returns a row for each service message type that is validated by an XML schema collection.

See sys.message_type_xml_schema_collection_usages.

public ITable<ServiceBrokerSchema.MessageTypeXmlSchemaCollectionUsage> MessageTypeXmlSchemaCollectionUsages { get; }

Property Value

ITable<ServiceBrokerSchema.MessageTypeXmlSchemaCollectionUsage>

RemoteServiceBindings

sys.remote_service_bindings (Transact-SQL)

Applies to: √ SQL Server (all supported versions)

This catalog view contains a row per remote service binding.

See sys.remote_service_bindings.

public ITable<ServiceBrokerSchema.RemoteServiceBinding> RemoteServiceBindings { get; }

Property Value

ITable<ServiceBrokerSchema.RemoteServiceBinding>

Routes

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.

public ITable<ServiceBrokerSchema.Route> Routes { get; }

Property Value

ITable<ServiceBrokerSchema.Route>

ServiceContractMessageUsages

sys.service_contract_message_usages (Transact-SQL)

Applies to: √ SQL Server (all supported versions)

This catalog view contains a row per (contract, message type) pair.

See sys.service_contract_message_usages.

public ITable<ServiceBrokerSchema.ServiceContractMessageUsage> ServiceContractMessageUsages { get; }

Property Value

ITable<ServiceBrokerSchema.ServiceContractMessageUsage>

ServiceContractUsages

sys.service_contract_usages (Transact-SQL)

Applies to: √ SQL Server (all supported versions)

This catalog view contains a row per (service, contract) pair.

See sys.service_contract_usages.

public ITable<ServiceBrokerSchema.ServiceContractUsage> ServiceContractUsages { get; }

Property Value

ITable<ServiceBrokerSchema.ServiceContractUsage>

ServiceContracts

sys.service_contracts (Transact-SQL)

Applies to: √ SQL Server (all supported versions)

This catalog view contains a row for each contract in the database.

See sys.service_contracts.

public ITable<ServiceBrokerSchema.ServiceContract> ServiceContracts { get; }

Property Value

ITable<ServiceBrokerSchema.ServiceContract>

ServiceMessageTypes

sys.service_message_types (Transact-SQL)

Applies to: √ SQL Server (all supported versions)

This catalog view contains a row per message type registered in the service broker.

See sys.service_message_types.

public ITable<ServiceBrokerSchema.ServiceMessageType> ServiceMessageTypes { get; }

Property Value

ITable<ServiceBrokerSchema.ServiceMessageType>

ServiceQueueUsages

sys.service_queue_usages (Transact-SQL)

Applies to: √ SQL Server (all supported versions)

This catalog view returns a row for each reference between service and service queue. A service can only be associated with one queue. A queue can be associated with multiple services.

See sys.service_queue_usages.

public ITable<ServiceBrokerSchema.ServiceQueueUsage> ServiceQueueUsages { get; }

Property Value

ITable<ServiceBrokerSchema.ServiceQueueUsage>

ServiceQueues

sys.service_queues (Transact-SQL)

Applies to: √ SQL Server (all supported versions)

Contains a row for each object in the database that is a service queue, with sys.objects.type = SQ.

See sys.service_queues.

public ITable<ServiceBrokerSchema.ServiceQueue> ServiceQueues { get; }

Property Value

ITable<ServiceBrokerSchema.ServiceQueue>

Services

sys.services (Transact-SQL)

Applies to: √ SQL Server (all supported versions)

This catalog view contains a row for each service in the database.

See sys.services.

public ITable<ServiceBrokerSchema.Service> Services { get; }

Property Value

ITable<ServiceBrokerSchema.Service>

TransmissionQueues

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.

public ITable<ServiceBrokerSchema.TransmissionQueue> TransmissionQueues { get; }

Property Value

ITable<ServiceBrokerSchema.TransmissionQueue>