Table of Contents

Class ExternalOperationsSchema.ExternalDataSource

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

sys.external_data_sources (Transact-SQL)

Applies to: √ SQL Server 2016 (13.x) and later √ Azure SQL Database √ Azure SQL Managed Instance √ Azure Synapse Analytics √ Analytics Platform System (PDW)

Contains a row for each external data source in the current database for SQL Server, SQL Database, and Azure Synapse Analytics.
Contains a row for each external data source on the server for Analytics Platform System (PDW).


See sys.external_data_sources.

[Table(Schema = "sys", Name = "external_data_sources", IsView = true)]
public class ExternalOperationsSchema.ExternalDataSource
Inheritance
ExternalOperationsSchema.ExternalDataSource
Extension Methods

Properties

CredentialID

The object ID of the database scoped credential used to connect to the external data source.

[Column("credential_id")]
[NotNull]
public int CredentialID { get; set; }

Property Value

int

DataSourceID

Object ID for the external data source.

[Column("data_source_id")]
[NotNull]
public int DataSourceID { get; set; }

Property Value

int

DatabaseName

For type RDBMS, the name of the remote database. For type, SHARD_MAP_MANAGER, the name of the shard map manager database. NULL for other types of external data sources.

[Column("database_name")]
[Nullable]
public string? DatabaseName { get; set; }

Property Value

string

Location

The connection string, which includes the protocol, IP address, and port for the external data source.

[Column("location")]
[NotNull]
public string Location { get; set; }

Property Value

string

Name

Name of the external data source.

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

Property Value

string

ResourceManagerLocation

For type HADOOP, the IP and port location of the Hadoop resource manager. The resource_manager_location is used for submitting a job on a Hadoop data source.

NULL for other types of external data sources.

[Column("resource_manager_location")]
[Nullable]
public string? ResourceManagerLocation { get; set; }

Property Value

string

ShardMapName

For type SHARD_MAP_MANAGER, the name of the shard map. NULL for other types of external data sources.

[Column("shard_map_name")]
[Nullable]
public string? ShardMapName { get; set; }

Property Value

string

TypeColumn

Data source type displayed as a number.
Range: 0 - HADOOP

1 - RDBMS

2 - SHARD_MAP_MANAGER

3 - REMOTE_DATA_ARCHIVE

4 - internal use only

5 - BLOB_STORAGE

6 - NONE

[Column("type")]
[NotNull]
public byte TypeColumn { get; set; }

Property Value

byte

TypeDesc

Data source type displayed as a string.
Range: HADOOP, RDBMS, SHARD_MAP_MANAGER, REMOTE_DATA_ARCHIVE, BLOB_STORAGE, NONE

[Column("type_desc")]
[Nullable]
public string? TypeDesc { get; set; }

Property Value

string