Class AzureSQLDatabaseSchema.DatabaseFirewallRule

Namespace

LinqToDB.Tools.DataProvider.SqlServer.Schemas

Assembly

linq2db.Tools.dll

sys.database_firewall_rules (Azure SQL Database)

Applies to: √ Azure SQL Database √ Azure SQL Managed Instance

Returns information about the database-level firewall settings associated with your Microsoft Azure SQL Database. Database-level firewall settings are particularly useful when using contained database users. For more information, see Contained Database Users - Making Your Database Portable.
The sys.database_firewall_rules view contains the following columns:

See sys.database_firewall_rules.

[Table(Schema = "sys", Name = "database_firewall_rules", IsView = true)]
public class AzureSQLDatabaseSchema.DatabaseFirewallRule

Inheritance

object

AzureSQLDatabaseSchema.DatabaseFirewallRule

Extension Methods

Map.DeepCopy<T>(T)

Properties

CreateDate

UTC date and time when the database-level firewall setting was created.

[Column("create_date")]
[NotNull]
public object CreateDate { get; set; }

Property Value

object

EndIPAddress

The highest IP address in the range of the firewall setting. IP addresses equal to or less than this can attempt to connect to the SQL Database instance. The highest possible IP address is 255.255.255.255.

Note: Azure connection attempts are allowed when both this field and the start_ip_address field equals 0.0.0.0.

[Column("end_ip_address")]
[NotNull]
public object EndIPAddress { get; set; }

Property Value

object

ID

The identifier of the database-level firewall setting.

[Column("id")]
[NotNull]
public object ID { get; set; }

Property Value

object

ModifyDate

UTC date and time when the database-level firewall setting was last modified.

[Column("modify_date")]
[NotNull]
public object ModifyDate { get; set; }

Property Value

object

Name

The name you chose to describe and distinguish the database-level firewall setting.

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

Property Value

object

StartIPAddress

The lowest IP address in the range of the database-level firewall setting. IP addresses equal to or greater than this can attempt to connect to the SQL Database instance. The lowest possible IP address is 0.0.0.0.

[Column("start_ip_address")]
[NotNull]
public object StartIPAddress { get; set; }

Property Value

object