Table of Contents

Class ObjectSchema.EventNotification

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

sys.event_notifications (Transact-SQL)

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

Returns a row for each object that is an event notification, with sys.objects.type = EN.


See sys.event_notifications.

[Table(Schema = "sys", Name = "event_notifications", IsView = true)]
public class ObjectSchema.EventNotification
Inheritance
ObjectSchema.EventNotification
Inherited Members
Extension Methods

Properties

BrokerInstance

broker_instance NULL nvarchar(128)

Broker instance to which the notification is sent. 
[Column("broker_instance")]
[Nullable]
public string? BrokerInstance { get; set; }

Property Value

string

CreateDate

create_date NOT NULL datetime

Date created. 
[Column("create_date")]
[NotNull]
public DateTime CreateDate { get; set; }

Property Value

DateTime

CreatorSID

creator_sid NULL varbinary(85)

SID of the login who created the event notification.

Is NULL if the FAN_IN option is not specified. 
[Column("creator_sid")]
[Nullable]
public byte[]? CreatorSID { get; set; }

Property Value

byte[]

ModifyDate

modify_date NOT NULL datetime

Always equals create_date. 
[Column("modify_date")]
[NotNull]
public DateTime ModifyDate { get; set; }

Property Value

DateTime

Name

name NOT NULL sysname

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

Property Value

string

Object

objects (sys.objects)

[Association(ThisKey = "ObjectID", OtherKey = "ObjectID", CanBeNull = false)]
public ObjectSchema.Object Object { get; set; }

Property Value

ObjectSchema.Object

ObjectID

object_id NOT NULL int

Object identification number. Is unique within a database. 
[Column("object_id")]
[NotNull]
public int ObjectID { get; set; }

Property Value

int

ParentClass

parent_class NOT NULL tinyint

Class of parent.

0 = Database

1 = Object or Column 
[Column("parent_class")]
[NotNull]
public byte ParentClass { get; set; }

Property Value

byte

ParentClassDesc

parent_class_desc NULL nvarchar(60)

DATABASE

OBJECT_OR_COLUMN 
[Column("parent_class_desc")]
[Nullable]
public string? ParentClassDesc { get; set; }

Property Value

string

ParentID

parent_id NOT NULL int

Non-zero ID of the parent object.

0 = The parent class is the database. 
[Column("parent_id")]
[NotNull]
public int ParentID { get; set; }

Property Value

int

PrincipalID

principal_id NULL int

ID of the database principal that owns this event notification. 
[Column("principal_id")]
[Nullable]
public int? PrincipalID { get; set; }

Property Value

int?

ServiceName

service_name NULL nvarchar(256)

Name of the target service to which the notification is sent. 
[Column("service_name")]
[Nullable]
public string? ServiceName { get; set; }

Property Value

string